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 FND_REQUEST

Line 128: fnd_request_id,

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,
131: process_flow_id,
132: last_update_date,

Line 129: parent_fnd_request_id,

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,
131: process_flow_id,
132: last_update_date,
133: last_updated_by,

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

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:
310: CURSOR get_asg_action_id(p_process_req_seq_id pay_process_requests.process_req_seq_id%TYPE) is

Line 533: p_fnd_request_id in number) IS

529: -- and request_id of the concurrent request
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:

Line 541: set fnd_request_id = p_fnd_request_id,

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
545: where process_req_seq_id = p_process_request_id;

Line 565: l_fnd_request_id number;

561: --
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:

Line 572: l_fnd_request_id := fnd_request.submit_request(

568: BEGIN
569:
570: hr_utility.set_location('Entering: '||l_proc, 5);
571:
572: l_fnd_request_id := fnd_request.submit_request(
573: application => 'PAY',
574: program => 'PYINVREQ',
575: description => null,
576: start_time => fnd_date.date_to_canonical(sysdate),

Line 580: update_process_status(p_request_id, l_fnd_request_id);

576: start_time => fnd_date.date_to_canonical(sysdate),
577: sub_request => null,
578: argument1 => p_request_id);
579:
580: update_process_status(p_request_id, l_fnd_request_id);
581:
582: commit;
583:
584: hr_utility.set_location('Leaving: '||l_proc, 10);

Line 598: procedure purge_requests(p_fnd_request_id in number default null,

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,
599: p_message out NOCOPY varchar2) IS
600: --
601: -- Cursor to get the parent fnd requests which have completed processing
602: CURSOR get_parent_fnd_requests is

Line 601: -- Cursor to get the parent fnd requests which have completed processing

597: -- ----------------------------------------------------------------------------
598: procedure purge_requests(p_fnd_request_id in number default null,
599: p_message out NOCOPY varchar2) IS
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

Line 602: CURSOR get_parent_fnd_requests is

598: procedure purge_requests(p_fnd_request_id in number default null,
599: p_message out NOCOPY varchar2) IS
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

Line 603: select ppr.fnd_request_id

599: p_message out NOCOPY varchar2) IS
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

Line 606: where ppr.fnd_request_id is not null

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
609: and fcr.phase_code = 'C'
610: order by fnd_request_id desc ;

Line 607: and ppr.PARENT_FND_REQUEST_ID is null

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
609: and fcr.phase_code = 'C'
610: order by fnd_request_id desc ;
611: --

Line 608: and ppr.fnd_request_id = fcr.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
609: and fcr.phase_code = 'C'
610: order by fnd_request_id desc ;
611: --
612: -- Cursor to get the child fnd requests which have completed processing

Line 610: order by fnd_request_id desc ;

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
609: and fcr.phase_code = 'C'
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

Line 612: -- Cursor to get the child fnd requests which have completed processing

608: and ppr.fnd_request_id = fcr.request_id
609: and fcr.phase_code = 'C'
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,

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 615: select ppr_child.fnd_request_id

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
619: where ppr_child.parent_fnd_request_id = p_fnd_request_id

Line 619: where ppr_child.parent_fnd_request_id = p_fnd_request_id

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
622: and fcr.phase_code = 'C'
623: order by ppr_child.fnd_request_id desc ;

Line 620: and ppr_parent.fnd_request_id = ppr_child.parent_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
622: and fcr.phase_code = 'C'
623: order by ppr_child.fnd_request_id desc ;
624: --

Line 621: and ppr_parent.fnd_request_id = fcr.request_id

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
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

Line 623: order by ppr_child.fnd_request_id desc ;

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
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

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 630: where ppr.fnd_request_id = p_fnd_request_id

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;
634: l_request_count number := 0;

Line 642: PROCEDURE purge_single_flow_request(p_fnd_request_id in number,

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
640: request is passed and all completed requests have to be purged.
641: */
642: PROCEDURE purge_single_flow_request(p_fnd_request_id in number,
643: l_fnd_req_completed in out NOCOPY BOOLEAN ) is
644: --
645: l_delete_parent varchar2(2);
646: --

Line 652: for fnd_child_rec in get_child_requests(p_fnd_request_id)

648:
649: l_delete_parent := 'N';
650:
651: -- First get all the child requests
652: for fnd_child_rec in get_child_requests(p_fnd_request_id)
653: loop
654: -- Delete the variable values for the child request first
655: for fnd_set_var_value_rec in get_set_var_values(fnd_child_rec.fnd_request_id)
656: loop

Line 655: for fnd_set_var_value_rec in get_set_var_values(fnd_child_rec.fnd_request_id)

651: -- First get all the child requests
652: for fnd_child_rec in get_child_requests(p_fnd_request_id)
653: loop
654: -- Delete the variable values for the child request first
655: for fnd_set_var_value_rec in get_set_var_values(fnd_child_rec.fnd_request_id)
656: loop
657:
658: delete
659: from pay_para_set_var_values

Line 667: where fnd_request_id = fnd_child_rec.fnd_request_id;

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:
671: l_delete_parent := 'Y';

Line 677: for fnd_set_var_value_rec in get_set_var_values(p_fnd_request_id)

673:
674: if (l_delete_parent = 'Y') then
675:
676: -- Delete the variable values for the parent request
677: for fnd_set_var_value_rec in get_set_var_values(p_fnd_request_id)
678: loop
679:
680: delete
681: from pay_para_set_var_values

Line 689: where fnd_request_id = p_fnd_request_id;

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:
693: ELSE

Line 696: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);

