APPS.OE_FTE_INTEGRATION_PVT dependencies on OE_ORDER_PUB

Line 14: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

10:
11: PROCEDURE Print_Time(p_msg IN VARCHAR2);
12:
13: PROCEDURE Update_FTE_Results
14: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
15: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
16:
17: PROCEDURE Create_FTE_Input
18: ( p_header_id IN NUMBER

Line 22: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

18: ( p_header_id IN NUMBER
19: ,p_line_id IN NUMBER
20: ,p_x_fte_source_line_tab IN OUT NOCOPY
21: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab
22: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
23: ,p_action IN VARCHAR2
24: ,x_config_count OUT NOCOPY /* file.sql.39 change */ NUMBER
25: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
26:

Line 30: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

26:
27: PROCEDURE Process_FTE_Output
28: ( p_x_fte_source_line_tab IN OUT NOCOPY
29: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab
30: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
31: ,p_config_count IN NUMBER
32: ,x_no_opr_count OUT NOCOPY /* file.sql.39 change */ NUMBER
33: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
34:

Line 75: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

71: | Change Record : |
72: +--------------------------------------------------------------*/
73:
74: PROCEDURE Update_FTE_Results
75: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
76: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
77:
78: IS
79: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 80: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

76: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
77:
78: IS
79: l_control_rec OE_GLOBALS.Control_Rec_Type;
80: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
81: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
82: BEGIN
83:
84: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Update_FTE_Results..');

Line 186: elgible lines in the oe_order_pub line table

182: we process the included items if they are not
183: frozen already. We will exclude all the non
184: eligible lines and prepate the fte input tab
185: at the same time we will also insert the
186: elgible lines in the oe_order_pub line table
187: to be used later.
188: Now we have line table with all the lines
189: beginnning with config lines.
190:

Line 209: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

205: ( p_header_id IN NUMBER
206: ,p_line_id IN NUMBER
207: ,p_x_fte_source_line_tab IN OUT NOCOPY
208: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab
209: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
210: ,p_action IN VARCHAR2
211: ,x_config_count OUT NOCOPY /* file.sql.39 change */ NUMBER
212: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
213:

Line 277: l_line_rec OE_ORDER_PUB.line_rec_type :=

273: l_order_category_code VARCHAR2(30);
274: l_line_count NUMBER := 0;
275: l_config_count NUMBER := 0;
276: l_count NUMBER := 0;
277: l_line_rec OE_ORDER_PUB.line_rec_type :=
278: OE_Order_Pub.G_MISS_LINE_REC;
279: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
280: BEGIN
281: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Create_FTE_Input...');

Line 278: OE_Order_Pub.G_MISS_LINE_REC;

274: l_line_count NUMBER := 0;
275: l_config_count NUMBER := 0;
276: l_count NUMBER := 0;
277: l_line_rec OE_ORDER_PUB.line_rec_type :=
278: OE_Order_Pub.G_MISS_LINE_REC;
279: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
280: BEGIN
281: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Create_FTE_Input...');
282:

Line 733: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

729:
730: PROCEDURE Process_FTE_Output
731: ( p_x_fte_source_line_tab IN OUT NOCOPY
732: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab
733: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
734: ,p_config_count IN NUMBER
735: ,x_no_opr_count OUT NOCOPY /* file.sql.39 change */ NUMBER
736: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
737: IS

Line 1063: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1059: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1060: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
1061: l_fte_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1062: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Rates_Tab;
1063: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1064: l_config_count NUMBER;
1065: l_no_opr_count NUMBER;
1066: l_msg_text VARCHAR2(2000);
1067: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;