APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 3395: DELETE FROM mtl_serial_numbers_temp

3391: DELETE FROM wms_freight_cost_temp
3392: WHERE organization_id = p_org_id
3393: AND lpn_id = l_outermost_lpn_id;
3394:
3395: DELETE FROM mtl_serial_numbers_temp
3396: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3397: FROM wms_direct_ship_temp
3398: WHERE lpn_id = p_outermost_lpn_id);
3399:

Line 3442: DELETE FROM mtl_serial_numbers_temp

3438: WHERE lpn_id = p_outermost_lpn_id;
3439:
3440: --Delete records from Mtl_Seral_Numbers_Temp if any
3441: BEGIN
3442: DELETE FROM mtl_serial_numbers_temp
3443: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3444: FROM wms_direct_ship_temp
3445: WHERE lpn_id = p_outermost_lpn_id);
3446: EXCEPTION

Line 3843: , mtl_serial_numbers_temp msnt

3839: , msnt.time_since_mark
3840: , msnt.cycles_since_mark
3841: , msnt.number_of_repairs
3842: FROM wsh_delivery_details_ob_grp_v dd
3843: , mtl_serial_numbers_temp msnt
3844: WHERE delivery_detail_id = p_delivery_detail_id
3845: AND msnt.transaction_temp_id = p_transaction_temp_id;
3846:
3847: l_explode_detail c_explode_detail%ROWTYPE;

Line 3994: -- Serial Number is lying in MTL_SERIAL_NUMBERS_TEMP

3990: IF (l_debug = 1) THEN
3991: DEBUG('P_SERIAL_CONTROL_CODE=6', 'EXPLODE_DELIVERY_DETAILS');
3992: END IF;
3993:
3994: -- Serial Number is lying in MTL_SERIAL_NUMBERS_TEMP
3995: IF (l_debug = 1) THEN
3996: DEBUG('EXPLODE delviery detail id ' || TO_CHAR(p_delivery_detail_id), 'EXPLODE_DELIVERY_DETAILS');
3997: END IF;
3998:

Line 4125: UPDATE mtl_serial_numbers_temp

4121: l_new_fm_serial := l_real_serial_prefix ||(l_serial_numeric + l_serial_quantity);
4122: l_current_to_serial := l_real_serial_prefix ||(l_serial_numeric + l_serial_quantity - 1);
4123: l_rowid := l_explode_detail.ROWID;
4124:
4125: UPDATE mtl_serial_numbers_temp
4126: SET fm_serial_number = l_new_fm_serial
4127: WHERE ROWID = l_rowid;
4128:
4129:

Line 4349: UPDATE mtl_serial_numbers_temp

4345: ****************************/
4346: l_running_quantity := l_serial_numbers_table.COUNT;
4347:
4348: FOR j IN 1 .. l_running_quantity LOOP
4349: UPDATE mtl_serial_numbers_temp
4350: SET transaction_temp_id = x_transaction_temp_id
4351: WHERE transaction_temp_id = p_transaction_temp_id
4352: AND fm_serial_number = l_serial_numbers_table(j);
4353: END LOOP;

Line 5779: FROM mtl_serial_numbers_temp

5775: ELSE
5776: BEGIN
5777: SELECT fm_serial_number
5778: INTO l_shipping_attr(1).serial_number
5779: FROM mtl_serial_numbers_temp
5780: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
5781: AND ROWNUM < 2;
5782:
5783: IF (l_debug = 1) THEN

Line 5793: DELETE FROM mtl_serial_numbers_temp

5789: , 'STAGE_LPN'
5790: );
5791: END IF;
5792:
5793: DELETE FROM mtl_serial_numbers_temp
5794: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
5795: EXCEPTION
5796: WHEN NO_DATA_FOUND THEN
5797: IF (l_debug = 1) THEN

Line 6045: FROM mtl_serial_numbers_temp

6041: ELSE
6042: BEGIN
6043: SELECT fm_serial_number
6044: INTO l_shipping_attr(1).serial_number
6045: FROM mtl_serial_numbers_temp
6046: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6047: AND ROWNUM < 2;
6048:
6049: IF ( l_debug = 1 ) THEN

Line 6054: DELETE FROM mtl_serial_numbers_temp

6050: DEBUG('found fm_serial='|| l_shipping_attr(1).serial_number||
6051: ' for transaction_temp_id='||l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6052: END IF;
6053:
6054: DELETE FROM mtl_serial_numbers_temp
6055: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6056: EXCEPTION
6057: WHEN NO_DATA_FOUND THEN
6058: IF (l_debug = 1) THEN

Line 6134: FROM mtl_serial_numbers_temp

6130: ELSE
6131: BEGIN
6132: SELECT fm_serial_number
6133: INTO l_shipping_attr(1).serial_number
6134: FROM mtl_serial_numbers_temp
6135: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6136: AND ROWNUM < 2;
6137:
6138: IF (l_debug = 1) THEN

Line 6148: DELETE FROM mtl_serial_numbers_temp

6144: , 'STAGE_LPN'
6145: );
6146: END IF;
6147:
6148: DELETE FROM mtl_serial_numbers_temp
6149: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6150: EXCEPTION
6151: WHEN NO_DATA_FOUND THEN
6152: IF (l_debug = 1) THEN