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.WSH_DELIVERY_AUTOCREATE dependencies on WSH_NEW_DELIVERIES

Line 324: FROM wsh_new_deliveries wnd

320: NULL,
321: NULL, -- X-dock, is_xdocked_flag
322: wnd.client_id, -- LSP PROJECT
323: nvl(wnd.consignee_flag, 'C') -- RTV changes
324: FROM wsh_new_deliveries wnd
325: WHERE wnd.delivery_id = p_del_id;
326:
327: i NUMBER;
328: l_grouping_attributes grp_attr_rec_type;

Line 662: -- and update the hash_value and hash string in wsh_new_deliveries.

658:
659: END Create_Hash;
660:
661: -- This API will create a hash based on the grouping attributes of the delivery
662: -- and update the hash_value and hash string in wsh_new_deliveries.
663: -- p_delivery_id : Delivery that needs hash value and string to be updated.
664:
665: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
666: x_return_status OUT NOCOPY varchar2) IS

Line 665: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

661: -- This API will create a hash based on the grouping attributes of the delivery
662: -- and update the hash_value and hash string in wsh_new_deliveries.
663: -- p_delivery_id : Delivery that needs hash value and string to be updated.
664:
665: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
666: x_return_status OUT NOCOPY varchar2) IS
667:
668: l_grp_attr_tab grp_attr_tab_type;
669: l_tmp_grp_attr_tab grp_attr_tab_type;

Line 1101: from wsh_new_deliveries wnd

1097: p_ship_method_code in varchar2,
1098: p_organization_id in number ,
1099: p_ship_method_grp_flag in varchar2 ) is
1100: select delivery_id
1101: from wsh_new_deliveries wnd
1102: where wnd.hash_value = p_hash_value
1103: and wnd.hash_string = p_hash_string
1104: and wnd.organization_id = p_organization_id
1105: and (NVL(wnd.planned_flag, 'N') = 'N')

Line 1129: from wsh_new_deliveries wnd

1125: p_customer_id in number ,
1126: p_ship_method_grp_flag in varchar2,
1127: p_consignee_flag varchar2) is --RTV changes
1128: select delivery_id
1129: from wsh_new_deliveries wnd
1130: where wnd.hash_value = p_hash_value
1131: and wnd.hash_string = p_hash_string
1132: and wnd.organization_id = p_organization_id
1133: and wnd.customer_id = p_customer_id

Line 1156: from wsh_new_deliveries wnd

1152: p_ship_method_code in varchar2,
1153: p_ship_method_grp_flag in varchar2
1154: ) is
1155: select delivery_id
1156: from wsh_new_deliveries wnd
1157: where wnd.hash_value = p_hash_value
1158: and wnd.hash_string = p_hash_string
1159: and wnd.batch_id = p_batch_id
1160: and (NVL(wnd.planned_flag, 'N') = 'N')

Line 1180: from wsh_new_deliveries wnd

1176: p_organization_id in number ,
1177: p_ship_method_grp_flag in varchar2,
1178: p_client_id in number) is
1179: select delivery_id
1180: from wsh_new_deliveries wnd
1181: where wnd.hash_value = p_hash_value
1182: and wnd.hash_string = p_hash_string
1183: and wnd.organization_id = p_organization_id
1184: and (NVL(wnd.planned_flag, 'N') = 'N')

Line 1209: from wsh_new_deliveries wnd

1205: p_customer_id in number ,
1206: p_ship_method_grp_flag in varchar2,
1207: p_client_id in number) is
1208: select delivery_id
1209: from wsh_new_deliveries wnd
1210: where wnd.hash_value = p_hash_value
1211: and wnd.hash_string = p_hash_string
1212: and wnd.organization_id = p_organization_id
1213: and wnd.customer_id = p_customer_id

Line 1237: from wsh_new_deliveries wnd

1233: p_ship_method_grp_flag in varchar2,
1234: p_client_id in number
1235: ) is
1236: select delivery_id
1237: from wsh_new_deliveries wnd
1238: where wnd.hash_value = p_hash_value
1239: and wnd.hash_string = p_hash_string
1240: and wnd.batch_id = p_batch_id
1241: and (NVL(wnd.planned_flag, 'N') = 'N')

Line 1256: from wsh_new_deliveries d

1252:
1253: --BUG 3383843
1254: CURSOR c_dlvy_for_cont(p_organization_id NUMBER, p_ship_from_loc_id NUMBER) IS
1255: select delivery_id
1256: from wsh_new_deliveries d
1257: where d.status_code IN ('OP','SA')
1258: and d.planned_flag = 'N'
1259: and NVL(p_ship_from_loc_id, nvl(d.initial_pickup_location_id, -1))
1260: = nvl(d.initial_pickup_location_id, -1)

Line 1632: 'from wsh_new_deliveries wnd '||

