Concurrent Hold Process Trigger

CREATE OR REPLACE TRIGGER  < TRIGGER_NAME >
   BEFORE INSERT
   ON FND_CONCURRENT_REQUESTS
   REFERENCING OLD AS OLD NEW AS NEW
   FOR EACH ROW
WHEN (
NEW.concurrent_program_id = 41819
      )
DECLARE
   v_key   NUMBER;
BEGIN
   --:NEW.hold_flag   := 'Y';
   :NEW.status_code := 'Z';
END;
/

CREATE OR REPLACE TRIGGER < Trigger_Name >
   BEFORE INSERT
   ON FND_CONCURRENT_REQUESTS
   REFERENCING OLD AS OLD NEW AS NEW
   FOR EACH ROW
WHEN (
NEW.concurrent_program_id = 109075
      )
DECLARE
   v_key          NUMBER;
   v_created_by   VARCHAR2 (100);
BEGIN
   SELECT created_by
     INTO v_created_by
     FROM ap_suppliers
    WHERE vendor_id IN (SELECT payee_supplier_id
                          FROM iby_payments_all
                         WHERE payment_instruction_id = :NEW.argument1);

   IF :NEW.requested_by = v_created_by
   THEN
      :NEW.status_code := 'A';
   END IF;
END;