DBA Data[Home] [Help]

APPS.BOM_CSTRIVTW_XMLP_PKG dependencies on CST_AP_VARIANCE_BATCHES

Line 172: CST_AP_VARIANCE_BATCHES

168: P_PROJECT_ID_v,
169: P_ADJUSTMENT_ACCOUNT_v,
170: P_CUTOFF_DATE_v
171: FROM
172: CST_AP_VARIANCE_BATCHES
173: WHERE BATCH_ID = LP_BATCH_ID;
174: IF (P_ITEM_ID_v IS NOT NULL) THEN
175: P_ITEM_OPTION_v := 2;
176: ELSE

Line 338: CST_AP_VARIANCE_BATCHES

334: NVL(ITEM_TYPE
335: ,0)
336: INTO L_SHOPFLOOR
337: FROM
338: CST_AP_VARIANCE_BATCHES
339: WHERE BATCH_ID = LP_BATCH_ID
340: AND ROWNUM = 1;
341: IF (P_TRANSACTION_PROCESS_MODE = 2 AND L_SHOPFLOOR <> 0) THEN
342: NULL;

Line 347: DELETE FROM CST_AP_VARIANCE_BATCHES CAVB

343: DELETE FROM CST_AP_VARIANCE_LINES CAVL
344: WHERE BATCH_ID = LP_BATCH_ID;
345: DELETE FROM CST_AP_VARIANCE_HEADERS CAVH
346: WHERE BATCH_ID = LP_BATCH_ID;
347: DELETE FROM CST_AP_VARIANCE_BATCHES CAVB
348: WHERE BATCH_ID = LP_BATCH_ID;
349: END IF;
350: END;
351: /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;