eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_DIAGNOSTIC dependencies on JTF_DIAG_ARRAYLIST

Line 3218: user_apps jtf_diag_arraylist; -- List of apps obtained using USER_NAME

3214: cursor valid_seeded_apps_cursor is
3215: select extractvalue(value(tbl),'/value') apps from
3216: table(xmlsequence(extract(P_VALID_APPS_XML,'/list/value'))) tbl;
3217:
3218: user_apps jtf_diag_arraylist; -- List of apps obtained using USER_NAME
3219: seeded_apps jtf_diag_arraylist; -- List of apps marked as valid @ test level
3220: custom_apps jtf_diag_arraylist; -- custom applications w.r.t seeded apps
3221: valid_apps jtf_diag_arraylist; -- valid seeded & custom apps for user
3222:

Line 3219: seeded_apps jtf_diag_arraylist; -- List of apps marked as valid @ test level

3215: select extractvalue(value(tbl),'/value') apps from
3216: table(xmlsequence(extract(P_VALID_APPS_XML,'/list/value'))) tbl;
3217:
3218: user_apps jtf_diag_arraylist; -- List of apps obtained using USER_NAME
3219: seeded_apps jtf_diag_arraylist; -- List of apps marked as valid @ test level
3220: custom_apps jtf_diag_arraylist; -- custom applications w.r.t seeded apps
3221: valid_apps jtf_diag_arraylist; -- valid seeded & custom apps for user
3222:
3223:

Line 3220: custom_apps jtf_diag_arraylist; -- custom applications w.r.t seeded apps

3216: table(xmlsequence(extract(P_VALID_APPS_XML,'/list/value'))) tbl;
3217:
3218: user_apps jtf_diag_arraylist; -- List of apps obtained using USER_NAME
3219: seeded_apps jtf_diag_arraylist; -- List of apps marked as valid @ test level
3220: custom_apps jtf_diag_arraylist; -- custom applications w.r.t seeded apps
3221: valid_apps jtf_diag_arraylist; -- valid seeded & custom apps for user
3222:
3223:
3224: BEGIN

Line 3221: valid_apps jtf_diag_arraylist; -- valid seeded & custom apps for user

3217:
3218: user_apps jtf_diag_arraylist; -- List of apps obtained using USER_NAME
3219: seeded_apps jtf_diag_arraylist; -- List of apps marked as valid @ test level
3220: custom_apps jtf_diag_arraylist; -- custom applications w.r.t seeded apps
3221: valid_apps jtf_diag_arraylist; -- valid seeded & custom apps for user
3222:
3223:
3224: BEGIN
3225:

Line 3231: user_apps := jtf_diag_arraylist();

3227: return 1;
3228: end if;
3229:
3230: -- List of apps obtained using USER_NAME
3231: user_apps := jtf_diag_arraylist();
3232:
3233: -- List of apps marked as valid @ test level
3234: seeded_apps := jtf_diag_arraylist();
3235:

Line 3234: seeded_apps := jtf_diag_arraylist();

3230: -- List of apps obtained using USER_NAME
3231: user_apps := jtf_diag_arraylist();
3232:
3233: -- List of apps marked as valid @ test level
3234: seeded_apps := jtf_diag_arraylist();
3235:
3236:
3237: -- get applications using USER_NAME
3238: for x in valid_user_apps_cursor loop

Line 3276: RETURN JTF_DIAG_ARRAYLIST IS

3272: -- ------------------------------------------------------------------------------------------
3273: -- Function to return an arraylist of custom applications w.r.t seed application
3274: -- ------------------------------------------------------------------------------------------
3275: FUNCTION GET_CUSTOM_APPS(seeded_app VARCHAR2)
3276: RETURN JTF_DIAG_ARRAYLIST IS
3277:
3278: p_object_id integer;
3279: p_permission_set_id integer;
3280: p_custom_role varchar2(100);

Line 3281: custom_apps_list jtf_diag_arraylist;

3277:
3278: p_object_id integer;
3279: p_permission_set_id integer;
3280: p_custom_role varchar2(100);
3281: custom_apps_list jtf_diag_arraylist;
3282:
3283: cursor custom_apps_cursor is select instance_pk1_value from fnd_grants
3284: where grantee_key = p_custom_role and object_id = p_object_id
3285: and menu_id = p_permission_set_id;

Line 3300: custom_apps_list := jtf_diag_arraylist();

3296: --Custom role attached to seed application
3297: p_custom_role := 'UMX|ODF_CUSTOM_'||seeded_app||'_ROLE';
3298:
3299: --instantiate array list
3300: custom_apps_list := jtf_diag_arraylist();
3301:
3302: for x in custom_apps_cursor loop
3303: custom_apps_list.addtolist(x.instance_pk1_value);
3304: end loop;

Line 3328: custom_apps_list jtf_diag_arraylist;

3324: FUNCTION GET_CUSTOM_APPS_ARRAY(APP_SHORT_NAME VARCHAR2)
3325: RETURN jtf_varchar2_table_100 IS
3326:
3327: custom_apps_array jtf_varchar2_table_100;
3328: custom_apps_list jtf_diag_arraylist;
3329: --asize integer:=0;
3330: BEGIN
3331: custom_apps_list:= GET_CUSTOM_APPS(APP_SHORT_NAME);
3332: custom_apps_array := jtf_varchar2_table_100();