DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on OE_SCH_CONC_REQUESTS

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

619: resultout := 'COMPLETE:INCOMPLETE';
620: OE_STANDARD_WF.Save_Messages;
621: OE_STANDARD_WF.Clear_Msg_Context;
622: --5166476
623: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
624: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
625: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
626: END IF;
627:

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

620: OE_STANDARD_WF.Save_Messages;
621: OE_STANDARD_WF.Clear_Msg_Context;
622: --5166476
623: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
624: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
625: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
626: END IF;
627:
628: OE_Delayed_Requests_PVT.Clear_Request

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

621: OE_STANDARD_WF.Clear_Msg_Context;
622: --5166476
623: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
624: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
625: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
626: END IF;
627:
628: OE_Delayed_Requests_PVT.Clear_Request
629: (x_return_status => l_return_status);

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

634: resultout := 'COMPLETE:INCOMPLETE';
635: OE_STANDARD_WF.Save_Messages;
636: OE_STANDARD_WF.Clear_Msg_Context;
637: --5166476
638: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
639: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
640: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
641: END IF;
642:

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

635: OE_STANDARD_WF.Save_Messages;
636: OE_STANDARD_WF.Clear_Msg_Context;
637: --5166476
638: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
639: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
640: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
641: END IF;
642:
643: OE_Delayed_Requests_PVT.Clear_Request

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

636: OE_STANDARD_WF.Clear_Msg_Context;
637: --5166476
638: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
639: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
640: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
641: END IF;
642:
643: OE_Delayed_Requests_PVT.Clear_Request
644: (x_return_status => l_return_status);

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

659: resultout := 'COMPLETE:INCOMPLETE';
660: OE_STANDARD_WF.Save_Messages;
661: OE_STANDARD_WF.Clear_Msg_Context;
662: --5166476
663: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
664: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
665: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
666: END IF;
667:

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

660: OE_STANDARD_WF.Save_Messages;
661: OE_STANDARD_WF.Clear_Msg_Context;
662: --5166476
663: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
664: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
665: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
666: END IF;
667:
668: OE_Delayed_Requests_PVT.Clear_Request

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

661: OE_STANDARD_WF.Clear_Msg_Context;
662: --5166476
663: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
664: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
665: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
666: END IF;
667:
668: OE_Delayed_Requests_PVT.Clear_Request
669: (x_return_status => l_return_status);

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

672: IF Is_Scheduling_Eligible(l_ato_line_id) THEN ---- Bug3083995
673: ROLLBACK TO Before_Lock;
674: resultout := 'COMPLETE:INCOMPLETE';
675: --5166476
676: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
677: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
678: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
679: END IF;
680:

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

673: ROLLBACK TO Before_Lock;
674: resultout := 'COMPLETE:INCOMPLETE';
675: --5166476
676: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
677: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
678: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
679: END IF;
680:
681: OE_STANDARD_WF.Save_Messages;

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

674: resultout := 'COMPLETE:INCOMPLETE';
675: --5166476
676: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
677: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
678: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
679: END IF;
680:
681: OE_STANDARD_WF.Save_Messages;
682: OE_STANDARD_WF.Clear_Msg_Context;

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

699: resultout := 'COMPLETE:INCOMPLETE';
700: OE_STANDARD_WF.Save_Messages;
701: OE_STANDARD_WF.Clear_Msg_Context;
702: --5166476
703: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
704: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
705: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
706: END IF;
707:

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

700: OE_STANDARD_WF.Save_Messages;
701: OE_STANDARD_WF.Clear_Msg_Context;
702: --5166476
703: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
704: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
705: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
706: END IF;
707:
708: OE_Delayed_Requests_PVT.Clear_Request

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

701: OE_STANDARD_WF.Clear_Msg_Context;
702: --5166476
703: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
704: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
705: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
706: END IF;
707:
708: OE_Delayed_Requests_PVT.Clear_Request
709: (x_return_status => l_return_status);

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

712: IF Is_Scheduling_Eligible(l_link_to_line_id) THEN -- Bug3083995
713: ROLLBACK TO Before_Lock;
714: resultout := 'COMPLETE:INCOMPLETE';
715: --5166476
716: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
717: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
718: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
719: END IF;
720:

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

713: ROLLBACK TO Before_Lock;
714: resultout := 'COMPLETE:INCOMPLETE';
715: --5166476
716: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
717: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
718: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
719: END IF;
720:
721: OE_STANDARD_WF.Save_Messages;

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

714: resultout := 'COMPLETE:INCOMPLETE';
715: --5166476
716: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
717: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
718: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
719: END IF;
720:
721: OE_STANDARD_WF.Save_Messages;
722: OE_STANDARD_WF.Clear_Msg_Context;

Line 732: IF NVL(OE_SCH_CONC_REQUESTS.g_checked_for_holds, 'N') <> 'Y' THEN -- ER 13114460

728:
729: END IF;
730: END IF; -- 3565621
731: --
732: IF NVL(OE_SCH_CONC_REQUESTS.g_checked_for_holds, 'N') <> 'Y' THEN -- ER 13114460
733: IF l_debug_level > 0 THEN
734: oe_debug_pub.add( 'CALLING CHECK HOLDS' , 1 ) ;
735: END IF;
736:

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

1027: --commit; /* Added this line to fix the bug 2884452 */
1028: OE_Delayed_Requests_PVT.Clear_Request
1029: (x_return_status => l_return_status);
1030: --5122730
1031: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1032: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1033: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1034: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1035: END IF;

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

1028: OE_Delayed_Requests_PVT.Clear_Request
1029: (x_return_status => l_return_status);
1030: --5122730
1031: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1032: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1033: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1034: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1035: END IF;
1036: END IF;

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

1029: (x_return_status => l_return_status);
1030: --5122730
1031: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1032: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1033: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1034: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1035: END IF;
1036: END IF;
1037:

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

1030: --5122730
1031: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1032: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1033: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1034: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1035: END IF;
1036: END IF;
1037:
1038: return;

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

1049: OE_Delayed_Requests_PVT.Clear_Request
1050: (x_return_status => l_return_status);
1051: -- app_exception.raise_exception;
1052: --5122730
1053: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1054: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1055: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1056: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1057: END IF;

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

1050: (x_return_status => l_return_status);
1051: -- app_exception.raise_exception;
1052: --5122730
1053: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1054: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1055: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1056: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1057: END IF;
1058: END IF;

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

1051: -- app_exception.raise_exception;
1052: --5122730
1053: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1054: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1055: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1056: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1057: END IF;
1058: END IF;
1059: return;

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

1052: --5122730
1053: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1054: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1055: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1056: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1057: END IF;
1058: END IF;
1059: return;
1060: END IF;