APPS.JTF_PREFAB_CACHE_PUB dependencies on FND_APPLICATION_VL

Line 338: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,

334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
336: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
337: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
338: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,
339: p_app_short_name OUT NOCOPY fnd_application_vl.application_short_name%TYPE,
340:
341: x_return_status OUT NOCOPY VARCHAR2,
342: x_msg_count OUT NOCOPY NUMBER,

Line 339: p_app_short_name OUT NOCOPY fnd_application_vl.application_short_name%TYPE,

335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
336: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
337: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
338: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,
339: p_app_short_name OUT NOCOPY fnd_application_vl.application_short_name%TYPE,
340:
341: x_return_status OUT NOCOPY VARCHAR2,
342: x_msg_count OUT NOCOPY NUMBER,
343: x_msg_data OUT NOCOPY VARCHAR2

Line 393: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host, fnd_application_vl fndapp

389: else
390:
391: SELECT app.object_version_number, app.wsh_po_id, app.application_id, app.cache_policy, app.cache_clear_flag, app.cache_reload_flag, app.cache_filter_policy, host.hostname, fndapp.application_name, fndapp.application_short_name
392: INTO p_object_version_number, p_wsh_po_id, p_application_id, p_cache_policy, p_cache_clear_flag, p_cache_reload_flag, p_cache_filter_policy, p_hostname, p_appname, p_app_short_name
393: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host, fnd_application_vl fndapp
394: WHERE app.host_app_id = p_host_app_id
395: AND app.wsh_po_id = host.wsh_po_id
396: AND app.application_id = fndapp.application_id;
397: