DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DELIVERY_AUTOCREATE

Line 191: l_del_params wsh_delivery_autocreate.grp_attr_tab_type;

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

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

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

Line 1680: wsh_delivery_autocreate.autocreate_del_across_orgs(

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

Line 2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;

2311: --
2312: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
2313: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2314: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;

Line 2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

2313: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2314: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;

Line 2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;

2314: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 2319: l_action_rec wsh_delivery_autocreate.action_rec_type;

2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:

Line 2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:
2324: -- Consolidation of BO Delivery details project

Line 2322: l_out_rec wsh_delivery_autocreate.out_rec_type;

2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:
2324: -- Consolidation of BO Delivery details project
2325: l_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2326: l_cons_flags WSH_UTIL_CORE.Column_Tab_Type;

Line 3117: wsh_delivery_autocreate.Find_Matching_Groups(

3113: l_action_rec.output_format_type := 'TEMP_TAB';
3114: l_action_rec.action := 'MATCH_GROUPS';
3115:
3116:
3117: wsh_delivery_autocreate.Find_Matching_Groups(
3118: p_attr_tab => l_attr_tab,
3119: p_action_rec => l_action_rec,
3120: p_target_rec => l_target_rec,
3121: p_group_tab => l_group_info,

Line 10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

10756: PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,
10757: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
10758: x_return_status OUT NOCOPY VARCHAR2) IS
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;

Line 10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

10757: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
10758: x_return_status OUT NOCOPY VARCHAR2) IS
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 10762: l_action_rec wsh_delivery_autocreate.action_rec_type;

10758: x_return_status OUT NOCOPY VARCHAR2) IS
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;
10766:

Line 10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;
10766:
10767: l_debug_on Boolean;

Line 10765: l_out_rec wsh_delivery_autocreate.out_rec_type;

10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;
10766:
10767: l_debug_on Boolean;
10768:
10769: --bug 7171766

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

10795: END LOOP;
10796: l_action_rec.action := 'MATCH_GROUPS';
10797:
10798: IF l_debug_on THEN
10799: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups', WSH_DEBUG_SV.C_PROC_LEVEL);
10800: END IF;
10801: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups (
10802: p_attr_tab => l_attr_tab,
10803: p_action_rec => l_action_rec,

Line 10801: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups (

10797:
10798: IF l_debug_on THEN
10799: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups', WSH_DEBUG_SV.C_PROC_LEVEL);
10800: END IF;
10801: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups (
10802: p_attr_tab => l_attr_tab,
10803: p_action_rec => l_action_rec,
10804: p_target_rec => l_target_rec,
10805: p_group_tab => l_group_tab,