APPS.JTF_DIAGNOSTIC dependencies on FND_APPLICATION

Line 17: -- from jtf_diagnostic_app a, fnd_application_tl b, fnd_application c

13:
14:
15: CURSOR APPLIST IS
16: -- select distinct a.appid, b.APPLICATION_NAME
17: -- from jtf_diagnostic_app a, fnd_application_tl b, fnd_application c
18: -- where a.appid = c.application_short_name
19: -- and c.application_id = b.application_id
20: -- and b.language = userenv('LANG');
21:

Line 295: -- from fnd_application_tl a, fnd_application b

291:
292: IF V_TEMP_TYPE = 1 AND V_TEMP_NAME <> 'SYSTEM_TESTS' THEN
293:
294: -- select a.application_name into V_TEMP_NAME
295: -- from fnd_application_tl a, fnd_application b
296: -- where b.APPLICATION_SHORT_NAME = x.PREREQID
297: -- and b.APPLICATION_ID = a.APPLICATION_ID
298: -- and a.language = userenv('LANG');
299: V_TEMP_NAME := '';

Line 1005: -- v_asn fnd_application.application_short_name%TYPE;

1001: P_APPID IN VARCHAR2,
1002: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1003: P_LUBID IN NUMBER) IS
1004:
1005: -- v_asn fnd_application.application_short_name%TYPE;
1006: V_SOURCETYPE BINARY_INTEGER := 1;
1007:
1008: BEGIN
1009:

Line 1011: -- a valid application in the fnd_application table

1007:
1008: BEGIN
1009:
1010: -- check if the application value entered is
1011: -- a valid application in the fnd_application table
1012: -- and if yes it should not already be there in the
1013: -- jtf_diagnostic_app table
1014:
1015: -- select distinct application_short_name into v_asn

Line 1016: -- from fnd_application

1012: -- and if yes it should not already be there in the
1013: -- jtf_diagnostic_app table
1014:
1015: -- select distinct application_short_name into v_asn
1016: -- from fnd_application
1017: -- where application_short_name = P_APPID
1018: -- and rownum <= 1;
1019:
1020: -- if sql%notfound then

Line 3205: and role_name not in ( 'FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD','UMX|ODF_APPLICATION_END_USER_ROLE',

3201: -- user obtained using USER_NAME
3202: cursor valid_user_apps_cursor is
3203: select distinct owner_tag from wf_roles where name in
3204: ( select role_name from wf_user_roles where user_name=sys_context('FND','USER_NAME')
3205: and role_name not in ( 'FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD','UMX|ODF_APPLICATION_END_USER_ROLE',
3206: 'UMX|ODF_APPLICATION_SUPER_USER_ROLE','UMX|ODF_DIAGNOSTICS_SUPER_USER_ROLE')
3207: and sysdate >=start_date and start_date 3208: and nvl2(expiration_date,expiration_date,sysdate+1) >= sysdate
3209: )

Line 3317: select application_id into p_appid from fnd_application where application_short_name = APP_SHORT_NAME;

3313: FUNCTION GET_APP_ID(APP_SHORT_NAME VARCHAR2)
3314: RETURN INTEGER IS
3315: p_appid integer;
3316: BEGIN
3317: select application_id into p_appid from fnd_application where application_short_name = APP_SHORT_NAME;
3318: return p_appid;
3319: END GET_APP_ID;
3320:
3321: -- ------------------------------------------------------------------------------------------