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.AMS_ACCESS_DENORM_PVT dependencies on FND_GLOBAL

Line 201: l_user_id NUMBER := fnd_global.user_id;

197: , p_object_id IN NUMBER
198: , p_edit_metrics IN VARCHAR2
199: )
200: IS
201: l_user_id NUMBER := fnd_global.user_id;
202: l_login_id NUMBER := fnd_global.conc_login_id;
203: l_sysdate DATE := SYSDATE;
204: BEGIN
205:

Line 202: l_login_id NUMBER := fnd_global.conc_login_id;

198: , p_edit_metrics IN VARCHAR2
199: )
200: IS
201: l_user_id NUMBER := fnd_global.user_id;
202: l_login_id NUMBER := fnd_global.conc_login_id;
203: l_sysdate DATE := SYSDATE;
204: BEGIN
205:
206: INSERT INTO ams_act_access_denorm

Line 260: l_user_id NUMBER := fnd_global.user_id;

256: , p_object_id IN NUMBER
257: , p_edit_metrics IN VARCHAR2
258: )
259: IS
260: l_user_id NUMBER := fnd_global.user_id;
261: l_login_id NUMBER := fnd_global.conc_login_id;
262: l_sysdate DATE := SYSDATE;
263:
264: CURSOR what_is_edit_metrics( c_resource_id IN NUMBER

Line 261: l_login_id NUMBER := fnd_global.conc_login_id;

257: , p_edit_metrics IN VARCHAR2
258: )
259: IS
260: l_user_id NUMBER := fnd_global.user_id;
261: l_login_id NUMBER := fnd_global.conc_login_id;
262: l_sysdate DATE := SYSDATE;
263:
264: CURSOR what_is_edit_metrics( c_resource_id IN NUMBER
265: , c_object_type IN VARCHAR2

Line 337: l_user_id NUMBER := fnd_global.user_id;

333: , p_object_id IN NUMBER
334: , p_edit_metrics IN VARCHAR2
335: )
336: IS
337: l_user_id NUMBER := fnd_global.user_id;
338: l_login_id NUMBER := fnd_global.conc_login_id;
339: l_sysdate DATE := SYSDATE;
340:
341: BEGIN

Line 338: l_login_id NUMBER := fnd_global.conc_login_id;

334: , p_edit_metrics IN VARCHAR2
335: )
336: IS
337: l_user_id NUMBER := fnd_global.user_id;
338: l_login_id NUMBER := fnd_global.conc_login_id;
339: l_sysdate DATE := SYSDATE;
340:
341: BEGIN
342:

Line 406: l_user_id NUMBER := fnd_global.user_id;

402: , p_object_id IN NUMBER
403: , p_edit_metrics IN VARCHAR2
404: )
405: IS
406: l_user_id NUMBER := fnd_global.user_id;
407: l_login_id NUMBER := fnd_global.conc_login_id;
408: l_sysdate DATE := SYSDATE;
409: BEGIN
410:

Line 407: l_login_id NUMBER := fnd_global.conc_login_id;

403: , p_edit_metrics IN VARCHAR2
404: )
405: IS
406: l_user_id NUMBER := fnd_global.user_id;
407: l_login_id NUMBER := fnd_global.conc_login_id;
408: l_sysdate DATE := SYSDATE;
409: BEGIN
410:
411: -- If the resource already exists as part of another group or as user AND

Line 483: l_user_id NUMBER := fnd_global.user_id;

479: , p_object_id IN NUMBER
480: , p_edit_metrics IN VARCHAR2
481: )
482: IS
483: l_user_id NUMBER := fnd_global.user_id;
484: l_login_id NUMBER := fnd_global.conc_login_id;
485: l_sysdate DATE := SYSDATE;
486:
487: BEGIN

Line 484: l_login_id NUMBER := fnd_global.conc_login_id;

