APPS.FLM_AUTO_REPLENISHMENT dependencies on MTL_KANBAN_CARD_PRINT_TEMP

Line 647: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval INTO l_report_id FROM dual;

643: l_territory VARCHAR2 (10);
644:
645: BEGIN
646:
647: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval INTO l_report_id FROM dual;
648:
649: FOR l_card_count in 1..p_Kanban_Card_Ids.COUNT LOOP
650: INSERT into MTL_KANBAN_CARD_PRINT_TEMP( REPORT_ID,KANBAN_CARD_ID)
651: VALUES (l_report_id,p_Kanban_Card_Ids(l_card_count));

Line 650: INSERT into MTL_KANBAN_CARD_PRINT_TEMP( REPORT_ID,KANBAN_CARD_ID)

646:
647: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval INTO l_report_id FROM dual;
648:
649: FOR l_card_count in 1..p_Kanban_Card_Ids.COUNT LOOP
650: INSERT into MTL_KANBAN_CARD_PRINT_TEMP( REPORT_ID,KANBAN_CARD_ID)
651: VALUES (l_report_id,p_Kanban_Card_Ids(l_card_count));
652: END LOOP; -- end of for loop
653:
654: IF NVL(FND_PROFILE.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 THEN

Line 704: DELETE FROM mtl_kanban_card_print_temp WHERE report_id = l_report_id;

700: l_report_id /* p_report_id */
701: );
702:
703: IF l_req_id = 0 THEN
704: DELETE FROM mtl_kanban_card_print_temp WHERE report_id = l_report_id;
705: END IF;
706: Commit;
707:
708: END Print_Kanban_Cards;