[Home] [Help]
199: OPEN c_fch_vs_id;
200: FETCH c_fch_vs_id into l_fch_vs_id;
201: CLOSE c_fch_vs_id;
202:
203: IF fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT') = to_char(l_fch_vs_id) THEN
204: amw_org_cert_aggr_pkg.populate_full_hierarchies(l_errbuf,l_retcode,l_cert_id);
205: END IF;
206:
207: commit;
435: round(least(ineff_processes+1,evaluated_processes+1,total_processes)/total_processes*100))
436: WHERE certification_id = proc_rec.certification_id
437: AND organization_id = l_pk3;
438: --END IF;
439: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
440: UPDATE amw_cert_dashboard_sum
441: SET last_update_date = sysdate,
442: last_updated_by = fnd_global.user_id,
443: last_update_login = fnd_global.conc_login_id,
488: round(least(ineff_processes+1,evaluated_processes,total_processes)/total_processes*100))
489: WHERE certification_id = proc_rec.certification_id
490: AND organization_id = l_pk3;
491: --END IF;
492: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
493: UPDATE amw_cert_dashboard_sum
494: SET last_update_date = sysdate,
495: last_updated_by = fnd_global.user_id,
496: last_update_login = fnd_global.conc_login_id,
523: round(greatest(0,ineff_processes-1)/total_processes*100))
524: WHERE certification_id = proc_rec.certification_id
525: AND organization_id = l_pk3;
526: --END IF;
527: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
528: /********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
529: /********* remove 'IF' logic now because the refresh logic is disabled temporarily
530: IF NOT ( (m_certification_list.exists(proc_rec.certification_id)) OR (g_refresh_flag = 'Y') OR (M_dashbd_proc_ineff_ctrl -1 > 0 ) ) THEN
531: g_refresh_flag := 'Y';
1192: OPEN c_fch_vs_id;
1193: FETCH c_fch_vs_id into l_fch_vs_id;
1194: CLOSE c_fch_vs_id;
1195:
1196: IF fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT') = to_char(l_fch_vs_id) THEN
1197:
1198: FOR FCH_Get_cert_info_rec IN FCH_Get_cert_info(l_fch_org_id) LOOP
1199: amw_org_cert_aggr_pkg.update_org_cert_aggr_rows(FCH_Get_cert_info_rec.certification_id, l_fch_org_id);
1200: END LOOP;
1582: AND organization_id = l_pk3;
1583: --END IF;
1584:
1585:
1586: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1587: /************ If the display format is a/b/c, then a >= 0 and b>= a and c>= b
1588: ************IF (M_dashbd_proc_not_cert -1 < 0 )THEN *************/
1589: /********* remove 'IF' logic now because the refresh logic is disabled temporarily
1590: IF NOT ( (m_certification_list.exists(l_pk2)) OR (g_refresh_flag = 'Y') OR (M_dashbd_proc_not_cert -1 > 0 ) ) THEN
1642: WHERE certification_id = l_pk2
1643: AND organization_id = l_pk3;
1644: --END IF;
1645:
1646: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1647: UPDATE amw_cert_dashboard_sum
1648: SET last_update_date = sysdate,
1649: last_updated_by = fnd_global.user_id,
1650: last_update_login = fnd_global.conc_login_id,
1683: AND organization_id = l_pk3;
1684: --END IF;
1685:
1686:
1687: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1688: /********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b
1689: **********IF (M_dashbd_proc_not_cert -1 < 0 )THEN *********************/
1690: /********* remove 'IF' logic now because the refresh logic is disabled temporarily
1691: IF NOT ( (m_certification_list.exists(l_pk2)) OR (g_refresh_flag = 'Y') OR (M_dashbd_proc_not_cert -1 > 0 ) ) THEN
1740: WHERE certification_id = l_pk2
1741: AND organization_id = l_pk3;
1742: --END IF;
1743:
1744: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1745: UPDATE amw_cert_dashboard_sum
1746: SET last_update_date = sysdate,
1747: last_updated_by = fnd_global.user_id,
1748: last_update_login = fnd_global.conc_login_id,
1973: OPEN c_fch_vs_id;
1974: FETCH c_fch_vs_id into l_fch_vs_id;
1975: CLOSE c_fch_vs_id;
1976:
1977: IF fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT') = to_char(l_fch_vs_id) THEN
1978: amw_org_cert_aggr_pkg.update_org_cert_aggr_rows(l_fch_cert_id, l_fch_org_id);
1979: END IF;
1980:
1981: -- somehow the change was not being committed to db without