DBA Data[Home] [Help]

APPS.WSH_FTE_COMP_CONSTRAINT_GRP dependencies on WSH_FTE_COMP_CONSTRAINT_PKG

Line 55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;

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;

Line 56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_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;

Line 57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_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;
61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

Line 342: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_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;

Line 343: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;

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);

Line 344: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;

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;