15:
16: PROCEDURE Prepare_Freight_Choices_Input
17: ( p_header_id IN NUMBER
18: ,p_x_fte_source_line_tab IN OUT NOCOPY
19: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab
20: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
21: ,p_action IN VARCHAR2
22: ,x_config_count OUT NOCOPY /* file.sql.39 change */ NUMBER
23: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
77:
78: PROCEDURE Prepare_Freight_Choices_Input
79: ( p_header_id IN NUMBER
80: ,p_x_fte_source_line_tab IN OUT NOCOPY
81: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab
82: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
83: ,p_action IN VARCHAR2
84: ,x_config_count OUT NOCOPY /* file.sql.39 change */ NUMBER
85: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
605: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
606:
607: IS
608: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
610: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
611: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
612: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
613: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
606:
607: IS
608: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
610: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
611: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
612: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
613: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
614: l_return_status VARCHAR2(1);
607: IS
608: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
610: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
611: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
612: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
613: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
614: l_return_status VARCHAR2(1);
615: l_msg_data VARCHAR2(2000);
608: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
610: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
611: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
612: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
613: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
614: l_return_status VARCHAR2(1);
615: l_msg_data VARCHAR2(2000);
616: l_msg_count NUMBER;
609: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
610: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
611: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
612: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
613: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
614: l_return_status VARCHAR2(1);
615: l_msg_data VARCHAR2(2000);
616: l_msg_count NUMBER;
617: l_config_count NUMBER;
660: -- Call FTE to get group info only if the number of lines is greater than zero
661: IF l_fte_source_line_tab.Count > 0 THEN
662:
663: Print_Time('Calling FTE for Get_Group ... ');
664: FTE_PROCESS_REQUESTS.Process_Lines(
665: p_source_line_tab => l_fte_source_line_tab,
666: p_source_header_tab => l_fte_source_header_tab,
667: p_source_type => 'ONT',
668: p_action => 'GET_GROUP', -- to get group info
775:
776: PROCEDURE Prepare_Adj_Detail
777: ( p_header_id IN NUMBER
778: ,p_line_id IN NUMBER
779: ,p_fte_rates_rec IN FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec
780: ,x_line_adj_rec OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
781: ,x_return_status OUT NOCOPY VARCHAR2
782:
783: ) IS
916: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
917: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
918: IS
919:
920: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
921: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
922: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
923: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;
924: l_price_control_rec OE_ORDER_PRICE_PVT.control_rec_type;
917: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
918: IS
919:
920: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
921: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
922: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
923: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;
924: l_price_control_rec OE_ORDER_PRICE_PVT.control_rec_type;
925: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
918: IS
919:
920: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
921: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
922: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
923: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;
924: l_price_control_rec OE_ORDER_PRICE_PVT.control_rec_type;
925: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
926: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
919:
920: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
921: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
922: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
923: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;
924: l_price_control_rec OE_ORDER_PRICE_PVT.control_rec_type;
925: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
926: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
927: query_line_tbl OE_Order_PUB.Line_Tbl_Type;
995: oe_debug_pub.Add('before process lines ');
996: oe_debug_pub.Add('source header id : ' || l_fte_source_line_tab(1).source_header_id);
997: Print_Time('Calling FTE for GET_RATE_CHOICE ... ');
998:
999: FTE_PROCESS_REQUESTS.Process_Lines (
1000: p_source_line_tab => l_fte_source_line_tab,
1001: p_source_header_tab => l_fte_source_header_tab,
1002: p_source_type => 'ONT',
1003: p_action => 'GET_RATE_CHOICE', -- to get freight rates
1319: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1320: IS
1321:
1322: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;
1323: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1324: l_fte_rates_rec FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec;
1325: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1326: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1327: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1320: IS
1321:
1322: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;
1323: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1324: l_fte_rates_rec FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec;
1325: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1326: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1327: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1328: query_line_tbl OE_Order_PUB.Line_Tbl_Type;
1322: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;
1323: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1324: l_fte_rates_rec FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec;
1325: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1326: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1327: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1328: query_line_tbl OE_Order_PUB.Line_Tbl_Type;
1329: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1330: l_control_rec OE_GLOBALS.Control_Rec_Type;