DBA Data[Home] [Help]

APPS.CSTPSMUT dependencies on CST_INV_SUB_LEDGER_ID_S

Line 4472: SET INV_SUB_LEDGER_ID = CST_INV_SUB_LEDGER_ID_S.NEXTVAL

4468: l_rows_inserted := l_rows_inserted + SQL%ROWCOUNT;
4469:
4470: /* R12 - Sub Ledger Unique Identifier */
4471: UPDATE MTL_TRANSACTION_ACCOUNTS
4472: SET INV_SUB_LEDGER_ID = CST_INV_SUB_LEDGER_ID_S.NEXTVAL
4473: WHERE TRANSACTION_ID = p_mtl_txn_id;
4474:
4475: IF (l_rows_inserted > 0) and (p_debug = 'Y')THEN
4476: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(l_rows_inserted)

Line 4730: SET INV_SUB_LEDGER_ID = CST_INV_SUB_LEDGER_ID_S.NEXTVAL

4726: HAVING ROUND(p_total_cost/p_min_acct_unit)*p_min_acct_unit <> 0;
4727: l_rows_inserted := SQL%ROWCOUNT;
4728:
4729: UPDATE MTL_TRANSACTION_ACCOUNTS
4730: SET INV_SUB_LEDGER_ID = CST_INV_SUB_LEDGER_ID_S.NEXTVAL
4731: WHERE TRANSACTION_ID = p_mtl_txn_id;
4732:
4733: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN
4734: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)