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_OTM_INBOUND_GRP dependencies on WSH_UTIL_CORE

Line 54: l_tp_plan_name WSH_UTIL_CORE.column_tab_type;

50: q NUMBER;
51: t NUMBER;
52: l_count NUMBER;
53: l_skip_trip BOOLEAN := FALSE;
54: l_tp_plan_name WSH_UTIL_CORE.column_tab_type;
55: l_carrier_id WSH_UTIL_CORE.id_tab_type;
56: l_mode_of_transport WSH_UTIL_CORE.column_tab_type;
57: l_service_level WSH_UTIL_CORE.column_tab_type;
58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;

Line 55: l_carrier_id WSH_UTIL_CORE.id_tab_type;

51: t NUMBER;
52: l_count NUMBER;
53: l_skip_trip BOOLEAN := FALSE;
54: l_tp_plan_name WSH_UTIL_CORE.column_tab_type;
55: l_carrier_id WSH_UTIL_CORE.id_tab_type;
56: l_mode_of_transport WSH_UTIL_CORE.column_tab_type;
57: l_service_level WSH_UTIL_CORE.column_tab_type;
58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;
59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;

Line 56: l_mode_of_transport WSH_UTIL_CORE.column_tab_type;

52: l_count NUMBER;
53: l_skip_trip BOOLEAN := FALSE;
54: l_tp_plan_name WSH_UTIL_CORE.column_tab_type;
55: l_carrier_id WSH_UTIL_CORE.id_tab_type;
56: l_mode_of_transport WSH_UTIL_CORE.column_tab_type;
57: l_service_level WSH_UTIL_CORE.column_tab_type;
58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;
59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;
60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;

Line 57: l_service_level WSH_UTIL_CORE.column_tab_type;

53: l_skip_trip BOOLEAN := FALSE;
54: l_tp_plan_name WSH_UTIL_CORE.column_tab_type;
55: l_carrier_id WSH_UTIL_CORE.id_tab_type;
56: l_mode_of_transport WSH_UTIL_CORE.column_tab_type;
57: l_service_level WSH_UTIL_CORE.column_tab_type;
58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;
59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;
60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;
61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;

Line 58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;

54: l_tp_plan_name WSH_UTIL_CORE.column_tab_type;
55: l_carrier_id WSH_UTIL_CORE.id_tab_type;
56: l_mode_of_transport WSH_UTIL_CORE.column_tab_type;
57: l_service_level WSH_UTIL_CORE.column_tab_type;
58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;
59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;
60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;
61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;
62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;

Line 59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;

55: l_carrier_id WSH_UTIL_CORE.id_tab_type;
56: l_mode_of_transport WSH_UTIL_CORE.column_tab_type;
57: l_service_level WSH_UTIL_CORE.column_tab_type;
58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;
59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;
60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;
61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;
62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;
63: l_vessel WSH_UTIL_CORE.column_tab_type;

Line 60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;

56: l_mode_of_transport WSH_UTIL_CORE.column_tab_type;
57: l_service_level WSH_UTIL_CORE.column_tab_type;
58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;
59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;
60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;
61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;
62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;
63: l_vessel WSH_UTIL_CORE.column_tab_type;
64: l_voyage_number WSH_UTIL_CORE.column_tab_type;

Line 61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;

57: l_service_level WSH_UTIL_CORE.column_tab_type;
58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;
59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;
60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;
61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;
62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;
63: l_vessel WSH_UTIL_CORE.column_tab_type;
64: l_voyage_number WSH_UTIL_CORE.column_tab_type;
65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;

Line 62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;

58: l_freight_terms_code WSH_UTIL_CORE.column_tab_type;
59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;
60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;
61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;
62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;
63: l_vessel WSH_UTIL_CORE.column_tab_type;
64: l_voyage_number WSH_UTIL_CORE.column_tab_type;
65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;
66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;

Line 63: l_vessel WSH_UTIL_CORE.column_tab_type;

59: l_vehicle_item_id WSH_UTIL_CORE.id_tab_type;
60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;
61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;
62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;
63: l_vessel WSH_UTIL_CORE.column_tab_type;
64: l_voyage_number WSH_UTIL_CORE.column_tab_type;
65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;
66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;
67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;

