2109:
2110: IF ( g_cc_entry.cycle_count_entry_id IS NULL ) THEN
2111: SELECT mtl_cycle_count_entries_s.NEXTVAL
2112: INTO l_cc_entry_id
2113: FROM DUAL;
2114:
2115: g_cc_entry.cycle_count_entry_id := l_cc_entry_id;
2116: -- Bug# 2386128
2117: -- For unscheduled cycle count entries, the count list sequence
3330:
3331: IF ( l_txn_header_id = -2 ) THEN
3332: SELECT mtl_material_transactions_s.NEXTVAL
3333: INTO l_txn_header_id
3334: FROM DUAL;
3335:
3336: g_txn_header_id := l_txn_header_id;
3337: print_debug ( 'l_txn_header_id '||l_txn_header_id );
3338: END IF;
3340: IF ( l_serial_number IS NOT NULL ) THEN
3341: print_debug ( 'l_serial_number '||l_serial_number);
3342: SELECT mtl_material_transactions_s.NEXTVAL
3343: INTO l_txn_temp_id
3344: FROM DUAL;
3345:
3346: SELECT auto_serial_alpha_prefix
3347: INTO l_serial_prefix
3348: FROM mtl_system_items
3518:
3519: -- Get a new txn temp ID for receiving the serial back into inventory
3520: SELECT mtl_material_transactions_s.NEXTVAL
3521: INTO l_txn_temp_id
3522: FROM DUAL;
3523: END IF;
3524: END IF;
3525:
3526: -- This loop deals with processing LPN discrepancies and issuing
3651:
3652: -- Get a new txn temp ID for the next record into MMTT
3653: SELECT mtl_material_transactions_s.NEXTVAL
3654: INTO l_txn_temp_id
3655: FROM DUAL;
3656: END IF;
3657: END IF;
3658: END IF; --End of fix for bug#4958692
3659: END IF;
4445: IF ( l_serial_count_option = 3 ) THEN
4446: IF ( l_cycle_count_entry_id IS NULL ) THEN
4447: SELECT mtl_cycle_count_entries_s.NEXTVAL
4448: INTO l_cycle_count_entry_id
4449: FROM DUAL;
4450:
4451: g_cc_entry.cycle_count_entry_id := l_cycle_count_entry_id;
4452: END IF;
4453:
4781: IF ( l_serial_count_option = 3 ) THEN
4782: IF ( l_cycle_count_entry_id IS NULL ) THEN
4783: SELECT mtl_cycle_count_entries_s.NEXTVAL
4784: INTO l_cycle_count_entry_id
4785: FROM DUAL;
4786:
4787: g_cc_entry.cycle_count_entry_id := l_cycle_count_entry_id;
4788: END IF;
4789:
6458: IF ( l_entry_status_code = 5 AND l_adjustment_quantity <> 0 ) THEN
6459: IF ( l_txn_header_id = -2 ) THEN
6460: SELECT mtl_material_transactions_s.NEXTVAL
6461: INTO l_txn_header_id
6462: FROM DUAL;
6463:
6464: g_txn_header_id := l_txn_header_id;
6465: END IF;
6466:
6465: END IF;
6466:
6467: SELECT mtl_material_transactions_s.NEXTVAL
6468: INTO l_txn_temp_id
6469: FROM DUAL;
6470:
6471: SELECT auto_serial_alpha_prefix
6472: INTO l_serial_prefix
6473: FROM mtl_system_items
6783:
6784: -- Get a new txn temp ID for receiving the serial back into inventory
6785: SELECT mtl_material_transactions_s.NEXTVAL
6786: INTO l_txn_temp_id
6787: FROM DUAL;
6788: END IF;
6789:
6790: IF ( l_adjustment_quantity = 1 ) THEN
6791: -- Receiving the serial into the sub and loc where it was found