APPS.OE_FTE_INTEGRATION_PVT dependencies on FTE_PROCESS_REQUESTS

Line 21: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab

17: PROCEDURE Create_FTE_Input
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);

Line 29: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab

25: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
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 );

Line 208: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab

204: PROCEDURE Create_FTE_Input
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)

Line 732: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab

728: +--------------------------------------------------------------*/
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 )

Line 1059: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;

1055: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1056: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1057: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1058: IS
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;

Line 1060: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;

1056: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1057: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1058: IS
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;

Line 1061: l_fte_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;

1057: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1058: IS
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;

Line 1062: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Rates_Tab;

1058: IS
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);

Line 1131: FTE_PROCESS_REQUESTS.Process_Lines

1127: -- Call FTE only if the number of lines is greater than zero.
1128:
1129: IF l_line_tbl.Count > 0 THEN
1130:
1131: FTE_PROCESS_REQUESTS.Process_Lines
1132: ( p_source_line_tab => l_fte_source_line_tab
1133: ,p_source_header_tab => l_fte_source_header_tab
1134: ,p_source_type => 'ONT'
1135: ,p_action => p_action