692:
693: ELSE
694: -- Pass back a message to UI informing that the request has not been purged.
695: hr_utility.set_message(801, 'PAY_33462_REQ_ACTION_INFO');
696: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);
697: hr_utility.set_message_token(801,'ACTION','purged');
698: p_message := hr_utility.get_message;
699: hr_utility.clear_message;
700:

Line 711: if(p_fnd_request_id is not null) THEN

707: hr_utility.set_location('Entering: '||l_proc, 5);
708:
709: l_fnd_req_completed := false;
710:
711: if(p_fnd_request_id is not null) THEN
712:
713: l_request_count := 1;
714: purge_single_flow_request(p_fnd_request_id,l_fnd_req_completed);
715:

Line 714: purge_single_flow_request(p_fnd_request_id,l_fnd_req_completed);

710:
711: if(p_fnd_request_id is not null) THEN
712:
713: l_request_count := 1;
714: purge_single_flow_request(p_fnd_request_id,l_fnd_req_completed);
715:
716: ELSE
717: -- fnd_request_id passed is null. Purge all completed requests.
718: -- Get the parent requests which are in completed state and call

Line 717: -- fnd_request_id passed is null. Purge all completed requests.

713: l_request_count := 1;
714: purge_single_flow_request(p_fnd_request_id,l_fnd_req_completed);
715:
716: ELSE
717: -- fnd_request_id passed is null. Purge all completed requests.
718: -- Get the parent requests which are in completed state and call
719: -- purge_single_flow_request for each of the parent requests.
720:
721: for fnd_parent_rec in get_parent_fnd_requests

Line 721: for fnd_parent_rec in get_parent_fnd_requests

717: -- fnd_request_id passed is null. Purge all completed requests.
718: -- Get the parent requests which are in completed state and call
719: -- purge_single_flow_request for each of the parent requests.
720:
721: for fnd_parent_rec in get_parent_fnd_requests
722: loop
723:
724: l_request_count := l_request_count +1 ;
725: purge_single_flow_request(fnd_parent_rec.fnd_request_id,l_fnd_req_completed);

Line 725: purge_single_flow_request(fnd_parent_rec.fnd_request_id,l_fnd_req_completed);

721: for fnd_parent_rec in get_parent_fnd_requests
722: loop
723:
724: l_request_count := l_request_count +1 ;
725: purge_single_flow_request(fnd_parent_rec.fnd_request_id,l_fnd_req_completed);
726:
727: end loop;
728:
729: end if;

Line 736: if (p_fnd_request_id IS NOT null) THEN

732: hr_utility.set_location(l_proc, 10);
733:
734: if(l_fnd_req_completed) THEN
735:
736: if (p_fnd_request_id IS NOT null) THEN
737:
738: hr_utility.set_message(801, 'PAY_33461_REQ_ACTION_CONFIRM');
739: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);
740: hr_utility.set_message_token(801,'ACTION','purged');

Line 739: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);

735:
736: if (p_fnd_request_id IS NOT null) THEN
737:
738: hr_utility.set_message(801, 'PAY_33461_REQ_ACTION_CONFIRM');
739: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);
740: hr_utility.set_message_token(801,'ACTION','purged');
741:
742: ELSE
743:

Line 768: procedure cancel_request(p_fnd_request_id in number,

764: -- This function is called from the UI and cancels the pending requests.
765: --
766: -- ----------------------------------------------------------------------------
767:
768: procedure cancel_request(p_fnd_request_id in number,
769: p_message out NOCOPY varchar2) IS
770: --
771: -- Cursor to get the child request which is spawned first by the
772: -- parent request and is in Pending state.

Line 775: CURSOR get_pending_child_request(p_fnd_request_id number) IS

771: -- Cursor to get the child request which is spawned first by the
772: -- parent request and is in Pending state.
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 =

Line 776: select ppr.fnd_request_id

772: -- parent request and is in Pending state.
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)

Line 779: where ppr.fnd_request_id =

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
782: where parent_fnd_request_id = p_fnd_request_id
783: )