Line 64: l_voyage_number WSH_UTIL_CORE.column_tab_type;

60: l_vehicle_item_name WSH_UTIL_CORE.column_tab_type;
61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;
62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;
63: l_vessel WSH_UTIL_CORE.column_tab_type;
64: l_voyage_number WSH_UTIL_CORE.column_tab_type;
65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;
66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;
67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;
68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;

Line 65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;

61: l_vehicle_number WSH_UTIL_CORE.column_tab_type;
62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;
63: l_vessel WSH_UTIL_CORE.column_tab_type;
64: l_voyage_number WSH_UTIL_CORE.column_tab_type;
65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;
66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;
67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;
68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;
69: /*

Line 66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;

62: l_vehicle_number_prefix WSH_UTIL_CORE.column_tab_type;
63: l_vessel WSH_UTIL_CORE.column_tab_type;
64: l_voyage_number WSH_UTIL_CORE.column_tab_type;
65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;
66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;
67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;
68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;
69: /*
70: l_stop_pa_date WSH_UTIL_CORE.column_tab_type;

Line 67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;

63: l_vessel WSH_UTIL_CORE.column_tab_type;
64: l_voyage_number WSH_UTIL_CORE.column_tab_type;
65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;
66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;
67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;
68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;
69: /*
70: l_stop_pa_date WSH_UTIL_CORE.column_tab_type;
71: l_stop_pd_date WSH_UTIL_CORE.column_tab_type;

Line 68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;

64: l_voyage_number WSH_UTIL_CORE.column_tab_type;
65: l_stop_location_id WSH_UTIL_CORE.column_tab_type;
66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;
67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;
68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;
69: /*
70: l_stop_pa_date WSH_UTIL_CORE.column_tab_type;
71: l_stop_pd_date WSH_UTIL_CORE.column_tab_type;
72: l_stop_aa_date WSH_UTIL_CORE.column_tab_type;

Line 70: l_stop_pa_date WSH_UTIL_CORE.column_tab_type;

66: l_stop_sequence_number WSH_UTIL_CORE.id_tab_type;
67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;
68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;
69: /*
70: l_stop_pa_date WSH_UTIL_CORE.column_tab_type;
71: l_stop_pd_date WSH_UTIL_CORE.column_tab_type;
72: l_stop_aa_date WSH_UTIL_CORE.column_tab_type;
73: l_stop_ad_date WSH_UTIL_CORE.column_tab_type;
74: */

Line 71: l_stop_pd_date WSH_UTIL_CORE.column_tab_type;

67: l_stop_timezone_code WSH_UTIL_CORE.column_tab_type;
68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;
69: /*
70: l_stop_pa_date WSH_UTIL_CORE.column_tab_type;
71: l_stop_pd_date WSH_UTIL_CORE.column_tab_type;
72: l_stop_aa_date WSH_UTIL_CORE.column_tab_type;
73: l_stop_ad_date WSH_UTIL_CORE.column_tab_type;
74: */
75:

Line 72: l_stop_aa_date WSH_UTIL_CORE.column_tab_type;

68: l_stop_trip_int_id WSH_UTIL_CORE.column_tab_type;
69: /*
70: l_stop_pa_date WSH_UTIL_CORE.column_tab_type;
71: l_stop_pd_date WSH_UTIL_CORE.column_tab_type;
72: l_stop_aa_date WSH_UTIL_CORE.column_tab_type;
73: l_stop_ad_date WSH_UTIL_CORE.column_tab_type;
74: */
75:
76: l_stop_pa_date WSH_UTIL_CORE.date_tab_type;

Line 73: l_stop_ad_date WSH_UTIL_CORE.column_tab_type;

69: /*
70: l_stop_pa_date WSH_UTIL_CORE.column_tab_type;
71: l_stop_pd_date WSH_UTIL_CORE.column_tab_type;
72: l_stop_aa_date WSH_UTIL_CORE.column_tab_type;
73: l_stop_ad_date WSH_UTIL_CORE.column_tab_type;
74: */
75:
76: l_stop_pa_date WSH_UTIL_CORE.date_tab_type;
77: l_stop_pd_date WSH_UTIL_CORE.date_tab_type;

