DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_AUTOCREATE

Line 39: p_line_rows IN OUT NOCOPY wsh_delivery_autocreate.grp_attr_tab_type,

35: -- x_unassigned_rows : table of delivery detail IDs that are not appended
36: -- x_return_status : return status
37: -- ------------------------------------------------------------------------------------
38: PROCEDURE Auto_Assign_Deliveries(
39: p_line_rows IN OUT NOCOPY wsh_delivery_autocreate.grp_attr_tab_type,
40: p_group_by_header IN VARCHAR2,
41: p_check_fte_compatibility IN VARCHAR2,
42: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
43: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 76: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

72: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
73: l_details_in_cc_group WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
74:
75:
76: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
77: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
78: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
79: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
80: l_matched_entities WSH_UTIL_CORE.id_tab_type;

Line 77: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

73: l_details_in_cc_group WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
74:
75:
76: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
77: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
78: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
79: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
80: l_matched_entities WSH_UTIL_CORE.id_tab_type;
81: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;

Line 78: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;

74:
75:
76: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
77: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
78: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
79: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
80: l_matched_entities WSH_UTIL_CORE.id_tab_type;
81: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
82:

Line 79: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;

75:
76: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
77: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
78: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
79: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
80: l_matched_entities WSH_UTIL_CORE.id_tab_type;
81: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
82:
83:

Line 81: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;

77: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
78: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
79: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
80: l_matched_entities WSH_UTIL_CORE.id_tab_type;
81: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
82:
83:
84: l_index NUMBER;
85: l_current_line NUMBER;

Line 328: WSH_Delivery_Autocreate.Reset_WSH_TMP;

324: l_attr_tab.delete;
325: l_attr_tab(1) := p_line_rows(l_current_line);
326: l_attr_tab(1).entity_type := 'DELIVERY_DETAIL';
327:
328: WSH_Delivery_Autocreate.Reset_WSH_TMP;
329:
330: wsh_delivery_autocreate.Find_Matching_Groups(
331: p_attr_tab => l_attr_tab,
332: p_action_rec => l_action_rec,

Line 330: wsh_delivery_autocreate.Find_Matching_Groups(

326: l_attr_tab(1).entity_type := 'DELIVERY_DETAIL';
327:
328: WSH_Delivery_Autocreate.Reset_WSH_TMP;
329:
330: wsh_delivery_autocreate.Find_Matching_Groups(
331: p_attr_tab => l_attr_tab,
332: p_action_rec => l_action_rec,
333: p_target_rec => l_target_rec,
334: p_group_tab => l_group_info,

Line 1065: l_detail_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

1061:
1062: l_warning_num NUMBER := 0;
1063: l_return_status VARCHAR2(1) ;
1064:
1065: l_detail_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1066:
1067: l_unassigned_rows WSH_UTIL_CORE.Id_Tab_Type;
1068: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1069: l_index NUMBER;

Line 1072: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

1068: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1069: l_index NUMBER;
1070: l_delivery_detail_id NUMBER;
1071:
1072: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1073: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1074: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1075: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1076: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;

Line 1073: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;

1069: l_index NUMBER;
1070: l_delivery_detail_id NUMBER;
1071:
1072: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1073: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1074: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1075: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1076: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1077:

Line 1074: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;

1070: l_delivery_detail_id NUMBER;
1071:
1072: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1073: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1074: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1075: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1076: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1077:
1078: l_debug_on BOOLEAN;

Line 1076: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;

1072: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1073: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1074: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1075: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1076: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1077:
1078: l_debug_on BOOLEAN;
1079: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'Append_to_Deliveries';
1080: Auto_Assign_Deliveries_ERR EXCEPTION;

Line 1192: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(

1188:
1189: l_action_rec.action := 'CREATE_GROUPS';
1190: l_action_rec.group_by_header_flag := p_group_by_header;
1191:
1192: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(
1193: p_attr_tab => l_detail_info,
1194: p_action_rec => l_action_rec,
1195: p_target_rec => l_target_rec,
1196: p_group_tab => l_group_info,

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

1215: raise Group_Delivery_Details_ERR;
1216: END IF;
1217:
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from wsh_delivery_autocreate.Find_Matching_Groups: '|| l_return_status );
1220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Auto_Assign_Deliveries');
1221: END IF;
1222:
1223: Auto_Assign_Deliveries(