APPS.CSTPPCIT dependencies on MTL_TXN_COST_DET_INTERFACE

Line 200: FROM MTL_TXN_COST_DET_INTERFACE

196: */
197: l_stmt_num := 100;
198: SELECT count(*)
199: INTO l_num_details
200: FROM MTL_TXN_COST_DET_INTERFACE
201: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
202:
203: IF ( i_new_avg_cost IS NOT NULL AND i_per_change IS NULL AND i_val_change IS NULL ) THEN
204: l_stmt_num := 110;

Line 208: FROM MTL_TXN_COST_DET_INTERFACE

204: l_stmt_num := 110;
205: l_count := 0;
206: SELECT count(*), SUM(new_average_cost)
207: INTO l_count, l_sum_new_cost
208: FROM MTL_TXN_COST_DET_INTERFACE
209: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id AND NVL(new_average_cost,-1) >= 0
210: AND percentage_change IS NULL AND value_change IS NULL;
211: IF (l_count <> l_num_details OR l_sum_new_cost <> i_new_avg_cost) THEN
212: l_err_num := 999;

Line 223: FROM MTL_TXN_COST_DET_INTERFACE

219: l_stmt_num := 120;
220: l_count := 0;
221: SELECT count(*)
222: INTO l_count
223: FROM MTL_TXN_COST_DET_INTERFACE
224: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id AND new_average_cost IS NULL
225: AND NVL(percentage_change,-999) >= -100 AND value_change IS NULL;
226: IF (l_count <> l_num_details) THEN
227: l_err_num := 999;

Line 238: FROM MTL_TXN_COST_DET_INTERFACE

234: l_stmt_num := 130;
235: l_count := 0;
236: SELECT count(*), SUM(value_change)
237: INTO l_count, l_sum_value_change
238: FROM MTL_TXN_COST_DET_INTERFACE
239: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id AND new_average_cost IS NULL
240: AND percentage_change IS NULL AND value_change IS NOT NULL;
241: IF (l_count <> l_num_details OR l_sum_value_change <> i_val_change) THEN
242: l_err_num := 999;

Line 350: FROM MTL_TXN_COST_DET_INTERFACE

346:
347:
348: SELECT count(*)
349: INTO l_num_detail
350: FROM MTL_TXN_COST_DET_INTERFACE
351: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
352:
353: SELECT legal_entity
354: INTO l_legal_entity

Line 365: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE

361: WHERE cost_type_id = i_cost_type_id
362: AND legal_entity = l_legal_entity
363: AND i_transaction_date between period_start_date and period_end_date;
364:
365: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE
366: * OR i_txn_interface_id is null.
367: * In this case, call cstpacit.cost_det_new_insert.
368: */
369:

Line 428: FROM MTL_TXN_COST_DET_INTERFACE

424: i_request_id,
425: i_prog_appl_id,
426: i_prog_id,
427: sysdate
428: FROM MTL_TXN_COST_DET_INTERFACE
429: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
430:
431: END IF;
432: