APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_SERIAL_NUMBERS_TEMP

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

2431: CLOSE suggestions_csr;
2432: END IF;
2433: END suggestions_pub;
2434:
2435: /* Local function to insert record in MTL_SERIAL_NUMBERS_TEMP given
2436: * a record type containing the information of one serial number (including
2437: * attributes). This procedure is called from complete_putaway to create
2438: * as many MSNT records for the serial numbers within the LPN for the quantity
2439: * confirmed

Line 2448: INSERT INTO mtl_serial_numbers_temp

2444: , p_serial_atts IN msn_attribute_rec_tp
2445: , p_user_id IN NUMBER
2446: , p_to_serial_number IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN IS
2447: BEGIN
2448: INSERT INTO mtl_serial_numbers_temp
2449: (
2450: transaction_temp_id
2451: , last_update_date
2452: , last_updated_by

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

2766: WHEN OTHERS THEN
2767: RETURN FALSE;
2768: END insert_dup_mtlt;
2769:
2770: /* Local function to insert records in MTL_SERIAL_NUMBERS_TEMP
2771: * from the original MSNT record(s). These records are needed by
2772: * the receiving transaction manager for the deliver transaction
2773: */
2774: FUNCTION insert_dup_msnt (

Line 2778: INSERT INTO mtl_serial_numbers_temp

2774: FUNCTION insert_dup_msnt (
2775: p_orig_temp_id IN NUMBER
2776: , p_new_temp_id IN NUMBER) RETURN BOOLEAN IS
2777: BEGIN
2778: INSERT INTO mtl_serial_numbers_temp
2779: (
2780: transaction_temp_id
2781: , last_update_date
2782: , last_updated_by

Line 2911: FROM mtl_serial_numbers_temp

2907: , n_attribute7
2908: , n_attribute8
2909: , n_attribute9
2910: , n_attribute10
2911: FROM mtl_serial_numbers_temp
2912: WHERE transaction_temp_id = p_orig_temp_id);
2913: RETURN TRUE;
2914: EXCEPTION
2915: WHEN OTHERS THEN

Line 4549: FROM mtl_serial_numbers_temp

4545: /* Bug 5213359-Added the following check */
4546:
4547: SELECT count(transaction_temp_id)
4548: INTO l_exist_msnt
4549: FROM mtl_serial_numbers_temp
4550: WHERE transaction_temp_id = p_temp_id
4551: AND fm_serial_number = l_serial ;
4552:
4553: mydebug('complete_putaway In patchset J, checking for msnt l_exist_msnt:'|| l_exist_msnt);

Line 6300: DELETE mtl_serial_numbers_temp

6296: WHERE transaction_temp_id = l_temp_id;
6297:
6298: -- Delete lot and serial records
6299: BEGIN
6300: DELETE mtl_serial_numbers_temp
6301: WHERE transaction_temp_id = (SELECT serial_transaction_temp_id
6302: FROM mtl_transaction_lots_temp
6303: WHERE transaction_temp_id = l_temp_id);
6304: EXCEPTION

Line 6318: DELETE mtl_serial_numbers_temp

6314: NULL;
6315: END;
6316:
6317: BEGIN
6318: DELETE mtl_serial_numbers_temp
6319: WHERE transaction_temp_id = l_temp_id;
6320: EXCEPTION
6321: WHEN NO_DATA_FOUND THEN
6322: NULL;

Line 6420: DELETE mtl_serial_numbers_temp

6416:
6417: IF p_delete_mmtt_flag = 'Y' THEN
6418: -- Delete lot and serial records
6419: BEGIN
6420: DELETE mtl_serial_numbers_temp
6421: WHERE transaction_temp_id IN
6422: (SELECT serial_transaction_temp_id
6423: FROM mtl_transaction_lots_temp
6424: WHERE transaction_temp_id = l_temp_id);

Line 6441: DELETE mtl_serial_numbers_temp

6437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6438: END;
6439:
6440: BEGIN
6441: DELETE mtl_serial_numbers_temp
6442: WHERE transaction_temp_id = l_temp_id;
6443: EXCEPTION
6444: WHEN OTHERS THEN
6445: mydebug('archive_task: Error deleting MSNT: ' || sqlerrm);

Line 6527: FROM mtl_serial_numbers_temp

6523: -- Add cursor to get the serial number(s) for a given MSNT record.
6524: -- SQL compiler complains of a Hash Join otherwise.
6525: CURSOR c_serial_number(v_transaction_temp_id NUMBER) IS
6526: SELECT fm_serial_number
6527: FROM mtl_serial_numbers_temp
6528: WHERE transaction_temp_id = v_transaction_temp_id;
6529: l_fm_serial_number NUMBER;
6530:
6531: BEGIN