APPS.INV_COST_GROUP_UPDATE dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2441: SELECT mtl_material_transactions_s.NEXTVAL

2437: l_cg_quantity_table(l_cost_group_id).new_transaction_temp_id := p_mmtt_rec.transaction_temp_id;
2438: l_cg_quantity_table(l_cost_group_id).update_mmtt := TRUE;
2439: ELSE
2440: -- otherwise generate a new_transaction_temp_id
2441: SELECT mtl_material_transactions_s.NEXTVAL
2442: INTO l_transaction_temp_id
2443: FROM dual;
2444: l_cg_quantity_table(l_cost_group_id).new_transaction_temp_id := l_transaction_temp_id;
2445: l_cg_quantity_table(l_cost_group_id).update_mmtt := FALSE;

Line 2924: SELECT mtl_material_transactions_s.NEXTVAL

2920: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := p_mmtt_rec.transaction_temp_id;
2921: l_cg_quantity_table(rec_msn.cost_group_id).update_mmtt := TRUE;
2922: ELSE
2923: -- otherwise generate a new_transaction_temp_id
2924: SELECT mtl_material_transactions_s.NEXTVAL
2925: INTO l_transaction_temp_id
2926: FROM dual;
2927: IF (l_debug = 1) THEN
2928: print_debug('l_transaction_temp_id: ' || l_transaction_temp_id);

Line 3482: SELECT mtl_material_transactions_s.NEXTVAL

3478: --Bug 3390284
3479: lot_cg_qty_table(rec_msn.cost_group_id).quantity := lot_cg_qty_table(rec_msn.cost_group_id).quantity + 1;
3480: --Bug 3390284
3481: ELSE
3482: SELECT mtl_material_transactions_s.NEXTVAL
3483: INTO l_transaction_temp_id
3484: FROM dual;
3485:
3486: l_serial_table(l_sti).new_serial_transaction_temp_id:= l_transaction_temp_id;

Line 3534: SELECT mtl_material_transactions_s.NEXTVAL

3530: --l_serial_table(l_sti).lot_number := rec_mtlt.lot_number;
3531: l_serial_table(l_sti).cost_group_id := rec_msn.cost_group_id;
3532: l_serial_table(l_sti).quantity := 1;
3533:
3534: SELECT mtl_material_transactions_s.NEXTVAL
3535: INTO l_transaction_temp_id
3536: FROM dual;
3537:
3538: --3390284

Line 3591: SELECT mtl_material_transactions_s.NEXTVAL

3587: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := p_mmtt_rec.transaction_temp_id;
3588: l_cg_quantity_table(rec_msn.cost_group_id).update_mmtt := TRUE;
3589: ELSE
3590: -- otherwise generate a new_transaction_temp_id
3591: SELECT mtl_material_transactions_s.NEXTVAL
3592: INTO l_transaction_temp_id
3593: FROM dual;
3594: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := l_transaction_temp_id;
3595: l_cg_quantity_table(rec_msn.cost_group_id).update_mmtt := FALSE;