Line 76: l_stop_pa_date WSH_UTIL_CORE.date_tab_type;

72: l_stop_aa_date WSH_UTIL_CORE.column_tab_type;
73: l_stop_ad_date WSH_UTIL_CORE.column_tab_type;
74: */
75:
76: l_stop_pa_date WSH_UTIL_CORE.date_tab_type;
77: l_stop_pd_date WSH_UTIL_CORE.date_tab_type;
78: l_stop_aa_date WSH_UTIL_CORE.date_tab_type;
79: l_stop_ad_date WSH_UTIL_CORE.date_tab_type;
80: -- bug 6700792: OTM Dock Door App Sched Proj

Line 77: l_stop_pd_date WSH_UTIL_CORE.date_tab_type;

73: l_stop_ad_date WSH_UTIL_CORE.column_tab_type;
74: */
75:
76: l_stop_pa_date WSH_UTIL_CORE.date_tab_type;
77: l_stop_pd_date WSH_UTIL_CORE.date_tab_type;
78: l_stop_aa_date WSH_UTIL_CORE.date_tab_type;
79: l_stop_ad_date WSH_UTIL_CORE.date_tab_type;
80: -- bug 6700792: OTM Dock Door App Sched Proj
81: l_stop_dock_door_id WSH_UTIL_CORE.column_tab_type;

Line 78: l_stop_aa_date WSH_UTIL_CORE.date_tab_type;

74: */
75:
76: l_stop_pa_date WSH_UTIL_CORE.date_tab_type;
77: l_stop_pd_date WSH_UTIL_CORE.date_tab_type;
78: l_stop_aa_date WSH_UTIL_CORE.date_tab_type;
79: l_stop_ad_date WSH_UTIL_CORE.date_tab_type;
80: -- bug 6700792: OTM Dock Door App Sched Proj
81: l_stop_dock_door_id WSH_UTIL_CORE.column_tab_type;
82: l_stop_start_time WSH_UTIL_CORE.date_tab_type;

Line 79: l_stop_ad_date WSH_UTIL_CORE.date_tab_type;

75:
76: l_stop_pa_date WSH_UTIL_CORE.date_tab_type;
77: l_stop_pd_date WSH_UTIL_CORE.date_tab_type;
78: l_stop_aa_date WSH_UTIL_CORE.date_tab_type;
79: l_stop_ad_date WSH_UTIL_CORE.date_tab_type;
80: -- bug 6700792: OTM Dock Door App Sched Proj
81: l_stop_dock_door_id WSH_UTIL_CORE.column_tab_type;
82: l_stop_start_time WSH_UTIL_CORE.date_tab_type;
83: l_stop_end_time WSH_UTIL_CORE.date_tab_type;

Line 81: l_stop_dock_door_id WSH_UTIL_CORE.column_tab_type;

77: l_stop_pd_date WSH_UTIL_CORE.date_tab_type;
78: l_stop_aa_date WSH_UTIL_CORE.date_tab_type;
79: l_stop_ad_date WSH_UTIL_CORE.date_tab_type;
80: -- bug 6700792: OTM Dock Door App Sched Proj
81: l_stop_dock_door_id WSH_UTIL_CORE.column_tab_type;
82: l_stop_start_time WSH_UTIL_CORE.date_tab_type;
83: l_stop_end_time WSH_UTIL_CORE.date_tab_type;
84:
85: l_delivery_name WSH_UTIL_CORE.column_tab_type;

Line 82: l_stop_start_time WSH_UTIL_CORE.date_tab_type;

78: l_stop_aa_date WSH_UTIL_CORE.date_tab_type;
79: l_stop_ad_date WSH_UTIL_CORE.date_tab_type;
80: -- bug 6700792: OTM Dock Door App Sched Proj
81: l_stop_dock_door_id WSH_UTIL_CORE.column_tab_type;
82: l_stop_start_time WSH_UTIL_CORE.date_tab_type;
83: l_stop_end_time WSH_UTIL_CORE.date_tab_type;
84:
85: l_delivery_name WSH_UTIL_CORE.column_tab_type;
86: l_release_xid WSH_UTIL_CORE.column_tab_type;

Line 83: l_stop_end_time WSH_UTIL_CORE.date_tab_type;

79: l_stop_ad_date WSH_UTIL_CORE.date_tab_type;
80: -- bug 6700792: OTM Dock Door App Sched Proj
81: l_stop_dock_door_id WSH_UTIL_CORE.column_tab_type;
82: l_stop_start_time WSH_UTIL_CORE.date_tab_type;
83: l_stop_end_time WSH_UTIL_CORE.date_tab_type;
84:
85: l_delivery_name WSH_UTIL_CORE.column_tab_type;
86: l_release_xid WSH_UTIL_CORE.column_tab_type;
87: l_ship_from_location_xid WSH_UTIL_CORE.column_tab_type;

Line 85: l_delivery_name WSH_UTIL_CORE.column_tab_type;

81: l_stop_dock_door_id WSH_UTIL_CORE.column_tab_type;
82: l_stop_start_time WSH_UTIL_CORE.date_tab_type;
83: l_stop_end_time WSH_UTIL_CORE.date_tab_type;
84:
85: l_delivery_name WSH_UTIL_CORE.column_tab_type;
86: l_release_xid WSH_UTIL_CORE.column_tab_type;
87: l_ship_from_location_xid WSH_UTIL_CORE.column_tab_type;
88: l_ship_to_location_xid WSH_UTIL_CORE.column_tab_type;
89: /*

Line 86: l_release_xid WSH_UTIL_CORE.column_tab_type;

82: l_stop_start_time WSH_UTIL_CORE.date_tab_type;
83: l_stop_end_time WSH_UTIL_CORE.date_tab_type;
84:
85: l_delivery_name WSH_UTIL_CORE.column_tab_type;
86: l_release_xid WSH_UTIL_CORE.column_tab_type;
87: l_ship_from_location_xid WSH_UTIL_CORE.column_tab_type;
88: l_ship_to_location_xid WSH_UTIL_CORE.column_tab_type;
89: /*
90: l_earliest_pickup_date WSH_UTIL_CORE.column_tab_type;

Line 87: l_ship_from_location_xid WSH_UTIL_CORE.column_tab_type;

83: l_stop_end_time WSH_UTIL_CORE.date_tab_type;
84:
85: l_delivery_name WSH_UTIL_CORE.column_tab_type;
86: l_release_xid WSH_UTIL_CORE.column_tab_type;
87: l_ship_from_location_xid WSH_UTIL_CORE.column_tab_type;
88: l_ship_to_location_xid WSH_UTIL_CORE.column_tab_type;
89: /*
90: l_earliest_pickup_date WSH_UTIL_CORE.column_tab_type;
91: l_latest_pickup_date WSH_UTIL_CORE.column_tab_type;

Line 88: l_ship_to_location_xid WSH_UTIL_CORE.column_tab_type;

84:
85: l_delivery_name WSH_UTIL_CORE.column_tab_type;
86: l_release_xid WSH_UTIL_CORE.column_tab_type;
87: l_ship_from_location_xid WSH_UTIL_CORE.column_tab_type;
88: l_ship_to_location_xid WSH_UTIL_CORE.column_tab_type;
89: /*
90: l_earliest_pickup_date WSH_UTIL_CORE.column_tab_type;
91: l_latest_pickup_date WSH_UTIL_CORE.column_tab_type;
92: l_earliest_dropoff_date WSH_UTIL_CORE.column_tab_type;

Line 90: l_earliest_pickup_date WSH_UTIL_CORE.column_tab_type;

86: l_release_xid WSH_UTIL_CORE.column_tab_type;
87: l_ship_from_location_xid WSH_UTIL_CORE.column_tab_type;
88: l_ship_to_location_xid WSH_UTIL_CORE.column_tab_type;
89: /*
90: l_earliest_pickup_date WSH_UTIL_CORE.column_tab_type;
91: l_latest_pickup_date WSH_UTIL_CORE.column_tab_type;
92: l_earliest_dropoff_date WSH_UTIL_CORE.column_tab_type;
93: l_latest_dropoff_date WSH_UTIL_CORE.column_tab_type;
94: */

Line 91: l_latest_pickup_date WSH_UTIL_CORE.column_tab_type;

87: l_ship_from_location_xid WSH_UTIL_CORE.column_tab_type;
88: l_ship_to_location_xid WSH_UTIL_CORE.column_tab_type;
89: /*
90: l_earliest_pickup_date WSH_UTIL_CORE.column_tab_type;
91: l_latest_pickup_date WSH_UTIL_CORE.column_tab_type;
92: l_earliest_dropoff_date WSH_UTIL_CORE.column_tab_type;
93: l_latest_dropoff_date WSH_UTIL_CORE.column_tab_type;
94: */
95: l_earliest_pickup_date WSH_UTIL_CORE.date_tab_type;

Line 92: l_earliest_dropoff_date WSH_UTIL_CORE.column_tab_type;

88: l_ship_to_location_xid WSH_UTIL_CORE.column_tab_type;
89: /*
90: l_earliest_pickup_date WSH_UTIL_CORE.column_tab_type;
91: l_latest_pickup_date WSH_UTIL_CORE.column_tab_type;
92: l_earliest_dropoff_date WSH_UTIL_CORE.column_tab_type;
93: l_latest_dropoff_date WSH_UTIL_CORE.column_tab_type;
94: */
95: l_earliest_pickup_date WSH_UTIL_CORE.date_tab_type;
96: l_latest_pickup_date WSH_UTIL_CORE.date_tab_type;

Line 93: l_latest_dropoff_date WSH_UTIL_CORE.column_tab_type;

89: /*
90: l_earliest_pickup_date WSH_UTIL_CORE.column_tab_type;
91: l_latest_pickup_date WSH_UTIL_CORE.column_tab_type;
92: l_earliest_dropoff_date WSH_UTIL_CORE.column_tab_type;
93: l_latest_dropoff_date WSH_UTIL_CORE.column_tab_type;
94: */
95: l_earliest_pickup_date WSH_UTIL_CORE.date_tab_type;
96: l_latest_pickup_date WSH_UTIL_CORE.date_tab_type;
97: l_earliest_dropoff_date WSH_UTIL_CORE.date_tab_type;

Line 95: l_earliest_pickup_date WSH_UTIL_CORE.date_tab_type;

91: l_latest_pickup_date WSH_UTIL_CORE.column_tab_type;
92: l_earliest_dropoff_date WSH_UTIL_CORE.column_tab_type;
93: l_latest_dropoff_date WSH_UTIL_CORE.column_tab_type;
94: */
95: l_earliest_pickup_date WSH_UTIL_CORE.date_tab_type;
96: l_latest_pickup_date WSH_UTIL_CORE.date_tab_type;
97: l_earliest_dropoff_date WSH_UTIL_CORE.date_tab_type;
98: l_latest_dropoff_date WSH_UTIL_CORE.date_tab_type;
99:

Line 96: l_latest_pickup_date WSH_UTIL_CORE.date_tab_type;

92: l_earliest_dropoff_date WSH_UTIL_CORE.column_tab_type;
93: l_latest_dropoff_date WSH_UTIL_CORE.column_tab_type;
94: */
95: l_earliest_pickup_date WSH_UTIL_CORE.date_tab_type;
96: l_latest_pickup_date WSH_UTIL_CORE.date_tab_type;
97: l_earliest_dropoff_date WSH_UTIL_CORE.date_tab_type;
98: l_latest_dropoff_date WSH_UTIL_CORE.date_tab_type;
99:
100: l_release_refnum WSH_UTIL_CORE.column_tab_type;

Line 97: l_earliest_dropoff_date WSH_UTIL_CORE.date_tab_type;

93: l_latest_dropoff_date WSH_UTIL_CORE.column_tab_type;
94: */
95: l_earliest_pickup_date WSH_UTIL_CORE.date_tab_type;
96: l_latest_pickup_date WSH_UTIL_CORE.date_tab_type;
97: l_earliest_dropoff_date WSH_UTIL_CORE.date_tab_type;
98: l_latest_dropoff_date WSH_UTIL_CORE.date_tab_type;
99:
100: l_release_refnum WSH_UTIL_CORE.column_tab_type;
101: l_release_freight_cost WSH_UTIL_CORE.column_tab_type;

Line 98: l_latest_dropoff_date WSH_UTIL_CORE.date_tab_type;

94: */
95: l_earliest_pickup_date WSH_UTIL_CORE.date_tab_type;
96: l_latest_pickup_date WSH_UTIL_CORE.date_tab_type;
97: l_earliest_dropoff_date WSH_UTIL_CORE.date_tab_type;
98: l_latest_dropoff_date WSH_UTIL_CORE.date_tab_type;
99:
100: l_release_refnum WSH_UTIL_CORE.column_tab_type;
101: l_release_freight_cost WSH_UTIL_CORE.column_tab_type;
102: l_release_freight_currency WSH_UTIL_CORE.column_tab_type;

Line 100: l_release_refnum WSH_UTIL_CORE.column_tab_type;

96: l_latest_pickup_date WSH_UTIL_CORE.date_tab_type;
97: l_earliest_dropoff_date WSH_UTIL_CORE.date_tab_type;
98: l_latest_dropoff_date WSH_UTIL_CORE.date_tab_type;
99:
100: l_release_refnum WSH_UTIL_CORE.column_tab_type;
101: l_release_freight_cost WSH_UTIL_CORE.column_tab_type;
102: l_release_freight_currency WSH_UTIL_CORE.column_tab_type;
103: l_release_freight_del_id WSH_UTIL_CORE.column_tab_type;
104: l_release_freight_dint_id WSH_UTIL_CORE.id_tab_type;

Line 101: l_release_freight_cost WSH_UTIL_CORE.column_tab_type;

97: l_earliest_dropoff_date WSH_UTIL_CORE.date_tab_type;
98: l_latest_dropoff_date WSH_UTIL_CORE.date_tab_type;
99:
100: l_release_refnum WSH_UTIL_CORE.column_tab_type;
101: l_release_freight_cost WSH_UTIL_CORE.column_tab_type;
102: l_release_freight_currency WSH_UTIL_CORE.column_tab_type;
103: l_release_freight_del_id WSH_UTIL_CORE.column_tab_type;
104: l_release_freight_dint_id WSH_UTIL_CORE.id_tab_type;
105:

Line 102: l_release_freight_currency WSH_UTIL_CORE.column_tab_type;

98: l_latest_dropoff_date WSH_UTIL_CORE.date_tab_type;
99:
100: l_release_refnum WSH_UTIL_CORE.column_tab_type;
101: l_release_freight_cost WSH_UTIL_CORE.column_tab_type;
102: l_release_freight_currency WSH_UTIL_CORE.column_tab_type;
103: l_release_freight_del_id WSH_UTIL_CORE.column_tab_type;
104: l_release_freight_dint_id WSH_UTIL_CORE.id_tab_type;
105:
106: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;

Line 103: l_release_freight_del_id WSH_UTIL_CORE.column_tab_type;

99:
100: l_release_refnum WSH_UTIL_CORE.column_tab_type;
101: l_release_freight_cost WSH_UTIL_CORE.column_tab_type;
102: l_release_freight_currency WSH_UTIL_CORE.column_tab_type;
103: l_release_freight_del_id WSH_UTIL_CORE.column_tab_type;
104: l_release_freight_dint_id WSH_UTIL_CORE.id_tab_type;
105:
106: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
107: l_dummy_del_id_tab WSH_UTIL_CORE.id_tab_type;

Line 104: l_release_freight_dint_id WSH_UTIL_CORE.id_tab_type;

100: l_release_refnum WSH_UTIL_CORE.column_tab_type;
101: l_release_freight_cost WSH_UTIL_CORE.column_tab_type;
102: l_release_freight_currency WSH_UTIL_CORE.column_tab_type;
103: l_release_freight_del_id WSH_UTIL_CORE.column_tab_type;
104: l_release_freight_dint_id WSH_UTIL_CORE.id_tab_type;
105:
106: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
107: l_dummy_del_id_tab WSH_UTIL_CORE.id_tab_type;
108: l_return_status VARCHAR2(1);

Line 107: l_dummy_del_id_tab WSH_UTIL_CORE.id_tab_type;

103: l_release_freight_del_id WSH_UTIL_CORE.column_tab_type;
104: l_release_freight_dint_id WSH_UTIL_CORE.id_tab_type;
105:
106: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
107: l_dummy_del_id_tab WSH_UTIL_CORE.id_tab_type;
108: l_return_status VARCHAR2(1);
109:
110: l_delivery_id VARCHAR2(32767) := NULL;
111: l_local_release_tab WSH_OTM_DEL_INTERFACES;

Line 126: l_dleg_int_act_code WSH_UTIL_CORE.column_tab_type;

122: l_int_del_cnt NUMBER := 0;
123: l_int_stop_cnt NUMBER := 0;
124: l_del_status_code VARCHAR2(2);
125:
126: l_dleg_int_act_code WSH_UTIL_CORE.column_tab_type;
127: l_dleg_del_id WSH_UTIL_CORE.column_tab_type;
128: l_dleg_del_int_id WSH_UTIL_CORE.id_tab_type;
129: l_dleg_pustop_id WSH_UTIL_CORE.id_tab_type;
130: l_dleg_dostop_id WSH_UTIL_CORE.id_tab_type;

Line 127: l_dleg_del_id WSH_UTIL_CORE.column_tab_type;

123: l_int_stop_cnt NUMBER := 0;
124: l_del_status_code VARCHAR2(2);
125:
126: l_dleg_int_act_code WSH_UTIL_CORE.column_tab_type;
127: l_dleg_del_id WSH_UTIL_CORE.column_tab_type;
128: l_dleg_del_int_id WSH_UTIL_CORE.id_tab_type;
129: l_dleg_pustop_id WSH_UTIL_CORE.id_tab_type;
130: l_dleg_dostop_id WSH_UTIL_CORE.id_tab_type;
131: l_group_id NUMBER ;

Line 128: l_dleg_del_int_id WSH_UTIL_CORE.id_tab_type;

124: l_del_status_code VARCHAR2(2);
125:
126: l_dleg_int_act_code WSH_UTIL_CORE.column_tab_type;
127: l_dleg_del_id WSH_UTIL_CORE.column_tab_type;
128: l_dleg_del_int_id WSH_UTIL_CORE.id_tab_type;
129: l_dleg_pustop_id WSH_UTIL_CORE.id_tab_type;
130: l_dleg_dostop_id WSH_UTIL_CORE.id_tab_type;
131: l_group_id NUMBER ;
132: l_request_id NUMBER ;

Line 129: l_dleg_pustop_id WSH_UTIL_CORE.id_tab_type;

125:
126: l_dleg_int_act_code WSH_UTIL_CORE.column_tab_type;
127: l_dleg_del_id WSH_UTIL_CORE.column_tab_type;
128: l_dleg_del_int_id WSH_UTIL_CORE.id_tab_type;
129: l_dleg_pustop_id WSH_UTIL_CORE.id_tab_type;
130: l_dleg_dostop_id WSH_UTIL_CORE.id_tab_type;
131: l_group_id NUMBER ;
132: l_request_id NUMBER ;
133: l_user_id NUMBER;

Line 130: l_dleg_dostop_id WSH_UTIL_CORE.id_tab_type;

126: l_dleg_int_act_code WSH_UTIL_CORE.column_tab_type;
127: l_dleg_del_id WSH_UTIL_CORE.column_tab_type;
128: l_dleg_del_int_id WSH_UTIL_CORE.id_tab_type;
129: l_dleg_pustop_id WSH_UTIL_CORE.id_tab_type;
130: l_dleg_dostop_id WSH_UTIL_CORE.id_tab_type;
131: l_group_id NUMBER ;
132: l_request_id NUMBER ;
133: l_user_id NUMBER;
134: l_resp_id NUMBER;

Line 142: l_del_int_id_tab WSH_UTIL_CORE.id_tab_type;

138: l_inp_count VARCHAR2(30) := 'p_int_trip_info COUNT '||p_int_trip_info.COUNT;
139: l_stop_count NUMBER := 1;
140: l_release_count NUMBER := 1;
141: l_ship_unit_count NUMBER := 1;
142: l_del_int_id_tab WSH_UTIL_CORE.id_tab_type;
143: l_trip_int_id WSH_UTIL_CORE.id_tab_type;
144: l_stop_int_id_tab WSH_UTIL_CORE.id_tab_type;
145: -- Bug#7491598(ER,defer planned shipment iface):
146: l_global_params WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