1628: ELSIF p_action_rec.output_format_type = 'SQL_STRING' THEN
1629: -- Return the string and the variables that need to be bound.
1630:
1631: l_query_string := 'select delivery_id '||
1632: 'from wsh_new_deliveries wnd '||
1633: 'where wnd.hash_value = :p_hash_value '||
1634: 'and wnd.hash_string = :p_hash_string '||
1635: 'and wnd.status_code = ''OP'' ';
1636:

Line 1881: p_delivery_info IN wsh_new_deliveries_pvt.delivery_rec_type,

1877: --
1878: -----------------------------------------------------------------------------
1879:
1880: PROCEDURE Autonomous_Create_Delivery (
1881: p_delivery_info IN wsh_new_deliveries_pvt.delivery_rec_type,
1882: x_rowid OUT NOCOPY VARCHAR2,
1883: x_delivery_id OUT NOCOPY NUMBER,
1884: x_delivery_name OUT NOCOPY VARCHAR2,
1885: x_return_status OUT NOCOPY VARCHAR2)

Line 1905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

1901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1902:
1903: IF l_debug_on THEN
1904: WSH_DEBUG_SV.push(l_module_name);
1905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1906: END IF;
1907: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1909: IF l_debug_on THEN

Line 1907: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);

1903: IF l_debug_on THEN
1904: WSH_DEBUG_SV.push(l_module_name);
1905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1906: END IF;
1907: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1911: END IF;

Line 1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');

1906: END IF;
1907: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1911: END IF;
1912: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

Line 1914: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1911: END IF;
1912: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');
1915: END IF;
1916: RAISE OTHERS;
1917: ELSE
1918: IF l_debug_on THEN

Line 1919: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');

1915: END IF;
1916: RAISE OTHERS;
1917: ELSE
1918: IF l_debug_on THEN
1919: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');
1920: WSH_DEBUG_SV.pop(l_module_name);
1921: END IF;
1922: ROLLBACK;
1923: RETURN;

Line 1935: (p_table_name => 'WSH_NEW_DELIVERIES',

1931: IF l_debug_on THEN
1932: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FLEXFIELD_UTILS.WRITE_DFF_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
1933: END IF;
1934: wsh_flexfield_utils.WRITE_DFF_ATTRIBUTES
1935: (p_table_name => 'WSH_NEW_DELIVERIES',
1936: p_primary_id => x_delivery_id,
1937: x_return_status => x_return_status);
1938:
1939: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 2023: from wsh_new_deliveries wnd

2019: p_carrier_id in number,
2020: p_mode_of_transport in varchar2,
2021: p_service_level in varchar2) is
2022: select delivery_id, name, rowid
2023: from wsh_new_deliveries wnd
2024: where wnd.hash_value = p_hash_value
2025: and wnd.hash_string = p_hash_string
2026: and wnd.batch_id = p_batch_id
2027: and (NVL(wnd.planned_flag, 'N') = 'N')

Line 2035: l_delivery_info wsh_new_deliveries_pvt.delivery_rec_type;

2031: and NVL(NVL(wnd.mode_of_transport, p_mode_of_transport), -1) = NVL(NVL(p_mode_of_transport, wnd.mode_of_transport), -1)
2032: and wnd.status_code in ('OP', 'SA');
2033:
2034: l_group_info grp_attr_tab_type;
2035: l_delivery_info wsh_new_deliveries_pvt.delivery_rec_type;
2036: l_rowid VARCHAR2(30);
2037: l_delivery_id NUMBER;
2038: l_delivery_name wsh_new_deliveries.name%TYPE;
2039: l_weight_uom_code VARCHAR2(10);

Line 2038: l_delivery_name wsh_new_deliveries.name%TYPE;

2034: l_group_info grp_attr_tab_type;
2035: l_delivery_info wsh_new_deliveries_pvt.delivery_rec_type;
2036: l_rowid VARCHAR2(30);
2037: l_delivery_id NUMBER;
2038: l_delivery_name wsh_new_deliveries.name%TYPE;
2039: l_weight_uom_code VARCHAR2(10);
2040: l_volume_uom_code VARCHAR2(10);
2041:
2042: l_assigned_flag VARCHAR2(1) := 'N';

Line 2276: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.get_name(l_attr_tab(i).DELIVERY_ID));

2272: END IF;
2273: --
2274: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_ASSIGNED_DEL');
2275: FND_MESSAGE.SET_TOKEN('DET_NAME', l_attr_tab(i).entity_id);
2276: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.get_name(l_attr_tab(i).DELIVERY_ID));
2277: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
2278:
2279: l_assigned_flag := 'Y';
2280:

Line 2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

2447: --}
2448: ELSE
2449: --{ non-parallel-pick case
2450: IF l_debug_on THEN
2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2452: END IF;
2453: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2455: IF l_debug_on THEN

Line 2453: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);

2449: --{ non-parallel-pick case
2450: IF l_debug_on THEN
2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2452: END IF;
2453: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2457: END IF;

Line 2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );

2452: END IF;
2453: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2457: END IF;
2458: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2459: IF l_debug_on THEN
2460: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

Line 2460: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2457: END IF;
2458: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2459: IF l_debug_on THEN
2460: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');
2461: END IF;
2462: raise others;
2463: ELSE
2464: IF l_debug_on THEN

Line 2465: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');

2461: END IF;
2462: raise others;
2463: ELSE
2464: IF l_debug_on THEN
2465: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');
2466: END IF;
2467: raise e_return_excp;
2468: END IF;
2469: END IF;

Line 2481: (p_table_name => 'WSH_NEW_DELIVERIES',

2477: IF l_debug_on THEN
2478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FLEXFIELD_UTILS.WRITE_DFF_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2479: END IF;
2480: wsh_flexfield_utils.WRITE_DFF_ATTRIBUTES
2481: (p_table_name => 'WSH_NEW_DELIVERIES',
2482: p_primary_id => l_delivery_id,
2483: x_return_status => x_return_status);
2484:
2485: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 3406: DELETE FROM wsh_new_deliveries wnd

3402: END IF;
3403:
3404: --OTM R12, allow delete of 'NS' deliveries
3405: IF (l_gc3_is_installed = 'Y') THEN
3406: DELETE FROM wsh_new_deliveries wnd
3407: WHERE batch_id = p_batch_id
3408: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3409: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3410: AND NOT EXISTS (

Line 3408: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

3404: --OTM R12, allow delete of 'NS' deliveries
3405: IF (l_gc3_is_installed = 'Y') THEN
3406: DELETE FROM wsh_new_deliveries wnd
3407: WHERE batch_id = p_batch_id
3408: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3409: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3410: AND NOT EXISTS (
3411: SELECT 'x'
3412: FROM wsh_delivery_assignments wda

Line 3409: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT

3405: IF (l_gc3_is_installed = 'Y') THEN
3406: DELETE FROM wsh_new_deliveries wnd
3407: WHERE batch_id = p_batch_id
3408: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3409: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3410: AND NOT EXISTS (
3411: SELECT 'x'
3412: FROM wsh_delivery_assignments wda
3413: WHERE wda.delivery_id = wnd.delivery_id

Line 3417: DELETE FROM wsh_new_deliveries wnd

3413: WHERE wda.delivery_id = wnd.delivery_id
3414: AND wda.delivery_id IS NOT NULL);
3415: --END OTM R12
3416: ELSE
3417: DELETE FROM wsh_new_deliveries wnd
3418: WHERE batch_id = p_batch_id
3419: AND NOT EXISTS (
3420: SELECT 'x'
3421: FROM wsh_delivery_assignments wda

Line 4083: p_del_attributes_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

4079: -- x_return_status: status.
4080: **/
4081:
4082: PROCEDURE Autocreate_Consol_Delivery(
4083: p_del_attributes_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
4084: p_caller IN VARCHAR2,
4085: p_trip_prefix IN VARCHAR2,
4086: x_parent_del_id OUT NOCOPY NUMBER,
4087: x_parent_trip_id OUT NOCOPY NUMBER,

Line 4094: FROM wsh_delivery_legs l, wsh_trip_stops s1, wsh_new_deliveries d

4090:
4091: CURSOR c_trip_info(p_delivery_id IN NUMBER) IS
4092: SELECT s1.trip_id,
4093: NVL(d.ignore_for_planning, 'N') --OTM R12, delivery ignore same as trip's
4094: FROM wsh_delivery_legs l, wsh_trip_stops s1, wsh_new_deliveries d
4095: WHERE l.delivery_id = p_delivery_id
4096: AND d.delivery_id = l.delivery_id
4097: AND s1.stop_id = l.pick_up_stop_id
4098: AND s1.stop_location_id = d.initial_pickup_location_id;

Line 4116: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

4112: l_trip_id NUMBER;
4113: l_trip_id_temp NUMBER;
4114: -- l_trip_info_rec_tab is table of c_trip_info%rowtype index by binary_integer;
4115:
4116: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4117: l_del_tab WSH_UTIL_CORE.id_tab_type;
4118: l_trip_del_tab WSH_UTIL_CORE.id_tab_type;
4119: l_intermediate_loc_tab WSH_UTIL_CORE.id_tab_type;
4120: l_pickup_stop_id NUMBER;

Line 4426: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_new_deliveries_pvt.create_delivery',WSH_DEBUG_SV.C_PROC_LEVEL);

4422:
4423: -- Create the delivery
4424:
4425: IF l_debug_on THEN
4426: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_new_deliveries_pvt.create_delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
4427: END IF;
4428:
4429: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);
4430:

Line 4429: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);

4425: IF l_debug_on THEN
4426: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_new_deliveries_pvt.create_delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
4427: END IF;
4428:
4429: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);
4430:
4431: wsh_util_core.api_post_call
4432: (
4433: p_return_status => l_return_status,