APPS.INVKBCGN dependencies on MTL_KANBAN_CARD_PRINT_TEMP

Line 365: from mtl_kanban_card_print_temp

361: OR (source_type in (1,2,3,4) AND
362: --release_kanban_flag = 1 AND
363: x_report_id IS NOT NULL and
364: pull_sequence_id in (select pull_sequence_id
365: from mtl_kanban_card_print_temp
366: where x_report_id = report_id))
367: for update of organization_id NOWAIT;
368:
369: KBCC MKPSC%ROWTYPE;

Line 1495: select MTL_KANBAN_CARD_PRINT_TEMP_S.nextval

1491: end if;
1492:
1493: if X_PRINT_KANBAN_CARD = INVKBCGN.flm_ekb_yes then
1494: if X_REPORT_ID IS NULL then
1495: select MTL_KANBAN_CARD_PRINT_TEMP_S.nextval
1496: into l_report_id from DUAL;
1497: X_REPORT_ID := l_report_id;
1498: end if;
1499: for l_card_count in 1..l_kanban_card_Ids.count

Line 1501: insert into MTL_KANBAN_CARD_PRINT_TEMP

1497: X_REPORT_ID := l_report_id;
1498: end if;
1499: for l_card_count in 1..l_kanban_card_Ids.count
1500: LOOP
1501: insert into MTL_KANBAN_CARD_PRINT_TEMP
1502: (REPORT_ID,KANBAN_CARD_ID)
1503: values ( x_report_id, l_kanban_card_Ids(l_card_count) );
1504: END LOOP;
1505: end if;

Line 1836: delete from MTL_KANBAN_CARD_PRINT_TEMP

1832: );
1833:
1834: PUT_LINE( fnd_message.get );
1835: if v_req_id = 0 then
1836: delete from MTL_KANBAN_CARD_PRINT_TEMP
1837: where
1838: report_id = X_REPORT_ID;
1839: end if;
1840: END print_kanban_report;