DBA Data[Home] [Help]

APPS.CSTPACWC dependencies on WIP_COST_TXN_INTERFACE

Line 2962: -- insert into wip_cost_txn_interface

2958:
2959: IF (l_count <> 0) THEN
2960:
2961: -----------------------------------------
2962: -- insert into wip_cost_txn_interface
2963: -----------------------------------------
2964: -- Get wip txn_id
2965: -----------------------------------------
2966: stmt_num := 440;

Line 2976: INSERT INTO wip_cost_txn_interface

2972: ----------------------------------------------------------------
2973: -- Insert into WCTI
2974: ----------------------------------------------------------------
2975: stmt_num := 460;
2976: INSERT INTO wip_cost_txn_interface
2977: (transaction_id,
2978: acct_period_id,
2979: process_status,
2980: process_phase,

Line 3133: FROM wip_cost_txn_interface wcti

3129: i_request_id,
3130: i_prog_appl_id,
3131: i_prog_id,
3132: sysdate
3133: FROM wip_cost_txn_interface wcti
3134: WHERE transaction_id = i_wcti_txn_id;
3135:
3136: /*------------------------------------------+
3137: | Do Accounting for wip valuation accounts

Line 3322: DELETE wip_cost_txn_interface

3318: WHERE TRANSACTION_ID = i_wcti_txn_id;
3319:
3320:
3321: stmt_num := 495;
3322: DELETE wip_cost_txn_interface
3323: WHERE transaction_id = i_wcti_txn_id;
3324:
3325: stmt_num := 500;
3326: UPDATE wip_period_balances wpb