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 731: FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab

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

Line 1058: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;

1054: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1055: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1056: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1057: IS
1058: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1059: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
1060: l_fte_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1061: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Rates_Tab;
1062: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1059: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;

1055: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1056: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1057: IS
1058: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1059: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
1060: l_fte_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1061: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Rates_Tab;
1062: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1063: l_config_count NUMBER;

Line 1060: l_fte_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;

1056: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1057: IS
1058: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1059: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
1060: l_fte_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1061: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Rates_Tab;
1062: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1063: l_config_count NUMBER;
1064: l_no_opr_count NUMBER;

Line 1061: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Rates_Tab;

1057: IS
1058: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1059: l_fte_source_header_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
1060: l_fte_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1061: l_fte_header_rates_tab FTE_PROCESS_REQUESTS.Fte_Source_Header_Rates_Tab;
1062: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1063: l_config_count NUMBER;
1064: l_no_opr_count NUMBER;
1065: l_msg_text VARCHAR2(2000);

Line 1130: FTE_PROCESS_REQUESTS.Process_Lines

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