APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2607: /* Local function to insert record in MTL_SERIAL_NUMBERS_TEMP given

2603: CLOSE suggestions_csr;
2604: END IF;
2605: END suggestions_pub;
2606:
2607: /* Local function to insert record in MTL_SERIAL_NUMBERS_TEMP given
2608: * a record type containing the information of one serial number (including
2609: * attributes). This procedure is called from complete_putaway to create
2610: * as many MSNT records for the serial numbers within the LPN for the quantity
2611: * confirmed

Line 2620: INSERT INTO mtl_serial_numbers_temp

2616: , p_serial_atts IN msn_attribute_rec_tp
2617: , p_user_id IN NUMBER
2618: , p_to_serial_number IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN IS
2619: BEGIN
2620: INSERT INTO mtl_serial_numbers_temp
2621: (
2622: transaction_temp_id
2623: , last_update_date
2624: , last_updated_by

Line 2974: /* Local function to insert records in MTL_SERIAL_NUMBERS_TEMP

2970: WHEN OTHERS THEN
2971: RETURN FALSE;
2972: END insert_dup_mtlt;
2973:
2974: /* Local function to insert records in MTL_SERIAL_NUMBERS_TEMP
2975: * from the original MSNT record(s). These records are needed by
2976: * the receiving transaction manager for the deliver transaction
2977: */
2978: FUNCTION insert_dup_msnt (

Line 2982: INSERT INTO mtl_serial_numbers_temp

2978: FUNCTION insert_dup_msnt (
2979: p_orig_temp_id IN NUMBER
2980: , p_new_temp_id IN NUMBER) RETURN BOOLEAN IS
2981: BEGIN
2982: INSERT INTO mtl_serial_numbers_temp
2983: (
2984: transaction_temp_id
2985: , last_update_date
2986: , last_updated_by

Line 3115: FROM mtl_serial_numbers_temp

3111: , n_attribute7
3112: , n_attribute8
3113: , n_attribute9
3114: , n_attribute10
3115: FROM mtl_serial_numbers_temp
3116: WHERE transaction_temp_id = p_orig_temp_id);
3117: RETURN TRUE;
3118: EXCEPTION
3119: WHEN OTHERS THEN

Line 4775: FROM mtl_serial_numbers_temp

4771: /* Bug 5213359-Added the following check */
4772:
4773: SELECT count(transaction_temp_id)
4774: INTO l_exist_msnt
4775: FROM mtl_serial_numbers_temp
4776: WHERE transaction_temp_id = p_temp_id
4777: AND fm_serial_number = l_serial ;
4778:
4779: mydebug('complete_putaway In patchset J, checking for msnt l_exist_msnt:'|| l_exist_msnt);

Line 6627: DELETE mtl_serial_numbers_temp

6623: WHERE transaction_temp_id = l_temp_id;
6624:
6625: -- Delete lot and serial records
6626: BEGIN
6627: DELETE mtl_serial_numbers_temp
6628: WHERE transaction_temp_id = (SELECT serial_transaction_temp_id
6629: FROM mtl_transaction_lots_temp
6630: WHERE transaction_temp_id = l_temp_id);
6631: EXCEPTION

Line 6645: DELETE mtl_serial_numbers_temp

6641: NULL;
6642: END;
6643:
6644: BEGIN
6645: DELETE mtl_serial_numbers_temp
6646: WHERE transaction_temp_id = l_temp_id;
6647: EXCEPTION
6648: WHEN NO_DATA_FOUND THEN
6649: NULL;

Line 6747: DELETE mtl_serial_numbers_temp

6743:
6744: IF p_delete_mmtt_flag = 'Y' THEN
6745: -- Delete lot and serial records
6746: BEGIN
6747: DELETE mtl_serial_numbers_temp
6748: WHERE transaction_temp_id IN
6749: (SELECT serial_transaction_temp_id
6750: FROM mtl_transaction_lots_temp
6751: WHERE transaction_temp_id = l_temp_id);

Line 6768: DELETE mtl_serial_numbers_temp

6764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6765: END;
6766:
6767: BEGIN
6768: DELETE mtl_serial_numbers_temp
6769: WHERE transaction_temp_id = l_temp_id;
6770: EXCEPTION
6771: WHEN OTHERS THEN
6772: mydebug('archive_task: Error deleting MSNT: ' || sqlerrm);

Line 6854: FROM mtl_serial_numbers_temp

6850: -- Add cursor to get the serial number(s) for a given MSNT record.
6851: -- SQL compiler complains of a Hash Join otherwise.
6852: CURSOR c_serial_number(v_transaction_temp_id NUMBER) IS
6853: SELECT fm_serial_number
6854: FROM mtl_serial_numbers_temp
6855: WHERE transaction_temp_id = v_transaction_temp_id;
6856: l_fm_serial_number NUMBER;
6857:
6858: BEGIN