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_FREIGHT_PRICING_SPECIAL dependencies on FTE_FREIGHT_PRICING

Line 1: PACKAGE FTE_FREIGHT_PRICING_SPECIAL as

1: PACKAGE FTE_FREIGHT_PRICING_SPECIAL as
2: /* $Header: FTEFRPSS.pls 120.1 2005/07/15 12:13:52 mechawla noship $ */
3:
4: -- Global Variables
5:

Line 6: g_package_name CONSTANT VARCHAR2(100) := 'FTE_FREIGHT_PRICING_SPECIAL';

2: /* $Header: FTEFRPSS.pls 120.1 2005/07/15 12:13:52 mechawla noship $ */
3:
4: -- Global Variables
5:
6: g_package_name CONSTANT VARCHAR2(100) := 'FTE_FREIGHT_PRICING_SPECIAL';
7:
8: -- parameters rec
9: TYPE lane_parameter_rec_type IS RECORD (
10: parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE,

Line 68: p_top_level_rec IN OUT NOCOPY fte_freight_pricing.shpmnt_content_rec_type,

64: PROCEDURE apply_dimensional_weight (
65: p_lane_id IN NUMBER,
66: p_carrier_id IN NUMBER,
67: p_service_code IN VARCHAR2,
68: p_top_level_rec IN OUT NOCOPY fte_freight_pricing.shpmnt_content_rec_type,
69: p_rolledup_rows IN OUT NOCOPY fte_freight_pricing.rolledup_line_tab_type,
70: x_return_status OUT NOCOPY VARCHAR2 );
71:
72: FUNCTION isLTL RETURN VARCHAR2;

Line 69: p_rolledup_rows IN OUT NOCOPY fte_freight_pricing.rolledup_line_tab_type,

65: p_lane_id IN NUMBER,
66: p_carrier_id IN NUMBER,
67: p_service_code IN VARCHAR2,
68: p_top_level_rec IN OUT NOCOPY fte_freight_pricing.shpmnt_content_rec_type,
69: p_rolledup_rows IN OUT NOCOPY fte_freight_pricing.rolledup_line_tab_type,
70: x_return_status OUT NOCOPY VARCHAR2 );
71:
72: FUNCTION isLTL RETURN VARCHAR2;
73:

Line 83: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,

79: x_charge_applied OUT NOCOPY VARCHAR2, -- Y/N
80: x_return_status OUT NOCOPY VARCHAR2);
81:
82: PROCEDURE process_LTL (
83: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
84: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
85: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
86: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
87: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,

Line 84: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,

80: x_return_status OUT NOCOPY VARCHAR2);
81:
82: PROCEDURE process_LTL (
83: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
84: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
85: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
86: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
87: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
88: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,

Line 85: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,

81:
82: PROCEDURE process_LTL (
83: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
84: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
85: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
86: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
87: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
88: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
89: --p_pricing_qualifier IN fte_qual_rec_type,

Line 86: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,

82: PROCEDURE process_LTL (
83: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
84: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
85: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
86: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
87: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
88: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
89: --p_pricing_qualifier IN fte_qual_rec_type,
90: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 87: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,

83: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
84: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
85: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
86: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
87: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
88: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
89: --p_pricing_qualifier IN fte_qual_rec_type,
90: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
91: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 88: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,

84: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
85: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
86: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
87: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
88: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
89: --p_pricing_qualifier IN fte_qual_rec_type,
90: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
91: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
92: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 98: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,

94: x_return_status OUT NOCOPY VARCHAR2 );
95:
96: -- This is called for Parcel
97: PROCEDURE process_Parcel (
98: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
99: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
100: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
101: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
102: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,

Line 99: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,

95:
96: -- This is called for Parcel
97: PROCEDURE process_Parcel (
98: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
99: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
100: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
101: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
102: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
103: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,

Line 100: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,

96: -- This is called for Parcel
97: PROCEDURE process_Parcel (
98: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
99: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
100: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
101: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
102: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
103: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
104: --p_pricing_qualifier IN fte_qual_rec_type,

Line 101: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,

97: PROCEDURE process_Parcel (
98: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
99: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
100: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
101: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
102: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
103: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
104: --p_pricing_qualifier IN fte_qual_rec_type,
105: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 102: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,

98: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
99: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
100: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
101: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
102: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
103: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
104: --p_pricing_qualifier IN fte_qual_rec_type,
105: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
106: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 103: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,

99: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
100: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
101: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
102: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
103: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
104: --p_pricing_qualifier IN fte_qual_rec_type,
105: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
106: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
107: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 113: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,

109: x_return_status OUT NOCOPY VARCHAR2 );
110:
111:
112: PROCEDURE process_others (
113: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
114: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
115: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
116: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
117: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,

Line 114: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,

110:
111:
112: PROCEDURE process_others (
113: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
114: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
115: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
116: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
117: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
118: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,

Line 115: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,

111:
112: PROCEDURE process_others (
113: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
114: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
115: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
116: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
117: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
118: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
119: --p_pricing_qualifier IN fte_qual_rec_type,

Line 116: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,

112: PROCEDURE process_others (
113: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
114: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
115: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
116: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
117: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
118: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
119: --p_pricing_qualifier IN fte_qual_rec_type,
120: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 117: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,

113: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
114: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
115: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
116: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
117: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
118: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
119: --p_pricing_qualifier IN fte_qual_rec_type,
120: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
121: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 118: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,

114: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
115: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
116: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
117: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
118: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
119: --p_pricing_qualifier IN fte_qual_rec_type,
120: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
121: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
122: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 132: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,

128: -- Depending upon the mix of conditions it calls other internal procedures to process the input lines.
129: -- If no special conditions apply, control is returned to the main code line.
130:
131: PROCEDURE process_special_conditions(
132: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
133: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
134: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
135: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
136: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,

Line 133: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,

129: -- If no special conditions apply, control is returned to the main code line.
130:
131: PROCEDURE process_special_conditions(
132: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
133: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
134: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
135: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
136: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
137: x_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,

Line 134: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,

130:
131: PROCEDURE process_special_conditions(
132: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
133: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
134: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
135: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
136: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
137: x_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
138: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 135: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,

131: PROCEDURE process_special_conditions(
132: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
133: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
134: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
135: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
136: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
137: x_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
138: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
139: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 136: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,

132: p_pricing_control_rec IN fte_freight_pricing.pricing_control_input_rec_type,
133: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
134: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
135: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
136: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
137: x_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
138: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
139: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 137: x_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,

133: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
134: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
135: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
136: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
137: x_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
138: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
139: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
141: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 147: p_lane_info IN fte_freight_pricing.lane_info_rec_type,

143:
144: -- J+ enhancement for container_all rate basis
145: -- this procedure is called by shipment_pricing to rate container_all basis
146: PROCEDURE rate_container_all(
147: p_lane_info IN fte_freight_pricing.lane_info_rec_type,
148: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
149: p_save_flag IN VARCHAR2,
150: p_currency_code IN VARCHAR2 ,
151: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

Line 148: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,

144: -- J+ enhancement for container_all rate basis
145: -- this procedure is called by shipment_pricing to rate container_all basis
146: PROCEDURE rate_container_all(
147: p_lane_info IN fte_freight_pricing.lane_info_rec_type,
148: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
149: p_save_flag IN VARCHAR2,
150: p_currency_code IN VARCHAR2 ,
151: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
152: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,

Line 151: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

147: p_lane_info IN fte_freight_pricing.lane_info_rec_type,
148: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
149: p_save_flag IN VARCHAR2,
150: p_currency_code IN VARCHAR2 ,
151: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
152: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
153: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
154: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
155: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

Line 152: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,

148: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
149: p_save_flag IN VARCHAR2,
150: p_currency_code IN VARCHAR2 ,
151: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
152: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
153: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
154: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
155: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
156: x_summary_lanesched_price OUT NOCOPY NUMBER,

Line 153: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

149: p_save_flag IN VARCHAR2,
150: p_currency_code IN VARCHAR2 ,
151: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
152: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
153: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
154: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
155: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
156: x_summary_lanesched_price OUT NOCOPY NUMBER,
157: x_summary_lanesched_price_uom OUT NOCOPY VARCHAR2,

Line 154: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,

150: p_currency_code IN VARCHAR2 ,
151: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
152: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
153: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
154: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
155: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
156: x_summary_lanesched_price OUT NOCOPY NUMBER,
157: x_summary_lanesched_price_uom OUT NOCOPY VARCHAR2,
158: x_return_status OUT NOCOPY VARCHAR2 );

Line 155: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

151: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
152: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
153: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
154: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
155: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
156: x_summary_lanesched_price OUT NOCOPY NUMBER,
157: x_summary_lanesched_price_uom OUT NOCOPY VARCHAR2,
158: x_return_status OUT NOCOPY VARCHAR2 );
159:

Line 164: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,

160: -- J+ enhancement for LTL rating to include container weight
161: -- this procedure is called by process_shipment_patterns to distribute LTL container weight to
162: -- pricing_engine_rows and g_rolledup_lines
163: PROCEDURE distribute_LTL_container_wt(
164: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
165: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
166: x_return_status OUT NOCOPY VARCHAR2 ) ;
167:
168: -- J+ enhancement for shipment flat rating

Line 165: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,

161: -- this procedure is called by process_shipment_patterns to distribute LTL container weight to
162: -- pricing_engine_rows and g_rolledup_lines
163: PROCEDURE distribute_LTL_container_wt(
164: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
165: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
166: x_return_status OUT NOCOPY VARCHAR2 ) ;
167:
168: -- J+ enhancement for shipment flat rating
169: -- this procedure is called by shipment_pricing to handle shipment flat rating

Line 171: p_lane_info IN fte_freight_pricing.lane_info_rec_type,

167:
168: -- J+ enhancement for shipment flat rating
169: -- this procedure is called by shipment_pricing to handle shipment flat rating
170: PROCEDURE process_shipment_flatrate(
171: p_lane_info IN fte_freight_pricing.lane_info_rec_type,
172: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
173: p_save_flag IN VARCHAR2,
174: p_currency_code IN VARCHAR2,
175: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

Line 172: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,

168: -- J+ enhancement for shipment flat rating
169: -- this procedure is called by shipment_pricing to handle shipment flat rating
170: PROCEDURE process_shipment_flatrate(
171: p_lane_info IN fte_freight_pricing.lane_info_rec_type,
172: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
173: p_save_flag IN VARCHAR2,
174: p_currency_code IN VARCHAR2,
175: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
176: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,

Line 175: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

171: p_lane_info IN fte_freight_pricing.lane_info_rec_type,
172: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
173: p_save_flag IN VARCHAR2,
174: p_currency_code IN VARCHAR2,
175: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
176: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
177: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
178: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
179: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

Line 176: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,

172: p_top_level_rows IN fte_freight_pricing.shpmnt_content_tab_type,
173: p_save_flag IN VARCHAR2,
174: p_currency_code IN VARCHAR2,
175: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
176: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
177: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
178: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
179: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
180: x_summary_lanesched_price OUT NOCOPY NUMBER,

Line 177: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

173: p_save_flag IN VARCHAR2,
174: p_currency_code IN VARCHAR2,
175: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
176: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
177: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
178: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
179: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
180: x_summary_lanesched_price OUT NOCOPY NUMBER,
181: x_summary_lanesched_price_uom OUT NOCOPY VARCHAR2,

Line 178: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,

174: p_currency_code IN VARCHAR2,
175: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
176: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
177: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
178: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
179: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
180: x_summary_lanesched_price OUT NOCOPY NUMBER,
181: x_summary_lanesched_price_uom OUT NOCOPY VARCHAR2,
182: x_return_status OUT NOCOPY VARCHAR2 );

Line 179: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,

175: x_freight_cost_main_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
176: x_freight_cost_temp_price OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
177: x_freight_cost_main_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
178: x_freight_cost_temp_charge OUT NOCOPY fte_freight_pricing.Freight_Cost_Temp_Tab_Type,
179: x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
180: x_summary_lanesched_price OUT NOCOPY NUMBER,
181: x_summary_lanesched_price_uom OUT NOCOPY VARCHAR2,
182: x_return_status OUT NOCOPY VARCHAR2 );
183:

Line 199: END FTE_FREIGHT_PRICING_SPECIAL;

195: G_NO_PARAMS_FOUND EXCEPTION; -- if parameter table is empty or required param is not available
196: G_INVALID_PARAM_VAL EXCEPTION; -- parameter has an invalid value
197:
198:
199: END FTE_FREIGHT_PRICING_SPECIAL;