Line 780: ( select min(fnd_request_id)

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
782: where parent_fnd_request_id = p_fnd_request_id
783: )
784: and ppr.fnd_request_id = fcr.request_id

Line 782: where parent_fnd_request_id = p_fnd_request_id

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';
786:

Line 784: and ppr.fnd_request_id = fcr.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';
786:
787: --
788: l_cancelled boolean := false ;

Line 790: l_fnd_request_id number;

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
794: --

Line 798: open get_pending_child_request(p_fnd_request_id);

794: --
795: hr_utility.set_location('Entering: '||l_proc, 5);
796: --
797: -- Get the pending child request and cancel it
798: open get_pending_child_request(p_fnd_request_id);
799: fetch get_pending_child_request into l_fnd_request_id;
800: if get_pending_child_request%FOUND then
801: l_cancelled := fnd_concurrent.cancel_request(l_fnd_request_id,l_message);
802: end if;

Line 799: fetch get_pending_child_request into l_fnd_request_id;

795: hr_utility.set_location('Entering: '||l_proc, 5);
796: --
797: -- Get the pending child request and cancel it
798: open get_pending_child_request(p_fnd_request_id);
799: fetch get_pending_child_request into l_fnd_request_id;
800: if get_pending_child_request%FOUND then
801: l_cancelled := fnd_concurrent.cancel_request(l_fnd_request_id,l_message);
802: end if;
803: close get_pending_child_request;

Line 801: l_cancelled := fnd_concurrent.cancel_request(l_fnd_request_id,l_message);

797: -- Get the pending child request and cancel it
798: open get_pending_child_request(p_fnd_request_id);
799: fetch get_pending_child_request into l_fnd_request_id;
800: if get_pending_child_request%FOUND then
801: l_cancelled := fnd_concurrent.cancel_request(l_fnd_request_id,l_message);
802: end if;
803: close get_pending_child_request;
804:
805: -- If child request has been cancelled then, cancel the parent request also.

Line 808: l_cancelled := fnd_concurrent.cancel_request(p_fnd_request_id,l_message);

804:
805: -- If child request has been cancelled then, cancel the parent request also.
806: if l_cancelled THEN
807:
808: l_cancelled := fnd_concurrent.cancel_request(p_fnd_request_id,l_message);
809:
810: hr_utility.set_message(801, 'PAY_33461_REQ_ACTION_CONFIRM');
811: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);
812: hr_utility.set_message_token(801,'ACTION','cancelled');

Line 811: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);

807:
808: l_cancelled := fnd_concurrent.cancel_request(p_fnd_request_id,l_message);
809:
810: hr_utility.set_message(801, 'PAY_33461_REQ_ACTION_CONFIRM');
811: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);
812: hr_utility.set_message_token(801,'ACTION','cancelled');
813: p_message := hr_utility.get_message;
814: p_message := p_message || ' ' || l_message;
815: hr_utility.clear_message;

Line 819: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);

815: hr_utility.clear_message;
816:
817: else
818: hr_utility.set_message(801, 'PAY_33462_REQ_ACTION_INFO');
819: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);
820: hr_utility.set_message_token(801,'ACTION','cancelled');
821: p_message := hr_utility.get_message;
822: hr_utility.clear_message;
823: end if;

Line 840: p_fnd_request_id in number) IS

836: -- update the table before doing any other processing post request completion.
837: --
838: -- ----------------------------------------------------------------------------
839: procedure insert_child_request(p_assignment_action_id in number,
840: p_fnd_request_id in number) IS
841: --
842: -- Cursor to get the parent request details from the assignment action id
843: -- If there are more than one record with the same assignment action, get the
844: -- request with the maximum process_request_id.

Line 847: ppr_outer.fnd_request_id,

843: -- If there are more than one record with the same assignment action, get the
844: -- request with the maximum process_request_id.
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)

Line 854: AND ppr_inner.parent_fnd_request_id IS null

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:
857: -- Cursor to verify if the child request record is already inserted in
858: -- the PAY_PROCESS_REQUESTS table.

Line 862: where fnd_request_id = p_fnd_request_id;

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;
866: l_parent_fnd_req_id pay_process_requests.fnd_request_id%TYPE;

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 895: fnd_request_id,

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,
898: process_flow_id,
899: last_update_date,

Line 896: parent_fnd_request_id,

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,
898: process_flow_id,
899: last_update_date,
900: last_updated_by,

Line 911: p_fnd_request_id,

907: validation_level ) values
908: (
909: pay_void_process_request_s1.NEXTVAL,
910: l_process_request_id,
911: p_fnd_request_id,
912: l_parent_fnd_req_id,
913: p_assignment_action_id,
914: l_process_flow_id,
915: null,