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 OE_ORDER_PUB

Line 6: --G_line_tbl OE_Order_PUB.Line_Tbl_Type;

2: /* $Header: OEXVFCHB.pls 120.9 2010/07/23 07:43:12 spothula ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_FREIGHT_CHOICES_PVT';
5: G_config_count NUMBER;
6: --G_line_tbl OE_Order_PUB.Line_Tbl_Type;
7:
8: TYPE number_type is table of number index by binary_integer;
9:
10: /*--------------------------------------------------------------+

Line 20: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

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

Line 60: elgible lines in the oe_order_pub line table

56: we process the included items if they are not
57: frozen already. We will exclude all the non
58: eligible lines and prepate the fte input tab
59: at the same time we will also insert the
60: elgible lines in the oe_order_pub line table
61: to be used later.
62: Now we have line table with all the lines
63: beginnning with config lines.
64:

Line 82: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

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)
86:

Line 152: l_line_rec OE_ORDER_PUB.line_rec_type :=

148: l_config_count NUMBER := 0;
149: l_count NUMBER := 0;
150: l_transactional_curr_code VARCHAR2(15);
151: l_conversion_type_code VARCHAR2(30);
152: l_line_rec OE_ORDER_PUB.line_rec_type :=
153: OE_Order_Pub.G_MISS_LINE_REC;
154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
155: BEGIN
156: Print_Time('Entering OE_FREIGHT_CHOICES_PVT.Prepare_Freight_Choices_Input...');

Line 153: OE_Order_Pub.G_MISS_LINE_REC;

149: l_count NUMBER := 0;
150: l_transactional_curr_code VARCHAR2(15);
151: l_conversion_type_code VARCHAR2(30);
152: l_line_rec OE_ORDER_PUB.line_rec_type :=
153: OE_Order_Pub.G_MISS_LINE_REC;
154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
155: BEGIN
156: Print_Time('Entering OE_FREIGHT_CHOICES_PVT.Prepare_Freight_Choices_Input...');
157:

Line 609: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

605: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
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;

Line 781: ,x_line_adj_rec OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

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
785:

Line 926: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

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;
929: l_config_count NUMBER;
930: l_no_opr_count NUMBER;

Line 927: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

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;
929: l_config_count NUMBER;
930: l_no_opr_count NUMBER;
931: l_msg_text VARCHAR2(2000);

Line 928: query_line_tbl OE_Order_PUB.Line_Tbl_Type;

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;
929: l_config_count NUMBER;
930: l_no_opr_count NUMBER;
931: l_msg_text VARCHAR2(2000);
932: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1326: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

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;
1330: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1328: l_line_tbl OE_Order_PUB.Line_Tbl_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;
1332: l_line_rec OE_ORDER_PUB.line_rec_type ;

Line 1329: query_line_tbl OE_Order_PUB.Line_Tbl_Type;

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;
1332: l_line_rec OE_ORDER_PUB.line_rec_type ;
1333: l_bulk_adj_rec OE_Freight_Rating_PVT.Bulk_Line_Adj_Rec_Type;

Line 1330: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

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;
1332: l_line_rec OE_ORDER_PUB.line_rec_type ;
1333: l_bulk_adj_rec OE_Freight_Rating_PVT.Bulk_Line_Adj_Rec_Type;
1334: l_count Number;

Line 1332: l_line_rec OE_ORDER_PUB.line_rec_type ;

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;
1332: l_line_rec OE_ORDER_PUB.line_rec_type ;
1333: l_bulk_adj_rec OE_Freight_Rating_PVT.Bulk_Line_Adj_Rec_Type;
1334: l_count Number;
1335: l_fte_count Number := 1;
1336: i Number := 1;