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 385: INSERT INTO wsh_serial_numbers

381: cur_fetch := tot_fetch - pre_fetch;
382: EXIT WHEN ( cur_fetch <= 0);
383:
384: FORALL i IN 1 .. cur_fetch
385: INSERT INTO wsh_serial_numbers
386: ( delivery_detail_id,
387: quantity,
388: fm_serial_number,
389: to_serial_number,

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

506: END IF;
507: END IF;
508:
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.log(l_module_name,'Numbers of rows inserted into wsh_serial_numbers: '|| to_char(ins_rows) ||
511: ', Number of rows deleted from mtl_serial_numbers_temp: '|| to_char(del_rows) ||
512: ', Number of rows updated in wsh_delivery_details: '|| to_char(upd_rows) );
513: WSH_DEBUG_SV.pop(l_module_name);
514: END IF;

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

550: -- value 'INV' is passed.
551: -- x_return_status return status of the API.
552: --
553: -- COMMENT : This procedure is used to transfer the serial number information
554: -- from mtl_serial_numbers_temp to the wsh_serial_numbers table.
555: -- It then deletes these entries from mtl_serial_numbers_temp.
556: -- IF this procedure is called during the INV interface then only
557: -- the lines that have been interfaced to OM are processed, else
558: -- the non-oe lines are processed as well.

Line 2541: from wsh_serial_numbers

2537: attribute12,
2538: attribute13,
2539: attribute14,
2540: attribute15
2541: from wsh_serial_numbers
2542: where delivery_detail_id = c_delivery_detail_id;
2543:
2544: l_trx_source_type_id number := NULL;
2545: l_trx_action_id number := NULL;

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

4119: --
4120: return;
4121: END IF;
4122:
4123: -- bug 2787888 : Added call to transfer serial records from mtl_serial_numbers_temp to wsh_serial_numbers
4124: IF l_debug_on THEN
4125: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling TRANSFER_SERIAL_NUMBERS FOR BATCH ' || TO_CHAR ( P_batch_id ) );
4126: END IF;
4127:

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

5292: ELSE --}{
5293: l_completion_status := 'INTERFACED' ;
5294: END if; --}
5295: --HVOP heali
5296: -- Bug 2657652 : Added call to transfer serial records from mtl_serial_numbers_temp to wsh_serial_numbers
5297: IF l_debug_on THEN
5298: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling TRANSFER_SERIAL_NUMBERS FOR ' || TO_CHAR ( p_batch_id ) );
5299: END IF;
5300: