51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58:
59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58:
59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58:
59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
338: IS
339:
340: l_cc_action_code VARCHAR2(3);
341: l_validate_result VARCHAR2(1) := 'S';
342: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
343: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
344: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
345: l_msg_count NUMBER;
346: l_msg_data VARCHAR2(2000) := NULL;
339:
340: l_cc_action_code VARCHAR2(3);
341: l_validate_result VARCHAR2(1) := 'S';
342: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
343: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
344: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
345: l_msg_count NUMBER;
346: l_msg_data VARCHAR2(2000) := NULL;
347: l_return_status VARCHAR2(1);
340: l_cc_action_code VARCHAR2(3);
341: l_validate_result VARCHAR2(1) := 'S';
342: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
343: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
344: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
345: l_msg_count NUMBER;
346: l_msg_data VARCHAR2(2000) := NULL;
347: l_return_status VARCHAR2(1);
348: l_in_ids WSH_UTIL_CORE.id_tab_type;