480: , p_edit_metrics IN VARCHAR2
481: )
482: IS
483: l_user_id NUMBER := fnd_global.user_id;
484: l_login_id NUMBER := fnd_global.conc_login_id;
485: l_sysdate DATE := SYSDATE;
486:
487: BEGIN
488:

Line 595: l_user_id NUMBER := fnd_global.user_id;

591: , p_object_id IN NUMBER
592: , p_edit_metrics IN VARCHAR2
593: )
594: IS
595: l_user_id NUMBER := fnd_global.user_id;
596: l_login_id NUMBER := fnd_global.conc_login_id;
597: l_sysdate DATE := SYSDATE;
598: -- First DELETE groups
599: BEGIN

Line 596: l_login_id NUMBER := fnd_global.conc_login_id;

592: , p_edit_metrics IN VARCHAR2
593: )
594: IS
595: l_user_id NUMBER := fnd_global.user_id;
596: l_login_id NUMBER := fnd_global.conc_login_id;
597: l_sysdate DATE := SYSDATE;
598: -- First DELETE groups
599: BEGIN
600: -- Delete if resource belongs to the group that is being deleted

Line 763: , last_updated_by = fnd_global.user_id

759: -- Bulk Update for admin flag
760: FORALL i IN 1..l_tbl_object_id.COUNT
761: UPDATE ams_act_access_denorm aacd
762: SET edit_metrics_yn = 'N'
763: , last_updated_by = fnd_global.user_id
764: , last_update_date = sysdate
765: , last_update_login = fnd_global.user_id
766: WHERE object_type = l_tbl_object(i)
767: AND object_id = l_tbl_object_id(i)

Line 765: , last_update_login = fnd_global.user_id

761: UPDATE ams_act_access_denorm aacd
762: SET edit_metrics_yn = 'N'
763: , last_updated_by = fnd_global.user_id
764: , last_update_date = sysdate
765: , last_update_login = fnd_global.user_id
766: WHERE object_type = l_tbl_object(i)
767: AND object_id = l_tbl_object_id(i)
768: AND resource_id NOT IN ( SELECT jgm.resource_id
769: FROM ams_act_access aac,

Line 809: l_user_id NUMBER := fnd_global.user_id;

805: PROCEDURE bulk_all_refresh_group
806:
807: IS
808:
809: l_user_id NUMBER := fnd_global.user_id;
810: l_login_id NUMBER := fnd_global.conc_login_id;
811: l_sysdate DATE := SYSDATE;
812:
813: TYPE user_role_tbl IS TABLE OF ams_act_access.user_or_role_id%TYPE ;

Line 810: l_login_id NUMBER := fnd_global.conc_login_id;

806:
807: IS
808:
809: l_user_id NUMBER := fnd_global.user_id;
810: l_login_id NUMBER := fnd_global.conc_login_id;
811: l_sysdate DATE := SYSDATE;
812:
813: TYPE user_role_tbl IS TABLE OF ams_act_access.user_or_role_id%TYPE ;
814: TYPE object_id_tbl IS TABLE OF ams_act_access.act_access_to_object_id%TYPE ;

Line 1000: l_user_id NUMBER := fnd_global.user_id;

996: PROCEDURE bulk_insert_group (p_last_run_date IN date)
997:
998: IS
999:
1000: l_user_id NUMBER := fnd_global.user_id;
1001: l_login_id NUMBER := fnd_global.conc_login_id;
1002: l_sysdate DATE := SYSDATE;
1003:
1004: TYPE user_role_tbl IS TABLE OF ams_act_access.user_or_role_id%TYPE ;

Line 1001: l_login_id NUMBER := fnd_global.conc_login_id;

997:
998: IS
999:
1000: l_user_id NUMBER := fnd_global.user_id;
1001: l_login_id NUMBER := fnd_global.conc_login_id;
1002: l_sysdate DATE := SYSDATE;
1003:
1004: TYPE user_role_tbl IS TABLE OF ams_act_access.user_or_role_id%TYPE ;
1005: TYPE object_id_tbl IS TABLE OF ams_act_access.act_access_to_object_id%TYPE ;

Line 1114: l_user_id NUMBER := fnd_global.user_id;

1110: p_reason_code varchar2)
1111:
1112: IS
1113:
1114: l_user_id NUMBER := fnd_global.user_id;
1115: l_login_id NUMBER := fnd_global.conc_login_id;
1116: l_sysdate DATE := SYSDATE;
1117:
1118: TYPE user_role_tbl IS TABLE OF ams_act_access.user_or_role_id%TYPE ;

