172: | across all accounting periods. |
173: +------------------------------------------------------------------------*/
174: l_stmt_num := 30;
175:
176: INSERT INTO wip_transaction_accounts
177: (transaction_id,
178: reference_account,
179: last_update_date,
180: last_updated_by,
296: | across all accounting periods. |
297: +------------------------------------------------------------------------*/
298: l_stmt_num := 40;
299:
300: INSERT INTO wip_transaction_accounts
301: (transaction_id,
302: reference_account,
303: last_update_date,
304: last_updated_by,
415: CLOSE c_transactions;
416:
417: l_stmt_num := 46;
418: FORALL l_index in l_transaction_t.FIRST..l_transaction_t.LAST
419: UPDATE WIP_TRANSACTION_ACCOUNTS
420: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
421: WHERE TRANSACTION_ID = l_transaction_t(l_index);
422:
423: l_stmt_num := 47;