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.

[Home] [Help]

APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_RISK_ASSOCIATIONS

Line 699: amw_risk_associations risks

695: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
696: FROM
697: amw_opinion_log_mv aov,
698: amw_fin_item_acc_risk fin,
699: amw_risk_associations risks
700: WHERE risks.pk1 = fin.fin_certification_id
701: and risks.object_type = ''PROCESS_FINCERT''
702: and risks.risk_id = fin.risk_id
703: and risks.pk2 = fin.organization_id

Line 831: amw_risk_associations risks

827: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
828: FROM
829: amw_opinion_log_mv aov,
830: amw_fin_item_acc_risk fin,
831: amw_risk_associations risks
832: WHERE risks.pk1 = fin.fin_certification_id
833: and risks.object_type = ''PROCESS_FINCERT''
834: and risks.risk_id = fin.risk_id
835: and risks.pk2 = fin.organization_id

Line 1475: from AMW_RISK_ASSOCIATIONS risks,

1471: *******/
1472:
1473: ----unmitigated_risks IS
1474: SELECT count(1) INTO x_unmitigated_risks
1475: from AMW_RISK_ASSOCIATIONS risks,
1476: AMW_OPINION_LOG_MV op
1477: where risks.pk1 = p_certification_id
1478: and risks.pk4 = op.opinion_log_id (+)
1479: and op.OPINION_VALUE_CODE <> 'EFFECTIVE'

Line 2411: amw_risk_associations risk

2407: OBJECT_VERSION_NUMBER )
2408: SELECT distinct 'ACCOUNT' OBJECT_TYPE , fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
2409: account_group_id, natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
2410: from amw_fin_cert_scope scp,
2411: amw_risk_associations risk
2412: where risk.pk1 = scp.fin_certification_id
2413: and risk.object_type = 'PROCESS_FINCERT'
2414: and scp.natural_account_id is not null
2415: and scp.organization_id = risk.pk2

Line 2422: amw_risk_associations risk

2418: union all
2419: select distinct 'FINANCIAL ITEM' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, financial_item_id,
2420: null account_group_id, null natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
2421: from amw_fin_cert_scope scp,
2422: amw_risk_associations risk
2423: where risk.pk1 = scp.fin_certification_id
2424: and risk.object_type = 'PROCESS_FINCERT'
2425: and scp.organization_id = risk.pk2
2426: and scp.process_id = risk.pk3

Line 2432: amw_risk_associations risk

2428: union all
2429: select distinct 'FINANCIAL STATEMENT' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
2430: null account_group_id, null natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
2431: from amw_fin_cert_scope scp,
2432: amw_risk_associations risk
2433: where risk.pk1 = scp.fin_certification_id
2434: and risk.object_type = 'PROCESS_FINCERT'
2435: and scp.organization_id = risk.pk2
2436: and scp.process_id = risk.pk3

Line 3151: UPDATE AMW_RISK_ASSOCIATIONS SET

3147: x_return_status => l_return_status,
3148: x_msg_count => l_msg_count,
3149: x_msg_data => l_msg_data);
3150:
3151: UPDATE AMW_RISK_ASSOCIATIONS SET
3152: LAST_UPDATE_DATE = sysdate,
3153: last_updated_by = fnd_global.user_id,
3154: last_update_login = fnd_global.conc_login_id,
3155: pk4 = l_opinion_log_id

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

3390: (p_certification_id => p_certification_id,
3391: x_return_status => l_return_status,
3392: x_msg_count => l_msg_count,
3393: x_msg_data => l_msg_data);
3394: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_risk_associations table:p_certification_id = ' || p_certification_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
3395: Populate_Fin_Ctrl_Ass_Sum
3396: (p_certification_id => p_certification_id,
3397: x_return_status => l_return_status,
3398: x_msg_count => l_msg_count,

Line 4095: AMW_RISK_ASSOCIATIONS ara,

4091:
4092: CURSOR unmitigated_risks IS
4093: SELECT count(1)
4094: FROM
4095: AMW_RISK_ASSOCIATIONS ara,
4096: AMW_FIN_PROCESS_FLAT orgrel,
4097: AMW_OPINION_MV aov
4098: WHERE ara.object_type = 'PROCESS_ORG'
4099: AND ara.pk1 = p_organization_id

Line 4127: AMW_RISK_ASSOCIATIONS ara,

4123:
4124: CURSOR total_risks IS
4125: SELECT count(1)
4126: FROM
4127: AMW_RISK_ASSOCIATIONS ara,
4128: AMW_FIN_PROCESS_FLAT orgrel
4129: WHERE ara.object_type = 'PROCESS_ORG'
4130: AND ara.pk1 = p_organization_id
4131: and orgrel.fin_certification_id = p_certification_id

Line 4145: AMW_RISK_ASSOCIATIONS ara,

4141: CURSOR risks_verified IS
4142: SELECT count(1)
4143: from (select distinct ara.pk1, ara.pk2, ara.risk_id
4144: FROM
4145: AMW_RISK_ASSOCIATIONS ara,
4146: AMW_OPINION_MV aov,
4147: AMW_FIN_PROCESS_FLAT orgrel
4148: WHERE ara.object_type = 'PROCESS_ORG'
4149: AND ara.pk1 = p_organization_id

Line 4597: AMW_RISK_ASSOCIATIONS risks,

4593: risks.DELETION_DATE,
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

Line 4621: AMW_RISK_ASSOCIATIONS risks,

4617: risks.DELETION_DATE,
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

Line 4689: SELECT COUNT(1) INTO l_count FROM AMW_RISK_ASSOCIATIONS

4685: -- Initialize API return status to SUCCESS
4686: x_return_status := FND_API.G_RET_STS_SUCCESS;
4687:
4688:
4689: SELECT COUNT(1) INTO l_count FROM AMW_RISK_ASSOCIATIONS
4690: WHERE object_type = 'PROCESS_FINCERT'
4691: AND pk1 = p_certification_id;
4692:
4693: IF (l_count = 0) THEN

Line 4704: INSERT INTO AMW_RISK_ASSOCIATIONS(

4700: CLOSE last_evaluation;
4701:
4702:
4703:
4704: INSERT INTO AMW_RISK_ASSOCIATIONS(
4705: RISK_ASSOCIATION_ID,
4706: RISK_ID,
4707: PK1,
4708: PK2,

Line 4723: VALUES ( amw_risk_associations_s.nextval,

4719: APPROVAL_DATE,
4720: DELETION_DATE,
4721: DELETION_APPROVAL_DATE,
4722: RISK_REV_ID)
4723: VALUES ( amw_risk_associations_s.nextval,
4724: risk_rec.risk_id,
4725: p_certification_id,
4726: risk_rec.PK1,
4727: risk_rec.PK2,

Line 4757: update AMW_RISK_ASSOCIATIONS /need only to update the opinionLogId here/

4753: OPEN last_evaluation(risk_rec.risk_id, risk_rec.pk1, risk_rec.pk2);
4754: FETCH last_evaluation INTO m_opinion_log_id;
4755: CLOSE last_evaluation;
4756:
4757: update AMW_RISK_ASSOCIATIONS /**need only to update the opinionLogId here**/
4758: set PK4 = m_opinion_log_id,
4759: LAST_UPDATE_DATE = sysdate,
4760: LAST_UPDATED_BY = fnd_global.USER_ID,
4761: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,

Line 4932: AMW_RISK_ASSOCIATIONS risks,

4928: controls.DELETION_DATE,
4929: controls.DELETION_APPROVAL_DATE,
4930: control.CONTROL_REV_ID
4931: FROM
4932: AMW_RISK_ASSOCIATIONS risks,
4933: AMW_CONTROL_ASSOCIATIONS controls,
4934: AMW_CONTROLS_B control
4935: WHERE
4936: controls.object_type='RISK_ORG'

Line 4960: AMW_RISK_ASSOCIATIONS risks,

4956: controls.DELETION_DATE,
4957: controls.DELETION_APPROVAL_DATE,
4958: control.CONTROL_REV_ID
4959: FROM
4960: AMW_RISK_ASSOCIATIONS risks,
4961: AMW_CONTROL_ASSOCIATIONS controls,
4962: AMW_CONTROLS_B control
4963: WHERE
4964: controls.object_type='ENTITY_CONTROL'

Line 5803: FROM AMW_RISK_ASSOCIATIONS ara,

5799:
5800:
5801: CURSOR unmitigated_risks IS
5802: SELECT count(distinct ara.risk_association_id)
5803: FROM AMW_RISK_ASSOCIATIONS ara,
5804: AMW_OPINION_MV aov
5805: WHERE ara.object_type = 'PROCESS_FINCERT'
5806: AND ara.pk1= p_certification_id
5807: AND ara.pk2= p_organization_id

Line 5827: FROM AMW_RISK_ASSOCIATIONS ara

5823:
5824:
5825: CURSOR total_risks IS
5826: SELECT count(distinct ara.risk_association_id)
5827: FROM AMW_RISK_ASSOCIATIONS ara
5828: WHERE ara.object_type = 'PROCESS_FINCERT'
5829: AND ara.pk1= p_certification_id
5830: AND ara.pk2= p_organization_id;
5831:

Line 5834: FROM AMW_RISK_ASSOCIATIONS ara,

5830: AND ara.pk2= p_organization_id;
5831:
5832: CURSOR verified_risks IS
5833: SELECT count(distinct ara.risk_association_id)
5834: FROM AMW_RISK_ASSOCIATIONS ara,
5835: AMW_OPINION_MV aov
5836: WHERE ara.object_type = 'PROCESS_FINCERT'
5837: AND ara.pk1= p_certification_id
5838: AND ara.pk2= p_organization_id

Line 6941: FROM AMW_RISK_ASSOCIATIONS

6937: IS
6938:
6939: CURSOR new_risks_added IS
6940: SELECT count(1)
6941: FROM AMW_RISK_ASSOCIATIONS
6942: WHERE association_creation_date >= (SELECT period.start_date
6943: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
6944: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
6945: AND cert.certification_period_set_name = period.period_set_name

Line 7484: FROM AMW_RISK_ASSOCIATIONS

7480:
7481: --CURSOR TO GET OLD EVAL OPINION ID
7482: CURSOR Get_old_opinion_id(l_cert_id number, l_org_id number, l_process_id number) IS
7483: SELECT PK4
7484: FROM AMW_RISK_ASSOCIATIONS
7485: WHERE OBJECT_TYPE = 'PROCESS_FINCERT'
7486: AND PK1 = l_cert_id
7487: AND PK2 = l_org_id
7488: AND PK3 = l_process_id

Line 10023: AMW_RISK_ASSOCIATIONS risks,

10019: risks.DELETION_DATE,
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

Line 10047: AMW_RISK_ASSOCIATIONS risks,

10043: risks.DELETION_DATE,
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

Line 10119: SELECT COUNT(1) INTO l_count FROM AMW_RISK_ASSOCIATIONS

10115: -- Initialize API return status to SUCCESS
10116: x_return_status := FND_API.G_RET_STS_SUCCESS;
10117:
10118:
10119: SELECT COUNT(1) INTO l_count FROM AMW_RISK_ASSOCIATIONS
10120: WHERE object_type = 'PROCESS_FINCERT'
10121: AND pk1 = p_certification_id;
10122:
10123: IF (l_count = 0) THEN

Line 10134: INSERT INTO AMW_RISK_ASSOCIATIONS(

10130: CLOSE last_evaluation;
10131:
10132:
10133:
10134: INSERT INTO AMW_RISK_ASSOCIATIONS(
10135: RISK_ASSOCIATION_ID,
10136: RISK_ID,
10137: PK1,
10138: PK2,

Line 10153: VALUES ( amw_risk_associations_s.nextval,

10149: APPROVAL_DATE,
10150: DELETION_DATE,
10151: DELETION_APPROVAL_DATE,
10152: RISK_REV_ID)
10153: VALUES ( amw_risk_associations_s.nextval,
10154: risk_rec.risk_id,
10155: p_certification_id,
10156: risk_rec.PK1,
10157: risk_rec.PK2,

Line 10233: AMW_RISK_ASSOCIATIONS risks,

10229: controls.DELETION_DATE,
10230: controls.DELETION_APPROVAL_DATE,
10231: control.CONTROL_REV_ID
10232: FROM
10233: AMW_RISK_ASSOCIATIONS risks,
10234: AMW_CONTROL_ASSOCIATIONS controls,
10235: AMW_CONTROLS_B control
10236: WHERE
10237: controls.object_type='RISK_ORG'

Line 10257: AMW_RISK_ASSOCIATIONS risks,

10253: controls.DELETION_DATE,
10254: controls.DELETION_APPROVAL_DATE,
10255: control.CONTROL_REV_ID
10256: FROM
10257: AMW_RISK_ASSOCIATIONS risks,
10258: AMW_CONTROL_ASSOCIATIONS controls,
10259: AMW_CONTROLS_B control
10260: WHERE
10261: controls.object_type='ENTITY_CONTROL'