DBA Data[Home] [Help]

APPS.OE_SCH_ORGANIZER_UTIL dependencies on OE_SCH_ID_LIST_TMP

Line 568: INSERT INTO OE_SCH_ID_LIST_TMP(line_id)

564: --R12.MOAC
565: PROCEDURE Insert_into_tmp_tab(p_line_id IN NUMBER)
566: IS
567: BEGIN
568: INSERT INTO OE_SCH_ID_LIST_TMP(line_id)
569: VALUES(p_line_id);
570:
571: END Insert_into_tmp_tab;
572:

Line 577: INSERT INTO OE_SCH_ID_LIST_TMP(line_id)

573: PROCEDURE Insert_into_tmp_tab(p_line_tbl IN OE_GLOBALS.Selected_Record_Tbl)
574: IS
575: BEGIN
576: FOR I IN 1..p_line_tbl.COUNT LOOP
577: INSERT INTO OE_SCH_ID_LIST_TMP(line_id)
578: VALUES(p_line_tbl(I).id1);
579: END LOOP;
580: END Insert_into_tmp_tab;
581:

Line 585: DELETE FROM OE_SCH_ID_LIST_TMP;

581:
582: PROCEDURE delete_tmp_tab
583: IS
584: BEGIN
585: DELETE FROM OE_SCH_ID_LIST_TMP;
586: END delete_tmp_tab;
587: /*--------------------------------------------------
588: PROCEDURE : Process_Schedule_Action
589: DESCRIPTION: This api will call oe_group_sch_util.schedule_multi_lines procedure per header_id