[Home] [Help]
2356:
2357: IF ( g_cc_entry.cycle_count_entry_id IS NULL ) THEN
2358: SELECT mtl_cycle_count_entries_s.NEXTVAL
2359: INTO l_cc_entry_id
2360: FROM DUAL;
2361:
2362: g_cc_entry.cycle_count_entry_id := l_cc_entry_id;
2363: -- Bug# 2386128
2364: -- For unscheduled cycle count entries, the count list sequence
3623:
3624: IF ( l_txn_header_id = -2 ) THEN
3625: SELECT mtl_material_transactions_s.NEXTVAL
3626: INTO l_txn_header_id
3627: FROM DUAL;
3628:
3629: g_txn_header_id := l_txn_header_id;
3630: print_debug ( 'l_txn_header_id '||l_txn_header_id );
3631: END IF;
3637: IF ( l_serial_number IS NOT NULL ) THEN
3638: print_debug ( 'l_serial_number '||l_serial_number);
3639: SELECT mtl_material_transactions_s.NEXTVAL
3640: INTO l_txn_temp_id
3641: FROM DUAL;
3642:
3643: SELECT auto_serial_alpha_prefix
3644: INTO l_serial_prefix
3645: FROM mtl_system_items
3815:
3816: -- Get a new txn temp ID for receiving the serial back into inventory
3817: SELECT mtl_material_transactions_s.NEXTVAL
3818: INTO l_txn_temp_id
3819: FROM DUAL;
3820: END IF;
3821: END IF;
3822:
3823: -- This loop deals with processing LPN discrepancies and issuing
3962:
3963: -- Get a new txn temp ID for the next record into MMTT
3964: SELECT mtl_material_transactions_s.NEXTVAL
3965: INTO l_txn_temp_id
3966: FROM DUAL;
3967: END IF;
3968: END IF;
3969: END IF; --End of fix for bug#4958692
3970: END IF;
4780: IF ( l_serial_count_option = 3 ) THEN
4781: IF ( l_cycle_count_entry_id IS NULL ) THEN
4782: SELECT mtl_cycle_count_entries_s.NEXTVAL
4783: INTO l_cycle_count_entry_id
4784: FROM DUAL;
4785:
4786: g_cc_entry.cycle_count_entry_id := l_cycle_count_entry_id;
4787: END IF;
4788:
6564: IF ( l_entry_status_code = 5 AND l_adjustment_quantity <> 0 ) THEN
6565: IF ( l_txn_header_id = -2 ) THEN
6566: SELECT mtl_material_transactions_s.NEXTVAL
6567: INTO l_txn_header_id
6568: FROM DUAL;
6569:
6570: g_txn_header_id := l_txn_header_id;
6571: END IF;
6572:
6571: END IF;
6572:
6573: SELECT mtl_material_transactions_s.NEXTVAL
6574: INTO l_txn_temp_id
6575: FROM DUAL;
6576:
6577: SELECT auto_serial_alpha_prefix
6578: INTO l_serial_prefix
6579: FROM mtl_system_items
6889:
6890: -- Get a new txn temp ID for receiving the serial back into inventory
6891: SELECT mtl_material_transactions_s.NEXTVAL
6892: INTO l_txn_temp_id
6893: FROM DUAL;
6894: END IF;
6895:
6896: IF ( l_adjustment_quantity = 1 ) THEN
6897: -- Receiving the serial into the sub and loc where it was found
9982: BEGIN
9983:
9984: SELECT 1
9985: INTO l_wdt_rowcnt
9986: FROM dual
9987: WHERE exists (SELECT 1
9988: FROM wms_dispatched_tasks t
9989: WHERE t.transaction_temp_id = l_transaction_temp_id);
9990: