4301: /*------------------------------------------------------------+
4302: | Generate transaction_id for WIP_TXN_ALLOCATIONS |
4303: +------------------------------------------------------------*/
4304: UPDATE wip_cost_txn_interface
4305: SET transaction_id = wip_transactions_s.nextval
4306: WHERE group_id = p_gib.group_id
4307: AND TRUNC(transaction_date) = TRUNC(p_gib.txn_date)
4308: AND transaction_type = WIP_CONSTANTS.RES_TXN;
4309:
5590: /*------------------------------------------------------------+
5591: | Generate transaction_id for WIP_TXN_ALLOCATIONS |
5592: +------------------------------------------------------------*/
5593: UPDATE wip_cost_txn_interface
5594: SET transaction_id = wip_transactions_s.nextval
5595: WHERE group_id = p_gib.group_id
5596: AND TRUNC(transaction_date) = TRUNC(p_gib.txn_date)
5597: AND transaction_type = WIP_CONSTANTS.OVHD_TXN;
5598: