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_FINSTMT_CERT_BES_PKG dependencies on AMW_CERT_DASHBOARD_SUM

Line 3440: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_cert_dashboard_sum table:p_certification_id = ' || p_certification_id || ' elapsed time is ' || (l_end_time-l_start_time)2460*60);

3436: x_msg_count => l_msg_count,
3437: x_msg_data => l_msg_data);
3438:
3439: l_end_time := sysdate;
3440: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_cert_dashboard_sum table:p_certification_id = ' || p_certification_id || ' elapsed time is ' || (l_end_time-l_start_time)*24*60*60);
3441: l_start_time := sysdate;
3442: Populate_All_Fin_Org_Eval_Sum
3443: (p_certification_id => p_certification_id,
3444: x_return_status => l_return_status,

Line 7054: UPDATE AMW_CERT_DASHBOARD_SUM

7050: x_ineffective_controls => l_ineffective_controls);
7051: Get_orgs_pending_in_scope(p_certification_id => l_certification_id,
7052: x_orgs_pending_in_scope => l_orgs_pending_in_scope);
7053:
7054: UPDATE AMW_CERT_DASHBOARD_SUM
7055: SET NEW_RISKS_ADDED = l_new_risks_added,
7056: NEW_CONTROLS_ADDED = l_new_controls_added,
7057: PROCESSES_NOT_CERT = l_global_proc_not_certified,
7058: PROCESSES_CERT_ISSUES = l_global_proc_with_issue,

Line 7074: INSERT INTO AMW_CERT_DASHBOARD_SUM (

7070: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
7071: WHERE certification_id = p_certification_id;
7072:
7073: IF (SQL%NOTFOUND) THEN
7074: INSERT INTO AMW_CERT_DASHBOARD_SUM (
7075: CERTIFICATION_ID,
7076: NEW_RISKS_ADDED,
7077: NEW_CONTROLS_ADDED,
7078: PROCESSES_NOT_CERT,

Line 7361: PROCEDURE reset_amw_cert_dashboard_sum(p_certification_id in number)

7357:
7358: END IF;
7359: END reset_amw_fin_org_eval_sum;
7360:
7361: PROCEDURE reset_amw_cert_dashboard_sum(p_certification_id in number)
7362: IS
7363: BEGIN
7364: SAVEPOINT reset_amw_cert_dashboard_sum;
7365:

Line 7364: SAVEPOINT reset_amw_cert_dashboard_sum;

7360:
7361: PROCEDURE reset_amw_cert_dashboard_sum(p_certification_id in number)
7362: IS
7363: BEGIN
7364: SAVEPOINT reset_amw_cert_dashboard_sum;
7365:
7366: IF p_certification_id is not null THEN
7367: UPDATE AMW_CERT_DASHBOARD_SUM
7368: SET

Line 7367: UPDATE AMW_CERT_DASHBOARD_SUM

7363: BEGIN
7364: SAVEPOINT reset_amw_cert_dashboard_sum;
7365:
7366: IF p_certification_id is not null THEN
7367: UPDATE AMW_CERT_DASHBOARD_SUM
7368: SET
7369: LAST_UPDATE_DATE = sysdate,
7370: last_updated_by = fnd_global.user_id,
7371: last_update_login = fnd_global.conc_login_id,

Line 7387: UPDATE AMW_CERT_DASHBOARD_SUM

7383: ORGS_PENDING_IN_SCOPE = 0,
7384: ORGS_PENDING_CERTIFICATION = 0
7385: WHERE certification_id = p_certification_id;
7386: ELSE
7387: UPDATE AMW_CERT_DASHBOARD_SUM
7388: SET
7389: LAST_UPDATE_DATE = sysdate,
7390: last_updated_by = fnd_global.user_id,
7391: last_update_login = fnd_global.conc_login_id,

Line 7412: END reset_amw_cert_dashboard_sum;

7408: where certifcationb.OBJECT_TYPE='FIN_STMT'
7409: and certifcationb.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT'));
7410: END IF;
7411:
7412: END reset_amw_cert_dashboard_sum;
7413:
7414: PROCEDURE reset_fin_all(p_certification_id in number)
7415: IS
7416: l_certification_id number ;

Line 7425: reset_amw_cert_dashboard_sum(l_certification_id);

7421:
7422: reset_amw_fin_cert_eval_sum(l_certification_id);
7423: reset_amw_fin_proc_eval_sum(l_certification_id);
7424: reset_amw_fin_org_eval_sum(l_certification_id);
7425: reset_amw_cert_dashboard_sum(l_certification_id);
7426:
7427: END reset_fin_all;
7428:
7429: --******************************************************************************************************

Line 7493: SELECT UNMITIGATED_RISKS FROM AMW_CERT_DASHBOARD_SUM

7489: AND RISK_ID = p_risk_id;
7490:
7491:
7492: CURSOR Get_Dashboard_Risk(l_cert_id NUMBER) IS
7493: SELECT UNMITIGATED_RISKS FROM AMW_CERT_DASHBOARD_SUM
7494: WHERE CERTIFICATION_ID = l_cert_id;
7495:
7496: CURSOR Get_Process_Risk(l_cert_id NUMBER, l_org_id NUMBER, l_process_id NUMBER) IS
7497: SELECT UNMITIGATED_RISKS, RISKS_VERIFIED, TOTAL_NUMBER_OF_RISKS

Line 7867: UPDATE AMW_CERT_DASHBOARD_SUM

7863: g_refresh_flag := 'Y';
7864: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
7865: ELSE
7866: *************/
7867: UPDATE AMW_CERT_DASHBOARD_SUM
7868: SET
7869: LAST_UPDATE_DATE = sysdate,
7870: last_updated_by = fnd_global.user_id,
7871: last_update_login = fnd_global.conc_login_id,

Line 7912: UPDATE AMW_CERT_DASHBOARD_SUM

7908: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7909: AND ORGANIZATION_ID = p_org_id;
7910: -- END IF;
7911: ELSIF(M_change_flag = 'B') THEN
7912: UPDATE AMW_CERT_DASHBOARD_SUM
7913: SET
7914: LAST_UPDATE_DATE = sysdate,
7915: last_updated_by = fnd_global.user_id,
7916: last_update_login = fnd_global.conc_login_id,

Line 8059: SELECT INEFFECTIVE_CONTROLS FROM AMW_CERT_DASHBOARD_SUM

8055: AND NATURAL_ACCOUNT_ID = l_acct_id
8056: AND OBJECT_TYPE = 'ACCOUNT';
8057:
8058: CURSOR Get_Dashboard_Ctrl(l_cert_id NUMBER) IS
8059: SELECT INEFFECTIVE_CONTROLS FROM AMW_CERT_DASHBOARD_SUM
8060: WHERE CERTIFICATION_ID = l_cert_id;
8061:
8062: CURSOR Get_Org_Ctrl(l_cert_id NUMBER, l_org_id NUMBER) IS
8063: SELECT INEFFECTIVE_CONTROLS, CONTROLS_VERIFIED, TOTAL_NUMBER_OF_CTRLS

Line 8477: UPDATE AMW_CERT_DASHBOARD_SUM

8473: g_refresh_flag := 'Y';
8474: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
8475: ELSE
8476: *****************/
8477: UPDATE AMW_CERT_DASHBOARD_SUM
8478: SET
8479: LAST_UPDATE_DATE = sysdate,
8480: last_updated_by = fnd_global.user_id,
8481: last_update_login = fnd_global.conc_login_id,

Line 8525: UPDATE AMW_CERT_DASHBOARD_SUM

8521: -- END IF;
8522:
8523: ELSIF(M_change_flag = 'B') THEN
8524:
8525: UPDATE AMW_CERT_DASHBOARD_SUM
8526: SET
8527: last_update_date = sysdate,
8528: last_updated_by = fnd_global.user_id,
8529: last_update_login = fnd_global.conc_login_id,

Line 8730: FROM amw_cert_dashboard_sum

8726:
8727: CURSOR Get_Dashboard_Info(l_cert_id number) IS
8728: SELECT PROCESSES_NOT_CERT, PROCESSES_CERT_ISSUES, ORG_PROCESS_NOT_CERT, ORG_PROCESS_CERT_ISSUES,
8729: PROC_INEFF_CONTROL, ORG_PROC_INEFF_CONTROL
8730: FROM amw_cert_dashboard_sum
8731: WHERE certification_id = l_cert_id;
8732:
8733: CURSOR Get_parent_process(l_opinion_log_id number, l_org_id number, l_process_id number) IS
8734: SELECT fin.fin_certification_id, fin.organization_id, fin.process_id, fin.number_of_sub_procs_certified, fin.total_number_of_sub_procs

Line 9006: --update amw_fin_org_eval_sum and amw_cert_dashboard_sum tables

9002:
9003:
9004: END LOOP;
9005:
9006: --update amw_fin_org_eval_sum and amw_cert_dashboard_sum tables
9007: FOR Get_All_Org_Cert_Rec in Get_All_Org_Cert(p_org_id) LOOP
9008: exit when Get_All_Org_Cert %notfound;
9009:
9010: OPEN Get_old_cert_opinion_id(Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID, p_org_id, p_process_id);

Line 9066: UPDATE amw_cert_dashboard_sum

9062: AND ORGANIZATION_ID = p_org_id;
9063: --END IF;
9064:
9065: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9066: UPDATE amw_cert_dashboard_sum
9067: SET last_update_date = sysdate,
9068: last_updated_by = fnd_global.user_id,
9069: last_update_login = fnd_global.conc_login_id,
9070: proc_ineff_control = proc_ineff_control+1

Line 9073: UPDATE amw_cert_dashboard_sum

9069: last_update_login = fnd_global.conc_login_id,
9070: proc_ineff_control = proc_ineff_control+1
9071: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9072: ELSE
9073: UPDATE amw_cert_dashboard_sum
9074: SET last_update_date = sysdate,
9075: last_updated_by = fnd_global.user_id,
9076: last_update_login = fnd_global.conc_login_id,
9077: org_proc_ineff_control = org_proc_ineff_control+1

Line 9108: UPDATE amw_cert_dashboard_sum

9104: g_refresh_flag := 'Y';
9105: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9106: ELSE
9107: ***********/
9108: UPDATE amw_cert_dashboard_sum
9109: SET last_update_date = sysdate,
9110: last_updated_by = fnd_global.user_id,
9111: last_update_login = fnd_global.conc_login_id,
9112: proc_ineff_control = greatest(0,proc_ineff_control-1)

Line 9124: UPDATE amw_cert_dashboard_sum

9120: g_refresh_flag := 'Y';
9121: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9122: ELSE
9123: *************/
9124: UPDATE amw_cert_dashboard_sum
9125: SET last_update_date = sysdate,
9126: last_updated_by = fnd_global.user_id,
9127: last_update_login = fnd_global.conc_login_id,
9128: org_proc_ineff_control = greatest(0, org_proc_ineff_control-1)

Line 9152: UPDATE amw_cert_dashboard_sum

9148: AND ORGANIZATION_ID = p_org_id;
9149: --END IF;
9150:
9151: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9152: UPDATE amw_cert_dashboard_sum
9153: SET last_update_date = sysdate,
9154: last_updated_by = fnd_global.user_id,
9155: last_update_login = fnd_global.conc_login_id,
9156: proc_ineff_control = proc_ineff_control + 1

Line 9159: UPDATE amw_cert_dashboard_sum

9155: last_update_login = fnd_global.conc_login_id,
9156: proc_ineff_control = proc_ineff_control + 1
9157: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9158: ELSE
9159: UPDATE amw_cert_dashboard_sum
9160: SET last_update_date = sysdate,
9161: last_updated_by = fnd_global.user_id,
9162: last_update_login = fnd_global.conc_login_id,
9163: org_proc_ineff_control = org_proc_ineff_control + 1

Line 9169: END LOOP; --end of amw_fin_org_eval_sum and amw_cert_dashboard_sum

9165: END IF;
9166:
9167: END IF; -- end of a list of ifs
9168:
9169: END LOOP; --end of amw_fin_org_eval_sum and amw_cert_dashboard_sum
9170:
9171: END IF; --end of p_action = 'EVALUATION'
9172:
9173: IF (p_action = 'CERTIFICATION') THEN

Line 9360: --update amw_fin_org_eval_sum and amw_cert_dashboard_sum tables

9356:
9357: END LOOP; --end of account loop
9358:
9359:
9360: --update amw_fin_org_eval_sum and amw_cert_dashboard_sum tables
9361: FOR Get_All_Org_Cert_Rec in Get_All_Org_Cert(p_org_id) LOOP
9362: exit when Get_All_Org_Cert %notfound;
9363:
9364: OPEN Get_old_cert_opinion_id(Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID, p_org_id, p_process_id);

Line 9435: UPDATE amw_cert_dashboard_sum

9431: g_refresh_flag := 'Y';
9432: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9433: ELSE
9434: *******************/
9435: UPDATE amw_cert_dashboard_sum
9436: SET last_update_date = sysdate,
9437: last_updated_by = fnd_global.user_id,
9438: last_update_login = fnd_global.conc_login_id,
9439: processes_cert_issues = processes_cert_issues +1,

Line 9452: UPDATE amw_cert_dashboard_sum

9448: g_refresh_flag := 'Y';
9449: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9450: ELSE
9451: ***************/
9452: UPDATE amw_cert_dashboard_sum
9453: SET last_update_date = sysdate,
9454: last_updated_by = fnd_global.user_id,
9455: last_update_login = fnd_global.conc_login_id,
9456: org_process_cert_issues = org_process_cert_issues+1,

Line 9488: UPDATE amw_cert_dashboard_sum

9484: g_refresh_flag := 'Y';
9485: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9486: ELSE
9487: *****************/
9488: UPDATE amw_cert_dashboard_sum
9489: set last_update_date = sysdate,
9490: last_updated_by = fnd_global.user_id,
9491: last_update_login = fnd_global.conc_login_id,
9492: processes_cert_issues = greatest(0, processes_cert_issues - 1)

Line 9504: UPDATE amw_cert_dashboard_sum

9500: g_refresh_flag := 'Y';
9501: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9502: ELSE
9503: ****************/
9504: UPDATE amw_cert_dashboard_sum
9505: set last_update_date = sysdate,
9506: last_updated_by = fnd_global.user_id,
9507: last_update_login = fnd_global.conc_login_id,
9508: org_process_cert_issues = greatest(0, org_process_cert_issues - 1)

Line 9531: UPDATE amw_cert_dashboard_sum

9527: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9528: AND ORGANIZATION_ID = p_org_id;
9529: --END IF;
9530: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9531: UPDATE amw_cert_dashboard_sum
9532: SET last_update_date = sysdate,
9533: last_updated_by = fnd_global.user_id,
9534: last_update_login = fnd_global.conc_login_id,
9535: processes_cert_issues = processes_cert_issues + 1

Line 9538: UPDATE amw_cert_dashboard_sum

9534: last_update_login = fnd_global.conc_login_id,
9535: processes_cert_issues = processes_cert_issues + 1
9536: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9537: ELSE
9538: UPDATE amw_cert_dashboard_sum
9539: SET last_update_date = sysdate,
9540: last_updated_by = fnd_global.user_id,
9541: last_update_login = fnd_global.conc_login_id,
9542: org_process_cert_issues = greatest(0, org_process_cert_issues - 1)

Line 9548: END LOOP; --end of amw_fin_org_eval_sum and amw_cert_dashboard_sum

9544: END IF;
9545:
9546: END IF; -- end of a list of ifs
9547:
9548: END LOOP; --end of amw_fin_org_eval_sum and amw_cert_dashboard_sum
9549:
9550: --update amw_fin_process_eval_sum table
9551: FOR Get_parent_process_Rec in Get_parent_process(p_opinion_log_id, p_org_id, p_process_id ) LOOP
9552: exit when Get_parent_process %notfound;