DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_AUTOCREATE

Line 33: p_line_rows IN OUT NOCOPY wsh_delivery_autocreate.grp_attr_tab_type,

29: -- x_unassigned_rows : table of delivery detail IDs that are not appended
30: -- x_return_status : return status
31: -- ------------------------------------------------------------------------------------
32: PROCEDURE Auto_Assign_Deliveries(
33: p_line_rows IN OUT NOCOPY wsh_delivery_autocreate.grp_attr_tab_type,
34: p_group_by_header IN VARCHAR2,
35: p_check_fte_compatibility IN VARCHAR2,
36: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
37: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 70: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

66: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
67: l_details_in_cc_group WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
68:
69:
70: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
71: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
72: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
73: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
74: l_matched_entities WSH_UTIL_CORE.id_tab_type;

Line 71: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

67: l_details_in_cc_group WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
68:
69:
70: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
71: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
72: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
73: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
74: l_matched_entities WSH_UTIL_CORE.id_tab_type;
75: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;

Line 72: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;

68:
69:
70: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
71: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
72: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
73: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
74: l_matched_entities WSH_UTIL_CORE.id_tab_type;
75: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
76:

Line 73: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;

69:
70: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
71: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
72: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
73: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
74: l_matched_entities WSH_UTIL_CORE.id_tab_type;
75: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
76:
77:

Line 75: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;

71: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
72: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
73: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
74: l_matched_entities WSH_UTIL_CORE.id_tab_type;
75: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
76:
77:
78: l_index NUMBER;
79: l_current_line NUMBER;

Line 322: WSH_Delivery_Autocreate.Reset_WSH_TMP;

318: l_attr_tab.delete;
319: l_attr_tab(1) := p_line_rows(l_current_line);
320: l_attr_tab(1).entity_type := 'DELIVERY_DETAIL';
321:
322: WSH_Delivery_Autocreate.Reset_WSH_TMP;
323:
324: wsh_delivery_autocreate.Find_Matching_Groups(
325: p_attr_tab => l_attr_tab,
326: p_action_rec => l_action_rec,

Line 324: wsh_delivery_autocreate.Find_Matching_Groups(

320: l_attr_tab(1).entity_type := 'DELIVERY_DETAIL';
321:
322: WSH_Delivery_Autocreate.Reset_WSH_TMP;
323:
324: wsh_delivery_autocreate.Find_Matching_Groups(
325: p_attr_tab => l_attr_tab,
326: p_action_rec => l_action_rec,
327: p_target_rec => l_target_rec,
328: p_group_tab => l_group_info,

Line 1059: l_detail_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

1055:
1056: l_warning_num NUMBER := 0;
1057: l_return_status VARCHAR2(1) ;
1058:
1059: l_detail_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1060:
1061: l_unassigned_rows WSH_UTIL_CORE.Id_Tab_Type;
1062: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1063: l_index NUMBER;

Line 1066: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

1062: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1063: l_index NUMBER;
1064: l_delivery_detail_id NUMBER;
1065:
1066: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1067: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1068: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1069: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1070: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;

Line 1067: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;

1063: l_index NUMBER;
1064: l_delivery_detail_id NUMBER;
1065:
1066: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1067: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1068: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1069: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1070: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1071:

Line 1068: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;

1064: l_delivery_detail_id NUMBER;
1065:
1066: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1067: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1068: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1069: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1070: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1071:
1072: l_debug_on BOOLEAN;

Line 1070: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;

1066: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1067: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1068: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1069: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1070: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1071:
1072: l_debug_on BOOLEAN;
1073: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'Append_to_Deliveries';
1074: Auto_Assign_Deliveries_ERR EXCEPTION;

Line 1186: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(

1182:
1183: l_action_rec.action := 'CREATE_GROUPS';
1184: l_action_rec.group_by_header_flag := p_group_by_header;
1185:
1186: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(
1187: p_attr_tab => l_detail_info,
1188: p_action_rec => l_action_rec,
1189: p_target_rec => l_target_rec,
1190: p_group_tab => l_group_info,

Line 1213: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from wsh_delivery_autocreate.Find_Matching_Groups: '|| l_return_status );

1209: raise Group_Delivery_Details_ERR;
1210: END IF;
1211:
1212: IF l_debug_on THEN
1213: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from wsh_delivery_autocreate.Find_Matching_Groups: '|| l_return_status );
1214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Auto_Assign_Deliveries');
1215: END IF;
1216:
1217: Auto_Assign_Deliveries(