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.OE_FREIGHT_CHOICES_PVT dependencies on FTE_PROCESS_REQUESTS

Line 19: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab

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);

Line 81: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab

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)

Line 610: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;

606: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
607:
608: IS
609: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
610: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
611: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
612: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
613: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
614: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;

Line 611: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;

607:
608: IS
609: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
610: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
611: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
612: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
613: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
614: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
615: l_return_status VARCHAR2(1);

Line 612: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;

608: IS
609: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
610: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
611: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
612: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
613: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
614: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
615: l_return_status VARCHAR2(1);
616: l_msg_data VARCHAR2(2000);

Line 613: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;

609: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
610: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
611: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
612: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
613: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
614: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
615: l_return_status VARCHAR2(1);
616: l_msg_data VARCHAR2(2000);
617: l_msg_count NUMBER;

Line 614: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;

610: l_fte_source_line_tab FTE_PROCESS_REQUESTS.fte_source_line_tab;
611: l_fte_source_header_tab FTE_PROCESS_REQUESTS.fte_source_header_tab;
612: l_fte_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
613: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
614: --l_rating_parameters_tab FTE_PROCESS_REQUESTS.fte_rating_parameters_tab;
615: l_return_status VARCHAR2(1);
616: l_msg_data VARCHAR2(2000);
617: l_msg_count NUMBER;
618: l_config_count NUMBER;

Line 665: FTE_PROCESS_REQUESTS.Process_Lines(

661: -- Call FTE to get group info only if the number of lines is greater than zero
662: IF l_fte_source_line_tab.Count > 0 THEN
663:
664: Print_Time('Calling FTE for Get_Group ... ');
665: FTE_PROCESS_REQUESTS.Process_Lines(
666: p_source_line_tab => l_fte_source_line_tab,
667: p_source_header_tab => l_fte_source_header_tab,
668: p_source_type => 'ONT',
669: p_action => 'GET_GROUP', -- to get group info

Line 780: ,p_fte_rates_rec IN FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec

776:
777: PROCEDURE Prepare_Adj_Detail
778: ( p_header_id IN NUMBER
779: ,p_line_id IN NUMBER
780: ,p_fte_rates_rec IN FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec
781: ,x_line_adj_rec OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
782: ,x_return_status OUT NOCOPY VARCHAR2
783:
784: ) IS

Line 921: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;

917: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
918: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
919: IS
920:
921: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
922: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
923: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
924: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;
925: l_price_control_rec OE_ORDER_PRICE_PVT.control_rec_type;

Line 922: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;

918: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
919: IS
920:
921: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
922: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
923: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
924: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;
925: l_price_control_rec OE_ORDER_PRICE_PVT.control_rec_type;
926: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 923: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;

919: IS
920:
921: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
922: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
923: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
924: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;
925: l_price_control_rec OE_ORDER_PRICE_PVT.control_rec_type;
926: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
927: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 924: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;

920:
921: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
922: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
923: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
924: l_fte_header_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_header_Rates_Tab;
925: l_price_control_rec OE_ORDER_PRICE_PVT.control_rec_type;
926: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
927: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
928: query_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1000: FTE_PROCESS_REQUESTS.Process_Lines (

996: oe_debug_pub.Add('before process lines ');
997: oe_debug_pub.Add('source header id : ' || l_fte_source_line_tab(1).source_header_id);
998: Print_Time('Calling FTE for GET_RATE_CHOICE ... ');
999:
1000: FTE_PROCESS_REQUESTS.Process_Lines (
1001: p_source_line_tab => l_fte_source_line_tab,
1002: p_source_header_tab => l_fte_source_header_tab,
1003: p_source_type => 'ONT',
1004: p_action => 'GET_RATE_CHOICE', -- to get freight rates

Line 1324: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;

1320: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1321: IS
1322:
1323: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;
1324: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1325: l_fte_rates_rec FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec;
1326: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1327: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1328: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1325: l_fte_rates_rec FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec;

1321: IS
1322:
1323: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;
1324: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1325: l_fte_rates_rec FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec;
1326: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1327: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1328: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1329: query_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1327: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;

1323: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;
1324: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1325: l_fte_rates_rec FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec;
1326: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1327: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1328: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1329: query_line_tbl OE_Order_PUB.Line_Tbl_Type;
1330: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1331: l_control_rec OE_GLOBALS.Control_Rec_Type;