DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_CERT_DASHBOARD_SUM

Line 1413: UPDATE AMW_CERT_DASHBOARD_SUM

1409: OPEN orgs_in_scope;
1410: FETCH orgs_in_scope INTO l_orgs_in_scope;
1411: CLOSE orgs_in_scope;
1412:
1413: UPDATE AMW_CERT_DASHBOARD_SUM
1414: SET NEW_RISKS_ADDED = l_new_risks_added,
1415: NEW_CONTROLS_ADDED = l_new_controls_added,
1416: PROCESSES_NOT_CERT = l_global_proc_not_certified,
1417: PROCESSES_CERT_ISSUES = l_global_proc_with_issue,

Line 1433: INSERT INTO AMW_CERT_DASHBOARD_SUM (

1429: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1430: WHERE certification_id = p_certification_id;
1431:
1432: IF (SQL%NOTFOUND) THEN
1433: INSERT INTO AMW_CERT_DASHBOARD_SUM (
1434: CERTIFICATION_ID,
1435: NEW_RISKS_ADDED,
1436: NEW_CONTROLS_ADDED,
1437: PROCESSES_NOT_CERT,

Line 1901: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_cert_dashboard_sum(p_certification_id => l_certification_id);

1897:
1898: -- AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_cert_eval_sum(p_certification_id => l_certification_id) ;
1899: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_proc_eval_sum(p_certification_id => l_certification_id);
1900: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_org_eval_sum(p_certification_id => l_certification_id);
1901: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_cert_dashboard_sum(p_certification_id => l_certification_id);
1902: --AMW_FINSTMT_CERT_BES_PKG.reset_fin_all(p_certification_id => l_certification_id);
1903: amw_fin_coso_views_pvt.DELETE_ROWS(x_fin_certification_id => l_certification_id);
1904:
1905: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum

Line 1918: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_cert_dashboard_sum(p_certification_id => cert_rec.certification_id);

1914: exit when c_cert%notfound;
1915: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_cert_eval_sum(p_certification_id => cert_rec.certification_id) ;
1916: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_proc_eval_sum(p_certification_id => cert_rec.certification_id);
1917: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_org_eval_sum(p_certification_id => cert_rec.certification_id);
1918: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_cert_dashboard_sum(p_certification_id => cert_rec.certification_id);
1919: --AMW_FINSTMT_CERT_BES_PKG.reset_fin_all(p_certification_id => cert_rec.certification_id);
1920: amw_fin_coso_views_pvt.DELETE_ROWS(x_fin_certification_id => cert_rec.certification_id);
1921:
1922: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum