DBA Data[Home] [Help]

APPS.CSTPSMUT dependencies on CST_WIP_SUB_LEDGER_ID_S

Line 4650: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL

4646: 4,p_pl_osp_cost,
4647: 5,p_pl_ovh_cost)/p_min_acct_unit)*p_min_acct_unit <> 0;
4648:
4649: UPDATE WIP_TRANSACTION_ACCOUNTS
4650: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
4651: WHERE TRANSACTION_ID = p_wip_txn_id;
4652: l_rows_inserted := l_rows_inserted + SQL%ROWCOUNT;
4653: END LOOP;
4654:

Line 4798: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL

4794: WHERE res.transaction_id = p_sm_txn_id
4795: HAVING NVL(ROUND(p_total_cost/p_min_acct_unit)*p_min_acct_unit,0) <> 0;
4796:
4797: UPDATE WIP_TRANSACTION_ACCOUNTS
4798: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
4799: WHERE TRANSACTION_ID = p_wip_txn_id;
4800: l_rows_inserted := SQL%ROWCOUNT;
4801: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN
4802: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted) || 'row(s) inserted ' ||