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 STANDARD

Line 2077: -- 5953806 - replaced to follow FNDLOAD standards

2073:
2074: BEGIN
2075:
2076: -- Translate owner to file_last_updated_by
2077: -- 5953806 - replaced to follow FNDLOAD standards
2078: /*if (P_OWNER = 'SEED') then
2079: f_luby := 1;
2080: else
2081: f_luby := 0;

Line 2095: -- Update record only as per standard

2091: into db_luby, db_ludate
2092: from jtf_diagnostic_app
2093: where appid = p_appid;
2094:
2095: -- Update record only as per standard
2096:
2097: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2098: /*if ((p_cust_mode = 'FORCE') or
2099: ((f_luby = 0) and (db_luby = 1)) or

Line 2097: -- 5953806 - replaced to if statement to follow FNDLOAD standards

2093: where appid = p_appid;
2094:
2095: -- Update record only as per standard
2096:
2097: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2098: /*if ((p_cust_mode = 'FORCE') or
2099: ((f_luby = 0) and (db_luby = 1)) or
2100: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2101: /* if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 2172: -- 5953806 - replaced to follow FNDLOAD standards

2168: v_sensitivity := to_number(nvl(P_SENSITIVITY, '1'));
2169:
2170: -- Translate owner to file_last_updated_by
2171:
2172: -- 5953806 - replaced to follow FNDLOAD standards
2173: /*if (P_OWNER = 'SEED') then
2174: f_luby := 1;
2175: else
2176: f_luby := 0;

Line 2191: -- Update record only as per standard

2187: from jtf_diagnostic_group
2188: where appid = p_appid and
2189: groupname = p_groupname;
2190:
2191: -- Update record only as per standard
2192:
2193: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2194: /*if ((p_cust_mode = 'FORCE') or
2195: ((f_luby = 0) and (db_luby = 1)) or

Line 2193: -- 5953806 - replaced to if statement to follow FNDLOAD standards

2189: groupname = p_groupname;
2190:
2191: -- Update record only as per standard
2192:
2193: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2194: /*if ((p_cust_mode = 'FORCE') or
2195: ((f_luby = 0) and (db_luby = 1)) or
2196: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2197: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 2307: -- 5953806 - replaced to follow FNDLOAD standards

2303: BEGIN
2304:
2305: -- Translate owner to file_last_updated_by
2306:
2307: -- 5953806 - replaced to follow FNDLOAD standards
2308: /*if (P_OWNER = 'SEED') then
2309: f_luby := 1;
2310: else
2311: f_luby := 0;

Line 2341: -- Update record only as per standard

2337: where appid = p_appid and
2338: groupname = p_groupname
2339: and testclassname = p_testclassname;
2340:
2341: -- Update record only as per standard
2342:
2343: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2344: /*if ((p_cust_mode = 'FORCE') or
2345: ((f_luby = 0) and (db_luby = 1)) or

Line 2343: -- 5953806 - replaced to if statement to follow FNDLOAD standards

2339: and testclassname = p_testclassname;
2340:
2341: -- Update record only as per standard
2342:
2343: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2344: /*if ((p_cust_mode = 'FORCE') or
2345: ((f_luby = 0) and (db_luby = 1)) or
2346: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2347: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 2544: -- 5953806 - replaced to follow FNDLOAD standards

2540: BEGIN
2541:
2542: -- Translate owner to file_last_updated_by
2543:
2544: -- 5953806 - replaced to follow FNDLOAD standards
2545: /*if (P_OWNER = 'SEED') then
2546: f_luby := 1;
2547: else
2548: f_luby := 0;

Line 2566: -- Update record only as per standard

2562: and testclassname = p_testclassname
2563: and argname = p_argname
2564: and rownumber = p_rownumber;
2565:
2566: -- Update record only as per standard
2567:
2568: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2569: /*if ((p_cust_mode = 'FORCE') or
2570: ((f_luby = 0) and (db_luby = 1)) or

Line 2568: -- 5953806 - replaced to if statement to follow FNDLOAD standards

2564: and rownumber = p_rownumber;
2565:
2566: -- Update record only as per standard
2567:
2568: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2569: /*if ((p_cust_mode = 'FORCE') or
2570: ((f_luby = 0) and (db_luby = 1)) or
2571: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2572: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 2658: -- 5953806 - replaced to follow FNDLOAD standards

2654:
2655: BEGIN
2656:
2657: -- Translate owner to file_last_updated_by
2658: -- 5953806 - replaced to follow FNDLOAD standards
2659: /*if (P_OWNER = 'SEED') then
2660: f_luby := 1;
2661: else
2662: f_luby := 0;

Line 2679: -- Update record only as per standard

2675: and prereqid = p_prereqid
2676: and SOURCEAPPID = p_SOURCEAPPID
2677: and type = p_type;
2678:
2679: -- Update record only as per standard
2680:
2681: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2682: /*if ((p_cust_mode = 'FORCE') or
2683: ((f_luby = 0) and (db_luby = 1)) or

Line 2681: -- 5953806 - replaced to if statement to follow FNDLOAD standards

2677: and type = p_type;
2678:
2679: -- Update record only as per standard
2680:
2681: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2682: /*if ((p_cust_mode = 'FORCE') or
2683: ((f_luby = 0) and (db_luby = 1)) or
2684: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2685: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 2775: -- 5953806 - replaced to follow FNDLOAD standards

2771: BEGIN
2772:
2773: -- Translate owner to file_last_updated_by
2774:
2775: -- 5953806 - replaced to follow FNDLOAD standards
2776: /*if (P_OWNER = 'SEED') then
2777: f_luby := 1;
2778: else
2779: f_luby := 0;

Line 2796: -- Update record only as per standard

2792: and GROUPNAME = P_GROUPNAME
2793: and TESTCLASSNAME = P_TESTCLASSNAME
2794: and TESTSTEPNAME = P_TESTSTEPNAME;
2795:
2796: -- Update record only as per standard
2797:
2798: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2799: /*if ((p_cust_mode = 'FORCE') or
2800: ((f_luby = 0) and (db_luby = 1)) or

Line 2798: -- 5953806 - replaced to if statement to follow FNDLOAD standards

2794: and TESTSTEPNAME = P_TESTSTEPNAME;
2795:
2796: -- Update record only as per standard
2797:
2798: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2799: /*if ((p_cust_mode = 'FORCE') or
2800: ((f_luby = 0) and (db_luby = 1)) or
2801: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2802: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 2933: -- 5953806 - replaced to follow FNDLOAD standards

2929: BEGIN
2930:
2931: -- Translate owner to file_last_updated_by
2932:
2933: -- 5953806 - replaced to follow FNDLOAD standards
2934: /*if (P_OWNER = 'SEED') then
2935: f_luby := 1;
2936: else
2937: f_luby := 0;

Line 2955: -- Update record only as per standard

2951: and TESTCLASSNAME = P_TESTCLASSNAME
2952: and TESTSTEPNAME = P_TESTSTEPNAME
2953: and COLUMN_NAME = P_COLUMN_NAME;
2954:
2955: -- Update record only as per standard
2956:
2957: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2958: /*if ((p_cust_mode = 'FORCE') or
2959: ((f_luby = 0) and (db_luby = 1)) or

Line 2957: -- 5953806 - replaced to if statement to follow FNDLOAD standards

2953: and COLUMN_NAME = P_COLUMN_NAME;
2954:
2955: -- Update record only as per standard
2956:
2957: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2958: /*if ((p_cust_mode = 'FORCE') or
2959: ((f_luby = 0) and (db_luby = 1)) or
2960: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2961: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 3050: -- 5953806 - replaced to follow FNDLOAD standards

3046: BEGIN
3047:
3048: -- Translate owner to file_last_updated_by
3049:
3050: -- 5953806 - replaced to follow FNDLOAD standards
3051: /*if (P_OWNER = 'SEED') then
3052: f_luby := 1;
3053: else
3054: f_luby := 0;

Line 3071: -- Update record only as per standard

3067: groupname = p_groupname
3068: and testclassname = p_testclassname
3069: and type = p_type;
3070:
3071: -- Update record only as per standard
3072:
3073: -- 5953806 - replaced to if statement to follow FNDLOAD standards
3074: /*if ((p_cust_mode = 'FORCE') or
3075: ((f_luby = 0) and (db_luby = 1)) or

Line 3073: -- 5953806 - replaced to if statement to follow FNDLOAD standards

3069: and type = p_type;
3070:
3071: -- Update record only as per standard
3072:
3073: -- 5953806 - replaced to if statement to follow FNDLOAD standards
3074: /*if ((p_cust_mode = 'FORCE') or
3075: ((f_luby = 0) and (db_luby = 1)) or
3076: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
3077: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 3183: -- 5953806 - replaced to follow FNDLOAD standards

3179: end;
3180:
3181: -- Translate owner to file_last_updated_by
3182:
3183: -- 5953806 - replaced to follow FNDLOAD standards
3184: /*if (P_OWNER = 'SEED') then
3185: f_luby := 1;
3186: else
3187: f_luby := 0;

Line 3201: -- Update record only as per standard

3197: into db_luby, db_ludate
3198: from jtf_diagnostic_kb
3199: where sequence = seq;
3200:
3201: -- Update record only as per standard
3202:
3203: -- 5953806 - replaced to if statement to follow FNDLOAD standards
3204: /*if ((p_cust_mode = 'FORCE') or
3205: ((f_luby = 0) and (db_luby = 1)) or

Line 3203: -- 5953806 - replaced to if statement to follow FNDLOAD standards

3199: where sequence = seq;
3200:
3201: -- Update record only as per standard
3202:
3203: -- 5953806 - replaced to if statement to follow FNDLOAD standards
3204: /*if ((p_cust_mode = 'FORCE') or
3205: ((f_luby = 0) and (db_luby = 1)) or
3206: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
3207: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 3349: -- Update record only as per standard

3345: into db_luby, db_ludate
3346: from jtf_diagnostic_testset
3347: where name = p_name;
3348:
3349: -- Update record only as per standard
3350:
3351: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
3352: p_cust_mode))
3353: then*/

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

3481: -- user obtained using USER_NAME
3482: cursor valid_user_apps_cursor is
3483: select distinct owner_tag from wf_roles where name in
3484: ( select role_name from wf_user_roles where user_name=sys_context('FND','USER_NAME')
3485: and role_name not in ( 'FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD','UMX|ODF_APPLICATION_END_USER_ROLE',
3486: 'UMX|ODF_APPLICATION_SUPER_USER_ROLE','UMX|ODF_DIAGNOSTICS_SUPER_USER_ROLE')
3487: and sysdate >=start_date and start_date 3488: and nvl2(expiration_date,expiration_date,sysdate+1) >= sysdate
3489: )