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 AMS_ACT_ACCESS_DENORM

Line 206: INSERT INTO ams_act_access_denorm

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
207: ( access_denorm_id
208: , resource_id
209: , edit_metrics_yn
210: , object_type

Line 219: SELECT ams_act_access_denorm_s.nextval

215: , last_update_date
216: , last_updated_by
217: , last_update_login
218: )
219: SELECT ams_act_access_denorm_s.nextval
220: , p_resource_id
221: , p_edit_metrics
222: , p_object_type
223: , p_object_id

Line 232: FROM ams_act_access_denorm

228: , l_user_id
229: , l_login_id
230: FROM dual
231: WHERE NOT EXISTS ( SELECT 1
232: FROM ams_act_access_denorm
233: WHERE resource_id = p_resource_id
234: AND object_type = p_object_type
235: AND object_id = p_object_id
236: );

Line 240: UPDATE ams_act_access_denorm

236: );
237:
238: IF SQL%NOTFOUND THEN
239: IF p_edit_metrics = 'Y' THEN
240: UPDATE ams_act_access_denorm
241: SET edit_metrics_yn = p_edit_metrics,
242: last_updated_by = l_user_id,
243: last_update_date = l_sysdate,
244: last_update_login = l_login_id

Line 270: FROM ams_act_access_denorm

266: , c_object_id IN NUMBER
267: )
268: IS
269: SELECT edit_metrics_yn
270: FROM ams_act_access_denorm
271: WHERE object_type = p_object_type
272: AND object_id = p_object_id
273: AND resource_id = p_resource_id;
274:

Line 281: UPDATE ams_act_access_denorm

277: BEGIN
278:
279: IF p_edit_metrics = 'Y' THEN
280:
281: UPDATE ams_act_access_denorm
282: SET edit_metrics_yn = p_edit_metrics
283: , last_updated_by = l_user_id
284: , last_update_date = l_sysdate
285: , last_update_login = l_login_id

Line 301: UPDATE ams_act_access_denorm aacd

297: CLOSE what_is_edit_metrics;
298:
299: IF l_edit_metrics <> 'N' THEN
300:
301: UPDATE ams_act_access_denorm aacd
302: SET edit_metrics_yn = p_edit_metrics
303: , last_updated_by = l_user_id
304: , last_update_date = l_sysdate
305: , last_update_login = l_login_id

Line 343: DELETE FROM AMS_ACT_ACCESS_DENORM aacd

339: l_sysdate DATE := SYSDATE;
340:
341: BEGIN
342:
343: DELETE FROM AMS_ACT_ACCESS_DENORM aacd
344: WHERE resource_id = p_resource_id
345: AND object_type = p_object_type
346: AND object_id = p_object_id
347: AND not exists ( SELECT 1

Line 372: UPDATE ams_act_access_denorm aacd

368: );
369:
370:
371: IF p_edit_metrics = 'Y' THEN
372: UPDATE ams_act_access_denorm aacd
373: SET edit_metrics_yn = 'N'
374: , last_updated_by = l_user_id
375: , last_update_date = l_sysdate
376: , last_update_login = l_login_id

Line 415: UPDATE ams_act_access_denorm aacd

411: -- If the resource already exists as part of another group or as user AND
412: -- if that group or user's edit metrics is 'N', update to 'Y'.
413:
414: IF p_edit_metrics = 'Y' THEN
415: UPDATE ams_act_access_denorm aacd
416: SET edit_metrics_yn = p_edit_metrics
417: , last_updated_by = l_user_id
418: , last_update_date = l_sysdate
419: , last_update_login = l_login_id

Line 435: INSERT INTO ams_act_access_denorm

431: AND edit_metrics_yn = 'N' ;
432: END IF;
433:
434: -- insert if a resource in a group doesnot exist in the denorm
435: INSERT INTO ams_act_access_denorm
436: ( access_denorm_id
437: , resource_id
438: , edit_metrics_yn
439: , object_type

Line 448: SELECT ams_act_access_denorm_s.nextval

444: , last_update_date
445: , last_updated_by
446: , last_update_login
447: )
448: SELECT ams_act_access_denorm_s.nextval
449: , resource_id
450: , p_edit_metrics
451: , p_object_type
452: , p_object_id

Line 469: FROM ams_act_access_denorm

465: AND jgd.start_date_active <= TRUNC(SYSDATE)
466: AND NVL(jgd.end_date_active,TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
467: AND jgm.delete_flag='N'
468: AND NOT EXISTS ( SELECT 1
469: FROM ams_act_access_denorm
470: WHERE resource_id = jgm.resource_id
471: AND object_type = p_object_type
472: AND object_id = p_object_id)
473: );

Line 490: UPDATE ams_act_access_denorm aacd

486:
487: BEGIN
488:
489: IF p_edit_metrics = 'Y' THEN
490: UPDATE ams_act_access_denorm aacd
491: SET edit_metrics_yn = p_edit_metrics
492: , last_updated_by = l_user_id
493: , last_update_date = l_sysdate
494: , last_update_login = l_login_id

Line 520: UPDATE ams_act_access_denorm aacd

516: -- update entries if the resource is part of the group heirarchy
517: -- AND the resource is not part of a group which has edit metrics as 'Y'
518: -- added by VMODUR 13-MAR-2003
519: -- The Owner may be part of the above groups and should not be updated
520: UPDATE ams_act_access_denorm aacd
521: SET edit_metrics_yn = p_edit_metrics
522: , last_updated_by = l_user_id
523: , last_update_date = l_sysdate
524: , last_update_login = l_login_id

Line 603: DELETE FROM ams_act_access_denorm aacd

599: BEGIN
600: -- Delete if resource belongs to the group that is being deleted
601: -- AND it does not exist as part of any other group
602: -- or exist as 'USER' FOR the object.
603: DELETE FROM ams_act_access_denorm aacd
604: WHERE object_type = p_object_type
605: AND object_id = p_object_id
606: AND resource_id IN ( SELECT jgm.resource_id
607: FROM jtf_rs_groups_denorm jgd,

Line 644: UPDATE ams_act_access_denorm aacd

640: -- then we have to evaluate if resource belongs to another group but with edit_metrics_yn
641:
642: IF p_edit_metrics = 'Y' THEN
643:
644: UPDATE ams_act_access_denorm aacd
645: SET edit_metrics_yn = 'N'
646: , last_updated_by = l_user_id
647: , last_update_date = l_sysdate
648: , last_update_login = l_login_id

Line 705: DELETE FROM ams_act_access_denorm aacd

701: -- delete the resources in the denorm table which are end-dated,
702: -- or no longer present in the group.
703: -- this deleted resource should not be part of any other active group or the user of
704: -- the object.
705: DELETE FROM ams_act_access_denorm aacd
706: WHERE aacd.object_type = p_object_type
707: AND aacd.object_id = p_object_id
708: AND NOT EXISTS ( SELECT 1 --anchaudh 21-MAR-03
709: FROM jtf_rs_groups_denorm jgd,

Line 763: DELETE FROM ams_act_access_denorm aacd

759: l_sysdate DATE := SYSDATE;
760:
761: BEGIN
762:
763: DELETE FROM ams_act_access_denorm aacd
764: WHERE aacd.object_type = p_object_type
765: AND aacd.object_id = p_object_id;
766:
767: INSERT INTO ams_act_access_denorm

Line 767: INSERT INTO ams_act_access_denorm

763: DELETE FROM ams_act_access_denorm aacd
764: WHERE aacd.object_type = p_object_type
765: AND aacd.object_id = p_object_id;
766:
767: INSERT INTO ams_act_access_denorm
768: (
769: access_denorm_id
770: , resource_id
771: , edit_metrics_yn

Line 781: SELECT ams_act_access_denorm_s.nextval

777: , last_update_date
778: , last_updated_by
779: , last_update_login
780: )
781: SELECT ams_act_access_denorm_s.nextval
782: ,user_or_role_id
783: ,admin_flag
784: ,arc_act_access_to_object
785: ,act_access_to_object_id

Line 823: populates the resources in that group in the ams_act_access_denorm table.

819:
820: /*
821: Modified to include an additional parameter to run in full mode.
822: This concurrent program picks the groups associated with the object, and
823: populates the resources in that group in the ams_act_access_denorm table.
824: By default, it will pick only the groups which are modified after the most recent
825: previous run date of conc. program.
826: However, user can choose to run it in full mode, in which it will refresh every group
827: from the object.

Line 886: FROM ams_act_access_denorm;

882: -- could be even changed while a new object is created.
883: /*
884: CURSOR cur_get_latest_run_date IS
885: SELECT max(last_update_date)
886: FROM ams_act_access_denorm;
887: */
888: BEGIN
889:
890: OPEN cur_get_conc_program_id;

Line 1034: FROM ams_act_access_denorm;

1030:
1031: -- Used only once i.e the first time ever this concurrent program is run
1032: CURSOR cur_get_latest_run_date IS
1033: SELECT MAX(last_update_date)
1034: FROM ams_act_access_denorm;
1035:
1036: l_last_run_date date;
1037:
1038: BEGIN

Line 1358: FROM ams_act_access_denorm;

1354: -- Used only once i.e the first time ever this concurrent program is run
1355: -- Use the minimum last_update_date
1356: CURSOR cur_get_latest_run_date IS
1357: SELECT MIN(last_update_date)
1358: FROM ams_act_access_denorm;
1359: l_last_run_date DATE;
1360:
1361: BEGIN
1362: