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_FIN_PROCESS_EVAL_SUM

Line 1276: FROM AMW_FIN_PROCESS_EVAL_SUM proc

1272: ) IS
1273: BEGIN
1274: SELECT count(1) INTO x_global_proc_not_certified
1275: FROM ( SELECT distinct proc.organization_id, proc.process_id
1276: FROM AMW_FIN_PROCESS_EVAL_SUM proc
1277: WHERE proc.fin_certification_id = p_certification_id
1278: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)
1279: AND not exists (SELECT 'Y'
1280: FROM AMW_OPINION_MV aov,

Line 1304: FROM AMW_FIN_PROCESS_EVAL_SUM proc

1300:
1301: -- local_proc_not_certified
1302: SELECT count(1) INTO x_local_proc_not_certified
1303: FROM ( SELECT distinct proc.organization_id, proc.process_id
1304: FROM AMW_FIN_PROCESS_EVAL_SUM proc
1305: WHERE proc.fin_certification_id = p_certification_id
1306: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)
1307: AND not exists (SELECT 'Y'
1308: FROM AMW_OPINION_MV aov,

Line 1332: FROM AMW_FIN_PROCESS_EVAL_SUM proc,

1328:
1329: ---- global_proc_with_issue
1330: SELECT count(1) INTO x_global_proc_with_issue
1331: FROM (SELECT DISTINCT proc.organization_id, proc.process_id
1332: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
1333: AMW_OPINION_MV aov,
1334: AMW_FIN_PROC_CERT_RELAN rel
1335: WHERE proc.fin_certification_id = p_certification_id
1336: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)

Line 1362: FROM AMW_FIN_PROCESS_EVAL_SUM proc,

1358: BEGIN
1359: ------local_proc_with_issue
1360: SELECT count(1) INTO x_local_proc_with_issue
1361: FROM (SELECT DISTINCT proc.organization_id, proc.process_id
1362: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
1363: AMW_OPINION_MV aov,
1364: AMW_FIN_PROC_CERT_RELAN rel
1365: WHERE proc.fin_certification_id = p_certification_id
1366: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)

Line 1393: FROM AMW_FIN_PROCESS_EVAL_SUM proc,

1389: BEGIN
1390: -------------global_proc_with_ineff_ctrl IS
1391: SELECT count(1) INTO x_global_proc_ineff_ctrl
1392: from (select distinct proc.organization_id, proc.process_id
1393: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
1394: AMW_OPINION_MV aov
1395: WHERE proc.fin_certification_id = p_certification_id
1396: AND proc.organization_id = aov.pk3_value
1397: AND proc.process_id = aov.pk1_value

Line 1422: FROM AMW_FIN_PROCESS_EVAL_SUM proc,

1418: BEGIN
1419: ------ local_proc_with_ineff_ctrl
1420: SELECT count(1) INTO x_local_proc_ineff_ctrl
1421: from (select distinct proc.organization_id, proc.process_id
1422: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
1423: AMW_OPINION_MV aov
1424: WHERE proc.fin_certification_id = p_certification_id
1425: AND proc.organization_id = aov.pk3_value
1426: AND proc.process_id = aov.pk1_value

Line 1904: SELECT COUNT(1) INTO L_COUNT2 FROM AMW_FIN_PROCESS_EVAL_SUM

1900: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
1901:
1902: /** even if there is no process attached to an account. if the account belongs to the financial
1903: ** certification, we should add it to the amw_fin_cert_scope table
1904: SELECT COUNT(1) INTO L_COUNT2 FROM AMW_FIN_PROCESS_EVAL_SUM
1905: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
1906:
1907:
1908: IF (L_COUNT2 = 0 OR L_COUNT2 IS NULL) THEN

Line 2972: UPDATE AMW_FIN_PROCESS_EVAL_SUM SET

2968: x_return_status => l_return_status,
2969: x_msg_count => l_msg_count,
2970: x_msg_data => l_msg_data);
2971:
2972: UPDATE AMW_FIN_PROCESS_EVAL_SUM SET
2973: LAST_UPDATE_DATE = sysdate,
2974: last_updated_by = fnd_global.user_id,
2975: last_update_login = fnd_global.conc_login_id,
2976: CERT_OPINION_LOG_ID = l_opinion_log_id,

Line 3123: UPDATE AMW_FIN_PROCESS_EVAL_SUM SET

3119: x_return_status => l_return_status,
3120: x_msg_count => l_msg_count,
3121: x_msg_data => l_msg_data);
3122:
3123: UPDATE AMW_FIN_PROCESS_EVAL_SUM SET
3124: LAST_UPDATE_DATE = sysdate,
3125: last_updated_by = fnd_global.user_id,
3126: last_update_login = fnd_global.conc_login_id,
3127: EVAL_OPINION_LOG_ID = l_opinion_log_id,

Line 3379: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_fin_process_eval_sum table:p_certification_id = ' || p_certification_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

3375: (p_certification_id => p_certification_id,
3376: x_return_status => l_return_status,
3377: x_msg_count => l_msg_count,
3378: x_msg_data => l_msg_data);
3379: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_fin_process_eval_sum table:p_certification_id = ' || p_certification_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
3380: ELSE
3381: Refresh_All_Fin_Proc_Eval_Sum
3382: (p_certification_id => p_certification_id,
3383: x_return_status => l_return_status,

Line 3498: FROM AMW_FIN_PROCESS_EVAL_SUM

3494: IS
3495:
3496: CURSOR c_process IS
3497: SELECT organization_id, process_id, revision_number, process_org_rev_id, account_process_flag
3498: FROM AMW_FIN_PROCESS_EVAL_SUM
3499: WHERE FIN_CERTIFICATION_ID = p_certification_id;
3500:
3501: l_error_message varchar2(4000);
3502:

Line 3776: from amw_fin_process_eval_sum evalsum

3772: AND aov.opinion_component_code = 'OVERALL'
3773: AND aov.pk3_value <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)
3774: AND aov.pk1_value = p_process_id
3775: AND aov.pk3_value in (select distinct evalsum.organization_id
3776: from amw_fin_process_eval_sum evalsum
3777: where evalsum.fin_certification_id = p_cert_id
3778: and evalsum.process_id=p_process_id)
3779: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
3780: where fin_stmt_cert_id = p_cert_id and end_date is null );

Line 3784: from amw_fin_process_eval_sum evalsum

3780: where fin_stmt_cert_id = p_cert_id and end_date is null );
3781:
3782: CURSOR total_org_processes(p_cert_id NUMBER,p_process_id NUMBER) IS
3783: select count(distinct evalsum.organization_id)
3784: from amw_fin_process_eval_sum evalsum
3785: where evalsum.fin_certification_id = p_cert_id
3786: and evalsum.process_id=p_process_id
3787: and evalsum.organization_id <>
3788: NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999);

Line 3795: FROM AMW_FIN_PROCESS_EVAL_SUM

3791: --Begin variant process
3792:
3793: CURSOR var_procs(p_cert_id NUMBER) IS
3794: SELECT fin_certification_id,organization_id,process_id
3795: FROM AMW_FIN_PROCESS_EVAL_SUM
3796: WHERE fin_certification_id = p_cert_id
3797: AND organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999);
3798:
3799: CURSOR org_var_processes_certified(p_cert_id NUMBER,p_start_date DATE,p_end_date DATE,p_process_id NUMBER) IS

Line 3815: from amw_fin_process_eval_sum evalsum

3811: FROM AMW_PROCESS varproc
3812: WHERE varproc.standard_variation = p_process_id
3813: AND varproc.standard_process_flag = 'N'
3814: AND varproc.process_id in (select distinct evalsum.process_id
3815: from amw_fin_process_eval_sum evalsum
3816: where evalsum.fin_certification_id = p_cert_id)));
3817:
3818:
3819: CURSOR total_org_var_processes(p_cert_id NUMBER,p_process_id NUMBER) IS

Line 3822: from amw_fin_process_eval_sum evalsum

3818:
3819: CURSOR total_org_var_processes(p_cert_id NUMBER,p_process_id NUMBER) IS
3820: select count(1) from
3821: (select distinct evalsum.organization_id,evalsum.process_id
3822: from amw_fin_process_eval_sum evalsum
3823: where evalsum.fin_certification_id = p_cert_id
3824: and evalsum.process_id in (select varproc.process_id
3825: FROM AMW_PROCESS varproc
3826: WHERE varproc.standard_variation = p_process_id

Line 3950: UPDATE AMW_FIN_PROCESS_EVAL_SUM

3946:
3947: l_total_org_processes := l_total_org_processes+
3948: l_total_org_var_processes;
3949:
3950: UPDATE AMW_FIN_PROCESS_EVAL_SUM
3951: SET LAST_UPDATE_DATE = sysdate,
3952: last_updated_by = fnd_global.user_id,
3953: last_update_login = fnd_global.conc_login_id,
3954: TOTAL_NUMBER_OF_ORG_PROCS = l_total_org_processes,

Line 4295: FROM AMW_FIN_PROCESS_EVAL_SUM sum

4291: x_return_status := FND_API.G_RET_STS_SUCCESS;
4292:
4293:
4294: SELECT count(1) into l_count
4295: FROM AMW_FIN_PROCESS_EVAL_SUM sum
4296: WHERE sum.fin_certification_id = p_certification_id
4297: AND sum.organization_id = p_organization_id
4298: AND sum.process_id = p_process_id
4299: AND EXISTS ( SELECT 'Y' FROM AMW_FIN_CERT_SCOPE scp

Line 4388: INSERT INTO AMW_FIN_PROCESS_EVAL_SUM(

4384:
4385: --first time to insert the process records for this certification
4386: IF (l_new = 0 and l_count = 0) THEN
4387:
4388: INSERT INTO AMW_FIN_PROCESS_EVAL_SUM(
4389: FIN_CERTIFICATION_ID,
4390: PROCESS_ID,
4391: ORGANIZATION_ID,
4392: CERT_OPINION_ID,

Line 4453: UPDATE AMW_FIN_PROCESS_EVAL_SUM

4449: p_process_org_rev_id);
4450:
4451: ELSE
4452:
4453: UPDATE AMW_FIN_PROCESS_EVAL_SUM
4454: SET
4455: CERT_OPINION_ID = l_cert_opinion_id,
4456: EVAL_OPINION_ID = l_eval_opinion_id,
4457: UNMITIGATED_RISKS = l_unmitigated_risks,

Line 4598: AMW_FIN_PROCESS_EVAL_SUM eval,

4594: risks.DELETION_APPROVAL_DATE,
4595: risk.RISK_REV_ID
4596: FROM
4597: AMW_RISK_ASSOCIATIONS risks,
4598: AMW_FIN_PROCESS_EVAL_SUM eval,
4599: AMW_RISKS_B risk
4600: WHERE
4601: eval.fin_certification_id = p_certification_id
4602: and risk.risk_id = risks.risk_id

Line 4622: AMW_FIN_PROCESS_EVAL_SUM eval,

4618: risks.DELETION_APPROVAL_DATE,
4619: risk.RISK_REV_ID
4620: FROM
4621: AMW_RISK_ASSOCIATIONS risks,
4622: AMW_FIN_PROCESS_EVAL_SUM eval,
4623: AMW_RISKS_B risk
4624: WHERE
4625: eval.fin_certification_id = p_certification_id
4626: and risk.risk_id = risks.risk_id

Line 5509: FROM AMW_FIN_PROCESS_EVAL_SUM

5505:
5506: -- select all the processes based on the certification_id
5507: CURSOR c_org IS
5508: SELECT distinct organization_id
5509: FROM AMW_FIN_PROCESS_EVAL_SUM
5510: WHERE FIN_CERTIFICATION_ID = p_certification_id;
5511:
5512: l_subsidiary_tbl amw_scope_pvt.sub_tbl_type;
5513: l_lob_tbl amw_scope_pvt.lob_tbl_type;

Line 5700: SELECT COUNT(DISTINCT PROCESS_ID) FROM AMW_FIN_PROCESS_EVAL_SUM

5696: FROM AMW_OPINIONS_LOG aov
5697: WHERE aov.opinion_id = l_opinion_id;
5698:
5699: CURSOR total_num_of_proc IS
5700: SELECT COUNT(DISTINCT PROCESS_ID) FROM AMW_FIN_PROCESS_EVAL_SUM
5701: WHERE FIN_CERTIFICATION_ID = p_certification_id AND ORGANIZATION_ID = p_organization_id;
5702:
5703:
5704: CURSOR pending_proc IS

Line 5706: FROM AMW_FIN_PROCESS_EVAL_SUM proeval

5702:
5703:
5704: CURSOR pending_proc IS
5705: SELECT count(distinct proeval.process_id)
5706: FROM AMW_FIN_PROCESS_EVAL_SUM proeval
5707: WHERE proeval.fin_certification_id = p_certification_id
5708: AND proeval.organization_id = p_organization_id
5709: AND proeval.cert_opinion_log_id is null;
5710:

Line 5714: FROM AMW_FIN_PROCESS_EVAL_SUM proeval,

5710:
5711:
5712: CURSOR proc_with_issue IS
5713: SELECT count(distinct proeval.process_id)
5714: FROM AMW_FIN_PROCESS_EVAL_SUM proeval,
5715: AMW_OPINION_MV aov
5716: WHERE proeval.fin_certification_id = p_certification_id
5717: AND proeval.organization_id = p_organization_id
5718: AND aov.object_name = 'AMW_ORG_PROCESS'

Line 5740: FROM AMW_FIN_PROCESS_EVAL_SUM proeval,

5736: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE';
5737:
5738: CURSOR proc_without_issue IS
5739: SELECT count(distinct proeval.process_id)
5740: FROM AMW_FIN_PROCESS_EVAL_SUM proeval,
5741: AMW_OPINION_MV aov
5742: WHERE proeval.fin_certification_id = p_certification_id
5743: AND proeval.organization_id = p_organization_id
5744: AND aov.object_name = 'AMW_ORG_PROCESS'

Line 5766: FROM AMW_FIN_PROCESS_EVAL_SUM proeval,

5762: AND aov.OPINION_VALUE_CODE = 'EFFECTIVE';
5763:
5764: CURSOR proc_with_ineff_ctrl IS
5765: SELECT count(distinct proeval.process_id)
5766: FROM AMW_FIN_PROCESS_EVAL_SUM proeval,
5767: AMW_OPINION_MV aov
5768: WHERE proeval.fin_certification_id = p_certification_id
5769: AND proeval.organization_id = p_organization_id
5770: AND aov.object_name = 'AMW_ORG_PROCESS'

Line 5787: FROM AMW_FIN_PROCESS_EVAL_SUM proeval,

5783: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE';
5784:
5785: CURSOR verified_processes IS
5786: SELECT count(distinct proeval.process_id)
5787: FROM AMW_FIN_PROCESS_EVAL_SUM proeval,
5788: AMW_OPINION_MV aov
5789: WHERE proeval.fin_certification_id = p_certification_id
5790: AND proeval.organization_id = p_organization_id
5791: AND aov.object_name = 'AMW_ORG_PROCESS'

Line 7228: UPDATE AMW_FIN_PROCESS_EVAL_SUM

7224: BEGIN
7225: SAVEPOINT reset_amw_fin_proc_eval_sum;
7226:
7227: IF(p_certification_id is not null) then
7228: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7229: SET
7230: LAST_UPDATE_DATE = sysdate,
7231: last_updated_by = fnd_global.user_id,
7232: last_update_login = fnd_global.conc_login_id,

Line 7252: UPDATE AMW_FIN_PROCESS_EVAL_SUM

7248: total_number_of_risks = 0,
7249: total_number_of_ctrls = 0
7250: WHERE fin_certification_id = p_certification_id;
7251: ELSE
7252: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7253: SET
7254: LAST_UPDATE_DATE = sysdate,
7255: last_updated_by = fnd_global.user_id,
7256: last_update_login = fnd_global.conc_login_id,

Line 7474: FROM AMW_FIN_PROCESS_EVAL_SUM proc,

7470:
7471: --CURSOR TO GET ALL OF FINANCIAL CERTIFICATION WHICH HAS PROCESSES THAT RELATES TO THIS RISK
7472: CURSOR Get_all_fin_cert(l_org_id number, l_process_id number) IS
7473: SELECT DISTINCT proc.FIN_CERTIFICATION_ID
7474: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
7475: AMW_CERTIFICATION_B cert
7476: WHERE proc.organization_id = l_org_id
7477: AND proc.PROCESS_ID = l_process_id
7478: AND proc.FIN_CERTIFICATION_ID = cert.CERTIFICATION_ID

Line 7498: FROM AMW_FIN_PROCESS_EVAL_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
7498: FROM AMW_FIN_PROCESS_EVAL_SUM
7499: WHERE FIN_CERTIFICATION_ID = l_cert_id
7500: AND ORGANIZATION_ID = l_org_id
7501: AND PROCESS_ID = l_process_id;
7502:

Line 7829: UPDATE AMW_FIN_PROCESS_EVAL_SUM

7825: g_refresh_flag := 'Y';
7826: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
7827: ELSE
7828: ************/
7829: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7830: SET
7831: last_update_date = sysdate,
7832: last_updated_by = fnd_global.user_id,
7833: last_update_login = fnd_global.conc_login_id,

Line 7883: UPDATE AMW_FIN_PROCESS_EVAL_SUM

7879: g_refresh_flag := 'Y';
7880: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
7881: ELSE
7882: ************/
7883: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7884: SET
7885: LAST_UPDATE_DATE = sysdate,
7886: last_updated_by = fnd_global.user_id,
7887: last_update_login = fnd_global.conc_login_id,

Line 7928: UPDATE AMW_FIN_PROCESS_EVAL_SUM

7924: g_refresh_flag := 'Y';
7925: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
7926: ELSE
7927: ************/
7928: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7929: SET
7930: last_update_date = sysdate,
7931: last_updated_by = fnd_global.user_id,
7932: last_update_login = fnd_global.conc_login_id,

Line 8024: FROM AMW_FIN_PROCESS_EVAL_SUM proc,

8020:
8021: --CURSOR TO GET ALL OF FINANCIAL CERTIFICATION WHICH HAS PROCESSES THAT RELATES TO THIS CONTROL
8022: CURSOR Get_all_fin_cert(l_org_id number) IS
8023: SELECT DISTINCT proc.FIN_CERTIFICATION_ID
8024: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
8025: AMW_CERTIFICATION_B cert
8026: WHERE proc.organization_id = l_org_id
8027: AND proc.FIN_CERTIFICATION_ID = cert.CERTIFICATION_ID
8028: AND cert.CERTIFICATION_STATUS IN ('ACTIVE', 'DRAFT');

Line 8070: FROM AMW_FIN_PROCESS_EVAL_SUM

8066: AND ORGANIZATION_ID = l_org_id;
8067:
8068: CURSOR Get_Proc_Ctrl(l_cert_id NUMBER, l_org_id NUMBER) IS
8069: SELECT INEFFECTIVE_CONTROLS, CONTROLS_VERIFIED, TOTAL_NUMBER_OF_CTRLS
8070: FROM AMW_FIN_PROCESS_EVAL_SUM
8071: WHERE FIN_CERTIFICATION_ID = l_cert_id
8072: AND ORGANIZATION_ID = l_org_id;
8073:
8074: M_item_ctrls_verified number;

Line 8437: UPDATE AMW_FIN_PROCESS_EVAL_SUM

8433: g_refresh_flag := 'Y';
8434: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
8435: ELSE
8436: *************/
8437: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8438: SET
8439: last_update_date = sysdate,
8440: last_updated_by = fnd_global.user_id,
8441: last_update_login = fnd_global.conc_login_id,

Line 8494: UPDATE AMW_FIN_PROCESS_EVAL_SUM

8490: g_refresh_flag := 'Y';
8491: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
8492: ELSE
8493: ************/
8494: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8495: SET
8496: LAST_UPDATE_DATE = sysdate,
8497: last_updated_by = fnd_global.user_id,
8498: last_update_login = fnd_global.conc_login_id,

Line 8560: UPDATE AMW_FIN_PROCESS_EVAL_SUM

8556: g_refresh_flag := 'Y';
8557: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
8558: ELSE
8559: ********/
8560: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8561: SET
8562: last_update_date = sysdate,
8563: last_updated_by = fnd_global.user_id,
8564: last_update_login = fnd_global.conc_login_id,

Line 8650: FROM AMW_FIN_PROCESS_EVAL_SUM proc,

8646:
8647: --CURSOR TO GET ALL OF FINANCIAL CERTIFICATION WHICH CONTAINS THIS PROCESSE
8648: CURSOR Get_all_fin_cert(l_org_id number, l_process_id number) IS
8649: SELECT proc.FIN_CERTIFICATION_ID
8650: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
8651: AMW_CERTIFICATION_B cert
8652: WHERE proc.organization_id = l_org_id
8653: AND proc.PROCESS_ID = l_process_id
8654: AND proc.FIN_CERTIFICATION_ID = cert.CERTIFICATION_ID

Line 8671: FROM AMW_FIN_PROCESS_EVAL_SUM

8667:
8668: --CURSOR TO GET OLD EVAL OPINION LOG ID
8669: CURSOR Get_old_opinion_id(l_cert_id number, l_org_id number, l_process_id number) IS
8670: SELECT EVAL_OPINION_LOG_ID
8671: FROM AMW_FIN_PROCESS_EVAL_SUM
8672: WHERE FIN_CERTIFICATION_ID = l_cert_id
8673: AND ORGANIZATION_ID = l_org_id
8674: AND PROCESS_ID = l_process_id;
8675:

Line 8679: FROM AMW_FIN_PROCESS_EVAL_SUM

8675:
8676: --CURSOR TO GET OLD CERT OPINION LOG ID
8677: CURSOR Get_old_cert_opinion_id(l_cert_id number, l_org_id number, l_process_id number) IS
8678: SELECT CERT_OPINION_LOG_ID
8679: FROM AMW_FIN_PROCESS_EVAL_SUM
8680: WHERE FIN_CERTIFICATION_ID = l_cert_id
8681: AND ORGANIZATION_ID = l_org_id
8682: AND PROCESS_ID = l_process_id;
8683:

Line 8735: FROM amw_fin_process_eval_sum fin

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
8735: FROM amw_fin_process_eval_sum fin
8736: WHERE fin.organization_id = l_org_id
8737: AND fin.process_id in (
8738: SELECT proc.parent_process_id
8739: FROM amw_fin_process_flat proc

Line 9550: --update amw_fin_process_eval_sum table

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;
9553:
9554: OPEN Get_old_cert_opinion_id(Get_parent_process_Rec.fin_certification_id, p_org_id, p_process_id);

Line 9567: UPDATE amw_fin_process_eval_sum

9563: g_refresh_flag := 'Y';
9564: m_certification_list(get_parent_process_rec.fin_certification_id) := get_parent_process_rec.fin_certification_id;
9565: ELSE
9566: ***************/
9567: UPDATE amw_fin_process_eval_sum
9568: SET
9569: last_update_date = sysdate,
9570: last_updated_by = fnd_global.user_id,
9571: last_update_login = fnd_global.conc_login_id,

Line 10024: AMW_FIN_PROCESS_EVAL_SUM eval,

10020: risks.DELETION_APPROVAL_DATE,
10021: risk.RISK_REV_ID
10022: FROM
10023: AMW_RISK_ASSOCIATIONS risks,
10024: AMW_FIN_PROCESS_EVAL_SUM eval,
10025: AMW_RISKS_B risk
10026: WHERE
10027: eval.fin_certification_id = p_certification_id
10028: and risk.risk_id = risks.risk_id

Line 10048: AMW_FIN_PROCESS_EVAL_SUM eval,

10044: risks.DELETION_APPROVAL_DATE,
10045: risk.RISK_REV_ID
10046: FROM
10047: AMW_RISK_ASSOCIATIONS risks,
10048: AMW_FIN_PROCESS_EVAL_SUM eval,
10049: AMW_RISKS_B risk
10050: WHERE
10051: eval.fin_certification_id = p_certification_id
10052: and risk.risk_id = risks.risk_id