eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_FTE_COMP_CONSTRAINT_PKG

Line 1842: p_group_tab IN OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,

1838: --========================================================================
1839:
1840: PROCEDURE create_valid_entity_group(
1841: p_entity_rec IN OUT NOCOPY entity_rec_type,
1842: p_group_tab IN OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
1843: x_return_status OUT NOCOPY VARCHAR2)
1844: IS
1845:
1846: l_group_count NUMBER := p_group_tab.COUNT;

Line 2607: -- This procedure is called from WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint.

2603: -- x_return_status Return status
2604: -- COMMENT :
2605: -- This is an internal procedure to determine if exclusive region/zone facility
2606: -- constraint has been defined for a given Region/Zone and facility
2607: -- This procedure is called from WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint.
2608: -- The procedure First validates Region Level Constraints and then Zone
2609: -- Level constraints.
2610: --========================================================================
2611:

Line 6301: p_group_tab IN WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,

6297: p_target_stops_info IN target_tripstop_cc_rec_type,
6298: p_entity_rec IN entity_rec_type,
6299: p_target_trip_id IN NUMBER DEFAULT NULL,
6300: p_entity_tab IN entity_tab_type,
6301: p_group_tab IN WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
6302: x_failed_constraints IN OUT NOCOPY line_constraint_tab_type,
6303: x_group_id OUT NOCOPY NUMBER,
6304: x_found OUT NOCOPY BOOLEAN,
6305: x_return_status OUT NOCOPY VARCHAR2)

Line 9897: p_group_tab IN OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,

9893: PROCEDURE validate_positive_constraint(
9894: p_action_code IN VARCHAR2,
9895: p_comp_class_tab IN WSH_UTIL_CORE.column_tab_type,
9896: p_entity_tab IN OUT NOCOPY entity_tab_type,
9897: p_group_tab IN OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
9898: p_detail_tab IN detail_ccinfo_tab_type,
9899: p_target_trip IN trip_ccinfo_rec_type,
9900: p_target_tripstops IN stop_ccinfo_tab_type,
9901: p_target_stops_info IN target_tripstop_cc_rec_type,

Line 9902: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,

9898: p_detail_tab IN detail_ccinfo_tab_type,
9899: p_target_trip IN trip_ccinfo_rec_type,
9900: p_target_tripstops IN stop_ccinfo_tab_type,
9901: p_target_stops_info IN target_tripstop_cc_rec_type,
9902: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,
9903: x_failed_lines IN OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,
9904: x_failed_constraints IN OUT NOCOPY line_constraint_tab_type,
9905: x_return_status OUT NOCOPY VARCHAR2)
9906: IS

Line 9903: x_failed_lines IN OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,

9899: p_target_trip IN trip_ccinfo_rec_type,
9900: p_target_tripstops IN stop_ccinfo_tab_type,
9901: p_target_stops_info IN target_tripstop_cc_rec_type,
9902: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,
9903: x_failed_lines IN OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,
9904: x_failed_constraints IN OUT NOCOPY line_constraint_tab_type,
9905: x_return_status OUT NOCOPY VARCHAR2)
9906: IS
9907:

Line 11581: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,

11577: p_target_trip_assign_dels IN delivery_ccinfo_tab_type,
11578: p_target_trip_dlvy_lines IN detail_ccinfo_tab_type,
11579: p_target_trip_incl_stops IN stop_ccinfo_tab_type,
11580: x_validate_result OUT NOCOPY VARCHAR2,
11581: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,
11582: x_group_info OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
11583: x_failed_lines OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,
11584: x_msg_count OUT NOCOPY NUMBER,
11585: x_msg_data OUT NOCOPY VARCHAR2,

Line 11582: x_group_info OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,

11578: p_target_trip_dlvy_lines IN detail_ccinfo_tab_type,
11579: p_target_trip_incl_stops IN stop_ccinfo_tab_type,
11580: x_validate_result OUT NOCOPY VARCHAR2,
11581: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,
11582: x_group_info OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
11583: x_failed_lines OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,
11584: x_msg_count OUT NOCOPY NUMBER,
11585: x_msg_data OUT NOCOPY VARCHAR2,
11586: x_return_status OUT NOCOPY VARCHAR2)

Line 11583: x_failed_lines OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,

11579: p_target_trip_incl_stops IN stop_ccinfo_tab_type,
11580: x_validate_result OUT NOCOPY VARCHAR2,
11581: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,
11582: x_group_info OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
11583: x_failed_lines OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,
11584: x_msg_count OUT NOCOPY NUMBER,
11585: x_msg_data OUT NOCOPY VARCHAR2,
11586: x_return_status OUT NOCOPY VARCHAR2)
11587: IS

Line 11618: l_group_tab1 WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;

