APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_SERIAL_NUMBERS

Line 24: -- wsh_serial_numbers and this will be used to display the

20:
21: --========================================================================
22: -- PROCEDURE : transfer_serial_numbers_pvt
23: -- Transfers Serial Numbers from mtl_serial_numbers_temp to
24: -- wsh_serial_numbers and this will be used to display the
25: -- Serial Numbers shipped from the Shipping Transactions Form
26: --
27: -- PARAMETERS: p_transfer_param Input Parameter for this API
28: -- Values can be WDD or MSNT

Line 37: -- from mtl_serial_numbers_temp to the wsh_serial_numbers table.

33: -- value 'INV' is passed.
34: -- x_return_status return status of the API.
35:
36: -- COMMENT : This procedure is used to transfer the serial number information
37: -- from mtl_serial_numbers_temp to the wsh_serial_numbers table.
38: -- It then deletes these entries from mtl_serial_numbers_temp.
39: -- IF this procedure is called during the INV interface then only
40: -- the lines that have been interfaced to OM are processed, else
41: -- the non-oe lines are processed as well.

Line 784: INSERT INTO wsh_serial_numbers

780: cur_fetch := tot_fetch - pre_fetch;
781: EXIT WHEN ( cur_fetch <= 0);
782:
783: FORALL i IN 1 .. cur_fetch
784: INSERT INTO wsh_serial_numbers
785: ( delivery_detail_id,
786: quantity,
787: fm_serial_number,
788: to_serial_number,

Line 953: WSH_DEBUG_SV.log(l_module_name,'Numbers of rows inserted into wsh_serial_numbers: '|| to_char(ins_rows) ||

949: END IF;
950: END IF;
951:
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.log(l_module_name,'Numbers of rows inserted into wsh_serial_numbers: '|| to_char(ins_rows) ||
954: ', Number of rows deleted from mtl_serial_numbers_temp: '|| to_char(del_rows) ||
955: ', Number of rows updated in wsh_delivery_details: '|| to_char(upd_rows) );
956: WSH_DEBUG_SV.pop(l_module_name);
957: END IF;

Line 997: -- from mtl_serial_numbers_temp to the wsh_serial_numbers table.

993: -- value 'INV' is passed.
994: -- x_return_status return status of the API.
995: --
996: -- COMMENT : This procedure is used to transfer the serial number information
997: -- from mtl_serial_numbers_temp to the wsh_serial_numbers table.
998: -- It then deletes these entries from mtl_serial_numbers_temp.
999: -- IF this procedure is called during the INV interface then only
1000: -- the lines that have been interfaced to OM are processed, else
1001: -- the non-oe lines are processed as well.

Line 3085: from wsh_serial_numbers

3081: time_since_repair,
3082: time_since_visit,
3083: serial_attribute_category
3084: --Bug 8467875
3085: from wsh_serial_numbers
3086: where delivery_detail_id = c_delivery_detail_id;
3087:
3088: --Bug 13529169 added cursor to fetch the lot attribute values
3089:

Line 5064: -- bug 2787888 : Added call to transfer serial records from mtl_serial_numbers_temp to wsh_serial_numbers

5060: --
5061: return;
5062: END IF;
5063:
5064: -- bug 2787888 : Added call to transfer serial records from mtl_serial_numbers_temp to wsh_serial_numbers
5065: IF l_debug_on THEN
5066: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling TRANSFER_SERIAL_NUMBERS FOR BATCH ' || TO_CHAR ( P_batch_id ) );
5067: END IF;
5068:

Line 6821: -- Bug 2657652 : Added call to transfer serial records from mtl_serial_numbers_temp to wsh_serial_numbers

6817: ELSE --}{
6818: l_completion_status := 'INTERFACED' ;
6819: END if; --}
6820: --HVOP heali
6821: -- Bug 2657652 : Added call to transfer serial records from mtl_serial_numbers_temp to wsh_serial_numbers
6822: IF l_debug_on THEN
6823: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling TRANSFER_SERIAL_NUMBERS FOR ' || TO_CHAR ( p_batch_id ) );
6824: END IF;
6825: