eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_PROCESS_PVT dependencies on WSH_DELIVERY_DETAILS

Line 880: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

876: l_order_type_id NUMBER := NULL;
877: l_document_set_id NUMBER := NULL;
878: l_sub_inventory VARCHAR2(30) := '';
879:
880: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
881: source_code VARCHAR2(15);
882: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;
883:
884: /* Handle exceptions */

Line 882: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;

878: l_sub_inventory VARCHAR2(30) := '';
879:
880: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
881: source_code VARCHAR2(15);
882: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;
883:
884: /* Handle exceptions */
885: fail_api EXCEPTION;
886: -- Added Mtl_Sytem_items_B to get serial_number_control_Code for the item that is being

Line 898: wsh_delivery_details wdd,

894: mtl.serial_number_control_code
895: FROM csd_repairs cr,
896: mtl_system_items_b mtl,
897: cs_estimate_details ced,
898: wsh_delivery_details wdd,
899: --Changed to view from table, bug: 4341784
900: wsh_delivery_assignments_v wda
901: WHERE cr.repair_line_id = ced.original_source_id
902: AND ced.original_source_code = 'DR'

Line 1011: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

1007: changed_attributes(1)
1008: .shipped_quantity);
1009: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');
1010: END IF;
1011: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1012: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
1013: p_init_msg_list => p_init_msg_list,
1014: p_commit => p_commit,
1015: x_return_status => x_return_status,

Line 1012: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,

1008: .shipped_quantity);
1009: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');
1010: END IF;
1011: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1012: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
1013: p_init_msg_list => p_init_msg_list,
1014: p_commit => p_commit,
1015: x_return_status => x_return_status,
1016: x_msg_count => x_msg_count,

Line 1319: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

1315: l_shipped_serial_number VARCHAR2(30);
1316: l_lot_number VARCHAR2(80); -- fix for bug#4625226
1317: l_SN_at_SO_new_SN_number BOOLEAN; /*This flag is true when user provide new SN for serialized item at SO */
1318:
1319: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1320: source_code VARCHAR2(15);
1321: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;
1322:
1323:

Line 1321: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;

1317: l_SN_at_SO_new_SN_number BOOLEAN; /*This flag is true when user provide new SN for serialized item at SO */
1318:
1319: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1320: source_code VARCHAR2(15);
1321: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;
1322:
1323:
1324: --bug#7675562
1325: l_ship_param_info WSH_SHIPPING_PARAMS_GRP.Shipping_Params_Rec;

Line 1371: FROM wsh_delivery_details a,

1367: a.organization_id,
1368: a.inventory_item_id,
1369: c.segment1 item_name,
1370: p.organization_code
1371: FROM wsh_delivery_details a,
1372: --Changed to view from table, bug: 4341784
1373: wsh_delivery_assignments_v b,
1374: mtl_system_items c,
1375: mtl_parameters p

Line 1408: from wsh_Delivery_Details

1404:
1405: --bug#6071005
1406: cursor get_delivery_detail_id(p_order_header_id IN NUMBER, p_order_line_id IN NUMBER) IS
1407: select delivery_detail_id
1408: from wsh_Delivery_Details
1409: where source_header_id = p_order_header_id and source_line_id = p_order_line_id;
1410:
1411:
1412: BEGIN

Line 1868: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

1864: Debug('Calling Update_Shipping_Attributes',
1865: l_mod_name,
1866: 1);
1867:
1868: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1869: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
1870: p_init_msg_list => p_init_msg_list,
1871: p_commit => p_commit,
1872: x_return_status => x_return_status,

Line 1869: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,

1865: l_mod_name,
1866: 1);
1867:
1868: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1869: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
1870: p_init_msg_list => p_init_msg_list,
1871: p_commit => p_commit,
1872: x_return_status => x_return_status,
1873: x_msg_count => x_msg_count,

Line 1898: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes

