APPS.PAY_VOID_UI_PKG dependencies on PAY_PROCESS_FLOWS

Line 48: l_process_flow_id pay_process_flows.process_flow_id%TYPE;

44: function get_process_name(p_fnd_request_id in number)
45: return varchar2
46: IS
47: l_set_id pay_parameter_sets.set_id%TYPE;
48: l_process_flow_id pay_process_flows.process_flow_id%TYPE;
49: l_set_name pay_parameter_definitions_tl.name%TYPE;
50:
51: --
52: -- Cursor to get the process name based on the process set_id

Line 78: p_process_flow_id pay_process_flows.process_flow_id%TYPE) is

74: order by process_req_seq_id;
75:
76: -- Cursor to get the set_id from pay_process_flow_sets
77: cursor csr_set_id(p_process_flow_seq pay_process_flow_sets.process_flow_seq%TYPE,
78: p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
79: select pfs.set_id
80: from pay_process_flow_sets pfs
81: where pfs.process_flow_id = p_process_flow_id
82: and pfs.process_flow_seq = p_process_flow_seq;

Line 86: cursor csr_flow_set_id(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is

82: and pfs.process_flow_seq = p_process_flow_seq;
83:
84: --
85: -- Cursor to get the set_id for the flow
86: cursor csr_flow_set_id(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
87: select ppf.set_id
88: from pay_process_flows ppf
89: where ppf.process_flow_id = p_process_flow_id;
90: --

Line 88: from pay_process_flows ppf

84: --
85: -- Cursor to get the set_id for the flow
86: cursor csr_flow_set_id(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
87: select ppf.set_id
88: from pay_process_flows ppf
89: where ppf.process_flow_id = p_process_flow_id;
90: --
91: l_proc varchar2(72) := 'PAY_VOID_UI_PKG.GET_PROCESS_NAME';
92: --

Line 158: CURSOR get_initialization_proc(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is

154: p_asg_action_id in number )
155: return number IS
156: --
157: -- Cursor to get the initialization procedure for the process flow
158: CURSOR get_initialization_proc(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
159: select initialization_procedure
160: from pay_process_flows
161: where process_flow_id = p_process_flow_id;
162: --

Line 160: from pay_process_flows

156: --
157: -- Cursor to get the initialization procedure for the process flow
158: CURSOR get_initialization_proc(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
159: select initialization_procedure
160: from pay_process_flows
161: where process_flow_id = p_process_flow_id;
162: --
163: l_initialization_procedure pay_process_flows.initialization_procedure%TYPE;
164: l_sql_stmt varchar2(200);

Line 163: l_initialization_procedure pay_process_flows.initialization_procedure%TYPE;

159: select initialization_procedure
160: from pay_process_flows
161: where process_flow_id = p_process_flow_id;
162: --
163: l_initialization_procedure pay_process_flows.initialization_procedure%TYPE;
164: l_sql_stmt varchar2(200);
165: l_asg_valid number;
166: l_proc varchar2(72) := 'PAY_VOID_UI_PKG.RETRIEVE_ASG_STATUS' ;
167: --