Line 1115: l_login_id NUMBER := fnd_global.conc_login_id;

1111:
1112: IS
1113:
1114: l_user_id NUMBER := fnd_global.user_id;
1115: l_login_id NUMBER := fnd_global.conc_login_id;
1116: l_sysdate DATE := SYSDATE;
1117:
1118: TYPE user_role_tbl IS TABLE OF ams_act_access.user_or_role_id%TYPE ;
1119: TYPE object_id_tbl IS TABLE OF ams_act_access.act_access_to_object_id%TYPE ;

Line 1260: l_user_id NUMBER := fnd_global.user_id;

1256: PROCEDURE bulk_update_group (p_last_run_date IN date)
1257:
1258: IS
1259:
1260: l_user_id NUMBER := fnd_global.user_id;
1261: l_login_id NUMBER := fnd_global.conc_login_id;
1262: l_sysdate DATE := SYSDATE;
1263:
1264: TYPE user_role_tbl IS TABLE OF ams_act_access.user_or_role_id%TYPE ;

Line 1261: l_login_id NUMBER := fnd_global.conc_login_id;

1257:
1258: IS
1259:
1260: l_user_id NUMBER := fnd_global.user_id;
1261: l_login_id NUMBER := fnd_global.conc_login_id;
1262: l_sysdate DATE := SYSDATE;
1263:
1264: TYPE user_role_tbl IS TABLE OF ams_act_access.user_or_role_id%TYPE ;
1265: TYPE object_id_tbl IS TABLE OF ams_act_access.act_access_to_object_id%TYPE ;

Line 1382: l_user_id NUMBER := fnd_global.user_id;

1378:
1379: PROCEDURE bulk_insert_resource (p_last_run_date IN date)
1380: IS
1381:
1382: l_user_id NUMBER := fnd_global.user_id;
1383: l_login_id NUMBER := fnd_global.conc_login_id;
1384: l_sysdate DATE := SYSDATE;
1385:
1386: TYPE resource_tbl IS TABLE OF jtf_rs_group_members.resource_id%TYPE ;

Line 1383: l_login_id NUMBER := fnd_global.conc_login_id;

1379: PROCEDURE bulk_insert_resource (p_last_run_date IN date)
1380: IS
1381:
1382: l_user_id NUMBER := fnd_global.user_id;
1383: l_login_id NUMBER := fnd_global.conc_login_id;
1384: l_sysdate DATE := SYSDATE;
1385:
1386: TYPE resource_tbl IS TABLE OF jtf_rs_group_members.resource_id%TYPE ;
1387: TYPE object_id_tbl IS TABLE OF ams_act_access.act_access_to_object_id%TYPE ;

Line 1513: l_user_id NUMBER := fnd_global.user_id;

1509: PROCEDURE bulk_delete_resource (p_last_run_date IN date)
1510:
1511: IS
1512:
1513: l_user_id NUMBER := fnd_global.user_id;
1514: l_login_id NUMBER := fnd_global.conc_login_id;
1515: l_sysdate DATE := SYSDATE;
1516:
1517: TYPE resource_tbl IS TABLE OF jtf_rs_group_members.resource_id%TYPE ;

Line 1514: l_login_id NUMBER := fnd_global.conc_login_id;

1510:
1511: IS
1512:
1513: l_user_id NUMBER := fnd_global.user_id;
1514: l_login_id NUMBER := fnd_global.conc_login_id;
1515: l_sysdate DATE := SYSDATE;
1516:
1517: TYPE resource_tbl IS TABLE OF jtf_rs_group_members.resource_id%TYPE ;
1518: TYPE object_id_tbl IS TABLE OF ams_act_access.act_access_to_object_id%TYPE ;

Line 1724: l_user_id NUMBER := fnd_global.user_id;

1720: AND arc_act_access_to_object = p_object_type
1721: AND arc_user_or_role_type = 'GROUP'
1722: AND delete_flag = 'N';
1723:
1724: l_user_id NUMBER := fnd_global.user_id;
1725: l_login_id NUMBER := fnd_global.conc_login_id;
1726: l_sysdate DATE := SYSDATE;
1727:
1728: BEGIN

Line 1725: l_login_id NUMBER := fnd_global.conc_login_id;

1721: AND arc_user_or_role_type = 'GROUP'
1722: AND delete_flag = 'N';
1723:
1724: l_user_id NUMBER := fnd_global.user_id;
1725: l_login_id NUMBER := fnd_global.conc_login_id;
1726: l_sysdate DATE := SYSDATE;
1727:
1728: BEGIN
1729:

Line 1801: l_user_id NUMBER := fnd_global.user_id;

1797: , retcode OUT NOCOPY VARCHAR2
1798: , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE
1799: )
1800: IS
1801: l_user_id NUMBER := fnd_global.user_id;
1802: l_login_id NUMBER := fnd_global.conc_login_id;
1803: l_sysdate DATE := SYSDATE;
1804: l_last_run_date DATE;
1805: l_program_application_id NUMBER := 530;

Line 1802: l_login_id NUMBER := fnd_global.conc_login_id;

1798: , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE
1799: )
1800: IS
1801: l_user_id NUMBER := fnd_global.user_id;
1802: l_login_id NUMBER := fnd_global.conc_login_id;
1803: l_sysdate DATE := SYSDATE;
1804: l_last_run_date DATE;
1805: l_program_application_id NUMBER := 530;
1806: l_concurrent_program_id NUMBER;

Line 1907: l_user_id NUMBER := fnd_global.user_id;

1903: PROCEDURE jtf_access_denorm ( errbuf OUT NOCOPY VARCHAR2
1904: , retcode OUT NOCOPY VARCHAR2)
1905: IS
1906:
1907: l_user_id NUMBER := fnd_global.user_id;
1908: l_login_id NUMBER := fnd_global.conc_login_id;
1909: l_sysdate DATE := sysdate;
1910: l_program_application_id NUMBER := 530;
1911: l_concurrent_program_id NUMBER;

Line 1908: l_login_id NUMBER := fnd_global.conc_login_id;

1904: , retcode OUT NOCOPY VARCHAR2)
1905: IS
1906:
1907: l_user_id NUMBER := fnd_global.user_id;
1908: l_login_id NUMBER := fnd_global.conc_login_id;
1909: l_sysdate DATE := sysdate;
1910: l_program_application_id NUMBER := 530;
1911: l_concurrent_program_id NUMBER;
1912:

Line 2075: l_user_id NUMBER := fnd_global.user_id;

2071: , retcode OUT NOCOPY VARCHAR2
2072: )
2073: IS
2074:
2075: l_user_id NUMBER := fnd_global.user_id;
2076: l_login_id NUMBER := fnd_global.conc_login_id;
2077: l_sysdate DATE := SYSDATE;
2078: l_program_application_id NUMBER := 530;
2079: l_concurrent_program_id NUMBER;

Line 2076: l_login_id NUMBER := fnd_global.conc_login_id;

2072: )
2073: IS
2074:
2075: l_user_id NUMBER := fnd_global.user_id;
2076: l_login_id NUMBER := fnd_global.conc_login_id;
2077: l_sysdate DATE := SYSDATE;
2078: l_program_application_id NUMBER := 530;
2079: l_concurrent_program_id NUMBER;
2080: