DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_AUTOCREATE

Line 2216: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;

2212:
2213: l_del_id_for_container c_del_id_for_cont_or_detail%ROWTYPE;
2214: l_del_id_for_detail c_del_id_for_cont_or_detail%ROWTYPE;
2215:
2216: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;
2217:
2218: invalid_detail exception;
2219: l_plan_flag varchar2(1);
2220: l_content_count NUMBER;

Line 2269: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

2265: l_topmost_cont NUMBER;
2266:
2267: -- Bug 4452930
2268:
2269: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2270: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2271: l_action_rec wsh_delivery_autocreate.action_rec_type;
2272: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2273: l_matched_entities wsh_util_core.id_tab_type;

Line 2270: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

2266:
2267: -- Bug 4452930
2268:
2269: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2270: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2271: l_action_rec wsh_delivery_autocreate.action_rec_type;
2272: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2273: l_matched_entities wsh_util_core.id_tab_type;
2274: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 2271: l_action_rec wsh_delivery_autocreate.action_rec_type;

2267: -- Bug 4452930
2268:
2269: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2270: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2271: l_action_rec wsh_delivery_autocreate.action_rec_type;
2272: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2273: l_matched_entities wsh_util_core.id_tab_type;
2274: l_out_rec wsh_delivery_autocreate.out_rec_type;
2275: l_group_index NUMBER;

Line 2272: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

2268:
2269: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2270: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2271: l_action_rec wsh_delivery_autocreate.action_rec_type;
2272: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2273: l_matched_entities wsh_util_core.id_tab_type;
2274: l_out_rec wsh_delivery_autocreate.out_rec_type;
2275: l_group_index NUMBER;
2276:

Line 2274: l_out_rec wsh_delivery_autocreate.out_rec_type;

2270: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2271: l_action_rec wsh_delivery_autocreate.action_rec_type;
2272: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2273: l_matched_entities wsh_util_core.id_tab_type;
2274: l_out_rec wsh_delivery_autocreate.out_rec_type;
2275: l_group_index NUMBER;
2276:
2277: l_num_warnings number := 0;
2278:

Line 2555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);

2551: -- J-IB-NPARIKH-}
2552: --
2553: --
2554: IF l_debug_on THEN
2555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
2556: END IF;
2557: --
2558: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(
2559: p_organization_id => l_del_id_for_detail.organization_id,

Line 2558: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(

2554: IF l_debug_on THEN
2555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
2556: END IF;
2557: --
2558: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(
2559: p_organization_id => l_del_id_for_detail.organization_id,
2560: p_client_id => l_del_id_for_detail.client_id, -- LSP PROJECT :
2561: x_group_by_flags => l_group_by_flags,
2562: x_return_status => x_return_status);

Line 2989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.CHECK_ASSIGN_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

2985: -- End of OTM R12 : assign delivery detail
2986:
2987:
2988: IF l_debug_on THEN
2989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.CHECK_ASSIGN_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2990: END IF;
2991:
2992: l_attr_tab(1).entity_id := l_del_id_for_container.delivery_id;
2993: l_attr_tab(1).entity_type := 'DELIVERY';

Line 3000: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,

2996:
2997: l_action_rec.action := 'MATCH_GROUPS';
2998: l_action_rec.check_single_grp := 'Y';
2999:
3000: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,
3001: p_action_rec => l_action_rec,
3002: p_target_rec => l_target_rec,
3003: p_group_tab => l_group_tab,
3004: x_matched_entities => l_matched_entities,

Line 4227: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

4223:
4224: -- bug 2691385
4225: l_detail_is_empty_cont VARCHAR2(1) := 'N';
4226:
4227: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
4228: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4229: l_action_rec wsh_delivery_autocreate.action_rec_type;
4230: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4231: l_matched_entities wsh_util_core.id_tab_type;

Line 4228: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

4224: -- bug 2691385
4225: l_detail_is_empty_cont VARCHAR2(1) := 'N';
4226:
4227: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
4228: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4229: l_action_rec wsh_delivery_autocreate.action_rec_type;
4230: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4231: l_matched_entities wsh_util_core.id_tab_type;
4232: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 4229: l_action_rec wsh_delivery_autocreate.action_rec_type;

4225: l_detail_is_empty_cont VARCHAR2(1) := 'N';
4226:
4227: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
4228: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4229: l_action_rec wsh_delivery_autocreate.action_rec_type;
4230: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4231: l_matched_entities wsh_util_core.id_tab_type;
4232: l_out_rec wsh_delivery_autocreate.out_rec_type;
4233:

Line 4230: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

4226:
4227: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
4228: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4229: l_action_rec wsh_delivery_autocreate.action_rec_type;
4230: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4231: l_matched_entities wsh_util_core.id_tab_type;
4232: l_out_rec wsh_delivery_autocreate.out_rec_type;
4233:
4234: -- K LPN CONV. rv

Line 4232: l_out_rec wsh_delivery_autocreate.out_rec_type;

4228: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4229: l_action_rec wsh_delivery_autocreate.action_rec_type;
4230: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4231: l_matched_entities wsh_util_core.id_tab_type;
4232: l_out_rec wsh_delivery_autocreate.out_rec_type;
4233:
4234: -- K LPN CONV. rv
4235: l_detail_wms_org VARCHAR2(10) := 'N';
4236: l_line_dir VARCHAR2(10);

Line 4630: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.CHECK_ASSIGN_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

4626: /* security rule, group by attributes must be the same as the delivery's */
4627: /* Error */
4628: --
4629: IF l_debug_on THEN
4630: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.CHECK_ASSIGN_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
4631: END IF;
4632: --
4633:
4634: l_attr_tab(1).entity_id := p_delivery_id;

Line 4646: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,

4642: -- IF this procedure is called from autocreate-delivery then
4643: -- the matching is already done.
4644:
4645: IF NVL(p_caller , 'WSH') <> 'AUTOCREATE' THEN --{ bug 5100229
4646: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,
4647: p_action_rec => l_action_rec,
4648: p_target_rec => l_target_rec,
4649: p_group_tab => l_group_tab,
4650: x_matched_entities => l_matched_entities,

Line 5428: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;

5424:
5425: detail_cont_name WSH_DELIVERY_DETAILS.CONTAINER_NAME%TYPE;
5426: parent_cont_name WSH_DELIVERY_DETAILS.CONTAINER_NAME%TYPE;
5427:
5428: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;
5429: /* H projects: pricing integration csun */
5430: m NUMBER := 0;
5431: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
5432: mark_reprice_error EXCEPTION;

Line 5864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);

5860: -- J-IB-NPARIKH-}
5861: --
5862: --
5863: IF l_debug_on THEN
5864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
5865: END IF;
5866: --
5867: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(
5868: p_organization_id => l_del_id_for_container1.organization_id,

Line 5867: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(

5863: IF l_debug_on THEN
5864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
5865: END IF;
5866: --
5867: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(
5868: p_organization_id => l_del_id_for_container1.organization_id,
5869: p_client_id => l_del_id_for_container1.client_id, -- LSP PROJECT
5870: x_group_by_flags => l_group_by_flags,
5871: x_return_status => x_return_status);