APPS.CSTPACMS dependencies on CST_COMP_SNAP_TEMP

Line 18: Transfer info from cst_comp_snap_temp to cst_comp_snapshot

14: BEGIN
15: stmt_num := 10;
16:
17: /*
18: Transfer info from cst_comp_snap_temp to cst_comp_snapshot
19: with transaction_id from MTL_MATERIAL_TRANSACTIONS
20: */
21: INSERT INTO cst_comp_snapshot
22: (transaction_id,

Line 58: cst_comp_snap_temp codt

54: -1,
55: -1,
56: sysdate
57: FROM
58: cst_comp_snap_temp codt
59: WHERE
60: transaction_temp_id = l_txn_temp_id;
61:
62: stmt_num := 20;

Line 66: Delete temporary info from cst_comp_snap_temp

62: stmt_num := 20;
63:
64:
65: /*
66: Delete temporary info from cst_comp_snap_temp
67: */
68: DELETE FROM cst_comp_snap_temp
69: WHERE
70: transaction_temp_id = l_txn_temp_id;

Line 68: DELETE FROM cst_comp_snap_temp

64:
65: /*
66: Delete temporary info from cst_comp_snap_temp
67: */
68: DELETE FROM cst_comp_snap_temp
69: WHERE
70: transaction_temp_id = l_txn_temp_id;
71:
72: stmt_num := 30;

Line 477: Transfer info from cst_comp_snap_interface to cst_comp_snap_temp

473: END IF;
474:
475: stmt_num := 15;
476: /*
477: Transfer info from cst_comp_snap_interface to cst_comp_snap_temp
478: with transaction_id from MTL_MATERIAL_TRANSACTIONS
479: */
480: INSERT INTO cst_comp_snap_temp
481: (transaction_temp_id,

Line 480: INSERT INTO cst_comp_snap_temp

476: /*
477: Transfer info from cst_comp_snap_interface to cst_comp_snap_temp
478: with transaction_id from MTL_MATERIAL_TRANSACTIONS
479: */
480: INSERT INTO cst_comp_snap_temp
481: (transaction_temp_id,
482: wip_entity_id,
483: operation_seq_num,
484: last_update_date,