APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_DETAILS_UTILITIES

Line 1: PACKAGE BODY WSH_DELIVERY_DETAILS_UTILITIES as

1: PACKAGE BODY WSH_DELIVERY_DETAILS_UTILITIES as
2: /* $Header: WSHDDUTB.pls 120.7 2008/06/11 08:27:34 brana noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_UTILITIES';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_UTILITIES';

1: PACKAGE BODY WSH_DELIVERY_DETAILS_UTILITIES as
2: /* $Header: WSHDDUTB.pls 120.7 2008/06/11 08:27:34 brana noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_UTILITIES';
6:
7:
8: -- ------------------------------------------------------------------------------------
9: -- Start of comments

Line 36: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,

32: PROCEDURE Auto_Assign_Deliveries(
33: p_line_rows IN OUT NOCOPY wsh_delivery_autocreate.grp_attr_tab_type,
34: p_group_by_header IN VARCHAR2,
35: p_check_fte_compatibility IN VARCHAR2,
36: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
37: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
38: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
39: x_return_status OUT NOCOPY VARCHAR2) IS
40:

Line 950: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');

946: -- if the cursor is still open then close the cursor
947: IF c_get_deliveries%ISOPEN THEN
948: CLOSE c_get_deliveries;
949: END IF;
950: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');
951: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.pop(l_module_name);
954: END IF;

Line 1014: x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,

1010: p_group_by_header IN VARCHAR2,
1011: p_commit IN VARCHAR2,
1012: p_lock_rows IN VARCHAR2,
1013: p_check_fte_compatibility IN VARCHAR2,
1014: x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
1015: x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1016: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1017: x_return_status OUT NOCOPY VARCHAR2) IS
1018:

Line 1062: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;

1058:
1059: l_detail_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1060:
1061: l_unassigned_rows WSH_UTIL_CORE.Id_Tab_Type;
1062: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1063: l_index NUMBER;
1064: l_delivery_detail_id NUMBER;
1065:
1066: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

Line 1294: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

1290: CLOSE get_line_details_check;
1291: END IF;
1292:
1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1294: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
1295: IF l_debug_on THEN
1296: wsh_debug_sv.log(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM);
1297: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
1298: END IF;

Line 1304: END WSH_DELIVERY_DETAILS_UTILITIES;

1300: END Append_to_Deliveries;
1301:
1302:
1303:
1304: END WSH_DELIVERY_DETAILS_UTILITIES;
1305:
1306: