DBA Data[Home] [Help]

APPS.BIS_APPLICATION_PVT dependencies on FND_APPLICATION_VL

Line 35: from fnd_application_vl

31: IS
32:
33: cursor app_cursor is
34: select application_id, APPLICATION_SHORT_NAME, APPLICATION_NAME
35: from fnd_application_vl
36: ORDER by UPPER(APPLICATION_NAME);
37:
38: l_rec Application_Rec_Type;
39:

Line 93: from fnd_application_vl

89: l_dummy number;
90:
91: CURSOR chk_application is
92: select 1
93: from fnd_application_vl
94: where Application_id = p_Application_Rec.Application_id;
95:
96: begin
97: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 208: FROM fnd_application_vl

204:
205: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Application_Short_Name)
206: = FND_API.G_TRUE) then
207: SELECT Application_id into x_Application_ID
208: FROM fnd_application_vl
209: WHERE Application_short_name = p_Application_Short_Name;
210: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Application_Name)
211: = FND_API.G_TRUE) then
212: SELECT Application_id into x_Application_ID

Line 213: FROM fnd_application_vl

209: WHERE Application_short_name = p_Application_Short_Name;
210: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Application_Name)
211: = FND_API.G_TRUE) then
212: SELECT Application_id into x_Application_ID
213: FROM fnd_application_vl
214: WHERE Application_name = p_Application_Name;
215: else
216: -- POLPULATE ERROR TABLE
217: RAISE FND_API.G_EXC_ERROR;