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_ORG_EVAL_SUM

Line 2945: UPDATE AMW_FIN_ORG_EVAL_SUM

2941: x_return_status => l_return_status,
2942: x_msg_count => l_msg_count,
2943: x_msg_data => l_msg_data);
2944:
2945: UPDATE AMW_FIN_ORG_EVAL_SUM
2946: SET
2947: LAST_UPDATE_DATE = sysdate,
2948: last_updated_by = fnd_global.user_id,
2949: last_update_login = fnd_global.conc_login_id,

Line 3096: UPDATE AMW_FIN_ORG_EVAL_SUM

3092: x_return_status => l_return_status,
3093: x_msg_count => l_msg_count,
3094: x_msg_data => l_msg_data);
3095:
3096: UPDATE AMW_FIN_ORG_EVAL_SUM
3097: SET
3098: LAST_UPDATE_DATE = sysdate,
3099: last_updated_by = fnd_global.user_id,
3100: last_update_login = fnd_global.conc_login_id,

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

3445: x_msg_count => l_msg_count,
3446: x_msg_data => l_msg_data);
3447:
3448: l_end_time := sysdate;
3449: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_fin_org_eval_sum table:p_certification_id = ' || p_certification_id || ' elapsed time is ' || (l_end_time-l_start_time)*24*60*60);
3450: l_start_time := sysdate;
3451:
3452: build_amw_fin_cert_eval_sum
3453: (p_certification_id => p_certification_id,

Line 5564: -- DELETE_ROWS(p_certification_id, 'AMW_FIN_ORG_EVAL_SUM');

5560: l_lob_vs := FND_PROFILE.value('AMW_LOB_AUDIT_UNITS');
5561:
5562: l_position := 1;
5563:
5564: -- DELETE_ROWS(p_certification_id, 'AMW_FIN_ORG_EVAL_SUM');
5565:
5566: FOR org_rec IN c_org LOOP
5567: exit when c_org%notfound;
5568:

Line 6074: UPDATE AMW_FIN_ORG_EVAL_SUM

6070: fnd_file.put_line(fnd_file.LOG, '********** WARNING: Unexpected error in OrganizationId: '||p_organization_id||', processing not done for this Organization' );
6071: else --- do the updates/inserts
6072: /**05.25.2006 npanandi: bug 5250100 test ends**/
6073:
6074: UPDATE AMW_FIN_ORG_EVAL_SUM
6075: SET EVAL_OPINION_ID = l_eval_opinion_id,
6076: PROC_PENDING_CERTIFICATION = l_proc_pending_cert,
6077: TOTAL_NUMBER_OF_PROCS = l_total_num_of_procs,
6078: PROC_CERTIFIED_WITH_ISSUES = l_proc_with_issue,

Line 6113: INSERT INTO AMW_FIN_ORG_EVAL_SUM(

6109: AND organization_id = p_organization_id;
6110:
6111:
6112: IF (SQL%NOTFOUND) THEN
6113: INSERT INTO AMW_FIN_ORG_EVAL_SUM(
6114: FIN_CERTIFICATION_ID,
6115: ORGANIZATION_ID,
6116: EVAL_OPINION_ID,
6117: PROC_PENDING_CERTIFICATION,

Line 7287: PROCEDURE reset_amw_fin_org_eval_sum(p_certification_id in number)

7283: END reset_amw_fin_proc_eval_sum;
7284:
7285:
7286:
7287: PROCEDURE reset_amw_fin_org_eval_sum(p_certification_id in number)
7288: IS
7289: BEGIN
7290: SAVEPOINT reset_amw_fin_org_eval_sum;
7291:

Line 7290: SAVEPOINT reset_amw_fin_org_eval_sum;

7286:
7287: PROCEDURE reset_amw_fin_org_eval_sum(p_certification_id in number)
7288: IS
7289: BEGIN
7290: SAVEPOINT reset_amw_fin_org_eval_sum;
7291:
7292: IF p_certification_id is not null THEN
7293: UPDATE
7294: AMW_FIN_ORG_EVAL_SUM

Line 7294: AMW_FIN_ORG_EVAL_SUM

7290: SAVEPOINT reset_amw_fin_org_eval_sum;
7291:
7292: IF p_certification_id is not null THEN
7293: UPDATE
7294: AMW_FIN_ORG_EVAL_SUM
7295: SET
7296: LAST_UPDATE_DATE = sysdate,
7297: last_updated_by = fnd_global.user_id,
7298: last_update_login = fnd_global.conc_login_id,

Line 7323: UPDATE AMW_FIN_ORG_EVAL_SUM

7319: total_number_of_ctrls = 0,
7320: proc_certified = 0
7321: WHERE fin_certification_id = p_certification_id;
7322: ELSE
7323: UPDATE AMW_FIN_ORG_EVAL_SUM
7324: SET
7325: LAST_UPDATE_DATE = sysdate,
7326: last_updated_by = fnd_global.user_id,
7327: last_update_login = fnd_global.conc_login_id,

Line 7359: END reset_amw_fin_org_eval_sum;

7355: certifcationb.OBJECT_TYPE='FIN_STMT'
7356: and certifcationb.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT'));
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

Line 7424: reset_amw_fin_org_eval_sum(l_certification_id);

7420: l_certification_id := p_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:

Line 7505: FROM AMW_FIN_ORG_EVAL_SUM

7501: AND PROCESS_ID = l_process_id;
7502:
7503: CURSOR Get_Org_Risk(l_cert_id NUMBER, l_org_id NUMBER) IS
7504: SELECT UNMITIGATED_RISKS, RISKS_VERIFIED, TOTAL_NUMBER_OF_RISKS
7505: FROM AMW_FIN_ORG_EVAL_SUM
7506: WHERE FIN_CERTIFICATION_ID = l_cert_id
7507: AND ORGANIZATION_ID = l_org_id;
7508:
7509: CURSOR Get_Item_Risk(l_cert_id NUMBER, l_stmt_id NUMBER, l_item_id NUMBER) IS

Line 7847: UPDATE AMW_FIN_ORG_EVAL_SUM

7843: g_refresh_flag := 'Y';
7844: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
7845: ELSE
7846: *********/
7847: UPDATE AMW_FIN_ORG_EVAL_SUM
7848: SET
7849: last_update_date = sysdate,
7850: last_updated_by = fnd_global.user_id,
7851: last_update_login = fnd_global.conc_login_id,

Line 7901: UPDATE AMW_FIN_ORG_EVAL_SUM

7897: g_refresh_flag := 'Y';
7898: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
7899: ELSE
7900: *********/
7901: UPDATE AMW_FIN_ORG_EVAL_SUM
7902: SET
7903: last_update_date = sysdate,
7904: last_updated_by = fnd_global.user_id,
7905: last_update_login = fnd_global.conc_login_id,

Line 7946: UPDATE AMW_FIN_ORG_EVAL_SUM

7942: g_refresh_flag := 'Y';
7943: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
7944: ELSE
7945: ***************/
7946: UPDATE AMW_FIN_ORG_EVAL_SUM
7947: SET
7948: last_update_date = sysdate,
7949: last_updated_by = fnd_global.user_id,
7950: last_update_login = fnd_global.conc_login_id,

Line 8064: FROM AMW_FIN_ORG_EVAL_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
8064: FROM AMW_FIN_ORG_EVAL_SUM
8065: WHERE FIN_CERTIFICATION_ID = l_cert_id
8066: AND ORGANIZATION_ID = l_org_id;
8067:
8068: CURSOR Get_Proc_Ctrl(l_cert_id NUMBER, l_org_id NUMBER) IS

Line 8455: UPDATE AMW_FIN_ORG_EVAL_SUM

8451: g_refresh_flag := 'Y';
8452: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
8453: ELSE
8454: ***********/
8455: UPDATE AMW_FIN_ORG_EVAL_SUM
8456: SET
8457: LAST_UPDATE_DATE = sysdate,
8458: last_updated_by = fnd_global.user_id,
8459: last_update_login = fnd_global.conc_login_id,

Line 8512: UPDATE AMW_FIN_ORG_EVAL_SUM

8508: g_refresh_flag := 'Y';
8509: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
8510: ELSE
8511: ************/
8512: UPDATE AMW_FIN_ORG_EVAL_SUM
8513: SET
8514: last_update_date = sysdate,
8515: last_updated_by = fnd_global.user_id,
8516: last_update_login = fnd_global.conc_login_id,

Line 8541: UPDATE AMW_FIN_ORG_EVAL_SUM

8537: g_refresh_flag := 'Y';
8538: m_certification_list(Get_all_fin_cert_Rec.fin_certification_id) := Get_all_fin_cert_Rec.fin_certification_id;
8539: ELSE
8540: ***********/
8541: UPDATE AMW_FIN_ORG_EVAL_SUM
8542: SET
8543: last_update_date = sysdate,
8544: last_updated_by = fnd_global.user_id,
8545: last_update_login = fnd_global.conc_login_id,

Line 8724: FROM amw_fin_org_eval_sum

8720: --CURSOR TO GET FIN-CERT ID IN ORG_SUM TABLE
8721: CURSOR Get_All_Org_Cert(l_org_id number) IS
8722: SELECT fin_certification_id, PROC_PENDING_CERTIFICATION, PROC_CERTIFIED_WITH_ISSUES,
8723: PROC_CERTIFIED, PROC_VERIFIED, TOTAL_NUMBER_OF_PROCS, PROC_WITH_INEFFECTIVE_CONTROLS
8724: FROM amw_fin_org_eval_sum
8725: WHERE ORGANIZATION_ID = l_org_id;
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,

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 9034: UPDATE AMW_FIN_ORG_EVAL_SUM SET

9030: g_refresh_flag := 'Y';
9031: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9032: ELSE
9033: ***********/
9034: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9035: LAST_UPDATE_DATE = sysdate,
9036: last_updated_by = fnd_global.user_id,
9037: last_update_login = fnd_global.conc_login_id,
9038: proc_verified = least(proc_verified + 1, total_number_of_procs )

Line 9054: UPDATE AMW_FIN_ORG_EVAL_SUM SET

9050: g_refresh_flag := 'Y';
9051: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9052: ELSE
9053: *************/
9054: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9055: last_update_date = sysdate,
9056: last_updated_by = fnd_global.user_id,
9057: last_update_login = fnd_global.conc_login_id,
9058: proc_verified = least(proc_verified + 1,total_number_of_procs),

Line 9090: UPDATE AMW_FIN_ORG_EVAL_SUM SET

9086: g_refresh_flag := 'Y';
9087: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9088: ELSE
9089: ****************/
9090: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9091: last_update_date = sysdate,
9092: last_updated_by = fnd_global.user_id,
9093: last_update_login = fnd_global.conc_login_id,
9094: proc_with_ineffective_controls = greatest(0, proc_with_ineffective_controls - 1),

Line 9141: UPDATE AMW_FIN_ORG_EVAL_SUM SET

9137: g_refresh_flag := 'Y';
9138: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9139: ELSE
9140: **************/
9141: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9142: last_update_date = sysdate,
9143: last_updated_by = fnd_global.user_id,
9144: last_update_login = fnd_global.conc_login_id,
9145: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1, proc_verified),

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 9391: UPDATE AMW_FIN_ORG_EVAL_SUM SET

9387: g_refresh_flag := 'Y';
9388: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9389: ELSE
9390: *****************/
9391: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9392: last_update_date = sysdate,
9393: last_updated_by = fnd_global.user_id,
9394: last_update_login = fnd_global.conc_login_id,
9395: proc_certified = least(proc_certified + 1,total_number_of_procs ),

Line 9414: UPDATE AMW_FIN_ORG_EVAL_SUM SET

9410: g_refresh_flag := 'Y';
9411: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9412: ELSE
9413: **************/
9414: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9415: last_update_date = sysdate,
9416: last_updated_by = fnd_global.user_id,
9417: last_update_login = fnd_global.conc_login_id,
9418: proc_certified = least(proc_certified + 1,total_number_of_procs),

Line 9470: UPDATE AMW_FIN_ORG_EVAL_SUM SET

9466: g_refresh_flag := 'Y';
9467: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9468: ELSE
9469: *************/
9470: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9471: last_update_date = sysdate,
9472: last_updated_by = fnd_global.user_id,
9473: last_update_login = fnd_global.conc_login_id,
9474: proc_certified_with_issues = greatest(0, proc_certified_with_issues - 1),

Line 9521: UPDATE AMW_FIN_ORG_EVAL_SUM SET

9517: g_refresh_flag := 'Y';
9518: m_certification_list(get_all_org_cert_rec.fin_certification_id) := get_all_org_cert_rec.fin_certification_id;
9519: ELSE
9520: ***************/
9521: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9522: last_update_date = sysdate,
9523: last_updated_by = fnd_global.user_id,
9524: last_update_login = fnd_global.conc_login_id,
9525: proc_certified_with_issues = least(proc_certified_with_issues + 1, total_number_of_procs),

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;

Line 9647: FROM AMW_FIN_ORG_EVAL_SUM org,

9643:
9644: --CURSOR TO GET ALL OF FINANCIAL CERTIFICATION WHICH RELATE THIS ORGANIZATION
9645: CURSOR Get_all_fin_cert(l_org_id number) IS
9646: SELECT org.FIN_CERTIFICATION_ID
9647: FROM AMW_FIN_ORG_EVAL_SUM org,
9648: AMW_CERTIFICATION_B cert
9649: WHERE org.organization_id = l_org_id
9650: AND org.FIN_CERTIFICATION_ID = cert.CERTIFICATION_ID
9651: AND cert.CERTIFICATION_STATUS IN ('ACTIVE', 'DRAFT');

Line 9657: FROM AMW_FIN_ORG_EVAL_SUM

9653:
9654: --CURSOR TO GET OLD EVAL OPINION LOG ID
9655: CURSOR Get_old_opinion_id(l_cert_id number, l_org_id number) IS
9656: SELECT DISTINCT EVAL_OPINION_LOG_ID
9657: FROM AMW_FIN_ORG_EVAL_SUM
9658: WHERE FIN_CERTIFICATION_ID = l_cert_id
9659: AND ORGANIZATION_ID = l_org_id;
9660:
9661: --CURSOR TO GET OLD CERT OPINION LOG ID

Line 9664: FROM AMW_FIN_ORG_EVAL_SUM

9660:
9661: --CURSOR TO GET OLD CERT OPINION LOG ID
9662: CURSOR Get_old_cert_opinion_id(l_cert_id number, l_org_id number) IS
9663: SELECT DISTINCT CERT_OPINION_LOG_ID
9664: FROM AMW_FIN_ORG_EVAL_SUM
9665: WHERE FIN_CERTIFICATION_ID = l_cert_id
9666: AND ORGANIZATION_ID = l_org_id;
9667:
9668: --CURSOR TO GET ORGANIZATION INFORMATION FOR ITEM