DBA Data[Home] [Help]

APPS.BIS_REPORT_FUNCTION_PVT dependencies on BIS_UTILITIES_PUB

Line 10: , x_error_tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

6: PROCEDURE Retrieve_Report_Functions
7: ( p_api_version IN number
8: , x_Report_Function_Tbl out Report_Function_Tbl_Type
9: , x_return_status OUT VARCHAR2
10: , x_error_tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
11: )
12: IS
13:
14: i NUMBER := 0;

Line 63: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

59: ( p_api_version IN NUMBER
60: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
61: , p_Report_Function_ID IN NUMBER
62: , x_return_status OUT VARCHAR2
63: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
64: )
65: IS
66:
67: CURSOR val_cur is

Line 110: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

106: , p_Report_Function_Name IN VARCHAR2
107: , p_Report_user_Function_Name IN VARCHAR2
108: , x_Report_Function_ID OUT NUMBER
109: , x_return_status OUT VARCHAR2
110: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
111: )
112: IS
113:
114: BEGIN

Line 118: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Report_Function_Name)

114: BEGIN
115:
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Report_Function_Name)
119: = FND_API.G_TRUE) then
120:
121: select function_id into x_Report_Function_ID
122: from fnd_form_functions_vl

Line 126: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Report_user_Function_Name)

122: from fnd_form_functions_vl
123: where function_name = p_Report_Function_Name
124: and TYPE = 'BISTAR';
125:
126: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Report_user_Function_Name)
127: = FND_API.G_TRUE) then
128:
129: select function_id into x_Report_Function_ID
130: from fnd_form_functions_vl