DBA Data[Home] [Help]

APPS.PAY_FLOW_REQUESTS_PKG dependencies on PAY_PARAMETER_SETS

Line 273: l_wrapper_pkg pay_parameter_sets.wrapper_pkg%TYPE;

269: retcode OUT NOCOPY NUMBER,
270: p_request_id in number) IS
271: p_dummy_num number;
272: l_process_id number;
273: l_wrapper_pkg pay_parameter_sets.wrapper_pkg%TYPE;
274: l_process_request_row PAY_PROCESS_REQUESTS%ROWTYPE;
275:
276: l_sql_stmt varchar2(200);
277: l_request_id number;

Line 370: -- Get the wrapper package name from pay_parameter_sets

366:
367: -- For each set_id
368: FOR l_set_id in get_set_ids(l_process_id)
369: LOOP
370: -- Get the wrapper package name from pay_parameter_sets
371: BEGIN
372: --
373: select wrapper_pkg into l_wrapper_pkg
374: from pay_parameter_sets

Line 374: from pay_parameter_sets

370: -- Get the wrapper package name from pay_parameter_sets
371: BEGIN
372: --
373: select wrapper_pkg into l_wrapper_pkg
374: from pay_parameter_sets
375: where set_id = l_set_id.set_id;
376: --
377: exception
378: when no_data_found then