DBA Data[Home] [Help]

APPS.AZW_REPORT dependencies on FND_APPLICATION_VL

Line 306: v_name fnd_application_vl.application_name%TYPE := TO_CHAR(p_app_id);

302: * Private function.
303: * Given an application id, return the application name.
304: *-----------------------------------------------------------------------*/
305: FUNCTION get_application_name(p_app_id IN NUMBER) RETURN VARCHAR2 IS
306: v_name fnd_application_vl.application_name%TYPE := TO_CHAR(p_app_id);
307:
308: BEGIN
309: SELECT application_name
310: INTO v_name

Line 311: FROM fnd_application_vl

307:
308: BEGIN
309: SELECT application_name
310: INTO v_name
311: FROM fnd_application_vl
312: WHERE application_id = p_app_id;
313:
314: RETURN v_name;
315: EXCEPTION

Line 332: v_name fnd_application_vl.application_short_name%TYPE := TO_CHAR(p_app_id);

328: * Private function.
329: * Given an application id, return the application short name.
330: *-----------------------------------------------------------------------*/
331: FUNCTION get_application_short_name(p_app_id IN NUMBER) RETURN VARCHAR2 IS
332: v_name fnd_application_vl.application_short_name%TYPE := TO_CHAR(p_app_id);
333:
334: BEGIN
335: SELECT application_short_name
336: INTO v_name

Line 337: FROM fnd_application_vl

333:
334: BEGIN
335: SELECT application_short_name
336: INTO v_name
337: FROM fnd_application_vl
338: WHERE application_id = p_app_id;
339:
340: RETURN v_name;
341: EXCEPTION

Line 4306: fnd_application_vl fav

4302: SELECT ag.dependency_parent_id,
4303: ag.application_id,
4304: fav.application_name
4305: FROM az_groups ag,
4306: fnd_application_vl fav
4307: WHERE ag.application_id IS NOT NULL
4308: AND ag.application_id = fav.application_id
4309: AND ag.process_type = g_current_mode
4310: ORDER BY ag.dependency_parent_id,