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 FND_PROFILE

Line 1278: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)

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,
1281: AMW_FIN_PROC_CERT_RELAN rel
1282: WHERE aov.object_name = 'AMW_ORG_PROCESS'

Line 1306: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)

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,
1309: AMW_FIN_PROC_CERT_RELAN rel
1310: WHERE aov.object_name = 'AMW_ORG_PROCESS'

Line 1336: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)

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)
1337: AND aov.object_name = 'AMW_ORG_PROCESS'
1338: AND aov.opinion_component_code = 'OVERALL'
1339: AND aov.opinion_type_code = 'CERTIFICATION'
1340: AND aov.pk3_value = proc.organization_id

Line 1366: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)

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)
1367: AND aov.object_name = 'AMW_ORG_PROCESS'
1368: AND aov.opinion_type_code = 'CERTIFICATION'
1369: AND aov.opinion_component_code = 'OVERALL'
1370: AND aov.pk3_value = proc.organization_id

Line 1400: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)

1396: AND proc.organization_id = aov.pk3_value
1397: AND proc.process_id = aov.pk1_value
1398: --fix bug 5724066
1399: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
1400: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)
1401: AND aov.object_name = 'AMW_ORG_PROCESS'
1402: AND aov.opinion_type_code = 'EVALUATION'
1403: AND aov.opinion_component_code = 'OVERALL'
1404: AND aov.authored_date = (select max(aov2.authored_date)

Line 1429: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)

1425: AND proc.organization_id = aov.pk3_value
1426: AND proc.process_id = aov.pk1_value
1427: --fix bug 5724066
1428: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
1429: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)
1430: AND aov.object_name = 'AMW_ORG_PROCESS'
1431: AND aov.opinion_type_code = 'EVALUATION'
1432: AND aov.opinion_component_code = 'OVERALL'
1433: AND aov.authored_date = (select max(aov2.authored_date)

Line 3773: AND aov.pk3_value <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)

3769: FROM AMW_OPINION_MV aov
3770: WHERE aov.object_name = 'AMW_ORG_PROCESS'
3771: AND aov.opinion_type_code = 'CERTIFICATION'
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

Line 3788: NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999);

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);
3789:
3790:
3791: --Begin variant process
3792:

Line 3797: AND organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999);

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
3800: select count(1) from
3801: (SELECT distinct aov.pk3_value,aov.pk1_value

Line 5559: l_sub_vs := FND_PROFILE.value('AMW_SUBSIDIARY_AUDIT_UNIT');

5555: WHERE ENTITY_TYPE = 'FINSTMT_CERTIFICATION'
5556: AND ENTITY_ID = p_certification_id;
5557:
5558:
5559: l_sub_vs := FND_PROFILE.value('AMW_SUBSIDIARY_AUDIT_UNIT');
5560: l_lob_vs := FND_PROFILE.value('AMW_LOB_AUDIT_UNITS');
5561:
5562: l_position := 1;
5563:

Line 5560: l_lob_vs := FND_PROFILE.value('AMW_LOB_AUDIT_UNITS');

5556: AND ENTITY_ID = p_certification_id;
5557:
5558:
5559: l_sub_vs := FND_PROFILE.value('AMW_SUBSIDIARY_AUDIT_UNIT');
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');

Line 9065: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN

9061: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
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,

Line 9099: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN

9095: proc_with_ineff_controls_prcnt = round( (greatest(0, proc_with_ineffective_controls - 1))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9096: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9097: AND ORGANIZATION_ID = p_org_id;
9098: --END IF;
9099: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9100: /********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b
9101: **********( m_dashbd_proc_ineff_ctrl -1 < 0 ) *******************************/
9102: /********* remove 'IF' logic now because the refresh logic is disabled temporarily
9103: IF NOT ( (m_certification_list.exists(get_all_org_cert_rec.fin_certification_id)) OR (g_refresh_flag = 'Y') OR( m_dashbd_proc_ineff_ctrl -1 > 0 ) ) THEN

Line 9151: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN

9147: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
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,

Line 9426: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN

9422: processes_with_issues_prcnt = round( (least(proc_certified_with_issues + 1, proc_certified))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9423: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9424: AND ORGANIZATION_ID = p_org_id;
9425: --END IF;
9426: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9427: /********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b
9428: **********( M_dashbd_proc_not_cert -1 < 0 )*******************************/
9429: /********* remove 'IF' logic now because the refresh logic is disabled temporarily
9430: IF NOT ( (m_certification_list.exists(get_all_org_cert_rec.fin_certification_id)) OR (g_refresh_flag = 'Y') OR( M_dashbd_proc_not_cert -1 > 0 ) ) THEN

Line 9479: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN

9475: processes_with_issues_prcnt = round( (greatest(0, proc_certified_with_issues - 1))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9476: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9477: AND ORGANIZATION_ID = p_org_id;
9478: --END IF;
9479: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9480: /********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b
9481: **********( m_dashbd_proc_cert_issue -1 < 0 ) *******************************/
9482: /********* remove 'IF' logic now because the refresh logic is disabled temporarily
9483: IF NOT ( (m_certification_list.exists(get_all_org_cert_rec.fin_certification_id)) OR (g_refresh_flag = 'Y') OR( m_dashbd_proc_cert_issue -1 > 0 ) ) THEN

Line 9530: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN

9526: processes_with_issues_prcnt = round( (least(proc_certified_with_issues + 1, total_number_of_procs))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
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,