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_UTIL_CORE

Line 8: g_is_fte_installed VARCHAR2(1) := WSH_UTIL_CORE.FTE_Is_Installed;

4: -- Global Variables
5:
6: g_hash_base NUMBER := 1;
7: g_hash_size NUMBER := power(2, 25);
8: g_is_fte_installed VARCHAR2(1) := WSH_UTIL_CORE.FTE_Is_Installed;
9: g_is_tp_installed VARCHAR2(1) := NULL;
10: g_session_id NUMBER;
11:
12: G_SHIPORG_FACILITY VARCHAR2(30) := 'ORG_FAC';

Line 388: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,

384:
385: PROCEDURE validate_constraint_dlvy(
386: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
387: p_action_code IN VARCHAR2 DEFAULT NULL,
388: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
389: p_in_ids IN WSH_UTIL_CORE.id_tab_type,
390: p_delivery_info IN delivery_ccinfo_tab_type,
391: p_dlvy_assigned_lines IN detail_ccinfo_tab_type,
392: p_target_trip IN trip_ccinfo_rec_type,

Line 389: p_in_ids IN WSH_UTIL_CORE.id_tab_type,

385: PROCEDURE validate_constraint_dlvy(
386: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
387: p_action_code IN VARCHAR2 DEFAULT NULL,
388: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
389: p_in_ids IN WSH_UTIL_CORE.id_tab_type,
390: p_delivery_info IN delivery_ccinfo_tab_type,
391: p_dlvy_assigned_lines IN detail_ccinfo_tab_type,
392: p_target_trip IN trip_ccinfo_rec_type,
393: p_target_tripstops IN OUT NOCOPY target_tripstop_cc_rec_type,

Line 432: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,

428:
429: PROCEDURE validate_constraint_dleg(
430: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
431: p_action_code IN VARCHAR2 DEFAULT NULL,
432: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
433: p_delivery_leg_rec IN dleg_ccinfo_rec_type,
434: p_target_trip IN trip_ccinfo_tab_type,
435: p_target_lane IN lane_ccinfo_tab_type,
436: x_succ_trips OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

Line 436: x_succ_trips OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

432: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
433: p_delivery_leg_rec IN dleg_ccinfo_rec_type,
434: p_target_trip IN trip_ccinfo_tab_type,
435: p_target_lane IN lane_ccinfo_tab_type,
436: x_succ_trips OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
437: x_succ_lanes OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
438: x_validate_result OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,

Line 437: x_succ_lanes OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

433: p_delivery_leg_rec IN dleg_ccinfo_rec_type,
434: p_target_trip IN trip_ccinfo_tab_type,
435: p_target_lane IN lane_ccinfo_tab_type,
436: x_succ_trips OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
437: x_succ_lanes OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
438: x_validate_result OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: x_return_status OUT NOCOPY VARCHAR2);

Line 488: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,

484:
485: PROCEDURE validate_constraint_dlvb(
486: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
487: p_action_code IN VARCHAR2 DEFAULT NULL,
488: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
489: p_in_ids IN WSH_UTIL_CORE.id_tab_type,
490: p_del_detail_info IN detail_ccinfo_tab_type,
491: p_target_delivery IN delivery_ccinfo_rec_type,
492: p_target_container IN detail_ccinfo_rec_type,

Line 489: p_in_ids IN WSH_UTIL_CORE.id_tab_type,

485: PROCEDURE validate_constraint_dlvb(
486: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
487: p_action_code IN VARCHAR2 DEFAULT NULL,
488: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
489: p_in_ids IN WSH_UTIL_CORE.id_tab_type,
490: p_del_detail_info IN detail_ccinfo_tab_type,
491: p_target_delivery IN delivery_ccinfo_rec_type,
492: p_target_container IN detail_ccinfo_rec_type,
493: p_dlvy_assigned_lines IN detail_ccinfo_tab_type,

Line 532: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,

528:
529: PROCEDURE validate_constraint_trip(
530: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
531: p_action_code IN VARCHAR2 DEFAULT NULL,
532: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
533: p_trip_info IN trip_ccinfo_tab_type,
534: p_trip_assigned_dels IN delivery_ccinfo_tab_type,
535: p_trip_dlvy_lines IN detail_ccinfo_tab_type,
536: p_trip_incl_stops IN stop_ccinfo_tab_type,

Line 537: x_fail_trips OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

533: p_trip_info IN trip_ccinfo_tab_type,
534: p_trip_assigned_dels IN delivery_ccinfo_tab_type,
535: p_trip_dlvy_lines IN detail_ccinfo_tab_type,
536: p_trip_incl_stops IN stop_ccinfo_tab_type,
537: x_fail_trips OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
538: x_validate_result OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,
540: x_msg_data OUT NOCOPY VARCHAR2,
541: x_return_status OUT NOCOPY VARCHAR2);

Line 570: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,

566:
567: PROCEDURE validate_constraint_stop(
568: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
569: p_action_code IN VARCHAR2 DEFAULT NULL,
570: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
571: p_stop_info IN stop_ccinfo_tab_type,
572: p_parent_trip_info IN trip_ccinfo_tab_type,
573: x_fail_stops OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
574: x_validate_result OUT NOCOPY VARCHAR2,

Line 573: x_fail_stops OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

569: p_action_code IN VARCHAR2 DEFAULT NULL,
570: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
571: p_stop_info IN stop_ccinfo_tab_type,
572: p_parent_trip_info IN trip_ccinfo_tab_type,
573: x_fail_stops OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
574: x_validate_result OUT NOCOPY VARCHAR2,
575: x_msg_count OUT NOCOPY NUMBER,
576: x_msg_data OUT NOCOPY VARCHAR2,
577: x_return_status OUT NOCOPY VARCHAR2);

Line 730: p_in_ids IN wsh_util_core.id_tab_type,

726: -- procedure is to find deconsolidation locations for a group of deliveries passed
727: --========================================================================
728: PROCEDURE validate_constraint_deconsol( p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
729: p_delivery_info IN OUT NOCOPY delivery_ccinfo_tab_type,
730: p_in_ids IN wsh_util_core.id_tab_type,
731: p_rule_deconsol_location IN NUMBER default NULL,
732: p_rule_override_deconsol IN BOOLEAN DEFAULT FALSE,
733: p_rule_to_zone_id IN NUMBER DEFAULT NULL,
734: p_caller IN VARCHAR2 DEFAULT NULL,

Line 757: x_customer_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

753:
754: PROCEDURE get_customer_from_loc(
755: p_location_id IN NUMBER,
756: --x_customer_id OUT NOCOPY NUMBER,
757: x_customer_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
758: x_return_status OUT NOCOPY VARCHAR2);
759:
760: --***************************************************************************--
761: --========================================================================

Line 772: x_organization_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

768: -- Returns table of organizations for location.
769: --========================================================================
770: PROCEDURE get_org_from_location(
771: p_location_id IN NUMBER,
772: x_organization_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
773: x_return_status OUT NOCOPY VARCHAR2);
774:
775: END WSH_FTE_CONSTRAINT_FRAMEWORK;
776: