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.FTE_TL_CORE dependencies on FTE_TL_CACHE

Line 47: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

43: -- Procedure declarations
44:
45: PROCEDURE create_input_line (
46: p_req_line_rec IN req_line_info_rec_type,
47: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
48: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
49: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
50: x_return_status OUT NOCOPY VARCHAR2);
51:

Line 48: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

44:
45: PROCEDURE create_input_line (
46: p_req_line_rec IN req_line_info_rec_type,
47: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
48: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
49: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
50: x_return_status OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE create_control_rec ( x_return_status OUT NOCOPY VARCHAR2);

Line 49: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

45: PROCEDURE create_input_line (
46: p_req_line_rec IN req_line_info_rec_type,
47: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
48: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
49: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
50: x_return_status OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE create_control_rec ( x_return_status OUT NOCOPY VARCHAR2);
53:

Line 56: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

52: PROCEDURE create_control_rec ( x_return_status OUT NOCOPY VARCHAR2);
53:
54:
55: PROCEDURE create_engine_inputs (
56: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
57: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
58: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
59: p_trip_index IN NUMBER DEFAULT NULL,
60: x_implicit_non_dummy_cnt OUT NOCOPY NUMBER,

Line 57: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

53:
54:
55: PROCEDURE create_engine_inputs (
56: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
57: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
58: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
59: p_trip_index IN NUMBER DEFAULT NULL,
60: x_implicit_non_dummy_cnt OUT NOCOPY NUMBER,
61: x_return_status OUT NOCOPY VARCHAR2);

Line 58: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

54:
55: PROCEDURE create_engine_inputs (
56: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
57: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
58: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
59: p_trip_index IN NUMBER DEFAULT NULL,
60: x_implicit_non_dummy_cnt OUT NOCOPY NUMBER,
61: x_return_status OUT NOCOPY VARCHAR2);
62:

Line 65: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

61: x_return_status OUT NOCOPY VARCHAR2);
62:
63: PROCEDURE create_line_attributes (
64: p_req_line_rec IN req_line_info_rec_type,
65: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
66: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
67: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
68: x_return_status OUT NOCOPY VARCHAR2);
69:

Line 66: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

62:
63: PROCEDURE create_line_attributes (
64: p_req_line_rec IN req_line_info_rec_type,
65: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
66: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
67: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
68: x_return_status OUT NOCOPY VARCHAR2);
69:
70:

Line 67: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

63: PROCEDURE create_line_attributes (
64: p_req_line_rec IN req_line_info_rec_type,
65: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
66: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
67: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
68: x_return_status OUT NOCOPY VARCHAR2);
69:
70:
71: PROCEDURE create_charge_line_attributes (

Line 73: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

69:
70:
71: PROCEDURE create_charge_line_attributes (
72: p_req_line_rec IN req_line_info_rec_type,
73: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
74: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
75: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
76: x_pricing_attr_tab IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
77: x_return_status OUT NOCOPY VARCHAR2);

Line 74: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

70:
71: PROCEDURE create_charge_line_attributes (
72: p_req_line_rec IN req_line_info_rec_type,
73: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
74: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
75: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
76: x_pricing_attr_tab IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
77: x_return_status OUT NOCOPY VARCHAR2);
78:

Line 75: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

71: PROCEDURE create_charge_line_attributes (
72: p_req_line_rec IN req_line_info_rec_type,
73: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
74: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
75: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
76: x_pricing_attr_tab IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
77: x_return_status OUT NOCOPY VARCHAR2);
78:
79:

Line 82: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

78:
79:
80: PROCEDURE create_line_qualifiers (
81: p_req_line_rec IN req_line_info_rec_type,
82: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
83: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
84: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
85: x_return_status OUT NOCOPY VARCHAR2);
86:

Line 83: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

79:
80: PROCEDURE create_line_qualifiers (
81: p_req_line_rec IN req_line_info_rec_type,
82: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
83: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
84: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
85: x_return_status OUT NOCOPY VARCHAR2);
86:
87: PROCEDURE retrieve_qp_output (

Line 84: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

80: PROCEDURE create_line_qualifiers (
81: p_req_line_rec IN req_line_info_rec_type,
82: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
83: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
84: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
85: x_return_status OUT NOCOPY VARCHAR2);
86:
87: PROCEDURE retrieve_qp_output (
88: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

Line 88: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

84: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
85: x_return_status OUT NOCOPY VARCHAR2);
86:
87: PROCEDURE retrieve_qp_output (
88: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
89: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
90: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
91: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
92: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 89: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

85: x_return_status OUT NOCOPY VARCHAR2);
86:
87: PROCEDURE retrieve_qp_output (
88: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
89: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
90: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
91: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
92: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
93: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,

Line 90: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

86:
87: PROCEDURE retrieve_qp_output (
88: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
89: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
90: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
91: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
92: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
93: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
94: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

Line 93: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,

89: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
90: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
91: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
92: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
93: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
94: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
95: x_return_status OUT NOCOPY VARCHAR2);
96:
97: PROCEDURE print_output(

Line 94: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

90: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
91: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
92: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
93: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
94: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
95: x_return_status OUT NOCOPY VARCHAR2);
96:
97: PROCEDURE print_output(
98: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type,

Line 98: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type,

94: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
95: x_return_status OUT NOCOPY VARCHAR2);
96:
97: PROCEDURE print_output(
98: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type,
99: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type
100: );
101:
102: -- This procedure throws a not on pricelist excpetion if

Line 99: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type

95: x_return_status OUT NOCOPY VARCHAR2);
96:
97: PROCEDURE print_output(
98: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type,
99: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type
100: );
101:
102: -- This procedure throws a not on pricelist excpetion if
103: -- all the non-dummy(not dummy stop,trip charge lines) qp output lines have an IPL status

Line 229: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

225: -- No direct
226: -- +======================================================================+
227:
228: PROCEDURE tl_core (
229: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
230: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
231: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
232: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
233: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

Line 230: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

226: -- +======================================================================+
227:
228: PROCEDURE tl_core (
229: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
230: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
231: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
232: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
233: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
234: x_return_status OUT NOCOPY VARCHAR2)

Line 231: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

227:
228: PROCEDURE tl_core (
229: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
230: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
231: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
232: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
233: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
234: x_return_status OUT NOCOPY VARCHAR2)
235: IS

Line 232: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,

228: PROCEDURE tl_core (
229: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
230: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
231: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
232: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
233: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
234: x_return_status OUT NOCOPY VARCHAR2)
235: IS
236:

Line 233: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

229: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
230: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
231: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
232: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
233: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
234: x_return_status OUT NOCOPY VARCHAR2)
235: IS
236:
237: l_pricing_control_rec fte_freight_pricing.pricing_control_input_rec_type;

Line 396: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

392: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
393: END tl_core;
394:
395: PROCEDURE create_engine_inputs (
396: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
397: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
398: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
399: p_trip_index IN NUMBER DEFAULT NULL,
400: x_implicit_non_dummy_cnt OUT NOCOPY NUMBER,

Line 397: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

393: END tl_core;
394:
395: PROCEDURE create_engine_inputs (
396: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
397: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
398: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
399: p_trip_index IN NUMBER DEFAULT NULL,
400: x_implicit_non_dummy_cnt OUT NOCOPY NUMBER,
401: x_return_status OUT NOCOPY VARCHAR2)

Line 398: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

394:
395: PROCEDURE create_engine_inputs (
396: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
397: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
398: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
399: p_trip_index IN NUMBER DEFAULT NULL,
400: x_implicit_non_dummy_cnt OUT NOCOPY NUMBER,
401: x_return_status OUT NOCOPY VARCHAR2)
402: IS

Line 1057: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

1053: --
1054:
1055: PROCEDURE create_input_line (
1056: p_req_line_rec IN req_line_info_rec_type,
1057: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1058: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1059: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1060: x_return_status OUT NOCOPY VARCHAR2)
1061:

Line 1058: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

1054:
1055: PROCEDURE create_input_line (
1056: p_req_line_rec IN req_line_info_rec_type,
1057: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1058: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1059: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1060: x_return_status OUT NOCOPY VARCHAR2)
1061:
1062: IS

Line 1059: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

1055: PROCEDURE create_input_line (
1056: p_req_line_rec IN req_line_info_rec_type,
1057: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1058: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1059: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1060: x_return_status OUT NOCOPY VARCHAR2)
1061:
1062: IS
1063:

Line 1155: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

1151: --
1152:
1153: PROCEDURE create_line_attributes (
1154: p_req_line_rec IN req_line_info_rec_type,
1155: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1156: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1157: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1158: x_return_status OUT NOCOPY VARCHAR2)
1159: IS

Line 1156: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

1152:
1153: PROCEDURE create_line_attributes (
1154: p_req_line_rec IN req_line_info_rec_type,
1155: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1156: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1157: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1158: x_return_status OUT NOCOPY VARCHAR2)
1159: IS
1160: l_pricing_attr_rec fte_freight_pricing.pricing_attribute_rec_type;

Line 1157: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

1153: PROCEDURE create_line_attributes (
1154: p_req_line_rec IN req_line_info_rec_type,
1155: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1156: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1157: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1158: x_return_status OUT NOCOPY VARCHAR2)
1159: IS
1160: l_pricing_attr_rec fte_freight_pricing.pricing_attribute_rec_type;
1161: l_pricing_attr_tab fte_freight_pricing.pricing_attribute_tab_type;

Line 1440: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

1436: --
1437:
1438: PROCEDURE create_charge_line_attributes (
1439: p_req_line_rec IN req_line_info_rec_type,
1440: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1441: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1442: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1443: x_pricing_attr_tab IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
1444: x_return_status OUT NOCOPY VARCHAR2)

Line 1441: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

1437:
1438: PROCEDURE create_charge_line_attributes (
1439: p_req_line_rec IN req_line_info_rec_type,
1440: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1441: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1442: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1443: x_pricing_attr_tab IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
1444: x_return_status OUT NOCOPY VARCHAR2)
1445: IS

Line 1442: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

1438: PROCEDURE create_charge_line_attributes (
1439: p_req_line_rec IN req_line_info_rec_type,
1440: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1441: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1442: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1443: x_pricing_attr_tab IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
1444: x_return_status OUT NOCOPY VARCHAR2)
1445: IS
1446: l_pricing_attr_rec fte_freight_pricing.pricing_attribute_rec_type;

Line 1452: l_stop_rec FTE_TL_CACHE.tl_trip_stop_input_rec_type;

1448: l_attr_idx NUMBER :=0;
1449: l_out_of_rt_dist NUMBER :=0;
1450: l_fac_handling_wt NUMBER :=0;
1451: l_fac_handling_vol NUMBER :=0;
1452: l_stop_rec FTE_TL_CACHE.tl_trip_stop_input_rec_type;
1453: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1454: l_method_name VARCHAR2(50) := 'create_charge_line_attributes';
1455:
1456: BEGIN

Line 1987: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

1983: --
1984:
1985: PROCEDURE create_line_qualifiers (
1986: p_req_line_rec IN req_line_info_rec_type,
1987: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1988: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1989: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1990: x_return_status OUT NOCOPY VARCHAR2)
1991: IS

Line 1988: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

1984:
1985: PROCEDURE create_line_qualifiers (
1986: p_req_line_rec IN req_line_info_rec_type,
1987: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1988: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1989: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1990: x_return_status OUT NOCOPY VARCHAR2)
1991: IS
1992: l_qual_rec fte_qp_engine.qualifier_rec_type;

Line 1989: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

1985: PROCEDURE create_line_qualifiers (
1986: p_req_line_rec IN req_line_info_rec_type,
1987: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
1988: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
1989: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
1990: x_return_status OUT NOCOPY VARCHAR2)
1991: IS
1992: l_qual_rec fte_qp_engine.qualifier_rec_type;
1993: l_return_status VARCHAR2(1);

Line 2163: PROCEDURE init_stop_rec (x_stop_rec IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_rec_type )

2159: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2160:
2161: END create_control_rec;
2162:
2163: PROCEDURE init_stop_rec (x_stop_rec IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_rec_type )
2164: IS
2165: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
2166: l_method_name VARCHAR2(50) := 'init_stop_rec';
2167: BEGIN

Line 2214: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,

2210: -- can be utilized by cost allocation.
2211: --
2212:
2213: PROCEDURE retrieve_qp_output (
2214: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
2215: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
2216: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
2217: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
2218: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 2215: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

2211: --
2212:
2213: PROCEDURE retrieve_qp_output (
2214: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
2215: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
2216: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
2217: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
2218: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2219: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,

Line 2216: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,

2212:
2213: PROCEDURE retrieve_qp_output (
2214: p_trip_rec IN FTE_TL_CACHE.TL_trip_data_input_rec_type,
2215: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
2216: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
2217: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
2218: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2219: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
2220: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

Line 2219: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,

2215: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
2216: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
2217: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
2218: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2219: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
2220: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
2221: x_return_status OUT NOCOPY VARCHAR2)
2222: IS
2223: l_return_status VARCHAR2(1);

Line 2220: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

2216: p_carrier_pref IN FTE_TL_CACHE.TL_carrier_pref_rec_type,
2217: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
2218: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2219: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
2220: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
2221: x_return_status OUT NOCOPY VARCHAR2)
2222: IS
2223: l_return_status VARCHAR2(1);
2224: i NUMBER := 0;

Line 2242: l_stop_rec FTE_TL_CACHE.TL_trip_stop_output_rec_type;

2238: l_num_of_weekend_layover NUMBER;
2239: l_stop_index NUMBER := 0;
2240:
2241: l_qp_out_det_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
2242: l_stop_rec FTE_TL_CACHE.TL_trip_stop_output_rec_type;
2243: l_stop_id NUMBER;
2244: l_req_line_info_rec req_line_info_rec_type;
2245: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
2246: l_method_name VARCHAR2(50) := 'retrieve_qp_output';

Line 3168: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type,

3164: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
3165: END print_req_line_tab;
3166:
3167: PROCEDURE print_output(
3168: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type,
3169: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type
3170: ) IS
3171: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
3172: l_method_name VARCHAR2(50) := 'print_output';

Line 3169: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type

3165: END print_req_line_tab;
3166:
3167: PROCEDURE print_output(
3168: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type,
3169: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type
3170: ) IS
3171: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
3172: l_method_name VARCHAR2(50) := 'print_output';
3173: i NUMBER;

Line 3296: p_trip_charges_tab IN FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,

3292:
3293: PROCEDURE print_output_multiple(
3294: p_start_trip_index IN NUMBER,
3295: p_end_trip_index IN NUMBER,
3296: p_trip_charges_tab IN FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
3297: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type
3298: ) IS
3299: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
3300: l_method_name VARCHAR2(50) := 'print_output_multiple';

Line 3297: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type

3293: PROCEDURE print_output_multiple(
3294: p_start_trip_index IN NUMBER,
3295: p_end_trip_index IN NUMBER,
3296: p_trip_charges_tab IN FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
3297: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type
3298: ) IS
3299: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
3300: l_method_name VARCHAR2(50) := 'print_output_multiple';
3301: i NUMBER;

Line 3362: WHILE((FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops > 0) AND

3358: '----------------------------------------------------------------');
3359:
3360:
3361: j := p_trip_charges_tab(i).stop_charge_reference;
3362: WHILE((FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops > 0) AND
3363: (j<(FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops+p_trip_charges_tab(i).stop_charge_reference)))
3364: LOOP
3365:
3366: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,

Line 3363: (j<(FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops+p_trip_charges_tab(i).stop_charge_reference)))

3359:
3360:
3361: j := p_trip_charges_tab(i).stop_charge_reference;
3362: WHILE((FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops > 0) AND
3363: (j<(FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops+p_trip_charges_tab(i).stop_charge_reference)))
3364: LOOP
3365:
3366: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,
3367: '----------------------- Stop Output----------------------------');

Line 3503: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,

3499:
3500: PROCEDURE retrieve_qp_output_multiple (
3501: p_start_trip_index IN NUMBER,
3502: p_end_trip_index IN NUMBER,
3503: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
3504: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
3505: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
3506: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
3507: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 3504: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

3500: PROCEDURE retrieve_qp_output_multiple (
3501: p_start_trip_index IN NUMBER,
3502: p_end_trip_index IN NUMBER,
3503: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
3504: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
3505: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
3506: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
3507: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3508: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,

Line 3505: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,

3501: p_start_trip_index IN NUMBER,
3502: p_end_trip_index IN NUMBER,
3503: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
3504: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
3505: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
3506: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
3507: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3508: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
3509: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

Line 3508: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,

3504: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
3505: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
3506: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
3507: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3508: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
3509: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
3510: x_return_status OUT NOCOPY VARCHAR2)
3511:
3512: IS

Line 3509: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

3505: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
3506: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE,
3507: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3508: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
3509: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
3510: x_return_status OUT NOCOPY VARCHAR2)
3511:
3512: IS
3513: l_return_status VARCHAR2(1);

Line 3538: l_trip_rec FTE_TL_CACHE.TL_trip_output_rec_type;

3534:
3535: j NUMBER;
3536: l_trip_index NUMBER;
3537: l_qp_out_det_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
3538: l_trip_rec FTE_TL_CACHE.TL_trip_output_rec_type;
3539: l_stop_rec FTE_TL_CACHE.TL_trip_stop_output_rec_type;
3540: l_stop_id NUMBER;
3541: l_req_line_info_rec req_line_info_rec_type;
3542: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;

Line 3539: l_stop_rec FTE_TL_CACHE.TL_trip_stop_output_rec_type;

3535: j NUMBER;
3536: l_trip_index NUMBER;
3537: l_qp_out_det_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
3538: l_trip_rec FTE_TL_CACHE.TL_trip_output_rec_type;
3539: l_stop_rec FTE_TL_CACHE.TL_trip_stop_output_rec_type;
3540: l_stop_id NUMBER;
3541: l_req_line_info_rec req_line_info_rec_type;
3542: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
3543: l_method_name VARCHAR2(50) := 'retrieve_qp_output_multiple';

Line 4794: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,

4790:
4791: PROCEDURE Identify_Same_Rate_Inputs(
4792: p_start_trip_index IN NUMBER,
4793: p_end_trip_index IN NUMBER,
4794: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4795: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4796: x_same_rate_map OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
4797: x_return_status OUT NOCOPY VARCHAR2) IS
4798:

Line 4795: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

4791: PROCEDURE Identify_Same_Rate_Inputs(
4792: p_start_trip_index IN NUMBER,
4793: p_end_trip_index IN NUMBER,
4794: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4795: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4796: x_same_rate_map OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
4797: x_return_status OUT NOCOPY VARCHAR2) IS
4798:
4799: i NUMBER;

Line 4856: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,

4852:
4853: PROCEDURE Copy_Same_Rates(
4854: p_start_trip_index IN NUMBER,
4855: p_end_trip_index IN NUMBER,
4856: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4857: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4858: p_same_rate_map IN DBMS_UTILITY.NUMBER_ARRAY,
4859: x_trip_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4860: x_stop_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

Line 4857: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

4853: PROCEDURE Copy_Same_Rates(
4854: p_start_trip_index IN NUMBER,
4855: p_end_trip_index IN NUMBER,
4856: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4857: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4858: p_same_rate_map IN DBMS_UTILITY.NUMBER_ARRAY,
4859: x_trip_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4860: x_stop_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4861: x_exceptions_tab IN OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,

Line 4859: x_trip_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,

4855: p_end_trip_index IN NUMBER,
4856: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4857: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4858: p_same_rate_map IN DBMS_UTILITY.NUMBER_ARRAY,
4859: x_trip_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4860: x_stop_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4861: x_exceptions_tab IN OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
4862: x_return_status OUT NOCOPY VARCHAR2) IS
4863:

Line 4860: x_stop_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

4856: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4857: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4858: p_same_rate_map IN DBMS_UTILITY.NUMBER_ARRAY,
4859: x_trip_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4860: x_stop_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4861: x_exceptions_tab IN OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
4862: x_return_status OUT NOCOPY VARCHAR2) IS
4863:
4864: i NUMBER;

Line 4923: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,

4919:
4920: PROCEDURE TL_Core_Multiple (
4921: p_start_trip_index IN NUMBER,
4922: p_end_trip_index IN NUMBER,
4923: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4924: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4925: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
4926: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4927: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

Line 4924: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,

4920: PROCEDURE TL_Core_Multiple (
4921: p_start_trip_index IN NUMBER,
4922: p_end_trip_index IN NUMBER,
4923: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4924: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4925: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
4926: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4927: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4928: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,

Line 4925: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,

4921: p_start_trip_index IN NUMBER,
4922: p_end_trip_index IN NUMBER,
4923: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4924: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4925: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
4926: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4927: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4928: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
4929: x_return_status OUT NOCOPY VARCHAR2) IS

Line 4926: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,

4922: p_end_trip_index IN NUMBER,
4923: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4924: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4925: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
4926: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4927: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4928: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
4929: x_return_status OUT NOCOPY VARCHAR2) IS
4930:

Line 4927: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

4923: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4924: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4925: p_carrier_pref_tab IN FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
4926: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4927: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4928: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
4929: x_return_status OUT NOCOPY VARCHAR2) IS
4930:
4931:

Line 4942: l_trip_rec FTE_TL_CACHE.TL_trip_data_input_rec_type;

4938: l_implicit_non_dummy_cnt NUMBER := 0;
4939:
4940: l_same_rate_map DBMS_UTILITY.NUMBER_ARRAY;
4941: l_exception_rec tl_exceptions_type;
4942: l_trip_rec FTE_TL_CACHE.TL_trip_data_input_rec_type;
4943: i NUMBER;
4944: l_return_status VARCHAR2(1);
4945:
4946: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;