APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_FIN_PROCESS_EVAL_SUM

Line 1788: UPDATE AMW_FIN_PROCESS_EVAL_SUM

1784: null;
1785: END;
1786:
1787:
1788: UPDATE AMW_FIN_PROCESS_EVAL_SUM
1789: SET CERT_OPINION_ID = l_cert_opinion_id,
1790: EVAL_OPINION_ID = l_eval_opinion_id,
1791: UNMITIGATED_RISKS = l_unmitigated_risks,
1792: INEFFECTIVE_CONTROLS = l_ineffective_controls,

Line 1808: INSERT INTO AMW_FIN_PROCESS_EVAL_SUM(

1804: AND organization_id = p_organization_id
1805: AND process_id = p_process_id;
1806:
1807: IF (SQL%NOTFOUND) THEN
1808: INSERT INTO AMW_FIN_PROCESS_EVAL_SUM(
1809: FIN_CERTIFICATION_ID,
1810: PROCESS_ID,
1811: ORGANIZATION_ID,
1812: CERT_OPINION_ID,

Line 2037: from amw_fin_process_eval_sum evalsum

2033: AND aov.opinion_type_code = 'CERTIFICATION'
2034: AND aov.pk3_value <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)
2035: AND aov.pk1_value = p_process_id
2036: AND aov.pk3_value in (select distinct evalsum.organization_id
2037: from amw_fin_process_eval_sum evalsum
2038: where evalsum.fin_certification_id = p_cert_id
2039: and evalsum.process_id=p_process_id)
2040: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
2041: where fin_stmt_cert_id = p_cert_id);

Line 2045: from amw_fin_process_eval_sum evalsum

2041: where fin_stmt_cert_id = p_cert_id);
2042:
2043: CURSOR total_org_processes(p_cert_id NUMBER,p_process_id NUMBER) IS
2044: select count(distinct evalsum.organization_id)
2045: from amw_fin_process_eval_sum evalsum
2046: where evalsum.fin_certification_id = p_cert_id
2047: and evalsum.process_id=p_process_id
2048: and evalsum.organization_id <>
2049: NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999);

Line 2055: FROM AMW_FIN_PROCESS_EVAL_SUM

2051: --Begin variant process
2052:
2053: CURSOR var_procs(p_cert_id NUMBER) IS
2054: SELECT fin_certification_id,organization_id,process_id
2055: FROM AMW_FIN_PROCESS_EVAL_SUM
2056: WHERE fin_certification_id = p_cert_id
2057: AND organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999);
2058:
2059: CURSOR org_var_processes_certified(p_cert_id NUMBER,p_start_date DATE,p_end_date DATE,p_process_id NUMBER) IS

Line 2076: from amw_fin_process_eval_sum evalsum

2072: FROM AMW_PROCESS varproc
2073: WHERE varproc.standard_variation = p_process_id
2074: AND varproc.standard_process_flag = 'N'
2075: AND varproc.process_id in (select distinct evalsum.process_id
2076: from amw_fin_process_eval_sum evalsum
2077: where evalsum.fin_certification_id = p_cert_id)));
2078:
2079:
2080: CURSOR total_org_var_processes(p_cert_id NUMBER,p_process_id NUMBER) IS

Line 2083: from amw_fin_process_eval_sum evalsum

2079:
2080: CURSOR total_org_var_processes(p_cert_id NUMBER,p_process_id NUMBER) IS
2081: select count(1) from
2082: (select distinct evalsum.organization_id,evalsum.process_id
2083: from amw_fin_process_eval_sum evalsum
2084: where evalsum.fin_certification_id = p_cert_id
2085: and evalsum.process_id in (select varproc.process_id
2086: FROM AMW_PROCESS varproc
2087: WHERE varproc.standard_variation = p_process_id

Line 2103: DELETE from AMW_FIN_PROCESS_EVAL_SUM

2099: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);
2100:
2101: IF p_certification_id IS NOT NULL THEN
2102:
2103: DELETE from AMW_FIN_PROCESS_EVAL_SUM
2104: WHERE fin_certification_id = p_certification_id;
2105:
2106: OPEN c_period_dates;
2107: FETCH c_period_dates INTO l_start_date,l_end_date;

Line 2145: UPDATE AMW_FIN_PROCESS_EVAL_SUM

2141:
2142: l_total_org_processes := l_total_org_processes+
2143: l_total_org_var_processes;
2144:
2145: UPDATE AMW_FIN_PROCESS_EVAL_SUM
2146: SET TOTAL_NUMBER_OF_ORG_PROCS = l_total_org_processes,
2147: NUMBER_OF_ORG_PROCS_CERTIFIED = l_org_processes_certified,
2148: ORG_PROCS_CERTIFIED_PRCNT =
2149: round(((l_org_processes_certified/decode(l_total_org_processes,0,1,l_total_org_processes)) *100),0)

Line 2161: DELETE from AMW_FIN_PROCESS_EVAL_SUM

2157: COMMIT;
2158: ELSE
2159: FOR cert_rec IN c_cert LOOP
2160:
2161: DELETE from AMW_FIN_PROCESS_EVAL_SUM
2162: WHERE fin_certification_id = cert_rec.certification_id;
2163:
2164: FOR process_rec IN c_process(cert_rec.certification_id) LOOP
2165: Populate_Fin_Process_Eval_Sum(cert_rec.certification_id,cert_rec.start_date,cert_rec.end_date,process_rec.process_organization_id,

Line 2197: UPDATE AMW_FIN_PROCESS_EVAL_SUM

2193: CLOSE total_org_processes;
2194: l_total_org_processes := l_total_org_processes+
2195: l_total_org_var_processes;
2196:
2197: UPDATE AMW_FIN_PROCESS_EVAL_SUM
2198: SET TOTAL_NUMBER_OF_ORG_PROCS = l_total_org_processes,
2199: NUMBER_OF_ORG_PROCS_CERTIFIED = l_org_processes_certified,
2200: ORG_PROCS_CERTIFIED_PRCNT =
2201: round(((l_org_processes_certified/decode(l_total_org_processes,0,1,l_total_org_processes)) *100),0)