APPS.INV_INVKBCPR_XMLP_PKG dependencies on MTL_KANBAN_CARD_PRINT_TEMP

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

114: P_CALL_WHERE := P_CALL_WHERE || ' AND ' || P_LOC_WHERE;
115: END IF;
116: ELSIF P_CALL_FROM = 2 THEN
117: IF P_REPORT_ID IS NOT NULL THEN
118: P_CALL_WHERE := P_CALL_WHERE || ' AND (MKC.KANBAN_CARD_ID IN ( SELECT MKBNT.KANBAN_CARD_ID FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT
119: WHERE MKBNT.REPORT_ID = ' || TO_CHAR(P_REPORT_ID) || ')
120: OR MKC.KANBAN_CARD_ID IN ( SELECT MKC.KANBAN_CARD_ID FROM MTL_KANBAN_CARDS MKC WHERE
121: MKC.PULL_SEQUENCE_ID IN ( SELECT MKBNT.PULL_SEQUENCE_ID
122: FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT

Line 122: FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT

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

Line 149: DELETE FROM MTL_KANBAN_CARD_PRINT_TEMP

145: FUNCTION AFTERREPORT RETURN BOOLEAN IS
146: BEGIN
147: IF P_CALL_FROM = 2 THEN
148: BEGIN
149: DELETE FROM MTL_KANBAN_CARD_PRINT_TEMP
150: WHERE REPORT_ID = P_REPORT_ID;
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153: NULL;