11614: l_validate_result VARCHAR2(1);
11615: l_comp_class_tab WSH_UTIL_CORE.column_tab_type;
11616: l_entity_tab entity_tab_type;
11617: l_group_tab entity_group_tab_type;
11618: l_group_tab1 WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
11619: l_found BOOLEAN := FALSE;
11620: l_failed_constraints line_constraint_tab_type;
11621: l_failed_constraint line_constraint_rec_type;
11622: l_delivery_rec delivery_ccinfo_rec_type;

Line 11667: l_dummy_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;

11663: l_location_id NUMBER := NULL;
11664: l_validate_carrier_result VARCHAR2(1) := 'S';
11665: l_validate_vehicle_result VARCHAR2(1) := 'S';
11666: l_validate_mode_result VARCHAR2(1) := 'S';
11667: l_dummy_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
11668: l_dummy_failed_lc NUMBER:=0;
11669: l_upd_delivery_rec delivery_ccinfo_rec_type;
11670: g_invalid_action_code EXCEPTION;
11671: l_vehicle_name VARCHAR2(2000);

Line 13189: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;

13185: l_trip_dlvy_tab delivery_ccinfo_tab_type;
13186: l_trip_stops_tab stop_ccinfo_tab_type;
13187: l_target_tripstops target_tripstop_cc_rec_type;
13188: l_entity_tab entity_tab_type;
13189: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
13190: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
13191: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
13192:
13193: l_delivery_leg_rec dleg_ccinfo_rec_type;

Line 13190: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;

13186: l_trip_stops_tab stop_ccinfo_tab_type;
13187: l_target_tripstops target_tripstop_cc_rec_type;
13188: l_entity_tab entity_tab_type;
13189: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
13190: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
13191: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
13192:
13193: l_delivery_leg_rec dleg_ccinfo_rec_type;
13194: l_physical_location_id NUMBER := NULL;

Line 13191: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;

13187: l_target_tripstops target_tripstop_cc_rec_type;
13188: l_entity_tab entity_tab_type;
13189: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
13190: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
13191: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
13192:
13193: l_delivery_leg_rec dleg_ccinfo_rec_type;
13194: l_physical_location_id NUMBER := NULL;
13195:

Line 14376: x_failed_lines OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,

14372: p_target_delivery IN delivery_ccinfo_rec_type,
14373: p_target_container IN detail_ccinfo_rec_type,
14374: p_dlvy_assigned_lines IN detail_ccinfo_tab_type,
14375: x_validate_result OUT NOCOPY VARCHAR2,
14376: x_failed_lines OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,
14377: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,
14378: x_group_info OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
14379: x_msg_count OUT NOCOPY NUMBER,
14380: x_msg_data OUT NOCOPY VARCHAR2,

Line 14377: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,

14373: p_target_container IN detail_ccinfo_rec_type,
14374: p_dlvy_assigned_lines IN detail_ccinfo_tab_type,
14375: x_validate_result OUT NOCOPY VARCHAR2,
14376: x_failed_lines OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,
14377: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,
14378: x_group_info OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
14379: x_msg_count OUT NOCOPY NUMBER,
14380: x_msg_data OUT NOCOPY VARCHAR2,
14381: x_return_status OUT NOCOPY VARCHAR2)

Line 14378: x_group_info OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,

14374: p_dlvy_assigned_lines IN detail_ccinfo_tab_type,
14375: x_validate_result OUT NOCOPY VARCHAR2,
14376: x_failed_lines OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type,
14377: x_line_groups OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type,
14378: x_group_info OUT NOCOPY WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type,
14379: x_msg_count OUT NOCOPY NUMBER,
14380: x_msg_data OUT NOCOPY VARCHAR2,
14381: x_return_status OUT NOCOPY VARCHAR2)
14382: IS

Line 14455: l_line_group_rec WSH_FTE_COMP_CONSTRAINT_PKG.line_group_rec_type;

14451: l_input_assign_lines BOOLEAN := FALSE;
14452: l_item_check_cus BOOLEAN := FALSE;
14453: l_comp_class_tab WSH_UTIL_CORE.Column_Tab_Type;
14454: l_detail_rec detail_ccinfo_rec_type;
14455: l_line_group_rec WSH_FTE_COMP_CONSTRAINT_PKG.line_group_rec_type;
14456: l_linegroup_rec WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_rec_type;
14457: l_failed_constraint line_constraint_rec_type;
14458: l_failed_constraints line_constraint_tab_type;
14459: l_entity_tab entity_tab_type;

Line 14456: l_linegroup_rec WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_rec_type;

14452: l_item_check_cus BOOLEAN := FALSE;
14453: l_comp_class_tab WSH_UTIL_CORE.Column_Tab_Type;
14454: l_detail_rec detail_ccinfo_rec_type;
14455: l_line_group_rec WSH_FTE_COMP_CONSTRAINT_PKG.line_group_rec_type;
14456: l_linegroup_rec WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_rec_type;
14457: l_failed_constraint line_constraint_rec_type;
14458: l_failed_constraints line_constraint_tab_type;
14459: l_entity_tab entity_tab_type;
14460: l_target_rec entity_rec_type;