APPS.PAY_FLOW_REQUESTS_PKG dependencies on PAY_FLOW_REQUESTS_PKG

Line 1: PACKAGE BODY PAY_FLOW_REQUESTS_PKG AS

1: PACKAGE BODY PAY_FLOW_REQUESTS_PKG AS
2: /* $Header: pyprflow.pkb 120.1.12020000.1 2013/03/22 08:07:40 nvankadh noship $ */
3: /*
4: ******************************************************************
5: * *

Line 87: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.CREATE_REQUEST';

83: select destin_set_var_id, source_set_var_id
84: from pay_para_set_override_vars
85: where source_set_var_id = p_csr_source_set_var_id;
86: ---
87: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.CREATE_REQUEST';
88: ---
89:
90: BEGIN
91:

Line 322: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.INVOKE_REQUEST';

318: select *
319: from PAY_PROCESS_REQUESTS
320: where process_req_seq_id = p_process_req_seq_id;
321: --
322: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.INVOKE_REQUEST';
323: --
324: l_wait_outcome BOOLEAN;
325: l_phase VARCHAR2(80);
326: l_status VARCHAR2(80);

Line 534: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.UPDATE_PROCESS_STATUS';

530: --
531: -- ----------------------------------------------------------------------------
532: procedure update_process_status (p_process_request_id in number,
533: p_fnd_request_id in number) IS
534: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.UPDATE_PROCESS_STATUS';
535:
536: BEGIN
537:
538: hr_utility.set_location('Entering: '||l_proc, 5);

Line 566: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.EXECUTE_REQUEST';

562: -- ----------------------------------------------------------------------------
563: procedure execute_request(p_request_id in number) IS
564:
565: l_fnd_request_id number;
566: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.EXECUTE_REQUEST';
567:
568: BEGIN
569:
570: hr_utility.set_location('Entering: '||l_proc, 5);

Line 635: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.PURGE_REQUESTS';

631: and ppsv.process_req_seq_id = ppr.process_req_seq_id ;
632: --
633: l_fnd_req_completed boolean;
634: l_request_count number := 0;
635: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.PURGE_REQUESTS';
636: --
637: /*
638: This procedure is called when a single parent request id is passed and all the child requests
639: for that request have to be purged. This procedure is called multiple times when no parent

Line 789: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.CANCEL_REQUEST';

785: and fcr.phase_code = 'P';
786:
787: --
788: l_cancelled boolean := false ;
789: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.CANCEL_REQUEST';
790: l_fnd_request_id number;
791: l_message varchar2(255);
792: --
793: BEGIN

Line 870: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.INSERT_CHILD_REQUEST';

866: l_parent_fnd_req_id pay_process_requests.fnd_request_id%TYPE;
867: l_process_flow_id pay_process_flows.process_flow_id%TYPE;
868: l_child_req_exists varchar2(5) default 'N';
869: --
870: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.INSERT_CHILD_REQUEST';
871: --
872: BEGIN
873:
874: -- First check if the child request has already been inserted

Line 947: END PAY_FLOW_REQUESTS_PKG;

943: raise;
944: --
945: END INSERT_CHILD_REQUEST;
946:
947: END PAY_FLOW_REQUESTS_PKG;