[Home] [Help]
265:
266: BEGIN
267: SELECT '1'
268: INTO l_dummy
269: FROM dual
270: WHERE exists (SELECT '1'
271: FROM mtl_txn_request_lines mtrl
272: WHERE mtrl.lpn_id = p_lpn_id
273: AND mtrl.organization_id = p_org_id
295: l_dummy VARCHAR2(1);
296: BEGIN
297: SELECT '1'
298: INTO l_dummy
299: FROM dual
300: WHERE exists (SELECT '1'
301: FROM wms_lpn_contents wlc
302: , wms_license_plate_numbers wlpn
303: , mtl_system_items msi
2869: END IF;
2870:
2871: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
2872: INTO l_lpn_grp_id
2873: FROM DUAL;
2874:
2875: UPDATE rcv_transactions_interface
2876: SET lpn_group_id = l_lpn_grp_id
2877: WHERE interface_transaction_id = l_lpn_grp_null.interface_transaction_id;
2952: END IF;
2953:
2954: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
2955: INTO l_lpn_grp_id
2956: FROM DUAL;
2957:
2958: UPDATE rcv_transactions_interface
2959: SET lpn_group_id = l_lpn_grp_id
2960: -- don't use shipment_num see update above ****
5005: --been validated by the ui already}}
5006: BEGIN
5007: SELECT 1
5008: INTO l_loaded
5009: FROM dual
5010: WHERE exists
5011: (SELECT 1
5012: FROM wms_dispatched_tasks wdt
5013: , mtl_material_transactions_temp mmtt
5406:
5407: BEGIN
5408: SELECT 1
5409: INTO l_loaded
5410: FROM dual
5411: WHERE exists
5412: (SELECT 1
5413: FROM wms_dispatched_tasks wdt
5414: , mtl_material_transactions_temp mmtt
7153:
7154: BEGIN
7155: SELECT 1
7156: INTO l_loaded
7157: FROM dual
7158: WHERE exists
7159: (SELECT 1
7160: FROM wms_dispatched_tasks wdt
7161: , mtl_material_transactions_temp mmtt
10511: l_progress := 'WMSINB-15850';
10512:
10513: SELECT rcv_transactions_interface_s.NEXTVAL
10514: INTO l_interface_transaction_id
10515: FROM DUAL;
10516:
10517: l_progress := 'WMSINB-15856';
10518:
10519: l_user_id := fnd_global.user_id;
11029:
11030: if l_lot_interface_id is null then
11031: SELECT mtl_material_transactions_s.NEXTVAL
11032: INTO l_lot_Interface_Id
11033: FROM DUAL;
11034: End if;
11035:
11036: l_serial_interface_id := null;
11037:
11047: -- Generate the serial interface id here
11048: if l_serial_interface_id is null then
11049: SELECT mtl_material_transactions_s.NEXTVAL
11050: INTO l_serial_Interface_Id
11051: FROM DUAL;
11052: End if;
11053:
11054: insert_msni(p_product_transaction_id => l_interface_transaction_id,
11055: p_product_code => 'RCV',
11110: -- Generate the serial interface id here
11111: if l_serial_interface_id is null then
11112: SELECT mtl_material_transactions_s.NEXTVAL
11113: INTO l_serial_Interface_Id
11114: FROM DUAL;
11115: End if;
11116:
11117: insert_msni(p_product_transaction_id => l_interface_transaction_id,
11118: p_product_code => 'RCV',
11543: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
11544: IF l_lot_interface_id IS NULL THEN
11545: SELECT mtl_material_transactions_s.NEXTVAL
11546: INTO l_lot_interface_id
11547: FROM DUAL;
11548: END IF;
11549:
11550: IF (l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_prim_uom_code) THEN
11551: l_prim_qty_to_insert := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id
11697: FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
11698: IF l_serial_interface_id IS NULL THEN
11699: SELECT mtl_material_transactions_s.NEXTVAL
11700: INTO l_serial_Interface_Id
11701: FROM DUAL;
11702: END IF;
11703:
11704: IF (l_debug = 1) THEN
11705: print_debug('Inserting MSNI for serial: '||l_rti_serial_tb(l_rti_index)(j),4);
11727: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
11728: IF l_lot_interface_id IS NULL THEN
11729: SELECT mtl_material_transactions_s.NEXTVAL
11730: INTO l_lot_interface_id
11731: FROM DUAL;
11732: END IF;
11733:
11734: IF (l_debug = 1) THEN
11735: print_debug('Inserting MTLI for lot: '||l_mol_mmtt_ctnt_tb(i).lot_number||
13656: IF (Nvl(g_lpn_group_id,-999) <> p_lpn_group_id) THEN
13657: g_lpn_group_id := p_lpn_group_id;
13658: SELECT wms_epc_s2.NEXTVAL
13659: INTO g_epc_group_id
13660: FROM dual;
13661: END IF;
13662:
13663: IF (l_debug = 1) THEN
13664: print_debug('Calling populate_outside_epc',4);
16912: IF (l_mtli_rec.serial_transaction_temp_id IS NOT NULL)
16913: THEN
16914: SELECT mtl_material_transactions_s.NEXTVAL
16915: INTO l_new_serial_txn_temp_id
16916: FROM DUAL;
16917: ELSE
16918: l_new_serial_txn_temp_id := NULL;
16919: END IF;
16920:
18343: IF (l_lot_control_code = 1) THEN
18344: BEGIN
18345: SELECT '1'
18346: INTO l_dummy
18347: FROM dual
18348: WHERE exists (SELECT 1
18349: FROM mtl_transaction_lots_temp
18350: WHERE product_code = 'RCV'
18351: AND product_transaction_id = l_rti_id);
18369: IF (l_serial_number_control_code = 1) THEN
18370: BEGIN
18371: SELECT '1'
18372: INTO l_dummy
18373: FROM dual
18374: WHERE exists (SELECT 1
18375: FROM mtl_serial_numbers_temp
18376: WHERE product_code = 'RCV'
18377: AND product_transaction_id = l_rti_id);
19980: l_dummy := '0';
19981: BEGIN
19982: SELECT '1'
19983: INTO l_dummy
19984: FROM dual
19985: WHERE exists (SELECT '1'
19986: FROM mtl_serial_numbers
19987: WHERE inventory_item_id = l_item_id
19988: AND current_organization_id = l_org_id
21053: l_dummy := '0';
21054: BEGIN
21055: SELECT '1'
21056: INTO l_dummy
21057: FROM dual
21058: WHERE exists (SELECT '1'
21059: FROM mtl_serial_numbers
21060: WHERE inventory_item_id = l_item_id
21061: AND current_organization_id = l_org_id
22235: IF (Nvl(g_lpn_group_id,-999) <> l_lpn_grp_id) THEN
22236: g_lpn_group_id := l_lpn_grp_id;
22237: SELECT wms_epc_s2.NEXTVAL
22238: INTO g_epc_group_id
22239: FROM dual;
22240: END IF;
22241:
22242: IF (l_debug = 1) THEN
22243: print_debug('Calling populate_outside_epc',4);
22655: IF (Nvl(g_lpn_group_id,-999) <> l_lpn_grp_id) THEN
22656: g_lpn_group_id := l_lpn_grp_id;
22657: SELECT wms_epc_s2.NEXTVAL
22658: INTO g_epc_group_id
22659: FROM dual;
22660: END IF;
22661:
22662: IF (l_debug = 1) THEN
22663: print_debug('Calling populate_outside_epc',4);