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_COMP_CONSTRAINT_PKG dependencies on WSH_FTE_CONSTRAINT_FRAMEWORK

Line 60: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

56: l_cc_count_del NUMBER;
57: l_cc_count_stop NUMBER;
58: l_cc_count_trip NUMBER;
59:
60: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
61: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
62: l_cc_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
63: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

Line 61: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

57: l_cc_count_stop NUMBER;
58: l_cc_count_trip NUMBER;
59:
60: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
61: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
62: l_cc_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
63: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

Line 62: l_cc_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;

58: l_cc_count_trip NUMBER;
59:
60: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
61: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
62: l_cc_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
63: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
66:

Line 63: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

59:
60: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
61: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
62: l_cc_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
63: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
66:
67: l_cc_del_detail_info WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

Line 64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

60: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
61: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
62: l_cc_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
63: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
66:
67: l_cc_del_detail_info WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
68: l_cc_target_delivery WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;

Line 65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

61: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
62: l_cc_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
63: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
66:
67: l_cc_del_detail_info WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
68: l_cc_target_delivery WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
69: l_cc_target_container WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_rec_type;

Line 67: l_cc_del_detail_info WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

63: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
66:
67: l_cc_del_detail_info WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
68: l_cc_target_delivery WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
69: l_cc_target_container WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_rec_type;
70:
71: l_cc_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;

Line 68: l_cc_target_delivery WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;

64: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
66:
67: l_cc_del_detail_info WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
68: l_cc_target_delivery WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
69: l_cc_target_container WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_rec_type;
70:
71: l_cc_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
72: l_cc_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

Line 69: l_cc_target_container WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_rec_type;

65: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
66:
67: l_cc_del_detail_info WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
68: l_cc_target_delivery WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
69: l_cc_target_container WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_rec_type;
70:
71: l_cc_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
72: l_cc_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
73: l_cc_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

Line 71: l_cc_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;

67: l_cc_del_detail_info WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
68: l_cc_target_delivery WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
69: l_cc_target_container WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_rec_type;
70:
71: l_cc_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
72: l_cc_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
73: l_cc_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
74: l_cc_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
75:

Line 72: l_cc_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

68: l_cc_target_delivery WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
69: l_cc_target_container WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_rec_type;
70:
71: l_cc_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
72: l_cc_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
73: l_cc_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
74: l_cc_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
75:
76: l_cc_stop_info WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

Line 73: l_cc_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

69: l_cc_target_container WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_rec_type;
70:
71: l_cc_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
72: l_cc_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
73: l_cc_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
74: l_cc_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
75:
76: l_cc_stop_info WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
77: l_cc_parent_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;

Line 74: l_cc_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

70:
71: l_cc_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
72: l_cc_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
73: l_cc_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
74: l_cc_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
75:
76: l_cc_stop_info WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
77: l_cc_parent_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
78: l_cc_parent_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

Line 76: l_cc_stop_info WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

72: l_cc_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
73: l_cc_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
74: l_cc_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
75:
76: l_cc_stop_info WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
77: l_cc_parent_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
78: l_cc_parent_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
79: l_cc_parent_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
80:

Line 77: l_cc_parent_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;

73: l_cc_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
74: l_cc_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
75:
76: l_cc_stop_info WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
77: l_cc_parent_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
78: l_cc_parent_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
79: l_cc_parent_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
80:
81: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;

Line 78: l_cc_parent_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

74: l_cc_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
75:
76: l_cc_stop_info WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
77: l_cc_parent_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
78: l_cc_parent_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
79: l_cc_parent_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
80:
81: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
82: l_id_tab WSH_UTIL_CORE.id_tab_type;

Line 79: l_cc_parent_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

75:
76: l_cc_stop_info WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
77: l_cc_parent_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
78: l_cc_parent_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
79: l_cc_parent_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
80:
81: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
82: l_id_tab WSH_UTIL_CORE.id_tab_type;
83: l_in_ids WSH_UTIL_CORE.id_tab_type;

Line 92: l_cc_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;

88: l_initial_pickup_location_id NUMBER;
89: l_ship_from_location_id NUMBER;
90: l_max_line_group_id NUMBER := 0;
91: l_shipping_control wsh_delivery_details.shipping_control%TYPE;
92: l_cc_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
93: l_delivery_type VARCHAR2(30);
94:
95: CURSOR c_shipping_control(l_detail_id NUMBER ) IS
96: SELECT NVL(shipping_control,'BUYER'), ship_from_location_id,

