DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on WSH_DELIVERY_DETAILS_PUB

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 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 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,