APPS.INV_INVKBCPR_XMLP_PKG dependencies on MTL_KANBAN_CARD_PRINT_TEMP

Line 120: P_CALL_WHERE := P_CALL_WHERE || ' AND (MKC.KANBAN_CARD_ID IN ( SELECT MKBNT.KANBAN_CARD_ID FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT

116: ELSIF P_CALL_FROM = 2 THEN
117: --in case for multiple cards from adf page also p_call_from has to be 2
118: --in case of pullsequence id also from adf page p_call_from has to be 2
119: IF P_REPORT_ID IS NOT NULL THEN
120: P_CALL_WHERE := P_CALL_WHERE || ' AND (MKC.KANBAN_CARD_ID IN ( SELECT MKBNT.KANBAN_CARD_ID FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT
121: WHERE MKBNT.REPORT_ID = ' || TO_CHAR(P_REPORT_ID) || ')
122: OR MKC.KANBAN_CARD_ID IN ( SELECT MKC.KANBAN_CARD_ID FROM MTL_KANBAN_CARDS MKC WHERE
123: MKC.PULL_SEQUENCE_ID IN ( SELECT MKBNT.PULL_SEQUENCE_ID
124: FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT

Line 124: FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT

120: P_CALL_WHERE := P_CALL_WHERE || ' AND (MKC.KANBAN_CARD_ID IN ( SELECT MKBNT.KANBAN_CARD_ID FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT
121: WHERE MKBNT.REPORT_ID = ' || TO_CHAR(P_REPORT_ID) || ')
122: OR MKC.KANBAN_CARD_ID IN ( SELECT MKC.KANBAN_CARD_ID FROM MTL_KANBAN_CARDS MKC WHERE
123: MKC.PULL_SEQUENCE_ID IN ( SELECT MKBNT.PULL_SEQUENCE_ID
124: FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT
125: WHERE MKBNT.REPORT_ID = ' || TO_CHAR(P_REPORT_ID) || ')))';
126: END IF;
127: ELSIF P_CALL_FROM = 3 THEN
128: IF P_KANBAN_CARD_ID IS NOT NULL THEN

Line 154: DELETE FROM MTL_KANBAN_CARD_PRINT_TEMP

150: --Added as part of ekanban by javakat
151: --where 4 is cal from adf page
152: IF P_CALL_FROM IN ( 2 ,4) THEN
153: BEGIN
154: DELETE FROM MTL_KANBAN_CARD_PRINT_TEMP
155: WHERE REPORT_ID = P_REPORT_ID;
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN
158: NULL;

Line 213: SELECT mtl_kanban_card_print_temp_s.NEXTVAL

209: 'Call from is 3 and Pull sequence is Passed'
210: );
211: IF v_report_id IS NULL
212: THEN
213: SELECT mtl_kanban_card_print_temp_s.NEXTVAL
214: INTO v_report_id
215: FROM DUAL;
216: END IF;
217:

Line 218: INSERT INTO mtl_kanban_card_print_temp

214: INTO v_report_id
215: FROM DUAL;
216: END IF;
217:
218: INSERT INTO mtl_kanban_card_print_temp
219: (report_id, kanban_card_id
220: )
221: select v_report_id,kanban_card_id from MTL_KANBAN_CARDS_V
222: where pull_sequence_id=pull_sequence_id;

Line 239: SELECT mtl_kanban_card_print_temp_s.NEXTVAL

235: INTO l_value
236: FROM DUAL;
237: IF v_report_id IS NULL
238: THEN
239: SELECT mtl_kanban_card_print_temp_s.NEXTVAL
240: INTO v_report_id
241: FROM DUAL;
242: END IF;
243:

Line 244: INSERT INTO mtl_kanban_card_print_temp

240: INTO v_report_id
241: FROM DUAL;
242: END IF;
243:
244: INSERT INTO mtl_kanban_card_print_temp
245: (report_id, kanban_card_id
246: )
247: VALUES (v_report_id, l_value
248: );