APPS.WSH_DELIVERY_SPLITTER_PKG dependencies on WSH_DELIVERY_DETAILS

Line 261: FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA

257: wdd.weight_uom_code,
258: p_uom,
259: WDD.GROSS_WEIGHT)) gross_weight_converted,
260: WDA.DELIVERY_DETAIL_ID
261: FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA
262: WHERE WDA.DELIVERY_ID = p_delivery_id
263: AND wda.delivery_detail_id = wdd.delivery_detail_id
264: AND WDA.PARENT_DELIVERY_DETAIL_ID IS NULL
265: AND WDD.WEIGHT_UOM_CODE IS NOT NULL

Line 272: FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA

268:
269: -- this will get all delivery details' (non LPN) released status
270: CURSOR c_get_delivery_line(p_delivery_id IN NUMBER) IS
271: SELECT WDD.RELEASED_STATUS
272: FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA
273: WHERE WDA.DELIVERY_ID = p_delivery_id
274: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
275: AND WDD.CONTAINER_FLAG = 'N'
276: AND WDD.RELEASED_STATUS NOT IN ('R', 'B', 'X');

Line 1002: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Unassign_multiple_details',

998: END LOOP;
999:
1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.logmsg(l_module_name,
1002: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Unassign_multiple_details',
1003: WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005:
1006: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(

Line 1006: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(

1002: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Unassign_multiple_details',
1003: WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005:
1006: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
1007: p_rec_of_detail_ids => l_temp_ids,
1008: p_from_delivery => 'Y',
1009: p_from_container => 'N',
1010: p_action_prms => l_action_prms,

Line 1014: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS: ' || l_return_status);

1010: p_action_prms => l_action_prms,
1011: x_return_status => l_return_status);
1012:
1013: IF l_debug_on THEN
1014: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS: ' || l_return_status);
1015: END IF;
1016:
1017: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1018:

Line 1075: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',

1071: l_temp_ids.DELETE;
1072:
1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.logmsg(l_module_name,
1075: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',
1076: WSH_DEBUG_SV.C_PROC_LEVEL);
1077: END IF;
1078:
1079: WSH_DELIVERY_DETAILS_GRP.autocreate_deliveries(

Line 1079: WSH_DELIVERY_DETAILS_GRP.autocreate_deliveries(

1075: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',
1076: WSH_DEBUG_SV.C_PROC_LEVEL);
1077: END IF;
1078:
1079: WSH_DELIVERY_DETAILS_GRP.autocreate_deliveries(
1080: p_api_version_number => 1.0,
1081: p_init_msg_list => FND_API.G_FALSE,
1082: p_commit => FND_API.G_FALSE,
1083: p_caller => l_action_prms.caller,

Line 1092: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);

1088: p_group_by_header_flag => 'N',
1089: x_del_rows => l_temp_ids);
1090:
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);
1093: END IF;
1094:
1095: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1096:

Line 1189: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',

1185: l_temp_ids.DELETE;
1186:
1187: IF l_debug_on THEN
1188: WSH_DEBUG_SV.logmsg(l_module_name,
1189: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',
1190: WSH_DEBUG_SV.C_PROC_LEVEL);
1191: END IF;
1192:
1193: WSH_DELIVERY_DETAILS_GRP.autocreate_deliveries(

Line 1193: WSH_DELIVERY_DETAILS_GRP.autocreate_deliveries(

1189: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',
1190: WSH_DEBUG_SV.C_PROC_LEVEL);
1191: END IF;
1192:
1193: WSH_DELIVERY_DETAILS_GRP.autocreate_deliveries(
1194: p_api_version_number => 1.0,
1195: p_init_msg_list => FND_API.G_FALSE,
1196: p_commit => FND_API.G_FALSE,
1197: p_caller => l_action_prms.caller,

Line 1206: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);

1202: p_group_by_header_flag => 'N',
1203: x_del_rows => l_temp_ids);
1204:
1205: IF l_debug_on THEN
1206: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);
1207: END IF;
1208:
1209: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1210: