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.

[Home] [Help]

APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_ORG_CERT_EVAL_SUM

Line 96: FROM amw_org_cert_eval_sum

92: ) return VARCHAR2
93: IS
94: CURSOR c_new_org(c_cert_id NUMBER) IS
95: SELECT organization_id
96: FROM amw_org_cert_eval_sum
97: WHERE certification_id = c_cert_id
98: AND unmitigated_risks IS NULL;
99:
100: CURSOR c_new_proc(c_cert_id NUMBER) IS

Line 149: AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_sum_spec (

145:
146: IF l_mode = 'AddToScope' THEN
147: -- to support org hierarchy, need to update the org denorm
148: -- for all the orgs in the certification
149: AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_sum_spec (
150: p_certification_id => l_cert_id);
151:
152: -- do not need to update the prcess denorm for the existing
153: -- org.

Line 167: AMW_ORG_CERT_EVAL_SUM_PVT.populate_summary (

163: ELSIF l_mode = 'ManageProc' THEN
164: l_org_id := p_event.GetValueForParameter('ORGANIZATION_ID');
165: -- only update the passed org, as there is no impact
166: -- on other orgs in the org hierarchy.
167: AMW_ORG_CERT_EVAL_SUM_PVT.populate_summary (
168: p_api_version_number => 1.0,
169: p_org_id => l_org_id,
170: p_certification_id => l_cert_id,
171: x_return_status => l_return_status,

Line 189: AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_sum_spec (

185:
186: ELSIF l_mode = 'RemoveFromScope' THEN
187: -- to support org hierarchy, need to update the org denorm
188: -- for all the orgs in the certification
189: AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_sum_spec (
190: p_certification_id => l_cert_id);
191: END IF;
192:
193: OPEN c_start_date(l_cert_id);

Line 276: FROM amw_org_cert_eval_sum

272:
273: CURSOR Get_org_cert(l_cert_id number, l_org_id number) IS
274: SELECT ineff_processes, processes_certified, total_processes, evaluated_processes,unmitigated_risks,
275: evaluated_risks, total_risks, ineffective_controls, evaluated_controls, total_controls
276: FROM amw_org_cert_eval_sum
277: WHERE certification_id = l_cert_id
278: AND organization_id = l_org_id;
279:
280: CURSOR Get_Dashboard_Info(l_cert_id number) IS

Line 304: FROM amw_org_cert_eval_sum

300: AND entity_type = PRIOR entity_type);
301:
302: CURSOR FCH_Get_cert_info(l_org_id number) IS
303: SELECT certification_id
304: FROM amw_org_cert_eval_sum
305: WHERE organization_id = l_org_id
306: AND certification_id IN (
307: SELECT cert.certification_id
308: FROM amw_certification_b cert

Line 383: -- update amw_org_cert_eval_sum.evaluation_opinion_log_id

379: CLOSE c_opinion_rec;
380:
381: IF l_obj_name = 'AMW_ORGANIZATION' THEN
382: -- find all the active proc cert that having this org
383: -- update amw_org_cert_eval_sum.evaluation_opinion_log_id
384: UPDATE amw_org_cert_eval_sum
385: SET last_update_date = sysdate,
386: last_updated_by = fnd_global.user_id,
387: last_update_login = fnd_global.conc_login_id,

Line 384: UPDATE amw_org_cert_eval_sum

380:
381: IF l_obj_name = 'AMW_ORGANIZATION' THEN
382: -- find all the active proc cert that having this org
383: -- update amw_org_cert_eval_sum.evaluation_opinion_log_id
384: UPDATE amw_org_cert_eval_sum
385: SET last_update_date = sysdate,
386: last_updated_by = fnd_global.user_id,
387: last_update_login = fnd_global.conc_login_id,
388: evaluation_opinion_id = l_opin_id,

Line 428: UPDATE amw_org_cert_eval_sum

424: g_refresh_flag := 'Y';
425: m_certification_list(proc_rec.certification_id) := proc_rec.certification_id;
426: ELSE
427: *****/
428: UPDATE amw_org_cert_eval_sum
429: SET last_update_date = sysdate,
430: last_updated_by = fnd_global.user_id,
431: last_update_login = fnd_global.conc_login_id,
432: evaluated_processes = least(evaluated_processes+1,total_processes),

Line 464: UPDATE amw_org_cert_eval_sum

460: G_REFRESH_FLAG := 'Y';
461: m_certification_list(proc_rec.certification_id) := proc_rec.certification_id;
462: ELSE
463: *********/
464: UPDATE amw_org_cert_eval_sum
465: SET last_update_date = sysdate,
466: last_updated_by = fnd_global.user_id,
467: last_update_login = fnd_global.conc_login_id,
468: evaluated_processes = least(evaluated_processes+1, total_processes)

Line 482: UPDATE amw_org_cert_eval_sum

478: g_refresh_flag := 'Y';
479: m_certification_list(proc_rec.certification_id) := proc_rec.certification_id;
480: ELSE
481: *****/
482: UPDATE amw_org_cert_eval_sum
483: SET last_update_date = sysdate,
484: last_updated_by = fnd_global.user_id,
485: last_update_login = fnd_global.conc_login_id,
486: ineff_processes = least(ineff_processes+1,evaluated_processes,total_processes),

Line 517: UPDATE amw_org_cert_eval_sum

513: G_REFRESH_FLAG := 'Y';
514: m_certification_list(proc_rec.certification_id) := proc_rec.certification_id;
515: ELSE
516: *************/
517: UPDATE amw_org_cert_eval_sum
518: SET last_update_date = sysdate,
519: last_updated_by = fnd_global.user_id,
520: last_update_login = fnd_global.conc_login_id,
521: ineff_processes = greatest(0,ineff_processes-1),

Line 609: UPDATE amw_org_cert_eval_sum

605: g_refresh_flag := 'Y';
606: m_certification_list(risk_rec.certification_id) := risk_rec.certification_id;
607: ELSE
608: ***********/
609: UPDATE amw_org_cert_eval_sum
610: SET last_update_date = sysdate,
611: last_updated_by = fnd_global.user_id,
612: last_update_login = fnd_global.conc_login_id,
613: evaluated_risks = least(evaluated_risks+1,total_risks),

Line 668: UPDATE amw_org_cert_eval_sum

664: g_refresh_flag := 'Y';
665: m_certification_list(risk_rec.certification_id) := risk_rec.certification_id;
666: ELSE
667: ****/
668: UPDATE amw_org_cert_eval_sum
669: SET last_update_date = sysdate,
670: last_updated_by = fnd_global.user_id,
671: last_update_login = fnd_global.conc_login_id,
672: evaluated_risks = least(evaluated_risks+1,total_risks)

Line 711: UPDATE amw_org_cert_eval_sum

707: g_refresh_flag := 'Y';
708: m_certification_list(risk_rec.certification_id) := risk_rec.certification_id;
709: ELSE
710: *************/
711: UPDATE amw_org_cert_eval_sum
712: SET last_update_date = sysdate,
713: last_updated_by = fnd_global.user_id,
714: last_update_login = fnd_global.conc_login_id,
715: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks,total_risks),

Line 767: UPDATE amw_org_cert_eval_sum

763: g_refresh_flag := 'Y';
764: m_certification_list(risk_rec.certification_id) := risk_rec.certification_id;
765: ELSE
766: ******************/
767: UPDATE amw_org_cert_eval_sum
768: SET last_update_date = sysdate,
769: last_updated_by = fnd_global.user_id,
770: last_update_login = fnd_global.conc_login_id,
771: unmitigated_risks = greatest(0,unmitigated_risks-1),

Line 878: UPDATE amw_org_cert_eval_sum

874: g_refresh_flag := 'Y';
875: m_certification_list(ctrl_rec.certification_id) := ctrl_rec.certification_id;
876: ELSE
877: **********/
878: UPDATE amw_org_cert_eval_sum
879: SET last_update_date = sysdate,
880: last_updated_by = fnd_global.user_id,
881: last_update_login = fnd_global.conc_login_id,
882: evaluated_controls = least(evaluated_controls+1,total_controls),

Line 942: UPDATE amw_org_cert_eval_sum

938: g_refresh_flag := 'Y';
939: m_certification_list(ctrl_rec.certification_id) := ctrl_rec.certification_id;
940: ELSE
941: ***********/
942: UPDATE amw_org_cert_eval_sum
943: SET last_update_date = sysdate,
944: last_updated_by = fnd_global.user_id,
945: last_update_login = fnd_global.conc_login_id,
946: evaluated_controls = least(evaluated_controls+1,total_controls)

Line 995: UPDATE amw_org_cert_eval_sum

991: g_refresh_flag := 'Y';
992: m_certification_list(ctrl_rec.certification_id) := ctrl_rec.certification_id;
993: ELSE
994: *********/
995: UPDATE amw_org_cert_eval_sum
996: SET last_update_date = sysdate,
997: last_updated_by = fnd_global.user_id,
998: last_update_login = fnd_global.conc_login_id,
999: ineffective_controls = least(ineffective_controls+1,evaluated_controls,total_controls),

Line 1058: UPDATE amw_org_cert_eval_sum

1054: g_refresh_flag := 'Y';
1055: m_certification_list(ctrl_rec.certification_id) := ctrl_rec.certification_id;
1056: ELSE
1057: ***********/
1058: UPDATE amw_org_cert_eval_sum
1059: SET last_update_date = sysdate,
1060: last_updated_by = fnd_global.user_id,
1061: last_update_login = fnd_global.conc_login_id,
1062: 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 1182: --AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_summary

1178: -- retcode => l_msg_count,
1179: -- p_certification_id => m_certification_list(l_index)
1180: --);
1181:
1182: --AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_summary
1183: --(x_errbuf => l_msg_data,
1184: -- x_retcode => l_msg_count,
1185: -- p_certification_id => m_certification_list(l_index)
1186: --);

Line 1266: FROM amw_org_cert_eval_sum

1262: AND aov.pk1_value = aes.process_id);
1263:
1264: CURSOR Get_org_cert(l_cert_id number, l_org_id number) IS
1265: SELECT organization_id, sub_org_cert, total_sub_org , sub_org_cert_issues, proc_cert_issues, processes_certified, total_processes
1266: FROM amw_org_cert_eval_sum
1267: WHERE certification_id = l_cert_id
1268: AND organization_id IN (
1269: SELECT parent_object_id
1270: FROM amw_entity_hierarchies

Line 1295: FROM amw_org_cert_eval_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
1295: FROM amw_org_cert_eval_sum
1296: WHERE certification_id = l_cert_id
1297: AND organization_id = l_org_id;
1298:
1299:

Line 1408: UPDATE amw_org_cert_eval_sum

1404: OPEN c_old_opinion(l_opin_log_id);
1405: FETCH c_old_opinion INTO l_old_cert;
1406: CLOSE c_old_opinion;
1407:
1408: UPDATE amw_org_cert_eval_sum
1409: SET last_update_date = sysdate,
1410: last_updated_by = fnd_global.user_id,
1411: last_update_login = fnd_global.conc_login_id,
1412: certification_opinion_id = l_opin_id

Line 1456: UPDATE amw_org_cert_eval_sum

1452: m_certification_list(l_pk2) := l_pk2;
1453: goto refresh_all_records;
1454: ELSE
1455: ************/
1456: UPDATE amw_org_cert_eval_sum
1457: SET last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.conc_login_id,
1460: sub_org_cert = least(sub_org_cert+1,total_sub_org)

Line 1475: UPDATE amw_org_cert_eval_sum

1471: m_certification_list(l_pk2) := l_pk2;
1472: goto refresh_all_records;
1473: ELSE
1474: ***********/
1475: UPDATE amw_org_cert_eval_sum
1476: SET last_update_date = sysdate,
1477: last_updated_by = fnd_global.user_id,
1478: last_update_login = fnd_global.conc_login_id,
1479: sub_org_cert = least(sub_org_cert+1,total_sub_org),

Line 1495: UPDATE amw_org_cert_eval_sum

1491: m_certification_list(l_pk2) := l_pk2;
1492: goto refresh_all_records;
1493: ELSE
1494: ***********/
1495: UPDATE amw_org_cert_eval_sum
1496: SET last_update_date = sysdate,
1497: last_updated_by = fnd_global.user_id,
1498: last_update_login = fnd_global.conc_login_id,
1499: sub_org_cert_issues = least(sub_org_cert_issues+1,sub_org_cert,total_sub_org)

Line 1514: UPDATE amw_org_cert_eval_sum

1510: m_certification_list( l_pk2) := l_pk2;
1511: goto refresh_all_records;
1512: ELSE
1513: ************/
1514: UPDATE amw_org_cert_eval_sum
1515: SET last_update_date = sysdate,
1516: last_updated_by = fnd_global.user_id,
1517: last_update_login = fnd_global.conc_login_id,
1518: sub_org_cert_issues = greatest(0,sub_org_cert_issues-1)

Line 1576: UPDATE amw_org_cert_eval_sum

1572: m_certification_list(l_pk2) := l_pk2;
1573: goto refresh_all_records;
1574: ELSE
1575: **********/
1576: UPDATE amw_org_cert_eval_sum
1577: SET last_update_date = sysdate,
1578: last_updated_by = fnd_global.user_id,
1579: last_update_login = fnd_global.conc_login_id,
1580: processes_certified = least(processes_certified+1,total_processes)

Line 1636: UPDATE amw_org_cert_eval_sum

1632: m_certification_list(l_pk2) := l_pk2;
1633: goto refresh_all_records;
1634: ELSE
1635: ***************/
1636: UPDATE amw_org_cert_eval_sum
1637: SET last_update_date = sysdate,
1638: last_updated_by = fnd_global.user_id,
1639: last_update_login = fnd_global.conc_login_id,
1640: processes_certified = least(processes_certified+1,total_processes),

Line 1677: UPDATE amw_org_cert_eval_sum

1673: m_certification_list(l_pk2) := l_pk2;
1674: goto refresh_all_records;
1675: ELSE
1676: ***********/
1677: UPDATE amw_org_cert_eval_sum
1678: SET last_update_date = sysdate,
1679: last_updated_by = fnd_global.user_id,
1680: last_update_login = fnd_global.conc_login_id,
1681: proc_cert_issues = greatest(0,proc_cert_issues-1)

Line 1735: UPDATE amw_org_cert_eval_sum

1731: m_certification_list(l_pk2) := l_pk2;
1732: goto refresh_all_records;
1733: ELSE
1734: **************/
1735: UPDATE amw_org_cert_eval_sum
1736: SET last_update_date = sysdate,
1737: last_updated_by = fnd_global.user_id,
1738: last_update_login = fnd_global.conc_login_id,
1739: proc_cert_issues = least(proc_cert_issues+1,processes_certified,total_processes)

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:

Line 1962: --AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_summary

1958: -- retcode => l_msg_count,
1959: -- p_certification_id => m_certification_list(l_index)
1960: --);
1961:
1962: --AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_summary
1963: --(x_errbuf => l_msg_data,
1964: -- x_retcode => l_msg_count,
1965: -- p_certification_id => m_certification_list(l_index)
1966: --);