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 1819: -- 5953806 - replaced to follow FNDLOAD standards

1815:
1816: BEGIN
1817:
1818: -- Translate owner to file_last_updated_by
1819: -- 5953806 - replaced to follow FNDLOAD standards
1820: /*if (P_OWNER = 'SEED') then
1821: f_luby := 1;
1822: else
1823: f_luby := 0;

Line 1837: -- Update record only as per standard

1833: into db_luby, db_ludate
1834: from jtf_diagnostic_app
1835: where appid = p_appid;
1836:
1837: -- Update record only as per standard
1838:
1839: -- 5953806 - replaced to if statement to follow FNDLOAD standards
1840: /*if ((p_cust_mode = 'FORCE') or
1841: ((f_luby = 0) and (db_luby = 1)) or

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

1835: where appid = p_appid;
1836:
1837: -- Update record only as per standard
1838:
1839: -- 5953806 - replaced to if statement to follow FNDLOAD standards
1840: /*if ((p_cust_mode = 'FORCE') or
1841: ((f_luby = 0) and (db_luby = 1)) or
1842: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
1843: /* if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

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

1910: v_sensitivity := to_number(nvl(P_SENSITIVITY, '1'));
1911:
1912: -- Translate owner to file_last_updated_by
1913:
1914: -- 5953806 - replaced to follow FNDLOAD standards
1915: /*if (P_OWNER = 'SEED') then
1916: f_luby := 1;
1917: else
1918: f_luby := 0;

Line 1933: -- Update record only as per standard

1929: from jtf_diagnostic_group
1930: where appid = p_appid and
1931: groupname = p_groupname;
1932:
1933: -- Update record only as per standard
1934:
1935: -- 5953806 - replaced to if statement to follow FNDLOAD standards
1936: /*if ((p_cust_mode = 'FORCE') or
1937: ((f_luby = 0) and (db_luby = 1)) or

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

1931: groupname = p_groupname;
1932:
1933: -- Update record only as per standard
1934:
1935: -- 5953806 - replaced to if statement to follow FNDLOAD standards
1936: /*if ((p_cust_mode = 'FORCE') or
1937: ((f_luby = 0) and (db_luby = 1)) or
1938: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
1939: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

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

2041: BEGIN
2042:
2043: -- Translate owner to file_last_updated_by
2044:
2045: -- 5953806 - replaced to follow FNDLOAD standards
2046: /*if (P_OWNER = 'SEED') then
2047: f_luby := 1;
2048: else
2049: f_luby := 0;

Line 2072: -- Update record only as per standard

2068: where appid = p_appid and
2069: groupname = p_groupname
2070: and testclassname = p_testclassname;
2071:
2072: -- Update record only as per standard
2073:
2074: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2075: /*if ((p_cust_mode = 'FORCE') or
2076: ((f_luby = 0) and (db_luby = 1)) or

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

2070: and testclassname = p_testclassname;
2071:
2072: -- Update record only as per standard
2073:
2074: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2075: /*if ((p_cust_mode = 'FORCE') or
2076: ((f_luby = 0) and (db_luby = 1)) or
2077: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2078: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

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

2260: BEGIN
2261:
2262: -- Translate owner to file_last_updated_by
2263:
2264: -- 5953806 - replaced to follow FNDLOAD standards
2265: /*if (P_OWNER = 'SEED') then
2266: f_luby := 1;
2267: else
2268: f_luby := 0;

Line 2286: -- Update record only as per standard

2282: and testclassname = p_testclassname
2283: and argname = p_argname
2284: and rownumber = p_rownumber;
2285:
2286: -- Update record only as per standard
2287:
2288: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2289: /*if ((p_cust_mode = 'FORCE') or
2290: ((f_luby = 0) and (db_luby = 1)) or

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

2284: and rownumber = p_rownumber;
2285:
2286: -- Update record only as per standard
2287:
2288: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2289: /*if ((p_cust_mode = 'FORCE') or
2290: ((f_luby = 0) and (db_luby = 1)) or
2291: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2292: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

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

2374:
2375: BEGIN
2376:
2377: -- Translate owner to file_last_updated_by
2378: -- 5953806 - replaced to follow FNDLOAD standards
2379: /*if (P_OWNER = 'SEED') then
2380: f_luby := 1;
2381: else
2382: f_luby := 0;

Line 2399: -- Update record only as per standard

2395: and prereqid = p_prereqid
2396: and SOURCEAPPID = p_SOURCEAPPID
2397: and type = p_type;
2398:
2399: -- Update record only as per standard
2400:
2401: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2402: /*if ((p_cust_mode = 'FORCE') or
2403: ((f_luby = 0) and (db_luby = 1)) or

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

2397: and type = p_type;
2398:
2399: -- Update record only as per standard
2400:
2401: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2402: /*if ((p_cust_mode = 'FORCE') or
2403: ((f_luby = 0) and (db_luby = 1)) or
2404: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2405: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

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

2491: BEGIN
2492:
2493: -- Translate owner to file_last_updated_by
2494:
2495: -- 5953806 - replaced to follow FNDLOAD standards
2496: /*if (P_OWNER = 'SEED') then
2497: f_luby := 1;
2498: else
2499: f_luby := 0;

Line 2516: -- Update record only as per standard

2512: and GROUPNAME = P_GROUPNAME
2513: and TESTCLASSNAME = P_TESTCLASSNAME
2514: and TESTSTEPNAME = P_TESTSTEPNAME;
2515:
2516: -- Update record only as per standard
2517:
2518: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2519: /*if ((p_cust_mode = 'FORCE') or
2520: ((f_luby = 0) and (db_luby = 1)) or

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

2514: and TESTSTEPNAME = P_TESTSTEPNAME;
2515:
2516: -- Update record only as per standard
2517:
2518: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2519: /*if ((p_cust_mode = 'FORCE') or
2520: ((f_luby = 0) and (db_luby = 1)) or
2521: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2522: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

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

2649: BEGIN
2650:
2651: -- Translate owner to file_last_updated_by
2652:
2653: -- 5953806 - replaced to follow FNDLOAD standards
2654: /*if (P_OWNER = 'SEED') then
2655: f_luby := 1;
2656: else
2657: f_luby := 0;

Line 2675: -- Update record only as per standard

2671: and TESTCLASSNAME = P_TESTCLASSNAME
2672: and TESTSTEPNAME = P_TESTSTEPNAME
2673: and COLUMN_NAME = P_COLUMN_NAME;
2674:
2675: -- Update record only as per standard
2676:
2677: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2678: /*if ((p_cust_mode = 'FORCE') or
2679: ((f_luby = 0) and (db_luby = 1)) or

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

2673: and COLUMN_NAME = P_COLUMN_NAME;
2674:
2675: -- Update record only as per standard
2676:
2677: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2678: /*if ((p_cust_mode = 'FORCE') or
2679: ((f_luby = 0) and (db_luby = 1)) or
2680: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2681: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

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

2766: BEGIN
2767:
2768: -- Translate owner to file_last_updated_by
2769:
2770: -- 5953806 - replaced to follow FNDLOAD standards
2771: /*if (P_OWNER = 'SEED') then
2772: f_luby := 1;
2773: else
2774: f_luby := 0;

Line 2791: -- Update record only as per standard

2787: groupname = p_groupname
2788: and testclassname = p_testclassname
2789: and type = p_type;
2790:
2791: -- Update record only as per standard
2792:
2793: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2794: /*if ((p_cust_mode = 'FORCE') or
2795: ((f_luby = 0) and (db_luby = 1)) or

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

2789: and type = p_type;
2790:
2791: -- Update record only as per standard
2792:
2793: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2794: /*if ((p_cust_mode = 'FORCE') or
2795: ((f_luby = 0) and (db_luby = 1)) or
2796: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2797: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

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

2899: end;
2900:
2901: -- Translate owner to file_last_updated_by
2902:
2903: -- 5953806 - replaced to follow FNDLOAD standards
2904: /*if (P_OWNER = 'SEED') then
2905: f_luby := 1;
2906: else
2907: f_luby := 0;

Line 2921: -- Update record only as per standard

2917: into db_luby, db_ludate
2918: from jtf_diagnostic_kb
2919: where sequence = seq;
2920:
2921: -- Update record only as per standard
2922:
2923: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2924: /*if ((p_cust_mode = 'FORCE') or
2925: ((f_luby = 0) and (db_luby = 1)) or

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

2919: where sequence = seq;
2920:
2921: -- Update record only as per standard
2922:
2923: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2924: /*if ((p_cust_mode = 'FORCE') or
2925: ((f_luby = 0) and (db_luby = 1)) or
2926: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2927: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 3069: -- Update record only as per standard

3065: into db_luby, db_ludate
3066: from jtf_diagnostic_testset
3067: where name = p_name;
3068:
3069: -- Update record only as per standard
3070:
3071: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
3072: p_cust_mode))
3073: 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: )