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_CERT_EVAL_SUM

Line 1638: SELECT COUNT(1) INTO M_COUNT FROM amw_fin_cert_eval_sum

1634:
1635: -- Initialize API return status to SUCCESS
1636: x_return_status := FND_API.G_RET_STS_SUCCESS;
1637:
1638: SELECT COUNT(1) INTO M_COUNT FROM amw_fin_cert_eval_sum
1639: WHERE FIN_CERTIFICATION_ID = X_FIN_CERTIFICATION_ID
1640: AND FINANCIAL_STATEMENT_ID = X_FINANCIAL_STATEMENT_ID
1641: AND NVL(FINANCIAL_ITEM_ID,0) = NVL(X_FINANCIAL_ITEM_ID,0)
1642: AND NVL(NATURAL_ACCOUNT_ID,0) = NVL(X_NATURAL_ACCOUNT_ID,0)

Line 1648: insert into amw_fin_cert_eval_sum(

1644: AND OBJECT_TYPE = X_OBJECT_TYPE;
1645:
1646:
1647: IF (M_COUNT is null or M_COUNT = 0) then
1648: insert into amw_fin_cert_eval_sum(
1649: FIN_CERTIFICATION_ID ,
1650: FINANCIAL_STATEMENT_ID ,
1651: FINANCIAL_ITEM_ID ,
1652: NATURAL_ACCOUNT_ID ,

Line 1733: update amw_fin_cert_eval_sum set

1729: );
1730:
1731: else -- update
1732:
1733: update amw_fin_cert_eval_sum set
1734: FIN_CERTIFICATION_ID
1735: = X_FIN_CERTIFICATION_ID,
1736: FINANCIAL_STATEMENT_ID
1737: = X_FINANCIAL_STATEMENT_ID,

Line 3452: build_amw_fin_cert_eval_sum

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,
3454: x_return_status => l_return_status,
3455: x_msg_count => l_msg_count,
3456: x_msg_data => l_msg_data);

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

3455: x_msg_count => l_msg_count,
3456: x_msg_data => l_msg_data);
3457:
3458: l_end_time := sysdate;
3459: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_fin_cert_eval_sum table:p_certification_id = ' || p_certification_id || ' elapsed time is ' || (l_end_time-l_start_time)*24*60*60);
3460:
3461: EXCEPTION
3462: WHEN NO_DATA_FOUND THEN
3463: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );

Line 6215: PROCEDURE build_amw_fin_cert_eval_sum(

6211: RETURN;
6212: END Populate_Fin_Org_Eval_Sum;
6213:
6214:
6215: PROCEDURE build_amw_fin_cert_eval_sum(
6216: p_api_version_number IN NUMBER := 1.0,
6217: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
6218: p_commit IN VARCHAR2 := FND_API.g_false,
6219: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

Line 6257: l_api_name CONSTANT VARCHAR2(30) := 'build_amw_fin_cert_eval_sum';

6253:
6254:
6255: l_certification_id NUMBER;
6256:
6257: l_api_name CONSTANT VARCHAR2(30) := 'build_amw_fin_cert_eval_sum';
6258: l_api_version_number CONSTANT NUMBER := 1.0;
6259:
6260: l_return_status VARCHAR2(32767);
6261: l_msg_count NUMBER;

Line 6266: SAVEPOINT build_amw_fin_cert_eval_sum;

6262: l_msg_data VARCHAR2(32767);
6263:
6264: BEGIN
6265:
6266: SAVEPOINT build_amw_fin_cert_eval_sum;
6267:
6268: -- Standard call to check for call compatibility.
6269: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
6270: p_api_version_number,

Line 6290: --DELETE_ROWS(P_CERTIFICATION_ID, 'AMW_FIN_CERT_EVAL_SUM');

6286:
6287:
6288: l_certification_id := P_CERTIFICATION_ID;
6289:
6290: --DELETE_ROWS(P_CERTIFICATION_ID, 'AMW_FIN_CERT_EVAL_SUM');
6291:
6292: FOR Get_all_items_Rec in Get_all_items LOOP
6293: exit when Get_all_items %notfound;
6294: compute_values_for_eval_sum

Line 6394: ROLLBACK TO build_amw_fin_cert_eval_sum;

6390: x_return_status := FND_API.G_RET_STS_ERROR;
6391: x_msg_count := 1;
6392: x_msg_data := 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name ;
6393: WHEN OTHERS THEN
6394: ROLLBACK TO build_amw_fin_cert_eval_sum;
6395: fnd_file.put_line(fnd_file.LOG, 'Unexpected error in ' || G_PKG_NAME || '.' || l_api_name );
6396: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6398: x_msg_count := 1;

Line 6408: END build_amw_fin_cert_eval_sum;

6404: p_data => x_msg_data);
6405: RETURN;
6406:
6407:
6408: END build_amw_fin_cert_eval_sum;
6409:
6410: /*********************************************************************************************/
6411: /**************************************Add by Dong -----------------------------------------*/
6412: /********************************* combine statement item and account calls into one --------*/

Line 7144: PROCEDURE reset_amw_fin_cert_eval_sum(p_certification_id in number)

7140: RETURN;
7141:
7142: END Populate_Cert_General_Sum;
7143:
7144: PROCEDURE reset_amw_fin_cert_eval_sum(p_certification_id in number)
7145: is
7146: begin
7147:
7148: SAVEPOINT reset_amw_fin_cert_eval_sum;

Line 7148: SAVEPOINT reset_amw_fin_cert_eval_sum;

7144: PROCEDURE reset_amw_fin_cert_eval_sum(p_certification_id in number)
7145: is
7146: begin
7147:
7148: SAVEPOINT reset_amw_fin_cert_eval_sum;
7149:
7150: if p_certification_id is not null then
7151: update amw_fin_cert_eval_sum
7152: set

Line 7151: update amw_fin_cert_eval_sum

7147:
7148: SAVEPOINT reset_amw_fin_cert_eval_sum;
7149:
7150: if p_certification_id is not null then
7151: update amw_fin_cert_eval_sum
7152: set
7153: LAST_UPDATE_DATE = sysdate,
7154: last_updated_by = fnd_global.user_id,
7155: last_update_login = fnd_global.conc_login_id,

Line 7183: update amw_fin_cert_eval_sum

7179: total_number_of_ctrls = 0,
7180: total_number_of_orgs = 0
7181: WHERE fin_certification_id = p_certification_id;
7182: else
7183: update amw_fin_cert_eval_sum
7184: set
7185: LAST_UPDATE_DATE = sysdate,
7186: last_updated_by = fnd_global.user_id,
7187: last_update_login = fnd_global.conc_login_id,

Line 7220: END reset_amw_fin_cert_eval_sum;

7216: where certifcationb.OBJECT_TYPE='FIN_STMT'
7217: and certifcationb.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT'));
7218: end if;
7219:
7220: END reset_amw_fin_cert_eval_sum;
7221:
7222: PROCEDURE reset_amw_fin_proc_eval_sum(p_certification_id in number)
7223: IS
7224: BEGIN

Line 7422: reset_amw_fin_cert_eval_sum(l_certification_id);

7418: SAVEPOINT reset_fin_all;
7419:
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:

Line 7511: FROM AMW_FIN_CERT_EVAL_SUM

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
7510: SELECT UNMITIGATED_RISKS, RISKS_VERIFIED, TOTAL_NUMBER_OF_RISKS
7511: FROM AMW_FIN_CERT_EVAL_SUM
7512: WHERE FIN_CERTIFICATION_ID = l_cert_id
7513: AND FINANCIAL_STATEMENT_ID = l_stmt_id
7514: AND FINANCIAL_ITEM_ID = l_item_id
7515: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 7519: FROM AMW_FIN_CERT_EVAL_SUM

7515: AND OBJECT_TYPE = 'FINANCIAL ITEM';
7516:
7517: CURSOR Get_Acct_Risk(l_cert_id NUMBER, l_acct_group_id NUMBER, l_acct_id NUMBER) IS
7518: SELECT UNMITIGATED_RISKS, RISKS_VERIFIED, TOTAL_NUMBER_OF_RISKS
7519: FROM AMW_FIN_CERT_EVAL_SUM
7520: WHERE FIN_CERTIFICATION_ID = l_cert_id
7521: AND ACCOUNT_GROUP_ID = l_acct_group_id
7522: AND NATURAL_ACCOUNT_ID = l_acct_id
7523: AND OBJECT_TYPE = 'ACCOUNT';

Line 7614: UPDATE AMW_FIN_CERT_EVAL_SUM

7610: g_refresh_flag := 'Y';
7611: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
7612: ELSE
7613: ********/
7614: UPDATE AMW_FIN_CERT_EVAL_SUM
7615: SET
7616: last_update_date = sysdate,
7617: last_updated_by = fnd_global.user_id,
7618: last_update_login = fnd_global.conc_login_id,

Line 7639: UPDATE AMW_FIN_CERT_EVAL_SUM

7635: g_refresh_flag := 'Y';
7636: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
7637: ELSE
7638: *************/
7639: UPDATE AMW_FIN_CERT_EVAL_SUM
7640: SET
7641: last_update_date = sysdate,
7642: last_updated_by = fnd_global.user_id,
7643: last_update_login = fnd_global.conc_login_id,

Line 7661: UPDATE AMW_FIN_CERT_EVAL_SUM

7657: g_refresh_flag := 'Y';
7658: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
7659: ELSE
7660: ***********/
7661: UPDATE AMW_FIN_CERT_EVAL_SUM
7662: SET
7663: last_update_date = sysdate,
7664: last_updated_by = fnd_global.user_id,
7665: last_update_login = fnd_global.conc_login_id,

Line 7719: UPDATE AMW_FIN_CERT_EVAL_SUM

7715: g_refresh_flag := 'Y';
7716: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
7717: ELSE
7718: *************/
7719: UPDATE AMW_FIN_CERT_EVAL_SUM
7720: SET
7721: last_update_date = sysdate,
7722: last_updated_by = fnd_global.user_id,
7723: last_update_login = fnd_global.conc_login_id,

Line 7741: UPDATE AMW_FIN_CERT_EVAL_SUM

7737: g_refresh_flag := 'Y';
7738: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
7739: ELSE
7740: **********/
7741: UPDATE AMW_FIN_CERT_EVAL_SUM
7742: SET
7743: last_update_date = sysdate,
7744: last_updated_by = fnd_global.user_id,
7745: last_update_login = fnd_global.conc_login_id,

Line 7764: UPDATE AMW_FIN_CERT_EVAL_SUM

7760: g_refresh_flag := 'Y';
7761: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
7762: ELSE
7763: ***************/
7764: UPDATE AMW_FIN_CERT_EVAL_SUM
7765: SET
7766: last_update_date = sysdate,
7767: last_updated_by = fnd_global.user_id,
7768: last_update_login = fnd_global.conc_login_id,

Line 8042: FROM AMW_FIN_CERT_EVAL_SUM

8038:
8039: --Cursor to get old values
8040: CURSOR Get_Item_Ctrl(l_cert_id NUMBER, l_stmt_id NUMBER, l_item_id NUMBER) IS
8041: SELECT INEFFECTIVE_CONTROLS, CONTROLS_VERIFIED, TOTAL_NUMBER_OF_CTRLS
8042: FROM AMW_FIN_CERT_EVAL_SUM
8043: WHERE FIN_CERTIFICATION_ID = l_cert_id
8044: AND FINANCIAL_STATEMENT_ID = l_stmt_id
8045: AND FINANCIAL_ITEM_ID = l_item_id
8046: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 8052: FROM AMW_FIN_CERT_EVAL_SUM

8048:
8049:
8050: CURSOR Get_Acct_Ctrl(l_cert_id NUMBER, l_acct_group_id NUMBER, l_acct_id NUMBER) IS
8051: SELECT INEFFECTIVE_CONTROLS, CONTROLS_VERIFIED, TOTAL_NUMBER_OF_CTRLS
8052: FROM AMW_FIN_CERT_EVAL_SUM
8053: WHERE FIN_CERTIFICATION_ID = l_cert_id
8054: AND ACCOUNT_GROUP_ID = l_acct_group_id
8055: AND NATURAL_ACCOUNT_ID = l_acct_id
8056: AND OBJECT_TYPE = 'ACCOUNT';

Line 8167: UPDATE AMW_FIN_CERT_EVAL_SUM

8163: g_refresh_flag := 'Y';
8164: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
8165: ELSE
8166: *************/
8167: UPDATE AMW_FIN_CERT_EVAL_SUM
8168: SET
8169: last_update_date = sysdate,
8170: last_updated_by = fnd_global.user_id,
8171: last_update_login = fnd_global.conc_login_id,

Line 8189: UPDATE AMW_FIN_CERT_EVAL_SUM

8185: g_refresh_flag := 'Y';
8186: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
8187: ELSE
8188: *************/
8189: UPDATE AMW_FIN_CERT_EVAL_SUM
8190: SET
8191: last_update_date = sysdate,
8192: last_updated_by = fnd_global.user_id,
8193: last_update_login = fnd_global.conc_login_id,

Line 8211: UPDATE AMW_FIN_CERT_EVAL_SUM

8207: g_refresh_flag := 'Y';
8208: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
8209: ELSE
8210: *************/
8211: UPDATE AMW_FIN_CERT_EVAL_SUM
8212: SET
8213: last_update_date = sysdate,
8214: last_updated_by = fnd_global.user_id,
8215: last_update_login = fnd_global.conc_login_id,

Line 8301: UPDATE AMW_FIN_CERT_EVAL_SUM

8297: g_refresh_flag := 'Y';
8298: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
8299: ELSE
8300: ************/
8301: UPDATE AMW_FIN_CERT_EVAL_SUM
8302: SET
8303: last_update_date = sysdate,
8304: last_updated_by = fnd_global.user_id,
8305: last_update_login = fnd_global.conc_login_id,

Line 8323: UPDATE AMW_FIN_CERT_EVAL_SUM

8319: g_refresh_flag := 'Y';
8320: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
8321: ELSE
8322: ****************/
8323: UPDATE AMW_FIN_CERT_EVAL_SUM
8324: SET
8325: last_update_date = sysdate,
8326: last_updated_by = fnd_global.user_id,
8327: last_update_login = fnd_global.conc_login_id,

Line 8345: UPDATE AMW_FIN_CERT_EVAL_SUM

8341: g_refresh_flag := 'Y';
8342: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
8343: ELSE
8344: ***********/
8345: UPDATE AMW_FIN_CERT_EVAL_SUM
8346: SET
8347: last_update_date = sysdate,
8348: last_updated_by = fnd_global.user_id,
8349: last_update_login = fnd_global.conc_login_id,

Line 8687: FROM AMW_FIN_CERT_EVAL_SUM

8683:
8684: --CURSOR TO GET PROCESS INFO FOR AN ITEM when an evaluation
8685: CURSOR Get_Item_Proc(l_cert_id NUMBER, l_stmt_id NUMBER, l_item_id NUMBER) IS
8686: SELECT PROC_WITH_INEFFECTIVE_CONTROLS, PROC_EVALUATED,TOTAL_NUMBER_OF_PROCESSES
8687: FROM AMW_FIN_CERT_EVAL_SUM
8688: WHERE FIN_CERTIFICATION_ID = l_cert_id
8689: AND FINANCIAL_STATEMENT_ID = l_stmt_id
8690: AND FINANCIAL_ITEM_ID = l_item_id
8691: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 8696: FROM AMW_FIN_CERT_EVAL_SUM

8692:
8693: --CURSOR TO GET PROCESS INFO FOR AN ACCOUNT
8694: CURSOR Get_Acct_Proc(l_cert_id NUMBER, l_acct_group_id NUMBER, l_acct_id NUMBER) IS
8695: SELECT PROC_WITH_INEFFECTIVE_CONTROLS, PROC_EVALUATED,TOTAL_NUMBER_OF_PROCESSES
8696: FROM AMW_FIN_CERT_EVAL_SUM
8697: WHERE FIN_CERTIFICATION_ID = l_cert_id
8698: AND ACCOUNT_GROUP_ID = l_acct_group_id
8699: AND NATURAL_ACCOUNT_ID = l_acct_id
8700: AND OBJECT_TYPE = 'ACCOUNT';

Line 8705: FROM AMW_FIN_CERT_EVAL_SUM

8701:
8702: --CURSOR TO GET PROCESS INFO FOR AN ITEM when certification is modified
8703: CURSOR Get_Cert_Item_Proc(l_cert_id NUMBER, l_stmt_id NUMBER, l_item_id NUMBER) IS
8704: SELECT TOTAL_NUMBER_OF_PROCESSES, PROC_PENDING_CERTIFICATION, PROC_CERTIFIED_WITH_ISSUES
8705: FROM AMW_FIN_CERT_EVAL_SUM
8706: WHERE FIN_CERTIFICATION_ID = l_cert_id
8707: AND FINANCIAL_STATEMENT_ID = l_stmt_id
8708: AND FINANCIAL_ITEM_ID = l_item_id
8709: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 8714: FROM AMW_FIN_CERT_EVAL_SUM

8710:
8711: --CURSOR TO GET PROCESS INFO FOR AN ACCOUNT when certification is modified
8712: CURSOR Get_Cert_Acct_Proc(l_cert_id NUMBER, l_acct_group_id NUMBER, l_acct_id NUMBER) IS
8713: SELECT TOTAL_NUMBER_OF_PROCESSES, PROC_PENDING_CERTIFICATION, PROC_CERTIFIED_WITH_ISSUES
8714: FROM AMW_FIN_CERT_EVAL_SUM
8715: WHERE FIN_CERTIFICATION_ID = l_cert_id
8716: AND ACCOUNT_GROUP_ID = l_acct_group_id
8717: AND NATURAL_ACCOUNT_ID = l_acct_id
8718: AND OBJECT_TYPE = 'ACCOUNT';

Line 8850: UPDATE AMW_FIN_CERT_EVAL_SUM

8846: g_refresh_flag := 'Y';
8847: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
8848: ELSE
8849: *************/
8850: UPDATE AMW_FIN_CERT_EVAL_SUM
8851: SET
8852: proc_evaluated = least(proc_evaluated + 1,total_number_of_processes),
8853: last_update_date = sysdate,
8854: last_updated_by = fnd_global.user_id,

Line 8874: UPDATE AMW_FIN_CERT_EVAL_SUM

8870: g_refresh_flag := 'Y';
8871: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
8872: ELSE
8873: ****************/
8874: UPDATE AMW_FIN_CERT_EVAL_SUM
8875: SET
8876: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1, controls_verified),
8877: proc_with_ineff_controls_prcnt = round( (least(m_item_proc_with_ineff_ctrl + 1, controls_verified))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2) * 100,
8878: last_update_date = sysdate,

Line 8896: UPDATE AMW_FIN_CERT_EVAL_SUM

8892: g_refresh_flag := 'Y';
8893: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
8894: ELSE
8895: **************/
8896: UPDATE AMW_FIN_CERT_EVAL_SUM
8897: SET
8898: proc_with_ineffective_controls = greatest(0, proc_with_ineffective_controls - 1),
8899: proc_with_ineff_controls_prcnt = round( (greatest(0,m_item_proc_with_ineff_ctrl - 1))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2) * 100,
8900: last_update_date = sysdate,

Line 8945: UPDATE AMW_FIN_CERT_EVAL_SUM

8941: g_refresh_flag := 'Y';
8942: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
8943: ELSE
8944: **************/
8945: UPDATE AMW_FIN_CERT_EVAL_SUM
8946: SET
8947: proc_evaluated = least(proc_evaluated + 1, total_number_of_processes),
8948: last_update_date = sysdate,
8949: last_updated_by = fnd_global.user_id,

Line 8967: UPDATE AMW_FIN_CERT_EVAL_SUM

8963: g_refresh_flag := 'Y';
8964: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
8965: ELSE
8966: ***************/
8967: UPDATE AMW_FIN_CERT_EVAL_SUM
8968: SET
8969: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1,controls_verified),
8970: proc_with_ineff_controls_prcnt = round( (least(m_item_proc_with_ineff_ctrl + 1, controls_verified))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2) * 100,
8971: last_update_date = sysdate,

Line 8989: UPDATE AMW_FIN_CERT_EVAL_SUM

8985: g_refresh_flag := 'Y';
8986: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
8987: ELSE
8988: ***********/
8989: UPDATE AMW_FIN_CERT_EVAL_SUM
8990: SET
8991: proc_with_ineffective_controls = greatest(0,proc_with_ineffective_controls - 1),
8992: proc_with_ineff_controls_prcnt = round( (greatest(0,m_acc_proc_with_ineff_ctrl - 1))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2) * 100,
8993: last_update_date = sysdate,

Line 9206: UPDATE AMW_FIN_CERT_EVAL_SUM SET

9202: g_refresh_flag := 'Y';
9203: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
9204: ELSE
9205: ***********/
9206: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9207: last_update_date = sysdate,
9208: last_updated_by = fnd_global.user_id,
9209: last_update_login = fnd_global.conc_login_id,
9210: proc_pending_certification = greatest(0, proc_pending_certification - 1),

Line 9230: UPDATE AMW_FIN_CERT_EVAL_SUM SET

9226: g_refresh_flag := 'Y';
9227: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
9228: ELSE
9229: *************/
9230: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9231: last_update_date = sysdate,
9232: last_updated_by = fnd_global.user_id,
9233: last_update_login = fnd_global.conc_login_id,
9234: proc_certified_with_issues = least(0,proc_certified_with_issues -1),

Line 9252: UPDATE AMW_FIN_CERT_EVAL_SUM SET

9248: g_refresh_flag := 'Y';
9249: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
9250: ELSE
9251: ****************/
9252: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9253: last_update_date = sysdate,
9254: last_updated_by = fnd_global.user_id,
9255: last_update_login = fnd_global.conc_login_id,
9256: proc_certified_with_issues = least(proc_certified_with_issues + 1, total_number_of_processes ),

Line 9300: UPDATE AMW_FIN_CERT_EVAL_SUM SET

9296: g_refresh_flag := 'Y';
9297: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
9298: ELSE
9299: ***************/
9300: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9301: last_update_date = sysdate,
9302: last_updated_by = fnd_global.user_id,
9303: last_update_login = fnd_global.conc_login_id,
9304: proc_pending_certification = greatest(0, proc_pending_certification - 1),

Line 9322: UPDATE AMW_FIN_CERT_EVAL_SUM SET

9318: g_refresh_flag := 'Y';
9319: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
9320: ELSE
9321: ***********/
9322: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9323: last_update_date = sysdate,
9324: last_updated_by = fnd_global.user_id,
9325: last_update_login = fnd_global.conc_login_id,
9326: proc_certified_with_issues = greatest(0,proc_certified_with_issues -1),

Line 9343: UPDATE AMW_FIN_CERT_EVAL_SUM SET

9339: g_refresh_flag := 'Y';
9340: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
9341: ELSE
9342: ********************/
9343: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9344: last_update_date = sysdate,
9345: last_updated_by = fnd_global.user_id,
9346: last_update_login = fnd_global.conc_login_id,
9347: proc_certified_with_issues = least(proc_certified_with_issues + 1,total_number_of_processes),

Line 9671: FROM AMW_FIN_CERT_EVAL_SUM

9667:
9668: --CURSOR TO GET ORGANIZATION INFORMATION FOR ITEM
9669: CURSOR Get_Item_Org(l_cert_id number, l_stmt_id number, l_item_id number) IS
9670: SELECT ORG_WITH_INEFFECTIVE_CONTROLS, ORGS_EVALUATED, TOTAL_NUMBER_OF_ORGS
9671: FROM AMW_FIN_CERT_EVAL_SUM
9672: WHERE FIN_CERTIFICATION_ID = l_cert_id
9673: AND FINANCIAL_STATEMENT_ID = l_stmt_id
9674: AND FINANCIAL_ITEM_ID = l_item_id
9675: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 9680: FROM AMW_FIN_CERT_EVAL_SUM

9676:
9677: --CURSOR TO GET ORGANIZATION INFORMATION FOR ACCOUNT
9678: CURSOR Get_Acc_Org(l_cert_id number, l_acct_group_id number, l_acct_id number) IS
9679: SELECT ORG_WITH_INEFFECTIVE_CONTROLS, ORGS_EVALUATED, TOTAL_NUMBER_OF_ORGS
9680: FROM AMW_FIN_CERT_EVAL_SUM
9681: WHERE FIN_CERTIFICATION_ID = l_cert_id
9682: AND ACCOUNT_GROUP_ID = l_acct_group_id
9683: AND NATURAL_ACCOUNT_ID = l_acct_id
9684: AND OBJECT_TYPE = 'ACCOUNT';

Line 9774: UPDATE AMW_FIN_CERT_EVAL_SUM

9770: g_refresh_flag := 'Y';
9771: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
9772: ELSE
9773: ****************/
9774: UPDATE AMW_FIN_CERT_EVAL_SUM
9775: SET
9776: orgs_evaluated = least(orgs_evaluated + 1, total_number_of_orgs),
9777: last_update_date = sysdate,
9778: last_updated_by = fnd_global.user_id,

Line 9795: UPDATE AMW_FIN_CERT_EVAL_SUM

9791: g_refresh_flag := 'Y';
9792: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
9793: ELSE
9794: *************/
9795: UPDATE AMW_FIN_CERT_EVAL_SUM
9796: SET
9797: org_with_ineffective_controls = least(org_with_ineffective_controls + 1, orgs_evaluated),
9798: org_with_ineff_controls_prcnt = round( (least(org_with_ineffective_controls + 1, orgs_evaluated, total_number_of_orgs) )/decode(nvl(total_number_of_orgs, 0), 0, 1, total_number_of_orgs), 2) * 100,
9799: last_update_date = sysdate,

Line 9816: UPDATE AMW_FIN_CERT_EVAL_SUM

9812: g_refresh_flag := 'Y';
9813: m_certification_list(Get_all_items_Rec.fin_certification_id) := Get_all_items_Rec.fin_certification_id;
9814: ELSE
9815: ***************/
9816: UPDATE AMW_FIN_CERT_EVAL_SUM
9817: SET
9818: org_with_ineffective_controls = greatest(0,org_with_ineffective_controls - 1),
9819: org_with_ineff_controls_prcnt = round( (greatest(0, m_item_org_with_ineff_ctrl - 1) )/decode(nvl(m_item_total_orgs, 0), 0, 1, m_item_total_orgs), 2) * 100,
9820: last_update_date = sysdate,

Line 9861: UPDATE AMW_FIN_CERT_EVAL_SUM

9857: g_refresh_flag := 'Y';
9858: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
9859: ELSE
9860: ****************/
9861: UPDATE AMW_FIN_CERT_EVAL_SUM
9862: SET
9863: orgs_evaluated = least(orgs_evaluated + 1, total_number_of_orgs),
9864: last_update_date = sysdate,
9865: last_updated_by = fnd_global.user_id,

Line 9882: UPDATE AMW_FIN_CERT_EVAL_SUM

9878: g_refresh_flag := 'Y';
9879: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
9880: ELSE
9881: **************/
9882: UPDATE AMW_FIN_CERT_EVAL_SUM
9883: SET
9884: org_with_ineffective_controls = least(org_with_ineffective_controls + 1, orgs_evaluated),
9885: proc_with_ineff_controls_prcnt = round( (least(m_acc_org_with_ineff_ctrl + 1, orgs_evaluated))/decode(nvl(m_acc_total_orgs, 0), 0, 1, m_acc_total_orgs), 2) * 100,
9886: last_update_date = sysdate,

Line 9903: UPDATE AMW_FIN_CERT_EVAL_SUM

9899: g_refresh_flag := 'Y';
9900: m_certification_list(Get_all_accts_Rec.fin_certification_id) := Get_all_accts_Rec.fin_certification_id;
9901: ELSE
9902: *******************/
9903: UPDATE AMW_FIN_CERT_EVAL_SUM
9904: SET
9905: org_with_ineffective_controls = greatest(0, org_with_ineffective_controls - 1),
9906: proc_with_ineff_controls_prcnt = round( (m_acc_org_with_ineff_ctrl - 1)/decode(nvl(m_acc_total_orgs, 0), 0, 1, m_acc_total_orgs), 2) * 100,
9907: last_update_date = sysdate,

Line 9934: UPDATE AMW_FIN_CERT_EVAL_SUM SET

9930:
9931: IF(M_opinion_log_id IS NULL OR M_opinion_log_id = 0 ) THEN -- a new certification
9932: M_new_flag := 'Y';
9933:
9934: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9935: LAST_UPDATE_DATE = sysdate,
9936: last_updated_by = fnd_global.user_id,
9937: last_update_login = fnd_global.conc_login_id,
9938: orgs_for_cert_done = least(orgs_for_cert_done + 1, total_number_of_orgs)

Line 9954: UPDATE AMW_FIN_CERT_EVAL_SUM SET

9950:
9951: IF(M_opinion_log_id IS NULL OR M_opinion_log_id = 0 ) THEN --new certification
9952: M_new_flag := 'Y';
9953:
9954: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9955: LAST_UPDATE_DATE = sysdate,
9956: last_updated_by = fnd_global.user_id,
9957: last_update_login = fnd_global.conc_login_id,
9958: orgs_for_cert_done = least(orgs_for_cert_done + 1, total_number_of_orgs)