Line 391: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(

387: l_cc_target_tripstops.PICKUP_STOP_PD_DATE := p_pickup_dep_date;
388: l_cc_target_tripstops.DROPOFF_STOP_PA_DATE := p_dropoff_arr_date;
389: l_cc_target_tripstops.DROPOFF_STOP_PD_DATE := p_dropoff_dep_date;
390:
391: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
392: p_init_msg_list => p_init_msg_list,
393: p_action_code => l_cc_action_code,
394: p_exception_list => l_cc_exception_list,
395: p_delivery_info => l_cc_delivery_info,

Line 534: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvb(

530: IF l_debug_on THEN
531: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_dlvb',WSH_DEBUG_SV.C_PROC_LEVEL);
532: END IF;
533:
534: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvb(
535: p_init_msg_list => p_init_msg_list,
536: p_action_code => l_cc_action_code,
537: p_exception_list => l_cc_exception_list,
538: p_del_detail_info => l_cc_del_detail_info,

Line 597: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_trip(

593: IF l_debug_on THEN
594: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_trip',WSH_DEBUG_SV.C_PROC_LEVEL);
595: END IF;
596:
597: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_trip(
598: p_init_msg_list => p_init_msg_list,
599: p_action_code => l_cc_action_code,
600: p_exception_list => l_cc_exception_list,
601: p_trip_info => l_cc_trip_info,

Line 680: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_stop(

676: IF l_debug_on THEN
677: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_stop',WSH_DEBUG_SV.C_PROC_LEVEL);
678: END IF;
679:
680: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_stop(
681: p_init_msg_list => p_init_msg_list,
682: p_action_code => l_cc_action_code,
683: p_exception_list => l_cc_exception_list,
684: p_stop_info => l_cc_stop_info,

Line 838: l_delivery_leg_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;

834: l_validate_result VARCHAR2(1) := 'S';
835: l_succ_trips WSH_UTIL_CORE.id_tab_type;
836: l_dummy_succ_lanes WSH_UTIL_CORE.id_tab_type;
837: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
838: l_delivery_leg_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
839: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
840: l_target_trip_tab WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
841: l_dummy_target_lane WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_tab_type;
842: l_parent_delivery_leg_id NUMBER;

Line 839: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;

835: l_succ_trips WSH_UTIL_CORE.id_tab_type;
836: l_dummy_succ_lanes WSH_UTIL_CORE.id_tab_type;
837: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
838: l_delivery_leg_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
839: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
840: l_target_trip_tab WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
841: l_dummy_target_lane WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_tab_type;
842: l_parent_delivery_leg_id NUMBER;
843:

Line 840: l_target_trip_tab WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;

836: l_dummy_succ_lanes WSH_UTIL_CORE.id_tab_type;
837: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
838: l_delivery_leg_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
839: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
840: l_target_trip_tab WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
841: l_dummy_target_lane WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_tab_type;
842: l_parent_delivery_leg_id NUMBER;
843:
844: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 841: l_dummy_target_lane WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_tab_type;

837: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
838: l_delivery_leg_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
839: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
840: l_target_trip_tab WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
841: l_dummy_target_lane WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_tab_type;
842: l_parent_delivery_leg_id NUMBER;
843:
844: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
845: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'validate_constraint_dlegui';

Line 902: IF p_action_code = WSH_FTE_CONSTRAINT_FRAMEWORK.G_DLEG_TRIP_SEARCH THEN

898: ELSE
899: l_delivery_leg_rec.exists_in_database := 'N';
900: END IF;
901:
902: IF p_action_code = WSH_FTE_CONSTRAINT_FRAMEWORK.G_DLEG_TRIP_SEARCH THEN
903:
904: OPEN c_get_trip_detail(p_target_trip_id);
905: FETCH c_get_trip_detail INTO l_target_trip;
906: CLOSE c_get_trip_detail;

Line 912: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dleg(

908: l_target_trip_tab(1) := l_target_trip;
909:
910: END IF;
911:
912: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dleg(
913: p_init_msg_list => p_init_msg_list,
914: p_action_code => p_action_code,
915: p_exception_list => l_dummy_exception_list,
916: p_delivery_leg_rec => l_delivery_leg_rec,