DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING dependencies on QP_PREQ_GRP

Line 2650: p_qp_output_line_row IN QP_PREQ_GRP.LINE_REC_TYPE,

2646: PROCEDURE prepare_fc_records (
2647: p_delivery_detail_id IN NUMBER, -- Top level container / loose item
2648: p_delivery_id IN NUMBER, -- Will be delivery id for 'T'
2649: p_entity_id IN NUMBER, -- Will be delivery id for 'T' and delivery leg id for 'M'
2650: p_qp_output_line_row IN QP_PREQ_GRP.LINE_REC_TYPE,
2651: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2652: p_pricing_engine_input IN pricing_engine_input_tab_type,
2653: p_grouping_level IN VARCHAR2 DEFAULT NULL,
2654: p_aggregation IN VARCHAR2 DEFAULT NULL,

Line 2651: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2647: p_delivery_detail_id IN NUMBER, -- Top level container / loose item
2648: p_delivery_id IN NUMBER, -- Will be delivery id for 'T'
2649: p_entity_id IN NUMBER, -- Will be delivery id for 'T' and delivery leg id for 'M'
2650: p_qp_output_line_row IN QP_PREQ_GRP.LINE_REC_TYPE,
2651: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2652: p_pricing_engine_input IN pricing_engine_input_tab_type,
2653: p_grouping_level IN VARCHAR2 DEFAULT NULL,
2654: p_aggregation IN VARCHAR2 DEFAULT NULL,
2655: p_save_flag IN VARCHAR2,

Line 3648: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

3644:
3645: PROCEDURE resolve_pricing_objective(
3646: p_pricing_dual_instances IN pricing_dual_instance_tab_type,
3647: x_pricing_engine_input IN OUT NOCOPY pricing_engine_input_tab_type,
3648: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3649: x_qp_output_line_details IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3650: x_return_status OUT NOCOPY VARCHAR2)
3651: IS
3652: i NUMBER:=0;

Line 3649: x_qp_output_line_details IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

3645: PROCEDURE resolve_pricing_objective(
3646: p_pricing_dual_instances IN pricing_dual_instance_tab_type,
3647: x_pricing_engine_input IN OUT NOCOPY pricing_engine_input_tab_type,
3648: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
3649: x_qp_output_line_details IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3650: x_return_status OUT NOCOPY VARCHAR2)
3651: IS
3652: i NUMBER:=0;
3653: j NUMBER:=0;

Line 4099: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE, -- line_index = input_index

4095: -- It creates freight_costs main/temp record and sends back
4096: -- Looks up delivery detail info from g_shipment_line_rows
4097:
4098: PROCEDURE process_qp_output (
4099: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE, -- line_index = input_index
4100: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4101: p_pricing_engine_input IN pricing_engine_input_tab_type,
4102: p_pricing_dual_instances IN pricing_dual_instance_tab_type,
4103: p_pattern_rows IN top_level_pattern_tab_type,

Line 4100: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

4096: -- Looks up delivery detail info from g_shipment_line_rows
4097:
4098: PROCEDURE process_qp_output (
4099: p_qp_output_line_rows IN QP_PREQ_GRP.LINE_TBL_TYPE, -- line_index = input_index
4100: p_qp_output_detail_rows IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4101: p_pricing_engine_input IN pricing_engine_input_tab_type,
4102: p_pricing_dual_instances IN pricing_dual_instance_tab_type,
4103: p_pattern_rows IN top_level_pattern_tab_type,
4104: p_shpmnt_toplevel_rows IN shpmnt_content_tab_type,

Line 4694: p_engine_output_line IN QP_PREQ_GRP.LINE_TBL_TYPE,

4690:
4691: END print_dual_instances;
4692:
4693: PROCEDURE print_qp_output_lines (
4694: p_engine_output_line IN QP_PREQ_GRP.LINE_TBL_TYPE,
4695: p_engine_output_detail IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4696: p_return_status IN VARCHAR2 ,
4697: x_return_status OUT NOCOPY VARCHAR2 )
4698: IS

Line 4695: p_engine_output_detail IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

4691: END print_dual_instances;
4692:
4693: PROCEDURE print_qp_output_lines (
4694: p_engine_output_line IN QP_PREQ_GRP.LINE_TBL_TYPE,
4695: p_engine_output_detail IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4696: p_return_status IN VARCHAR2 ,
4697: x_return_status OUT NOCOPY VARCHAR2 )
4698: IS
4699:

Line 7413: l_pricing_engine_output_lines QP_PREQ_GRP.LINE_TBL_TYPE;

7409: l_pattern_rows top_level_pattern_tab_type;
7410: l_pricing_attribute_rows pricing_attribute_tab_type;
7411: l_pricing_control_rec pricing_control_input_rec_type;
7412: l_pricing_qualifier fte_qual_rec_type;
7413: l_pricing_engine_output_lines QP_PREQ_GRP.LINE_TBL_TYPE;
7414: l_qp_output_line_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7415: l_freight_cost_main_price Freight_Cost_Main_Tab_Type;
7416: l_freight_cost_main_charge Freight_Cost_Main_Tab_Type;
7417: l_freight_cost_temp_price Freight_Cost_Temp_Tab_Type;

Line 7414: l_qp_output_line_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

7410: l_pricing_attribute_rows pricing_attribute_tab_type;
7411: l_pricing_control_rec pricing_control_input_rec_type;
7412: l_pricing_qualifier fte_qual_rec_type;
7413: l_pricing_engine_output_lines QP_PREQ_GRP.LINE_TBL_TYPE;
7414: l_qp_output_line_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7415: l_freight_cost_main_price Freight_Cost_Main_Tab_Type;
7416: l_freight_cost_main_charge Freight_Cost_Main_Tab_Type;
7417: l_freight_cost_temp_price Freight_Cost_Temp_Tab_Type;
7418: l_freight_cost_temp_charge Freight_Cost_Temp_Tab_Type;