[Home] [Help]
4002: * This Transaction temp id will be associated
4003: * with the delivery line id at the end of processing
4004: * We will use this Transaction temp Id as the group Mark Id aslo.
4005: ********************/
4006: SELECT mtl_material_transactions_s.NEXTVAL
4007: INTO x_transaction_temp_id
4008: FROM DUAL;
4009:
4010: -- Update group_mark_id to reflect newly created transaction_temp_id
5625: DEBUG('The serial number control code is in 2,5', 'stage_lpns');
5626: END IF;
5627:
5628: IF (l_delivery_detail_tab(i).transaction_temp_id IS NULL) THEN
5629: SELECT mtl_material_transactions_s.NEXTVAL
5630: INTO l_delivery_detail_tab(i).transaction_temp_id
5631: FROM DUAL;
5632:
5633: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514
5894: DEBUG('The serial number control code is in 2,5', 'stage_lpns');
5895: END IF;
5896:
5897: IF (l_delivery_detail_tab(i).transaction_temp_id IS NULL) THEN
5898: SELECT mtl_material_transactions_s.NEXTVAL
5899: INTO l_delivery_detail_tab(i).transaction_temp_id
5900: FROM DUAL;
5901:
5902: l_invpcinrectype.transaction_temp_id := l_delivery_detail_tab(i).transaction_temp_id;
9104: END IF;
9105:
9106: -- get group_id
9107: BEGIN
9108: SELECT mtl_material_transactions_s.NEXTVAL
9109: INTO g_group_id
9110: FROM DUAL;
9111: EXCEPTION
9112: WHEN NO_DATA_FOUND THEN
9136: END IF;
9137:
9138: IF (l_processed_lines_tab(l_temp_index).serial_required_flag = 'Y') THEN
9139: BEGIN
9140: SELECT mtl_material_transactions_s.NEXTVAL
9141: INTO l_trx_temp_id
9142: FROM DUAL;
9143: EXCEPTION
9144: WHEN NO_DATA_FOUND THEN
10114: -- first time line is being processed
10115: -- insert
10116: IF (l_serial_required_flag = 'Y') THEN
10117: BEGIN
10118: SELECT mtl_material_transactions_s.NEXTVAL
10119: INTO l_trx_temp_id
10120: FROM DUAL;
10121: EXCEPTION
10122: WHEN NO_DATA_FOUND THEN
10220: , p_inventory_item_id
10221: , l_processed_quantity
10222: , 'Y'
10223: , l_serial_required_flag
10224: , decode(l_serial_required_flag,'Y',mtl_material_transactions_s.NEXTVAL,l_trx_temp_id)
10225: , g_creation_date
10226: , g_created_by
10227: , g_last_update_date
10228: , g_last_updated_by