1894: If Item is Reservable then
1895: Check if item is Serial Controlled @ SO Issue
1896: ( This is existing solution and it will continue to stay
1897: If item is serial controlled at Sales Order issue then
1898: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
1899: and update with serial_number and quantity.
1900: End If;
1901: Else If Item is Non-Reservable
1902: If Item is serial Controlled then

Line 1906: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes and

1902: If Item is serial Controlled then
1903: Get Lot_Number, Revision, Sub Inventory Information from
1904: Mtl_Serial_numbers for a given serial_number, item_id,organization_id
1905:
1906: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes and
1907: Update Serial_Number, Quantity ( will be 1 for serial controlled
1908: items), lot_number, Revision and subinventory
1909: Else if item is non serial controlled then
1910: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes

Line 1910: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes

1906: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes and
1907: Update Serial_Number, Quantity ( will be 1 for serial controlled
1908: items), lot_number, Revision and subinventory
1909: Else if item is non serial controlled then
1910: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
1911: Values for Quantity, Lot_Number, Revision and Sub Inventory
1912: should be pulled from UI.
1913: Update Quantity, Lot_Number, Revision and Sub-Inventory
1914: End If ;

Line 1940: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

1936: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1937: END IF;
1938:
1939:
1940: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1941: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
1942: p_api_version_number => 1.0,
1943: p_init_msg_list => p_init_msg_list,
1944: p_commit => p_commit,

Line 1941: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(

1937: END IF;
1938:
1939:
1940: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1941: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
1942: p_api_version_number => 1.0,
1943: p_init_msg_list => p_init_msg_list,
1944: p_commit => p_commit,
1945: x_return_status => x_return_status,

Line 2092: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(

2088: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2089: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2090: END IF;
2091:
2092: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
2093: p_api_version_number => 1.0,
2094: p_init_msg_list => p_init_msg_list,
2095: p_commit => p_commit,
2096: x_return_status => x_return_status,

Line 2255: from wsh_delivery_details wdd

2251: THEN
2252: begin
2253: select 'N'
2254: into l_shipped_flag
2255: from wsh_delivery_details wdd
2256: where wdd.delivery_detail_id = i.delivery_detail_id
2257: and wdd.released_status <> 'C';
2258: exception
2259: when no_data_found then

Line 3758: FROM wsh_delivery_details

3754:
3755: BEGIN
3756: SELECT released_status
3757: INTO l_release_status
3758: FROM wsh_delivery_details
3759: WHERE source_line_id = l_order_line_id
3760: AND SOURCE_CODE = 'OE'; /*Fixed for bug#5846054 */
3761: EXCEPTION
3762: WHEN NO_DATA_FOUND THEN

Line 3799: FROM wsh_delivery_details

3795:
3796: BEGIN
3797: SELECT released_status
3798: INTO l_release_status
3799: FROM wsh_delivery_details
3800: WHERE source_line_id = l_order_line_id
3801: AND SOURCE_CODE = 'OE'; /*Fixed for bug#5846054 */
3802: EXCEPTION
3803: WHEN NO_DATA_FOUND THEN

Line 3912: FROM wsh_delivery_details

3908:
3909: BEGIN
3910: SELECT requested_quantity, released_status
3911: INTO l_ship_qty, l_release_status
3912: FROM wsh_delivery_details
3913: WHERE source_header_id =
3914: l_order_rec.order_header_id
3915: AND source_line_id = l_order_rec.order_line_id
3916: AND SOURCE_CODE = 'OE'; /*Fixed for bug#5685341*/

Line 8285: FROM wsh_delivery_details

8281: WHERE product_transaction_id = p_prod_txn_id;
8282:
8283: CURSOR released_lines_cur(p_order_header_id IN NUMBER, p_Order_Line_id IN NUMBER) IS
8284: SELECT source_header_id, source_line_id, released_status
8285: FROM wsh_delivery_details
8286: WHERE source_header_id = p_order_header_id
8287: AND Source_line_id = p_Order_line_id
8288: AND SOURCE_CODE = 'OE' /*Fixed for bug#5846054*/
8289: AND released_status = C_Staged_PickConfirmed;

Line 8293: FROM wsh_delivery_details

8289: AND released_status = C_Staged_PickConfirmed;
8290:
8291: CURSOR shipped_lines_cur(p_order_header_id IN NUMBER, p_Order_Line_Id IN NUMBER) IS
8292: SELECT source_header_id, source_line_id, released_status
8293: FROM wsh_delivery_details
8294: WHERE source_header_id = p_order_header_id
8295: AND Source_line_id = p_Order_line_id
8296: AND SOURCE_CODE = 'OE' /*Fixed for bug#5846054*/
8297: AND released_status = C_Shipped;

Line 8691: FROM wsh_delivery_details a

8687: -- check released_status column value for the delivery line, if even one record is found
8688: -- with status ready_for_release or backordered then whole order header needs to be pick released
8689: SELECT 'Y'
8690: INTO l_order_to_be_pickreleased
8691: FROM wsh_delivery_details a
8692: WHERE a.source_header_id =
8693: x_product_txn_rec.order_header_id
8694: AND a.source_line_id =
8695: x_product_txn_rec.order_line_id

Line 8758: FROM wsh_Delivery_Details

8754: -- order line id, if so line is not eligible to stamp for 'Released' status.
8755: BEGIN
8756: SELECT 'Y'
8757: INTO l_order_to_Be_PickReleased
8758: FROM wsh_Delivery_Details
8759: WHERE source_header_id =
8760: x_product_txn_rec.order_header_id
8761: AND source_line_id =
8762: x_product_txn_Rec.Order_line_id

Line 8887: FROM wsh_delivery_details

8883: -- select C_Yes
8884: -- into l_allow_ship
8885: SELECT Released_Status
8886: INTO l_Released_Status
8887: FROM wsh_delivery_details
8888: WHERE source_header_id =
8889: l_order_rec.order_header_id
8890: AND source_line_id = l_order_rec.order_line_id
8891: AND released_status IN (C_Staged_PickConfirmed,

Line 8962: FROM wsh_Delivery_Details

8958: -- product txn lines with Shipped status, if not then update product txn table
8959: BEGIN
8960: SELECT 'Y'
8961: INTO l_order_to_Be_Shipped
8962: FROM wsh_Delivery_Details
8963: WHERE source_header_id =
8964: x_product_txn_rec.order_header_id
8965: AND source_line_id =
8966: x_product_txn_Rec.Order_line_id