DBA Data[Home] [Help]

APPS.OE_SCH_ORGANIZER_UTIL dependencies on OE_SCH_ID_LIST_TMP

Line 553: INSERT INTO OE_SCH_ID_LIST_TMP(line_id)

549: --R12.MOAC
550: PROCEDURE Insert_into_tmp_tab(p_line_id IN NUMBER)
551: IS
552: BEGIN
553: INSERT INTO OE_SCH_ID_LIST_TMP(line_id)
554: VALUES(p_line_id);
555:
556: END Insert_into_tmp_tab;
557:

Line 562: INSERT INTO OE_SCH_ID_LIST_TMP(line_id)

558: PROCEDURE Insert_into_tmp_tab(p_line_tbl IN OE_GLOBALS.Selected_Record_Tbl)
559: IS
560: BEGIN
561: FOR I IN 1..p_line_tbl.COUNT LOOP
562: INSERT INTO OE_SCH_ID_LIST_TMP(line_id)
563: VALUES(p_line_tbl(I).id1);
564: END LOOP;
565: END Insert_into_tmp_tab;
566:

Line 570: DELETE FROM OE_SCH_ID_LIST_TMP;

566:
567: PROCEDURE delete_tmp_tab
568: IS
569: BEGIN
570: DELETE FROM OE_SCH_ID_LIST_TMP;
571: END delete_tmp_tab;
572: /*--------------------------------------------------
573: PROCEDURE : Process_Schedule_Action
574: DESCRIPTION: This api will call oe_group_sch_util.schedule_multi_lines procedure per header_id