Line 143: l_trip_int_id WSH_UTIL_CORE.id_tab_type;

139: l_stop_count NUMBER := 1;
140: l_release_count NUMBER := 1;
141: l_ship_unit_count NUMBER := 1;
142: l_del_int_id_tab WSH_UTIL_CORE.id_tab_type;
143: l_trip_int_id WSH_UTIL_CORE.id_tab_type;
144: l_stop_int_id_tab WSH_UTIL_CORE.id_tab_type;
145: -- Bug#7491598(ER,defer planned shipment iface):
146: l_global_params WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
147: -- Bug#7491598(ER,defer planned shipment iface):

Line 144: l_stop_int_id_tab WSH_UTIL_CORE.id_tab_type;

140: l_release_count NUMBER := 1;
141: l_ship_unit_count NUMBER := 1;
142: l_del_int_id_tab WSH_UTIL_CORE.id_tab_type;
143: l_trip_int_id WSH_UTIL_CORE.id_tab_type;
144: l_stop_int_id_tab WSH_UTIL_CORE.id_tab_type;
145: -- Bug#7491598(ER,defer planned shipment iface):
146: l_global_params WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
147: -- Bug#7491598(ER,defer planned shipment iface):
148:

Line 153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

149: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
150: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'initiate_planned_shipment';
151: BEGIN
152:
153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
154: IF l_debug_on THEN
155: WSH_DEBUG_SV.push (l_module_name);
156: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- START ----------------');
157: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info COUNT : '||l_cnt);

Line 223: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

219: x_delivery_tab => l_delivery_tab,
220: x_delivery_id_tab => l_dummy_del_id_tab,
221: x_return_status => l_return_status);
222:
223: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: ELSE
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.logmsg(l_module_name,'Returned from WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP x_return_status : '||l_return_status);

Line 388: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

384: p_tp_plan_name => p_int_trip_info(i).shipment_xid,
385: p_commit_flag => 'N',
386: x_return_status => l_return_status);
387:
388: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
389: raise FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:
392: --IF nvl(p_int_trip_info(i).transaction_code,'CREATE') <> 'DELETE' THEN

Line 842: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

838: x_return_status => l_return_status);
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
841: END IF;
842: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
843: x_return_status := l_return_status;
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.pop(l_module_name);
846: END IF;

Line 871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

867: WSH_DEBUG_SV.logmsg(l_module_name,'Request submission failed ');
868: END IF;
869: x_msg_data := FND_MESSAGE.GET_STRING('WSH','WSH_OTM_IB_CONC_ERROR');
870: --x_msg_data := 'Concurrent Request submission failed';
871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
872: ELSE
873: x_output_request_id := l_request_id;
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.logmsg(l_module_name,'Request '||l_request_id||' submitted successfully');

Line 884: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

880:
881: ELSE
882: x_msg_data := FND_MESSAGE.GET_STRING('WSH','WSH_OTM_IB_NO_ELIG_DLVY');
883: --x_msg_data := 'No Eligible Deliveries Found';
884: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
885:
886: END IF; -- l_group_id IS NOT NULL
887:
888: IF l_debug_on THEN

Line 897: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

893:
894: EXCEPTION
895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
896: ROLLBACK TO SAVEPOINT before_insert;
897: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
898: --
899: IF l_debug_on THEN
900: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
901: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');

Line 908: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

904: --
905: x_msg_data := 'Oracle error message is '|| SQLERRM;
906: WHEN others THEN
907: ROLLBACK TO SAVEPOINT before_insert;
908: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
909: x_msg_data := 'Oracle error message is '|| SQLERRM;
910: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.initiate_planned_shipment');
911: --
912: IF l_debug_on THEN

Line 910: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.initiate_planned_shipment');

906: WHEN others THEN
907: ROLLBACK TO SAVEPOINT before_insert;
908: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
909: x_msg_data := 'Oracle error message is '|| SQLERRM;
910: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.initiate_planned_shipment');
911: --
912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
914: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');