DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_AUTOCREATE

Line 2110: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;

2106:
2107: l_del_id_for_container c_del_id_for_cont_or_detail%ROWTYPE;
2108: l_del_id_for_detail c_del_id_for_cont_or_detail%ROWTYPE;
2109:
2110: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;
2111:
2112: invalid_detail exception;
2113: l_plan_flag varchar2(1);
2114: l_content_count NUMBER;

Line 2163: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

2159: l_topmost_cont NUMBER;
2160:
2161: -- Bug 4452930
2162:
2163: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2164: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2165: l_action_rec wsh_delivery_autocreate.action_rec_type;
2166: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2167: l_matched_entities wsh_util_core.id_tab_type;

Line 2164: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

2160:
2161: -- Bug 4452930
2162:
2163: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2164: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2165: l_action_rec wsh_delivery_autocreate.action_rec_type;
2166: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2167: l_matched_entities wsh_util_core.id_tab_type;
2168: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 2165: l_action_rec wsh_delivery_autocreate.action_rec_type;

2161: -- Bug 4452930
2162:
2163: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2164: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2165: l_action_rec wsh_delivery_autocreate.action_rec_type;
2166: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2167: l_matched_entities wsh_util_core.id_tab_type;
2168: l_out_rec wsh_delivery_autocreate.out_rec_type;
2169: l_group_index NUMBER;

Line 2166: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

2162:
2163: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2164: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2165: l_action_rec wsh_delivery_autocreate.action_rec_type;
2166: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2167: l_matched_entities wsh_util_core.id_tab_type;
2168: l_out_rec wsh_delivery_autocreate.out_rec_type;
2169: l_group_index NUMBER;
2170:

Line 2168: l_out_rec wsh_delivery_autocreate.out_rec_type;

2164: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2165: l_action_rec wsh_delivery_autocreate.action_rec_type;
2166: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2167: l_matched_entities wsh_util_core.id_tab_type;
2168: l_out_rec wsh_delivery_autocreate.out_rec_type;
2169: l_group_index NUMBER;
2170:
2171: l_num_warnings number := 0;
2172:

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

2445: -- J-IB-NPARIKH-}
2446: --
2447: --
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
2450: END IF;
2451: --
2452: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(
2453: p_organization_id => l_del_id_for_detail.organization_id,

Line 2452: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(

2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
2450: END IF;
2451: --
2452: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(
2453: p_organization_id => l_del_id_for_detail.organization_id,
2454: x_group_by_flags => l_group_by_flags,
2455: x_return_status => x_return_status);
2456:

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

2840: -- End of OTM R12 : assign delivery detail
2841:
2842:
2843: IF l_debug_on THEN
2844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.CHECK_ASSIGN_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2845: END IF;
2846:
2847: l_attr_tab(1).entity_id := l_del_id_for_container.delivery_id;
2848: l_attr_tab(1).entity_type := 'DELIVERY';

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

2851:
2852: l_action_rec.action := 'MATCH_GROUPS';
2853: l_action_rec.check_single_grp := 'Y';
2854:
2855: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,
2856: p_action_rec => l_action_rec,
2857: p_target_rec => l_target_rec,
2858: p_group_tab => l_group_tab,
2859: x_matched_entities => l_matched_entities,

Line 4080: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

4076:
4077: -- bug 2691385
4078: l_detail_is_empty_cont VARCHAR2(1) := 'N';
4079:
4080: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
4081: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4082: l_action_rec wsh_delivery_autocreate.action_rec_type;
4083: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4084: l_matched_entities wsh_util_core.id_tab_type;

Line 4081: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

4077: -- bug 2691385
4078: l_detail_is_empty_cont VARCHAR2(1) := 'N';
4079:
4080: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
4081: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4082: l_action_rec wsh_delivery_autocreate.action_rec_type;
4083: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4084: l_matched_entities wsh_util_core.id_tab_type;
4085: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 4082: l_action_rec wsh_delivery_autocreate.action_rec_type;

4078: l_detail_is_empty_cont VARCHAR2(1) := 'N';
4079:
4080: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
4081: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4082: l_action_rec wsh_delivery_autocreate.action_rec_type;
4083: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4084: l_matched_entities wsh_util_core.id_tab_type;
4085: l_out_rec wsh_delivery_autocreate.out_rec_type;
4086:

Line 4083: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

4079:
4080: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
4081: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4082: l_action_rec wsh_delivery_autocreate.action_rec_type;
4083: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4084: l_matched_entities wsh_util_core.id_tab_type;
4085: l_out_rec wsh_delivery_autocreate.out_rec_type;
4086:
4087: -- K LPN CONV. rv

Line 4085: l_out_rec wsh_delivery_autocreate.out_rec_type;

4081: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
4082: l_action_rec wsh_delivery_autocreate.action_rec_type;
4083: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
4084: l_matched_entities wsh_util_core.id_tab_type;
4085: l_out_rec wsh_delivery_autocreate.out_rec_type;
4086:
4087: -- K LPN CONV. rv
4088: l_detail_wms_org VARCHAR2(10) := 'N';
4089: l_line_dir VARCHAR2(10);

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

4477: /* security rule, group by attributes must be the same as the delivery's */
4478: /* Error */
4479: --
4480: IF l_debug_on THEN
4481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.CHECK_ASSIGN_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
4482: END IF;
4483: --
4484:
4485: l_attr_tab(1).entity_id := p_delivery_id;

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

4493: -- IF this procedure is called from autocreate-delivery then
4494: -- the matching is already done.
4495:
4496: IF NVL(p_caller , 'WSH') <> 'AUTOCREATE' THEN --{ bug 5100229
4497: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,
4498: p_action_rec => l_action_rec,
4499: p_target_rec => l_target_rec,
4500: p_group_tab => l_group_tab,
4501: x_matched_entities => l_matched_entities,

Line 5275: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;

5271:
5272: detail_cont_name WSH_DELIVERY_DETAILS.CONTAINER_NAME%TYPE;
5273: parent_cont_name WSH_DELIVERY_DETAILS.CONTAINER_NAME%TYPE;
5274:
5275: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;
5276: /* H projects: pricing integration csun */
5277: m NUMBER := 0;
5278: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
5279: mark_reprice_error EXCEPTION;

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

5707: -- J-IB-NPARIKH-}
5708: --
5709: --
5710: IF l_debug_on THEN
5711: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
5712: END IF;
5713: --
5714: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(
5715: p_organization_id => l_del_id_for_container1.organization_id,

Line 5714: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(

5710: IF l_debug_on THEN
5711: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
5712: END IF;
5713: --
5714: WSH_DELIVERY_AUTOCREATE.get_group_by_attr(
5715: p_organization_id => l_del_id_for_container1.organization_id,
5716: x_group_by_flags => l_group_by_flags,
5717: x_return_status => x_return_status);
5718: