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 QP_PREQ_GRP

Line 2219: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

2215: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
2216: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
2217: x_deficit_wt_applied OUT NOCOPY VARCHAR2, -- Added AG 5/10
2218: x_min_charge_comp_price OUT NOCOPY NUMBER, -- AG 5/10
2219: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2220: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2221: x_return_status OUT NOCOPY VARCHAR2 )
2222: IS
2223: l_return_status VARCHAR2(1);

Line 2220: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2216: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
2217: x_deficit_wt_applied OUT NOCOPY VARCHAR2, -- Added AG 5/10
2218: x_min_charge_comp_price OUT NOCOPY NUMBER, -- AG 5/10
2219: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2220: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2221: x_return_status OUT NOCOPY VARCHAR2 )
2222: IS
2223: l_return_status VARCHAR2(1);
2224: l_total_wt NUMBER;

Line 2259: l_qp_output_dfw_detail_row QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;

2255: l_lowest_up_priced_uom VARCHAR2(30);
2256: l_lowest_up_tot_qty NUMBER:=0;
2257: l_lowest_up_line_priced_qty NUMBER:=0;
2258: l_adjustment_amount NUMBER;
2259: l_qp_output_dfw_detail_row QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
2260:
2261: l_deficit_wt_enabled BOOLEAN;
2262:
2263: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;

Line 2846: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

2842: p_set_num IN NUMBER,
2843: p_comp_with_price IN NUMBER DEFAULT NULL,
2844: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
2845: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
2846: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2847: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2848: x_return_status OUT NOCOPY VARCHAR2 )
2849: IS
2850: l_event_num NUMBER;

Line 2847: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2843: p_comp_with_price IN NUMBER DEFAULT NULL,
2844: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
2845: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
2846: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2847: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2848: x_return_status OUT NOCOPY VARCHAR2 )
2849: IS
2850: l_event_num NUMBER;
2851: l_charge_applied VARCHAR2(1);

Line 2961: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

2957: p_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
2958: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
2959: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
2960: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
2961: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2962: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2963: x_return_status OUT NOCOPY VARCHAR2 )
2964: IS
2965: l_return_status VARCHAR2(1);

Line 2962: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2958: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
2959: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
2960: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
2961: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2962: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2963: x_return_status OUT NOCOPY VARCHAR2 )
2964: IS
2965: l_return_status VARCHAR2(1);
2966: l_total_wt NUMBER;

Line 3446: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

3442: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
3443: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
3444: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
3445: --p_pricing_qualifier IN fte_qual_rec_type,
3446: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3447: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3448: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3449: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3450: x_return_status OUT NOCOPY VARCHAR2 )

Line 3447: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

3443: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
3444: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
3445: --p_pricing_qualifier IN fte_qual_rec_type,
3446: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3447: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3448: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3449: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3450: x_return_status OUT NOCOPY VARCHAR2 )
3451: IS

Line 3448: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

3444: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
3445: --p_pricing_qualifier IN fte_qual_rec_type,
3446: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3447: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3448: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3449: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3450: x_return_status OUT NOCOPY VARCHAR2 )
3451: IS
3452:

Line 3449: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

3445: --p_pricing_qualifier IN fte_qual_rec_type,
3446: --x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3447: --x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3448: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3449: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3450: x_return_status OUT NOCOPY VARCHAR2 )
3451: IS
3452:
3453: l_return_status VARCHAR2(1);

Line 4275: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

4271: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
4272: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
4273: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
4274: --p_pricing_qualifier IN fte_qual_rec_type,
4275: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
4276: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4277: x_return_status OUT NOCOPY VARCHAR2 )
4278: IS
4279:

Line 4276: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

4272: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
4273: p_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
4274: --p_pricing_qualifier IN fte_qual_rec_type,
4275: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
4276: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4277: x_return_status OUT NOCOPY VARCHAR2 )
4278: IS
4279:
4280: l_return_status VARCHAR2(1);

Line 4457: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

4453: p_pattern_rows IN fte_freight_pricing.top_level_pattern_tab_type,
4454: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
4455: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
4456: x_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
4457: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
4458: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4459: x_return_status OUT NOCOPY VARCHAR2 )
4460: IS
4461:

Line 4458: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

4454: p_pricing_dual_instances IN fte_freight_pricing.pricing_dual_instance_tab_type,
4455: x_pricing_engine_rows IN OUT NOCOPY fte_freight_pricing.pricing_engine_input_tab_type,
4456: x_pricing_attribute_rows IN OUT NOCOPY fte_freight_pricing.pricing_attribute_tab_type,
4457: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
4458: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4459: x_return_status OUT NOCOPY VARCHAR2 )
4460: IS
4461:
4462: l_return_status VARCHAR2(1);

Line 4611: l_qp_output_line_rows QP_PREQ_GRP.LINE_TBL_TYPE;

4607: l_pricing_engine_rows fte_freight_pricing.pricing_engine_input_tab_type;
4608: l_engine_row_count NUMBER;
4609: l_pricing_attribute_rows fte_freight_pricing.pricing_attribute_tab_type;
4610:
4611: l_qp_output_line_rows QP_PREQ_GRP.LINE_TBL_TYPE;
4612: l_qp_output_detail_rows QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
4613:
4614: l_uom_ea VARCHAR2(30);
4615: i NUMBER;

Line 4612: l_qp_output_detail_rows QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

4608: l_engine_row_count NUMBER;
4609: l_pricing_attribute_rows fte_freight_pricing.pricing_attribute_tab_type;
4610:
4611: l_qp_output_line_rows QP_PREQ_GRP.LINE_TBL_TYPE;
4612: l_qp_output_detail_rows QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
4613:
4614: l_uom_ea VARCHAR2(30);
4615: i NUMBER;
4616: j NUMBER;

Line 5509: l_qp_output_line_rows QP_PREQ_GRP.LINE_TBL_TYPE;

5505: l_pricing_engine_rows fte_freight_pricing.pricing_engine_input_tab_type;
5506: l_engine_row_count NUMBER;
5507: l_pricing_attribute_rows fte_freight_pricing.pricing_attribute_tab_type;
5508:
5509: l_qp_output_line_rows QP_PREQ_GRP.LINE_TBL_TYPE;
5510: l_qp_output_detail_rows QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5511:
5512: l_uom_ea VARCHAR2(30);
5513: i NUMBER;

Line 5510: l_qp_output_detail_rows QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

5506: l_engine_row_count NUMBER;
5507: l_pricing_attribute_rows fte_freight_pricing.pricing_attribute_tab_type;
5508:
5509: l_qp_output_line_rows QP_PREQ_GRP.LINE_TBL_TYPE;
5510: l_qp_output_detail_rows QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5511:
5512: l_uom_ea VARCHAR2(30);
5513: i NUMBER;
5514: j NUMBER;