APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 1125: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232

1121: asn_debug.put_line('-------------------------------------------');
1122: asn_debug.put_line(' Processing Returns without receipts');
1123: asn_debug.put_line('-------------------------------------------');
1124: END IF;
1125: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1126: END IF;
1127: load_mtl_interfaces ('Issue out', wdd_rec, l_header_id, p_delivery_id);
1128: END LOOP;
1129:

Line 1224: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232

1220: asn_debug.put_line('-------------------------------------------');
1221: asn_debug.put_line('Processing Direct transfers from Return hub');
1222: asn_debug.put_line('-------------------------------------------');
1223: END IF;
1224: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1225: END IF;
1226: load_mtl_interfaces ('Direct Transfer', wdd_rec, l_header_id, p_delivery_id);
1227: END LOOP;
1228:

Line 1695: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232

1691: INTO l_txn_reference
1692: FROM rcv_transactions_interface
1693: WHERE interface_transaction_id = p_wdd_rec.source_line_id; -- Bug 12974284
1694: --
1695: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232
1696: --
1697: INSERT INTO mtl_transactions_interface
1698: ( transaction_header_id,
1699: transaction_interface_id,

Line 2296: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232

2292: IF (l_source_allows_lot AND p_wdd_rec.lot_number IS NOT NULL ) THEN
2293: IF (p_source = 'INV') THEN
2294: l_temp_id := p_parent_id;
2295: ELSIF (p_source = 'RCV') THEN
2296: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232
2297: END IF;
2298: --
2299: INSERT INTO mtl_transaction_lots_interface
2300: ( transaction_interface_id,

Line 2373: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232

2369:
2370: IF (l_serial_temp_id IS NULL) THEN
2371: IF (p_source = 'INV') THEN
2372: IF (l_lot_inserted) THEN
2373: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232
2374: ELSE
2375: l_serial_temp_id := p_parent_id;
2376: END IF;
2377: ELSIF (p_source = 'RCV') THEN

Line 2378: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232

2374: ELSE
2375: l_serial_temp_id := p_parent_id;
2376: END IF;
2377: ELSIF (p_source = 'RCV') THEN
2378: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232
2379: END IF;
2380: END IF;
2381: --
2382: -- Transfer tagged serial to receipt org if return is done from another org ie, direct txr is completed at this point.