DBA Data[Home] [Help]

APPS.FND_GLOBAL dependencies on FND_APPLICATION

Line 645: buffer fnd_application_vl.application_name%type;

641: end audit_active;
642:
643: -- APPLICATION_NAME -
644: function application_name return varchar2 is
645: buffer fnd_application_vl.application_name%type;
646: v_raid integer := resp_appl_id;
647: begin
648: if v_raid is null then
649: return null;

Line 660: from fnd_application_vl a

656:
657: -- Re-query every time in case of language change --
658: select a.application_name
659: into buffer
660: from fnd_application_vl a
661: where a.application_id = v_raid;
662:
663: -- no caching of APPLICATION_NAME
664: -- to avoid changing pragma in spec

Line 2159: -- query fnd_application data if resp_appl_id changed

2155: end if;
2156:
2157: -- Would be nice to query these on-demand but the pragmas are all RNDS.
2158:
2159: -- query fnd_application data if resp_appl_id changed
2160: --
2161: if appl_context_change then
2162:
2163: clear(FND_CONST.APPLICATION_SHORT_NAME);

Line 2170: v_asn fnd_application.application_short_name%type;

2166: -- and just clear the APPLICATION_SHORT_NAME instead
2167: if is_defined(FND_CONST.RESP_APPL_ID) then
2168:
2169: declare
2170: v_asn fnd_application.application_short_name%type;
2171: v_raid fnd_application.application_id%type := resp_appl_id;
2172: begin
2173:
2174: select a.application_short_name

Line 2171: v_raid fnd_application.application_id%type := resp_appl_id;

2167: if is_defined(FND_CONST.RESP_APPL_ID) then
2168:
2169: declare
2170: v_asn fnd_application.application_short_name%type;
2171: v_raid fnd_application.application_id%type := resp_appl_id;
2172: begin
2173:
2174: select a.application_short_name
2175: into v_asn

Line 2176: from fnd_application a

2172: begin
2173:
2174: select a.application_short_name
2175: into v_asn
2176: from fnd_application a
2177: where a.application_id = v_raid;
2178:
2179: put(FND_CONST.APPLICATION_SHORT_NAME,v_asn);
2180: