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.AMW_PROCCERT_EVENT_PVT dependencies on AMW_CERT_DASHBOARD_SUM

Line 282: FROM amw_cert_dashboard_sum

278: AND organization_id = l_org_id;
279:
280: CURSOR Get_Dashboard_Info(l_cert_id number) IS
281: SELECT UNMITIGATED_RISKS, INEFFECTIVE_CONTROLS, PROC_INEFF_CONTROL, ORG_PROC_INEFF_CONTROL
282: FROM amw_cert_dashboard_sum
283: WHERE certification_id = l_cert_id;
284:
285: CURSOR Get_proc_cert_info(l_cert_id number, l_org_id number, l_process_id number) IS
286: SELECT ineffective_controls, evaluated_controls, total_controls, unmitigated_risks, evaluated_risks, total_risks

Line 440: UPDATE amw_cert_dashboard_sum

436: WHERE certification_id = proc_rec.certification_id
437: AND organization_id = l_pk3;
438: --END IF;
439: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
440: UPDATE amw_cert_dashboard_sum
441: SET last_update_date = sysdate,
442: last_updated_by = fnd_global.user_id,
443: last_update_login = fnd_global.conc_login_id,
444: proc_ineff_control = proc_ineff_control+1

Line 447: UPDATE amw_cert_dashboard_sum

443: last_update_login = fnd_global.conc_login_id,
444: proc_ineff_control = proc_ineff_control+1
445: WHERE certification_id = proc_rec.certification_id;
446: ELSE
447: UPDATE amw_cert_dashboard_sum
448: SET last_update_date = sysdate,
449: last_updated_by = fnd_global.user_id,
450: last_update_login = fnd_global.conc_login_id,
451: org_proc_ineff_control = org_proc_ineff_control+1

Line 493: UPDATE amw_cert_dashboard_sum

489: WHERE certification_id = proc_rec.certification_id
490: AND organization_id = l_pk3;
491: --END IF;
492: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
493: UPDATE amw_cert_dashboard_sum
494: SET last_update_date = sysdate,
495: last_updated_by = fnd_global.user_id,
496: last_update_login = fnd_global.conc_login_id,
497: proc_ineff_control = proc_ineff_control+1

Line 500: UPDATE amw_cert_dashboard_sum

496: last_update_login = fnd_global.conc_login_id,
497: proc_ineff_control = proc_ineff_control+1
498: WHERE certification_id = proc_rec.certification_id;
499: ELSE
500: UPDATE amw_cert_dashboard_sum
501: SET last_update_date = sysdate,
502: last_updated_by = fnd_global.user_id,
503: last_update_login = fnd_global.conc_login_id,
504: org_proc_ineff_control = org_proc_ineff_control+1

Line 536: UPDATE amw_cert_dashboard_sum

532: m_certification_list(proc_rec.certification_id) := proc_rec.certification_id;
533:
534: ELSE
535: **********/
536: UPDATE amw_cert_dashboard_sum
537: SET last_update_date = sysdate,
538: last_updated_by = fnd_global.user_id,
539: last_update_login = fnd_global.conc_login_id,
540: proc_ineff_control = greatest(0,proc_ineff_control-1)

Line 550: UPDATE amw_cert_dashboard_sum

546: IF NOT ( (m_certification_list.exists(proc_rec.certification_id)) OR (M_dashbd_org_proc_ineff_ctrl -1 > 0 ) OR (g_refresh_flag = 'Y') ) THEN
547: m_certification_list(proc_rec.certification_id) := proc_rec.certification_id;
548: ELSE
549: *******/
550: UPDATE amw_cert_dashboard_sum
551: SET last_update_date = sysdate,
552: last_updated_by = fnd_global.user_id,
553: last_update_login = fnd_global.conc_login_id,
554: org_proc_ineff_control = greatest(0,org_proc_ineff_control-1)

Line 652: UPDATE amw_cert_dashboard_sum

648: AND entity_id = PRIOR entity_id
649: AND entity_type = PRIOR entity_type);
650: --END IF;
651:
652: UPDATE amw_cert_dashboard_sum
653: SET last_update_date = sysdate,
654: last_updated_by = fnd_global.user_id,
655: last_update_login = fnd_global.conc_login_id,
656: unmitigated_risks = unmitigated_risks+1

Line 751: UPDATE amw_cert_dashboard_sum

747: AND organization_id = PRIOR organization_id
748: AND entity_id = PRIOR entity_id
749: AND entity_type = PRIOR entity_type);
750: --END IF;
751: UPDATE amw_cert_dashboard_sum
752: SET last_update_date = sysdate,
753: last_updated_by = fnd_global.user_id,
754: last_update_login = fnd_global.conc_login_id,
755: unmitigated_risks = unmitigated_risks+1

Line 816: UPDATE amw_cert_dashboard_sum

812: g_refresh_flag := 'Y';
813: m_certification_list(risk_rec.certification_id) := risk_rec.certification_id;
814: ELSE
815: ************/
816: UPDATE amw_cert_dashboard_sum
817: SET last_update_date = sysdate,
818: last_updated_by = fnd_global.user_id,
819: last_update_login = fnd_global.conc_login_id,
820: unmitigated_risks = greatest(0,unmitigated_risks-1)

Line 926: UPDATE amw_cert_dashboard_sum

922: AND organization_id = PRIOR organization_id
923: AND entity_id = PRIOR entity_id
924: AND entity_type = PRIOR entity_type);
925: --END IF;
926: UPDATE amw_cert_dashboard_sum
927: SET last_update_date = sysdate,
928: last_updated_by = fnd_global.user_id,
929: last_update_login = fnd_global.conc_login_id,
930: ineffective_controls = ineffective_controls+1

Line 1042: UPDATE amw_cert_dashboard_sum

1038: AND entity_id = PRIOR entity_id
1039: AND entity_type = PRIOR entity_type);
1040: --END IF;
1041:
1042: UPDATE amw_cert_dashboard_sum
1043: SET last_update_date = sysdate,
1044: last_updated_by = fnd_global.user_id,
1045: last_update_login = fnd_global.conc_login_id,
1046: ineffective_controls = ineffective_controls+1

Line 1114: UPDATE amw_cert_dashboard_sum

1110: g_refresh_flag := 'Y';
1111: m_certification_list(ctrl_rec.certification_id) := ctrl_rec.certification_id;
1112: ELSE
1113: *************/
1114: UPDATE amw_cert_dashboard_sum
1115: SET last_update_date = sysdate,
1116: last_updated_by = fnd_global.user_id,
1117: last_update_login = fnd_global.conc_login_id,
1118: ineffective_controls = greatest(0,ineffective_controls-1)

Line 1165: --refresh all of the summary tables amw_cert_dashboard_sum, amw_proc_cert_eval_sum, amw_org_cert_eval_sum

1161:
1162: END IF;
1163:
1164:
1165: --refresh all of the summary tables amw_cert_dashboard_sum, amw_proc_cert_eval_sum, amw_org_cert_eval_sum
1166: -- IF (G_REFRESH_FLAG = 'Y') THEN
1167: --l_index := m_certification_list.FIRST;
1168: --WHILE l_index <= m_certification_list.LAST LOOP
1169:

Line 1285: FROM amw_cert_dashboard_sum

1281:
1282:
1283: CURSOR Get_Dashboard_Info(l_cert_id number) IS
1284: SELECT orgs_pending_certification, processes_cert_issues, processes_not_cert, org_process_cert_issues, org_process_not_cert
1285: FROM amw_cert_dashboard_sum
1286: WHERE certification_id = l_cert_id;
1287:
1288: CURSOR Get_cert_dashboard(l_cert_id number) IS
1289: SELECT processes_not_cert, org_process_not_cert, processes_cert_issues, org_process_cert_issues

Line 1290: FROM amw_cert_dashboard_sum

1286: WHERE certification_id = l_cert_id;
1287:
1288: CURSOR Get_cert_dashboard(l_cert_id number) IS
1289: SELECT processes_not_cert, org_process_not_cert, processes_cert_issues, org_process_cert_issues
1290: FROM amw_cert_dashboard_sum
1291: WHERE certification_id = l_cert_id;
1292:
1293: CURSOR c_org_cert(l_cert_id number, l_org_id number) IS
1294: SELECT processes_certified, total_processes, proc_cert_issues

Line 1431: UPDATE amw_cert_dashboard_sum

1427: m_certification_list(l_pk2) := l_pk2;
1428: goto refresh_all_records;
1429: ELSE
1430: *************/
1431: UPDATE amw_cert_dashboard_sum
1432: SET last_update_date = sysdate,
1433: last_updated_by = fnd_global.user_id,
1434: last_update_login = fnd_global.conc_login_id,
1435: orgs_pending_certification = greatest(0,orgs_pending_certification-1)

Line 1596: UPDATE amw_cert_dashboard_sum

1592: m_certification_list(l_pk2) := l_pk2;
1593: goto refresh_all_records;
1594: ELSE
1595: *************/
1596: UPDATE amw_cert_dashboard_sum
1597: SET last_update_date = sysdate,
1598: last_updated_by = fnd_global.user_id,
1599: last_update_login = fnd_global.conc_login_id,
1600: orgs_pending_in_scope = l_orgs_pending,

Line 1615: UPDATE amw_cert_dashboard_sum

1611: m_certification_list(l_pk2) := l_pk2;
1612: goto refresh_all_records;
1613: ELSE
1614: ********/
1615: UPDATE amw_cert_dashboard_sum
1616: SET last_update_date = sysdate,
1617: last_updated_by = fnd_global.user_id,
1618: last_update_login = fnd_global.conc_login_id,
1619: orgs_pending_in_scope = l_orgs_pending,

Line 1647: UPDATE amw_cert_dashboard_sum

1643: AND organization_id = l_pk3;
1644: --END IF;
1645:
1646: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1647: UPDATE amw_cert_dashboard_sum
1648: SET last_update_date = sysdate,
1649: last_updated_by = fnd_global.user_id,
1650: last_update_login = fnd_global.conc_login_id,
1651: orgs_pending_in_scope = l_orgs_pending,

Line 1657: UPDATE amw_cert_dashboard_sum

1653: processes_cert_issues = processes_cert_issues+1
1654: WHERE certification_id = l_pk2;
1655: ELSE
1656:
1657: UPDATE amw_cert_dashboard_sum
1658: SET last_update_date = sysdate,
1659: last_updated_by = fnd_global.user_id,
1660: last_update_login = fnd_global.conc_login_id,
1661: orgs_pending_in_scope = l_orgs_pending,

Line 1697: UPDATE amw_cert_dashboard_sum

1693: m_certification_list(l_pk2) := l_pk2;
1694: goto refresh_all_records;
1695: ELSE
1696: *************/
1697: UPDATE amw_cert_dashboard_sum
1698: SET last_update_date = sysdate,
1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.conc_login_id,
1701: orgs_pending_in_scope = l_orgs_pending,

Line 1715: UPDATE amw_cert_dashboard_sum

1711: m_certification_list(l_pk2) := l_pk2;
1712: goto refresh_all_records;
1713: ELSE
1714: **************/
1715: UPDATE amw_cert_dashboard_sum
1716: SET last_update_date = sysdate,
1717: last_updated_by = fnd_global.user_id,
1718: last_update_login = fnd_global.conc_login_id,
1719: orgs_pending_in_scope = l_orgs_pending,

Line 1745: UPDATE amw_cert_dashboard_sum

1741: AND organization_id = l_pk3;
1742: --END IF;
1743:
1744: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1745: UPDATE amw_cert_dashboard_sum
1746: SET last_update_date = sysdate,
1747: last_updated_by = fnd_global.user_id,
1748: last_update_login = fnd_global.conc_login_id,
1749: orgs_pending_in_scope = l_orgs_pending,

Line 1753: UPDATE amw_cert_dashboard_sum

1749: orgs_pending_in_scope = l_orgs_pending,
1750: processes_cert_issues = processes_cert_issues+1
1751: WHERE certification_id = l_pk2;
1752: ELSE
1753: UPDATE amw_cert_dashboard_sum
1754: SET last_update_date = sysdate,
1755: last_updated_by = fnd_global.user_id,
1756: last_update_login = fnd_global.conc_login_id,
1757: orgs_pending_in_scope = l_orgs_pending,

Line 1944: --refresh all of the summary tables amw_cert_dashboard_sum, amw_proc_cert_eval_sum, amw_org_cert_eval_sum

1940:
1941: END IF;
1942:
1943: <>
1944: --refresh all of the summary tables amw_cert_dashboard_sum, amw_proc_cert_eval_sum, amw_org_cert_eval_sum
1945: --IF ((G_REFRESH_FLAG = 'Y') or (G_REFRESH_FLAG = 'y') ) THEN
1946: --l_index := m_certification_list.FIRST;
1947: --WHILE l_index <= m_certification_list.LAST LOOP
1948: