APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 11535: FROM mtl_serial_numbers_temp msnt

11531: msnt.attribute13,
11532: msnt.attribute14,
11533: msnt.attribute15,
11534: msnt.dff_updated_flag
11535: FROM mtl_serial_numbers_temp msnt
11536: WHERE msnt.transaction_temp_id = x_tt_id
11537: ORDER BY msnt.fm_serial_number DESC;
11538:
11539: CURSOR c_temp_id IS

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

11644: END IF; -- x_old_detail_rec.to_serail_number IS NULL
11645:
11646: ELSE
11647:
11648: -- we have at least one record in MTL_SERIAL_NUMBERS_TEMP
11649: --
11650: IF l_debug_on THEN
11651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_SERIAL_QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
11652: END IF;

Line 11742: UPDATE mtl_serial_numbers_temp

11738: -- update record only if old delivery line still has at least 1 to ship.
11739: IF l_debug_on THEN
11740: WSH_DEBUG_SV.log(l_module_name,'l_old_to_sn',l_old_to_sn);
11741: END IF;
11742: UPDATE mtl_serial_numbers_temp
11743: SET to_serial_number = l_old_to_sn,
11744: serial_prefix = TO_CHAR(l_range_count - l_qty_to_split),
11745: last_update_date = SYSDATE,
11746: last_updated_by = FND_GLOBAL.USER_ID,

Line 11752: 'inserting into mtl_serial_numbers_temp'

11748: WHERE rowid = c.rowid;
11749: END IF;
11750: IF l_debug_on THEN
11751: WSH_DEBUG_SV.log(l_module_name,
11752: 'inserting into mtl_serial_numbers_temp'
11753: ,l_transaction_temp_id);
11754: END IF;
11755:
11756: -- Changes for 3782838

Line 11758: INSERT INTO mtl_serial_numbers_temp

11754: END IF;
11755:
11756: -- Changes for 3782838
11757: IF l_transaction_temp_id IS NOT NULL THEN
11758: INSERT INTO mtl_serial_numbers_temp
11759: (TRANSACTION_TEMP_ID,
11760: LAST_UPDATE_DATE,
11761: LAST_UPDATED_BY,
11762: LAST_UPDATE_LOGIN,

Line 11900: 'Updating mtl_serial_numbers_temp',

11896:
11897: IF l_transaction_temp_id IS NOT NULL THEN
11898: IF l_debug_on THEN
11899: WSH_DEBUG_SV.log(l_module_name,
11900: 'Updating mtl_serial_numbers_temp',
11901: l_transaction_temp_id);
11902: END IF;
11903: -- we need to assign the full serial number range to the new line
11904: UPDATE mtl_serial_numbers_temp

Line 11904: UPDATE mtl_serial_numbers_temp

11900: 'Updating mtl_serial_numbers_temp',
11901: l_transaction_temp_id);
11902: END IF;
11903: -- we need to assign the full serial number range to the new line
11904: UPDATE mtl_serial_numbers_temp
11905: SET transaction_temp_id = l_transaction_temp_id,
11906: last_update_date = SYSDATE,
11907: last_updated_by = FND_GLOBAL.USER_ID,
11908: last_update_login = FND_GLOBAL.LOGIN_ID

Line 11977: DELETE mtl_serial_numbers_temp

11973: --bug 2740681
11974: ELSE
11975: -- we need to remove this serial number range (which has count of 1)
11976: x_new_delivery_detail_rec.serial_number := c.fm_serial_number;
11977: DELETE mtl_serial_numbers_temp
11978: WHERE rowid = c.rowid;
11979: END IF;
11980:
11981: l_qty_to_split := l_qty_to_split - l_range_count;

Line 12025: -- Takes individual lines FROM MTL_SERIAL_NUMBERS_TEMP that

12021: --
12022: -- Name
12023: -- Explode_Delivery_Details
12024: -- Purpose
12025: -- Takes individual lines FROM MTL_SERIAL_NUMBERS_TEMP that
12026: -- are under serial number control and explodes them into multiple
12027: -- lines based on the serial numbers entered.
12028: --
12029: -- Bug 1752809: rewritten to explode into serial number ranges.