eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FLOW_REQUESTS_PKG dependencies on PAY_PROCESS_REQUESTS

Line 41: -- This procedure creates a request in the data model - pay_process_requests table

37: -- |-------------------------< create_request >--------------------------------|
38: -- ----------------------------------------------------------------------------
39: --
40: -- Description:
41: -- This procedure creates a request in the data model - pay_process_requests table
42: -- to be picked up for processing
43: --
44: -- ----------------------------------------------------------------------------
45: procedure create_request ( p_process_flow_id in number,

Line 55: l_curr_request_id PAY_PROCESS_REQUESTS.process_req_seq_id%TYPE;

51: ) IS
52:
53: -- Variable Declaration
54:
55: l_curr_request_id PAY_PROCESS_REQUESTS.process_req_seq_id%TYPE;
56: TYPE type_process_request_ids
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;

Line 57: is table of PAY_PROCESS_REQUESTS.process_req_seq_id%TYPE

53: -- Variable Declaration
54:
55: l_curr_request_id PAY_PROCESS_REQUESTS.process_req_seq_id%TYPE;
56: TYPE type_process_request_ids
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;

Line 126: insert into PAY_PROCESS_REQUESTS ( process_req_seq_id,

122: select pay_void_process_request_s1.NEXTVAL
123: into l_curr_request_id from dual;
124:
125: -- Create a process request
126: insert into PAY_PROCESS_REQUESTS ( process_req_seq_id,
127: process_request_id,
128: fnd_request_id,
129: parent_fnd_request_id,
130: assignment_action_id,

Line 274: l_process_request_row PAY_PROCESS_REQUESTS%ROWTYPE;

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;
278: l_group_id number;

Line 301: -- Cursor for getting the process_req_seq_id, primary key of the pay_process_requests table.

297: and ppsv.set_id = p_set_id
298: and ppsvv.process_req_seq_id = p_request_id
299: order by ppsv.set_var_sequence;
300:
301: -- Cursor for getting the process_req_seq_id, primary key of the pay_process_requests table.
302:
303: CURSOR get_proc_req_seq_id(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) is
304: select process_req_seq_id
305: from pay_process_requests

Line 303: CURSOR get_proc_req_seq_id(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) is

299: order by ppsv.set_var_sequence;
300:
301: -- Cursor for getting the process_req_seq_id, primary key of the pay_process_requests table.
302:
303: CURSOR get_proc_req_seq_id(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) is
304: select process_req_seq_id
305: from pay_process_requests
306: where fnd_request_id = p_fnd_request_id;
307:

Line 305: from pay_process_requests

301: -- Cursor for getting the process_req_seq_id, primary key of the pay_process_requests table.
302:
303: CURSOR get_proc_req_seq_id(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) is
304: select process_req_seq_id
305: from pay_process_requests
306: where fnd_request_id = p_fnd_request_id;
307:
308: -- Cursor for getting the assignment action id for a process request
309:

Line 310: CURSOR get_asg_action_id(p_process_req_seq_id pay_process_requests.process_req_seq_id%TYPE) is

306: where fnd_request_id = p_fnd_request_id;
307:
308: -- Cursor for getting the assignment action id for a process request
309:
310: CURSOR get_asg_action_id(p_process_req_seq_id pay_process_requests.process_req_seq_id%TYPE) is
311: select ppr.assignment_action_id
312: from pay_process_requests ppr
313: where ppr.process_req_seq_id = p_process_req_seq_id;
314:

Line 312: from pay_process_requests ppr

308: -- Cursor for getting the assignment action id for a process request
309:
310: CURSOR get_asg_action_id(p_process_req_seq_id pay_process_requests.process_req_seq_id%TYPE) is
311: select ppr.assignment_action_id
312: from pay_process_requests ppr
313: where ppr.process_req_seq_id = p_process_req_seq_id;
314:
315: -- Cursor for retrieving the details of the flow request in PAY_PROCESS_REQUESTS
316:

Line 315: -- Cursor for retrieving the details of the flow request in PAY_PROCESS_REQUESTS

311: select ppr.assignment_action_id
312: from pay_process_requests ppr
313: where ppr.process_req_seq_id = p_process_req_seq_id;
314:
315: -- Cursor for retrieving the details of the flow request in PAY_PROCESS_REQUESTS
316:
317: CURSOR get_flow_req_details(p_process_req_seq_id pay_process_requests.process_req_seq_id%TYPE) is
318: select *
319: from PAY_PROCESS_REQUESTS

Line 317: CURSOR get_flow_req_details(p_process_req_seq_id pay_process_requests.process_req_seq_id%TYPE) is

313: where ppr.process_req_seq_id = p_process_req_seq_id;
314:
315: -- Cursor for retrieving the details of the flow request in PAY_PROCESS_REQUESTS
316:
317: CURSOR get_flow_req_details(p_process_req_seq_id pay_process_requests.process_req_seq_id%TYPE) is
318: select *
319: from PAY_PROCESS_REQUESTS
320: where process_req_seq_id = p_process_req_seq_id;
321: --

Line 319: from PAY_PROCESS_REQUESTS

315: -- Cursor for retrieving the details of the flow request in PAY_PROCESS_REQUESTS
316:
317: CURSOR get_flow_req_details(p_process_req_seq_id pay_process_requests.process_req_seq_id%TYPE) is
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: --

Line 336: -- With the request_id get the process_id from PAY_PROCESS_REQUESTS

332: BEGIN
333:
334: hr_utility.set_location('Entering: '||l_proc, 5);
335:
336: -- With the request_id get the process_id from PAY_PROCESS_REQUESTS
337:
338: BEGIN
339: --
340: OPEN get_flow_req_details(p_request_id);

Line 356: from PAY_PROCESS_REQUESTS

352: -- selecting the process flow id
353: BEGIN
354: --
355: select process_flow_id into l_process_id
356: from PAY_PROCESS_REQUESTS
357: where process_req_seq_id = p_request_id;
358: --
359: exception
360: when no_data_found then

Line 528: -- This function updates the PAY_PROCESS_REQUESTS table with the current status

524: -- |-------------------------< update_process_status >------------------------|
525: -- ----------------------------------------------------------------------------
526: --
527: -- Description:
528: -- This function updates the PAY_PROCESS_REQUESTS table with the current status
529: -- and request_id of the concurrent request
530: --
531: -- ----------------------------------------------------------------------------
532: procedure update_process_status (p_process_request_id in number,

Line 540: update PAY_PROCESS_REQUESTS

536: BEGIN
537:
538: hr_utility.set_location('Entering: '||l_proc, 5);
539:
540: update PAY_PROCESS_REQUESTS
541: set fnd_request_id = p_fnd_request_id,
542: last_update_date = sysdate,
543: last_updated_by = fnd_global.user_id,
544: last_update_login = fnd_global.login_id

Line 560: -- request in PAY_PROCESS_REQUESTS

556: -- ----------------------------------------------------------------------------
557: --
558: -- Description:
559: -- This function invokes the request and then updates the status of the
560: -- request in PAY_PROCESS_REQUESTS
561: --
562: -- ----------------------------------------------------------------------------
563: procedure execute_request(p_request_id in number) IS
564:

Line 594: -- associated parameter values from the tables PAY_PROCESS_REQUESTS and

590: -- ----------------------------------------------------------------------------
591: --
592: -- Description:
593: -- This function is called from the UI and purges the completed requests and
594: -- associated parameter values from the tables PAY_PROCESS_REQUESTS and
595: -- PAY_PARA_SET_VAR_VALUES.
596: --
597: -- ----------------------------------------------------------------------------
598: procedure purge_requests(p_fnd_request_id in number default null,

Line 604: from PAY_PROCESS_REQUESTS ppr,

600: --
601: -- Cursor to get the parent fnd requests which have completed processing
602: CURSOR get_parent_fnd_requests is
603: select ppr.fnd_request_id
604: from PAY_PROCESS_REQUESTS ppr,
605: fnd_concurrent_requests fcr
606: where ppr.fnd_request_id is not null
607: and ppr.PARENT_FND_REQUEST_ID is null
608: and ppr.fnd_request_id = fcr.request_id

Line 614: CURSOR get_child_requests(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS

610: order by fnd_request_id desc ;
611: --
612: -- Cursor to get the child fnd requests which have completed processing
613: -- for a particular parent request.
614: CURSOR get_child_requests(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS
615: select ppr_child.fnd_request_id
616: from PAY_PROCESS_REQUESTS ppr_child,
617: pay_process_requests ppr_parent,
618: fnd_concurrent_requests fcr

Line 616: from PAY_PROCESS_REQUESTS ppr_child,

612: -- Cursor to get the child fnd requests which have completed processing
613: -- for a particular parent request.
614: CURSOR get_child_requests(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS
615: select ppr_child.fnd_request_id
616: from PAY_PROCESS_REQUESTS ppr_child,
617: pay_process_requests ppr_parent,
618: fnd_concurrent_requests fcr
619: where ppr_child.parent_fnd_request_id = p_fnd_request_id
620: and ppr_parent.fnd_request_id = ppr_child.parent_fnd_request_id

Line 617: pay_process_requests ppr_parent,

613: -- for a particular parent request.
614: CURSOR get_child_requests(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS
615: select ppr_child.fnd_request_id
616: from PAY_PROCESS_REQUESTS ppr_child,
617: pay_process_requests ppr_parent,
618: fnd_concurrent_requests fcr
619: where ppr_child.parent_fnd_request_id = p_fnd_request_id
620: and ppr_parent.fnd_request_id = ppr_child.parent_fnd_request_id
621: and ppr_parent.fnd_request_id = fcr.request_id

Line 626: CURSOR get_set_var_values(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS

622: and fcr.phase_code = 'C'
623: order by ppr_child.fnd_request_id desc ;
624: --
625: -- Cursor to get the Variable values for the request being deleted
626: CURSOR get_set_var_values(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS
627: select ppsv.set_variable_value_id
628: from pay_para_set_var_values ppsv,
629: pay_process_requests ppr
630: where ppr.fnd_request_id = p_fnd_request_id

Line 629: pay_process_requests ppr

625: -- Cursor to get the Variable values for the request being deleted
626: CURSOR get_set_var_values(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS
627: select ppsv.set_variable_value_id
628: from pay_para_set_var_values ppsv,
629: pay_process_requests ppr
630: where ppr.fnd_request_id = p_fnd_request_id
631: and ppsv.process_req_seq_id = ppr.process_req_seq_id ;
632: --
633: l_fnd_req_completed boolean;

Line 666: from pay_process_requests

662: end loop;
663:
664: -- Now, delete the child requests
665: delete
666: from pay_process_requests
667: where fnd_request_id = fnd_child_rec.fnd_request_id;
668:
669: end loop;
670:

Line 688: from pay_process_requests

684: end loop;
685:
686: -- Now, delete the parent request
687: delete
688: from pay_process_requests
689: where fnd_request_id = p_fnd_request_id;
690:
691: l_fnd_req_completed := true;
692:

Line 777: from pay_process_requests ppr,

773: -- Only pending requests should be cancelled. Once the flow processing starts
774: -- and the child request is running, the flow cannot be cancelled
775: CURSOR get_pending_child_request(p_fnd_request_id number) IS
776: select ppr.fnd_request_id
777: from pay_process_requests ppr,
778: fnd_concurrent_requests fcr
779: where ppr.fnd_request_id =
780: ( select min(fnd_request_id)
781: from pay_process_requests

Line 781: from pay_process_requests

777: from pay_process_requests ppr,
778: fnd_concurrent_requests fcr
779: where ppr.fnd_request_id =
780: ( select min(fnd_request_id)
781: from pay_process_requests
782: where parent_fnd_request_id = p_fnd_request_id
783: )
784: and ppr.fnd_request_id = fcr.request_id
785: and fcr.phase_code = 'P';

Line 834: -- This procedure inserts the child requests in the pay_process_requests table.

830: -- |-------------------------< insert_child_request >--------------------------|
831: -- ----------------------------------------------------------------------------
832: --
833: -- Description:
834: -- This procedure inserts the child requests in the pay_process_requests table.
835: -- This can be called from the wrapper packages of individual processes to
836: -- update the table before doing any other processing post request completion.
837: --
838: -- ----------------------------------------------------------------------------

Line 849: from pay_process_requests ppr_outer

845: CURSOR get_parent_request IS
846: select ppr_outer.process_request_id,
847: ppr_outer.fnd_request_id,
848: ppr_outer.process_flow_id
849: from pay_process_requests ppr_outer
850: where ppr_outer.process_request_id =
851: ( SELECT max(ppr_inner.process_request_id)
852: FROM pay_process_requests ppr_inner
853: WHERE ppr_inner.assignment_action_id = p_assignment_action_id

Line 852: FROM pay_process_requests ppr_inner

848: ppr_outer.process_flow_id
849: from pay_process_requests ppr_outer
850: where ppr_outer.process_request_id =
851: ( SELECT max(ppr_inner.process_request_id)
852: FROM pay_process_requests ppr_inner
853: WHERE ppr_inner.assignment_action_id = p_assignment_action_id
854: AND ppr_inner.parent_fnd_request_id IS null
855: );
856:

Line 858: -- the PAY_PROCESS_REQUESTS table.

854: AND ppr_inner.parent_fnd_request_id IS null
855: );
856:
857: -- Cursor to verify if the child request record is already inserted in
858: -- the PAY_PROCESS_REQUESTS table.
859: CURSOR child_request_exists IS
860: select 'Y'
861: from pay_process_requests
862: where fnd_request_id = p_fnd_request_id;

Line 861: from pay_process_requests

857: -- Cursor to verify if the child request record is already inserted in
858: -- the PAY_PROCESS_REQUESTS table.
859: CURSOR child_request_exists IS
860: select 'Y'
861: from pay_process_requests
862: where fnd_request_id = p_fnd_request_id;
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;

Line 864: l_proc_req_seq_id pay_process_requests.process_req_seq_id%TYPE;

860: select 'Y'
861: from pay_process_requests
862: where fnd_request_id = p_fnd_request_id;
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';

Line 865: l_process_request_id pay_process_requests.process_request_id%TYPE;

861: from pay_process_requests
862: where fnd_request_id = p_fnd_request_id;
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: --

Line 866: l_parent_fnd_req_id pay_process_requests.fnd_request_id%TYPE;

862: where fnd_request_id = p_fnd_request_id;
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';

Line 883: -- Update the PAY_PROCESS_REQUESTS table here

879: --
880: close child_request_exists;
881: --
882: else
883: -- Update the PAY_PROCESS_REQUESTS table here
884: --
885: open get_parent_request;
886: fetch get_parent_request into l_process_request_id,
887: l_parent_fnd_req_id,

Line 893: insert into PAY_PROCESS_REQUESTS ( process_req_seq_id,

889: if (get_parent_request%FOUND) then
890: --
891: close get_parent_request;
892:
893: insert into PAY_PROCESS_REQUESTS ( process_req_seq_id,
894: process_request_id,
895: fnd_request_id,
896: parent_fnd_request_id,
897: assignment_action_id,