APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 3585: DELETE FROM mtl_serial_numbers_temp

3581: DELETE FROM wms_freight_cost_temp
3582: WHERE organization_id = p_org_id
3583: AND lpn_id = l_outermost_lpn_id;
3584:
3585: DELETE FROM mtl_serial_numbers_temp
3586: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3587: FROM wms_direct_ship_temp
3588: WHERE lpn_id = p_outermost_lpn_id);
3589:

Line 3632: DELETE FROM mtl_serial_numbers_temp

3628: WHERE lpn_id = p_outermost_lpn_id;
3629:
3630: --Delete records from Mtl_Seral_Numbers_Temp if any
3631: BEGIN
3632: DELETE FROM mtl_serial_numbers_temp
3633: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3634: FROM wms_direct_ship_temp
3635: WHERE lpn_id = p_outermost_lpn_id);
3636: EXCEPTION

Line 4045: , mtl_serial_numbers_temp msnt

4041: , msnt.time_since_mark
4042: , msnt.cycles_since_mark
4043: , msnt.number_of_repairs
4044: FROM wsh_delivery_details_ob_grp_v dd
4045: , mtl_serial_numbers_temp msnt
4046: WHERE delivery_detail_id = p_delivery_detail_id
4047: AND msnt.transaction_temp_id = p_transaction_temp_id;
4048:
4049: l_explode_detail c_explode_detail%ROWTYPE;

Line 4196: -- Serial Number is lying in MTL_SERIAL_NUMBERS_TEMP

4192: IF (l_debug = 1) THEN
4193: DEBUG('P_SERIAL_CONTROL_CODE=6', 'EXPLODE_DELIVERY_DETAILS');
4194: END IF;
4195:
4196: -- Serial Number is lying in MTL_SERIAL_NUMBERS_TEMP
4197: IF (l_debug = 1) THEN
4198: DEBUG('EXPLODE delviery detail id ' || TO_CHAR(p_delivery_detail_id), 'EXPLODE_DELIVERY_DETAILS');
4199: END IF;
4200:

Line 4327: UPDATE mtl_serial_numbers_temp

4323: l_new_fm_serial := l_real_serial_prefix ||(l_serial_numeric + l_serial_quantity);
4324: l_current_to_serial := l_real_serial_prefix ||(l_serial_numeric + l_serial_quantity - 1);
4325: l_rowid := l_explode_detail.ROWID;
4326:
4327: UPDATE mtl_serial_numbers_temp
4328: SET fm_serial_number = l_new_fm_serial
4329: WHERE ROWID = l_rowid;
4330:
4331:

Line 4551: UPDATE mtl_serial_numbers_temp

4547: ****************************/
4548: l_running_quantity := l_serial_numbers_table.COUNT;
4549:
4550: FOR j IN 1 .. l_running_quantity LOOP
4551: UPDATE mtl_serial_numbers_temp
4552: SET transaction_temp_id = x_transaction_temp_id
4553: WHERE transaction_temp_id = p_transaction_temp_id
4554: AND fm_serial_number = l_serial_numbers_table(j);
4555: END LOOP;

Line 6126: FROM mtl_serial_numbers_temp

6122: ELSE
6123: BEGIN
6124: SELECT fm_serial_number
6125: INTO l_shipping_attr(1).serial_number
6126: FROM mtl_serial_numbers_temp
6127: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6128: AND ROWNUM < 2;
6129:
6130: IF (l_debug = 1) THEN

Line 6139: DELETE FROM mtl_serial_numbers_temp

6135: , 'STAGE_LPN'
6136: );
6137: END IF;
6138:
6139: DELETE FROM mtl_serial_numbers_temp
6140: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6141: EXCEPTION
6142: WHEN NO_DATA_FOUND THEN
6143: IF (l_debug = 1) THEN

Line 6468: FROM mtl_serial_numbers_temp

6464: ELSE
6465: BEGIN
6466: SELECT fm_serial_number
6467: INTO l_shipping_attr(1).serial_number
6468: FROM mtl_serial_numbers_temp
6469: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6470: AND ROWNUM < 2;
6471:
6472: IF ( l_debug = 1 ) THEN

Line 6477: DELETE FROM mtl_serial_numbers_temp

6473: DEBUG('found fm_serial='|| l_shipping_attr(1).serial_number||
6474: ' for transaction_temp_id='||l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6475: END IF;
6476:
6477: DELETE FROM mtl_serial_numbers_temp
6478: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6479: EXCEPTION
6480: WHEN NO_DATA_FOUND THEN
6481: IF (l_debug = 1) THEN

Line 6530: FROM mtl_serial_numbers_temp

6526: ELSE
6527: BEGIN
6528: SELECT fm_serial_number
6529: INTO l_shipping_attr(1).serial_number
6530: FROM mtl_serial_numbers_temp
6531: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6532: AND ROWNUM < 2;
6533:
6534: IF (l_debug = 1) THEN

Line 6543: DELETE FROM mtl_serial_numbers_temp

6539: , 'STAGE_LPN'
6540: );
6541: END IF;
6542:
6543: DELETE FROM mtl_serial_numbers_temp
6544: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6545: EXCEPTION
6546: WHEN NO_DATA_FOUND THEN
6547: IF (l_debug = 1) THEN

Line 6926: FROM mtl_serial_numbers_temp

6922: ELSE
6923: BEGIN
6924: SELECT fm_serial_number
6925: INTO l_shipping_attr(1).serial_number
6926: FROM mtl_serial_numbers_temp
6927: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6928: AND ROWNUM < 2;
6929:
6930: IF (l_debug = 1) THEN

Line 6939: DELETE FROM mtl_serial_numbers_temp

6935: , 'STAGE_LPN'
6936: );
6937: END IF;
6938:
6939: DELETE FROM mtl_serial_numbers_temp
6940: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6941: EXCEPTION
6942: WHEN NO_DATA_FOUND THEN
6943: IF (l_debug = 1) THEN

Line 7193: FROM mtl_serial_numbers_temp

7189: ELSE
7190: BEGIN
7191: SELECT fm_serial_number
7192: INTO l_shipping_attr(1).serial_number
7193: FROM mtl_serial_numbers_temp
7194: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
7195: AND ROWNUM < 2;
7196:
7197: IF ( l_debug = 1 ) THEN

Line 7202: DELETE FROM mtl_serial_numbers_temp

7198: DEBUG('found fm_serial='|| l_shipping_attr(1).serial_number||
7199: ' for transaction_temp_id='||l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
7200: END IF;
7201:
7202: DELETE FROM mtl_serial_numbers_temp
7203: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
7204: EXCEPTION
7205: WHEN NO_DATA_FOUND THEN
7206: IF (l_debug = 1) THEN

Line 7252: FROM mtl_serial_numbers_temp

7248: ELSE
7249: BEGIN
7250: SELECT fm_serial_number
7251: INTO l_shipping_attr(1).serial_number
7252: FROM mtl_serial_numbers_temp
7253: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
7254: AND ROWNUM < 2;
7255:
7256: IF (l_debug = 1) THEN

Line 7265: DELETE FROM mtl_serial_numbers_temp

7261: , 'STAGE_LPN'
7262: );
7263: END IF;
7264:
7265: DELETE FROM mtl_serial_numbers_temp
7266: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
7267: EXCEPTION
7268: WHEN NO_DATA_FOUND THEN
7269: IF (l_debug = 1) THEN