APPS.PAY_FLOW_REQUESTS_PKG dependencies on PAY_PROCESS_FLOWS

Line 61: l_flow_set_id pay_process_flows.set_id%TYPE;

57: is table of PAY_PROCESS_REQUESTS.process_req_seq_id%TYPE
58: index by BINARY_INTEGER;
59: p_process_request_ids type_process_request_ids;
60: l_request_details REQUEST_DETAIL_ARRAY;
61: l_flow_set_id pay_process_flows.set_id%TYPE;
62: l_var_value varchar2(255);
63:
64:
65: -- Cursor for identifying the sets associated with a flow's individual processes

Line 66: CURSOR csr_process_sets(p_process_flow_id pay_process_flows.process_flow_id%TYPE)

62: l_var_value varchar2(255);
63:
64:
65: -- Cursor for identifying the sets associated with a flow's individual processes
66: CURSOR csr_process_sets(p_process_flow_id pay_process_flows.process_flow_id%TYPE)
67: is
68: select set_id, process_flow_set_id
69: from PAY_PROCESS_FLOW_SETS
70: where process_flow_id = p_process_flow_id;

Line 103: from pay_process_flows

99: hr_utility.trace('Asg Action = '||p_asg_action);
100: hr_utility.trace('ParameterName ParameterId SetVariableId SetVariableValue SetVariableSequence DefaultType');
101:
102: select set_id into l_flow_set_id
103: from pay_process_flows
104: where process_flow_id = p_process_flow_id;
105:
106: FOR table_row in 1 .. p_no_of_params
107: LOOP

Line 284: CURSOR get_set_ids(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is

280: l_process_status varchar2(1);
281:
282: -- Cursor for getting the set_if for the requests in a flow.
283:
284: CURSOR get_set_ids(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
285: select set_id
286: from PAY_PROCESS_FLOW_SETS
287: where process_flow_id = p_process_flow_id
288: order by process_flow_seq;

Line 867: l_process_flow_id pay_process_flows.process_flow_id%TYPE;

863:
864: l_proc_req_seq_id pay_process_requests.process_req_seq_id%TYPE;
865: l_process_request_id pay_process_requests.process_request_id%TYPE;
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: --