DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on OE_SCH_CONC_REQUESTS

Line 579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN

575: resultout := 'COMPLETE:INCOMPLETE';
576: OE_STANDARD_WF.Save_Messages;
577: OE_STANDARD_WF.Clear_Msg_Context;
578: --5166476
579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
580: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
581: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
582: END IF;
583:

Line 580: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

576: OE_STANDARD_WF.Save_Messages;
577: OE_STANDARD_WF.Clear_Msg_Context;
578: --5166476
579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
580: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
581: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
582: END IF;
583:
584: OE_Delayed_Requests_PVT.Clear_Request

Line 581: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

577: OE_STANDARD_WF.Clear_Msg_Context;
578: --5166476
579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
580: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
581: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
582: END IF;
583:
584: OE_Delayed_Requests_PVT.Clear_Request
585: (x_return_status => l_return_status);

Line 594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN

590: resultout := 'COMPLETE:INCOMPLETE';
591: OE_STANDARD_WF.Save_Messages;
592: OE_STANDARD_WF.Clear_Msg_Context;
593: --5166476
594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
595: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
596: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
597: END IF;
598:

Line 595: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

591: OE_STANDARD_WF.Save_Messages;
592: OE_STANDARD_WF.Clear_Msg_Context;
593: --5166476
594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
595: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
596: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
597: END IF;
598:
599: OE_Delayed_Requests_PVT.Clear_Request

Line 596: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

592: OE_STANDARD_WF.Clear_Msg_Context;
593: --5166476
594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
595: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
596: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
597: END IF;
598:
599: OE_Delayed_Requests_PVT.Clear_Request
600: (x_return_status => l_return_status);

Line 616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN

612: resultout := 'COMPLETE:INCOMPLETE';
613: OE_STANDARD_WF.Save_Messages;
614: OE_STANDARD_WF.Clear_Msg_Context;
615: --5166476
616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
617: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
618: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
619: END IF;
620:

Line 617: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

613: OE_STANDARD_WF.Save_Messages;
614: OE_STANDARD_WF.Clear_Msg_Context;
615: --5166476
616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
617: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
618: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
619: END IF;
620:
621: OE_Delayed_Requests_PVT.Clear_Request

Line 618: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

614: OE_STANDARD_WF.Clear_Msg_Context;
615: --5166476
616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
617: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
618: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
619: END IF;
620:
621: OE_Delayed_Requests_PVT.Clear_Request
622: (x_return_status => l_return_status);

Line 629: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN

625: IF Is_Scheduling_Eligible(l_ato_line_id) THEN ---- Bug3083995
626: ROLLBACK TO Before_Lock;
627: resultout := 'COMPLETE:INCOMPLETE';
628: --5166476
629: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
630: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
632: END IF;
633:

Line 630: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

626: ROLLBACK TO Before_Lock;
627: resultout := 'COMPLETE:INCOMPLETE';
628: --5166476
629: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
630: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
632: END IF;
633:
634: OE_STANDARD_WF.Save_Messages;

Line 631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

627: resultout := 'COMPLETE:INCOMPLETE';
628: --5166476
629: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
630: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
632: END IF;
633:
634: OE_STANDARD_WF.Save_Messages;
635: OE_STANDARD_WF.Clear_Msg_Context;

Line 652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN

648: resultout := 'COMPLETE:INCOMPLETE';
649: OE_STANDARD_WF.Save_Messages;
650: OE_STANDARD_WF.Clear_Msg_Context;
651: --5166476
652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
653: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
654: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
655: END IF;
656:

Line 653: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

649: OE_STANDARD_WF.Save_Messages;
650: OE_STANDARD_WF.Clear_Msg_Context;
651: --5166476
652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
653: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
654: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
655: END IF;
656:
657: OE_Delayed_Requests_PVT.Clear_Request

Line 654: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

650: OE_STANDARD_WF.Clear_Msg_Context;
651: --5166476
652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
653: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
654: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
655: END IF;
656:
657: OE_Delayed_Requests_PVT.Clear_Request
658: (x_return_status => l_return_status);

Line 665: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN

661: IF Is_Scheduling_Eligible(l_link_to_line_id) THEN -- Bug3083995
662: ROLLBACK TO Before_Lock;
663: resultout := 'COMPLETE:INCOMPLETE';
664: --5166476
665: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
666: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
668: END IF;
669:

Line 666: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

662: ROLLBACK TO Before_Lock;
663: resultout := 'COMPLETE:INCOMPLETE';
664: --5166476
665: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
666: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
668: END IF;
669:
670: OE_STANDARD_WF.Save_Messages;

Line 667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

663: resultout := 'COMPLETE:INCOMPLETE';
664: --5166476
665: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
666: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
668: END IF;
669:
670: OE_STANDARD_WF.Save_Messages;
671: OE_STANDARD_WF.Clear_Msg_Context;

Line 926: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN

922: --commit; /* Added this line to fix the bug 2884452 */
923: OE_Delayed_Requests_PVT.Clear_Request
924: (x_return_status => l_return_status);
925: --5122730
926: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
927: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
930: END IF;

Line 927: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476

923: OE_Delayed_Requests_PVT.Clear_Request
924: (x_return_status => l_return_status);
925: --5122730
926: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
927: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
930: END IF;
931: END IF;

Line 928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';

924: (x_return_status => l_return_status);
925: --5122730
926: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
927: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
930: END IF;
931: END IF;
932:

Line 929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';

925: --5122730
926: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
927: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
930: END IF;
931: END IF;
932:
933: return;

Line 948: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN

944: OE_Delayed_Requests_PVT.Clear_Request
945: (x_return_status => l_return_status);
946: -- app_exception.raise_exception;
947: --5122730
948: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
952: END IF;

Line 949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476

945: (x_return_status => l_return_status);
946: -- app_exception.raise_exception;
947: --5122730
948: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
952: END IF;
953: END IF;

Line 950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';

946: -- app_exception.raise_exception;
947: --5122730
948: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
952: END IF;
953: END IF;
954: return;

Line 951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';

947: --5122730
948: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
952: END IF;
953: END IF;
954: return;
955: END IF;