DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DELIVERY_AUTOCREATE

Line 195: l_del_params wsh_delivery_autocreate.grp_attr_tab_type;

191: l_cont_ins_id NUMBER := NULL;
192: l_tabofdeldets wsh_util_core.id_tab_type;
193: l_msg_summary VARCHAR2(2000) := NULL;
194: l_msg_details VARCHAR2(4000) := NULL;
195: l_del_params wsh_delivery_autocreate.grp_attr_tab_type;
196: wsh_no_del_det_tbl EXCEPTION;
197: wsh_no_delivery_id EXCEPTION;
198: wsh_no_delivery EXCEPTION; /*2777869*/
199: wsh_invalid_delivery_id EXCEPTION; /*2777869*/

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

1677: END IF;
1678: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1679:
1680: IF l_debug_on THEN
1681: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS',WSH_DEBUG_SV.C_PROC_LEVEL);
1682: END IF;
1683: --
1684: wsh_delivery_autocreate.autocreate_del_across_orgs(
1685: p_line_rows => p_line_rows,

Line 1684: wsh_delivery_autocreate.autocreate_del_across_orgs(

1680: IF l_debug_on THEN
1681: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS',WSH_DEBUG_SV.C_PROC_LEVEL);
1682: END IF;
1683: --
1684: wsh_delivery_autocreate.autocreate_del_across_orgs(
1685: p_line_rows => p_line_rows,
1686: p_org_rows => l_dummy_rows, -- bug 1668578
1687: p_container_flag => 'N',
1688: p_check_flag => 'N',

Line 2321: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;

2317: --
2318: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
2319: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2320: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2321: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2322:
2323: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2324: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2325: l_action_rec wsh_delivery_autocreate.action_rec_type;

Line 2323: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

2319: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2320: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2321: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2322:
2323: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2324: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2325: l_action_rec wsh_delivery_autocreate.action_rec_type;
2326: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2327: l_matched_entities wsh_util_core.id_tab_type;

Line 2324: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;

2320: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2321: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2322:
2323: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2324: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2325: l_action_rec wsh_delivery_autocreate.action_rec_type;
2326: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2327: l_matched_entities wsh_util_core.id_tab_type;
2328: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 2325: l_action_rec wsh_delivery_autocreate.action_rec_type;

2321: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2322:
2323: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2324: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2325: l_action_rec wsh_delivery_autocreate.action_rec_type;
2326: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2327: l_matched_entities wsh_util_core.id_tab_type;
2328: l_out_rec wsh_delivery_autocreate.out_rec_type;
2329:

Line 2326: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

2322:
2323: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2324: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2325: l_action_rec wsh_delivery_autocreate.action_rec_type;
2326: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2327: l_matched_entities wsh_util_core.id_tab_type;
2328: l_out_rec wsh_delivery_autocreate.out_rec_type;
2329:
2330: -- Consolidation of BO Delivery details project

Line 2328: l_out_rec wsh_delivery_autocreate.out_rec_type;

2324: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2325: l_action_rec wsh_delivery_autocreate.action_rec_type;
2326: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2327: l_matched_entities wsh_util_core.id_tab_type;
2328: l_out_rec wsh_delivery_autocreate.out_rec_type;
2329:
2330: -- Consolidation of BO Delivery details project
2331: l_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2332: l_cons_flags WSH_UTIL_CORE.Column_Tab_Type;

Line 3124: wsh_delivery_autocreate.Find_Matching_Groups(

3120: l_action_rec.output_format_type := 'TEMP_TAB';
3121: l_action_rec.action := 'MATCH_GROUPS';
3122:
3123:
3124: wsh_delivery_autocreate.Find_Matching_Groups(
3125: p_attr_tab => l_attr_tab,
3126: p_action_rec => l_action_rec,
3127: p_target_rec => l_target_rec,
3128: p_group_tab => l_group_info,

Line 10880: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

10876: PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,
10877: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
10878: x_return_status OUT NOCOPY VARCHAR2) IS
10879:
10880: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10881: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10882: l_action_rec wsh_delivery_autocreate.action_rec_type;
10883: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10884: l_matched_entities wsh_util_core.id_tab_type;

Line 10881: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

10877: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
10878: x_return_status OUT NOCOPY VARCHAR2) IS
10879:
10880: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10881: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10882: l_action_rec wsh_delivery_autocreate.action_rec_type;
10883: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10884: l_matched_entities wsh_util_core.id_tab_type;
10885: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 10882: l_action_rec wsh_delivery_autocreate.action_rec_type;

10878: x_return_status OUT NOCOPY VARCHAR2) IS
10879:
10880: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10881: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10882: l_action_rec wsh_delivery_autocreate.action_rec_type;
10883: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10884: l_matched_entities wsh_util_core.id_tab_type;
10885: l_out_rec wsh_delivery_autocreate.out_rec_type;
10886:

Line 10883: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

10879:
10880: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10881: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10882: l_action_rec wsh_delivery_autocreate.action_rec_type;
10883: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10884: l_matched_entities wsh_util_core.id_tab_type;
10885: l_out_rec wsh_delivery_autocreate.out_rec_type;
10886:
10887: l_debug_on Boolean;

Line 10885: l_out_rec wsh_delivery_autocreate.out_rec_type;

10881: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10882: l_action_rec wsh_delivery_autocreate.action_rec_type;
10883: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10884: l_matched_entities wsh_util_core.id_tab_type;
10885: l_out_rec wsh_delivery_autocreate.out_rec_type;
10886:
10887: l_debug_on Boolean;
10888:
10889: --bug 7171766

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

10915: END LOOP;
10916: l_action_rec.action := 'MATCH_GROUPS';
10917:
10918: IF l_debug_on THEN
10919: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups', WSH_DEBUG_SV.C_PROC_LEVEL);
10920: END IF;
10921: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups (
10922: p_attr_tab => l_attr_tab,
10923: p_action_rec => l_action_rec,

Line 10921: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups (

10917:
10918: IF l_debug_on THEN
10919: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups', WSH_DEBUG_SV.C_PROC_LEVEL);
10920: END IF;
10921: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups (
10922: p_attr_tab => l_attr_tab,
10923: p_action_rec => l_action_rec,
10924: p_target_rec => l_target_rec,
10925: p_group_tab => l_group_tab,