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 757: l_user_id NUMBER := fnd_global.user_id;

753: AND arc_act_access_to_object = p_object_type
754: AND arc_user_or_role_type = 'GROUP'
755: AND delete_flag = 'N';
756:
757: l_user_id NUMBER := fnd_global.user_id;
758: l_login_id NUMBER := fnd_global.conc_login_id;
759: l_sysdate DATE := SYSDATE;
760:
761: BEGIN

Line 758: l_login_id NUMBER := fnd_global.conc_login_id;

754: AND arc_user_or_role_type = 'GROUP'
755: AND delete_flag = 'N';
756:
757: l_user_id NUMBER := fnd_global.user_id;
758: l_login_id NUMBER := fnd_global.conc_login_id;
759: l_sysdate DATE := SYSDATE;
760:
761: BEGIN
762:

Line 834: l_user_id NUMBER := fnd_global.user_id;

830: , retcode OUT NOCOPY VARCHAR2
831: , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE
832: )
833: IS
834: l_user_id NUMBER := fnd_global.user_id;
835: l_login_id NUMBER := fnd_global.conc_login_id;
836: l_sysdate DATE := SYSDATE;
837: l_last_run_date DATE;
838: l_program_application_id NUMBER := 530;

Line 835: l_login_id NUMBER := fnd_global.conc_login_id;

831: , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE
832: )
833: IS
834: l_user_id NUMBER := fnd_global.user_id;
835: l_login_id NUMBER := fnd_global.conc_login_id;
836: l_sysdate DATE := SYSDATE;
837: l_last_run_date DATE;
838: l_program_application_id NUMBER := 530;
839: l_concurrent_program_id NUMBER;

Line 960: l_user_id NUMBER := fnd_global.user_id;

956: PROCEDURE jtf_access_denorm ( errbuf OUT NOCOPY VARCHAR2
957: , retcode OUT NOCOPY VARCHAR2)
958: IS
959:
960: l_user_id NUMBER := fnd_global.user_id;
961: l_login_id NUMBER := fnd_global.conc_login_id;
962: l_sysdate DATE := sysdate;
963: l_program_application_id NUMBER := 530;
964: l_concurrent_program_id NUMBER;

Line 961: l_login_id NUMBER := fnd_global.conc_login_id;

957: , retcode OUT NOCOPY VARCHAR2)
958: IS
959:
960: l_user_id NUMBER := fnd_global.user_id;
961: l_login_id NUMBER := fnd_global.conc_login_id;
962: l_sysdate DATE := sysdate;
963: l_program_application_id NUMBER := 530;
964: l_concurrent_program_id NUMBER;
965:

Line 1128: l_user_id NUMBER := fnd_global.user_id;

1124: , retcode OUT NOCOPY VARCHAR2
1125: )
1126: IS
1127:
1128: l_user_id NUMBER := fnd_global.user_id;
1129: l_login_id NUMBER := fnd_global.conc_login_id;
1130: l_sysdate DATE := SYSDATE;
1131: l_program_application_id NUMBER := 530;
1132: l_concurrent_program_id NUMBER;

Line 1129: l_login_id NUMBER := fnd_global.conc_login_id;

1125: )
1126: IS
1127:
1128: l_user_id NUMBER := fnd_global.user_id;
1129: l_login_id NUMBER := fnd_global.conc_login_id;
1130: l_sysdate DATE := SYSDATE;
1131: l_program_application_id NUMBER := 530;
1132: l_concurrent_program_id NUMBER;
1133: