APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 11104: FROM mtl_serial_numbers_temp msnt

11100: msnt.attribute13,
11101: msnt.attribute14,
11102: msnt.attribute15,
11103: msnt.dff_updated_flag
11104: FROM mtl_serial_numbers_temp msnt
11105: WHERE msnt.transaction_temp_id = x_tt_id
11106: ORDER BY msnt.fm_serial_number DESC;
11107:
11108: CURSOR c_temp_id IS

Line 11217: -- we have at least one record in MTL_SERIAL_NUMBERS_TEMP

11213: END IF; -- x_old_detail_rec.to_serail_number IS NULL
11214:
11215: ELSE
11216:
11217: -- we have at least one record in MTL_SERIAL_NUMBERS_TEMP
11218: --
11219: IF l_debug_on THEN
11220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_SERIAL_QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
11221: END IF;

Line 11311: UPDATE mtl_serial_numbers_temp

11307: -- update record only if old delivery line still has at least 1 to ship.
11308: IF l_debug_on THEN
11309: WSH_DEBUG_SV.log(l_module_name,'l_old_to_sn',l_old_to_sn);
11310: END IF;
11311: UPDATE mtl_serial_numbers_temp
11312: SET to_serial_number = l_old_to_sn,
11313: serial_prefix = TO_CHAR(l_range_count - l_qty_to_split),
11314: last_update_date = SYSDATE,
11315: last_updated_by = FND_GLOBAL.USER_ID,

Line 11321: 'inserting into mtl_serial_numbers_temp'

11317: WHERE rowid = c.rowid;
11318: END IF;
11319: IF l_debug_on THEN
11320: WSH_DEBUG_SV.log(l_module_name,
11321: 'inserting into mtl_serial_numbers_temp'
11322: ,l_transaction_temp_id);
11323: END IF;
11324:
11325: -- Changes for 3782838

Line 11327: INSERT INTO mtl_serial_numbers_temp

11323: END IF;
11324:
11325: -- Changes for 3782838
11326: IF l_transaction_temp_id IS NOT NULL THEN
11327: INSERT INTO mtl_serial_numbers_temp
11328: (TRANSACTION_TEMP_ID,
11329: LAST_UPDATE_DATE,
11330: LAST_UPDATED_BY,
11331: LAST_UPDATE_LOGIN,

Line 11452: 'Updating mtl_serial_numbers_temp',

11448:
11449: IF l_transaction_temp_id IS NOT NULL THEN
11450: IF l_debug_on THEN
11451: WSH_DEBUG_SV.log(l_module_name,
11452: 'Updating mtl_serial_numbers_temp',
11453: l_transaction_temp_id);
11454: END IF;
11455: -- we need to assign the full serial number range to the new line
11456: UPDATE mtl_serial_numbers_temp

Line 11456: UPDATE mtl_serial_numbers_temp

11452: 'Updating mtl_serial_numbers_temp',
11453: l_transaction_temp_id);
11454: END IF;
11455: -- we need to assign the full serial number range to the new line
11456: UPDATE mtl_serial_numbers_temp
11457: SET transaction_temp_id = l_transaction_temp_id,
11458: last_update_date = SYSDATE,
11459: last_updated_by = FND_GLOBAL.USER_ID,
11460: last_update_login = FND_GLOBAL.LOGIN_ID

Line 11512: DELETE mtl_serial_numbers_temp

11508: --bug 2740681
11509: ELSE
11510: -- we need to remove this serial number range (which has count of 1)
11511: x_new_delivery_detail_rec.serial_number := c.fm_serial_number;
11512: DELETE mtl_serial_numbers_temp
11513: WHERE rowid = c.rowid;
11514: END IF;
11515:
11516: l_qty_to_split := l_qty_to_split - l_range_count;

Line 11560: -- Takes individual lines FROM MTL_SERIAL_NUMBERS_TEMP that

11556: --
11557: -- Name
11558: -- Explode_Delivery_Details
11559: -- Purpose
11560: -- Takes individual lines FROM MTL_SERIAL_NUMBERS_TEMP that
11561: -- are under serial number control and explodes them into multiple
11562: -- lines based on the serial numbers entered.
11563: --
11564: -- Bug 1752809: rewritten to explode into serial number ranges.