APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_PROC_CERT_EVAL_SUM

Line 103: Update AMW_PROC_CERT_EVAL_SUM

99:
100: -- /* Update the summary table with the certified subprocess info*/
101:
102: g_user_id := fnd_global.user_id;
103: Update AMW_PROC_CERT_EVAL_SUM
104: SET SUB_PROCESS_CERT = l_sum_certified,TOTAL_SUB_PROCESS_CERT = l_subprocess_total, LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = G_USER_ID
105: where PROCESS_ID = p_process_id and CERTIFICATION_ID = p_certification_id and ORGANIZATION_ID = p_org_id;
106:
107: EXCEPTION

Line 136: Update AMW_PROC_CERT_EVAL_SUM

132:
133: BEGIN
134: g_user_id := fnd_global.user_id;
135:
136: Update AMW_PROC_CERT_EVAL_SUM
137: SET (CERTIFICATION_OPINION_ID) =
138: (select opinion.OPINION_ID
139: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype
140: WHERE

Line 190: Update AMW_PROC_CERT_EVAL_SUM

186:
187: -- Set Global Process flag for each row of the global process, also update the total no. of orgs in which
188: -- the process is executed in
189: g_user_id := fnd_global.user_id;
190: Update AMW_PROC_CERT_EVAL_SUM
191: SET TOTAL_ORG_PROCESS_CERT =
192: (Select distinct count(*) from AMW_PROCESS_ORGANIZATION processorg where
193: (processorg.PROCESS_ID = p_process_id) and
194: (processorg.ORGANIZATION_ID = p_global_org_id))

Line 200: Update AMW_PROC_CERT_EVAL_SUM

196: where PROCESS_ID = p_process_id and CERTIFICATION_ID = p_certification_id
197: and ORGANIZATION_ID = p_global_org_id;
198:
199: -- Update the row again with number of orgs where the process is certified
200: Update AMW_PROC_CERT_EVAL_SUM
201: SET ORG_PROCESS_CERT =
202: (
203: select distinct count(*)
204: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype

Line 252: Update AMW_PROC_CERT_EVAL_SUM

248:
249: BEGIN
250: g_user_id := fnd_global.user_id;
251:
252: Update AMW_PROC_CERT_EVAL_SUM
253: SET (EVALUATION_OPINION_ID) =
254: (
255: select opinion.OPINION_ID
256: FROM AMW_OPINIONS_V opinion, AMW_OPINION_TYPES_TL opiniontype, FND_OBJECTS fndobject, AMW_OBJECT_OPINION_TYPES objectopiniontype

Line 297: Update AMW_PROC_CERT_EVAL_SUM

293:
294: BEGIN
295: g_user_id := fnd_global.user_id;
296:
297: Update AMW_PROC_CERT_EVAL_SUM
298: SET UNMITIGATED_RISKS =
299: (
300: select distinct count(*)
301: from amw_risk_associations assoctable,

Line 375: Update AMW_PROC_CERT_EVAL_SUM

371:
372: BEGIN
373: g_user_id := fnd_global.user_id;
374:
375: Update AMW_PROC_CERT_EVAL_SUM
376: SET INEFFECTIVE_CONTROLS =
377: (select distinct Count(*)
378:
379: from amw_control_associations ctrlassoc,

Line 479: select count(*) into l_count from amw_proc_cert_eval_sum

475: g_login_id := fnd_global.conc_login_id;
476:
477: for proc_rec in proc loop
478:
479: select count(*) into l_count from amw_proc_cert_eval_sum
480: where certification_id = p_certification_id and
481: process_id = proc_rec.process_id and organization_id = proc_rec.organization_id;
482:
483: if l_count = 0 then

Line 485: INSERT into AMW_PROC_CERT_EVAL_SUM(CERTIFICATION_ID, PROCESS_ID, ORGANIZATION_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, lAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

481: process_id = proc_rec.process_id and organization_id = proc_rec.organization_id;
482:
483: if l_count = 0 then
484:
485: INSERT into AMW_PROC_CERT_EVAL_SUM(CERTIFICATION_ID, PROCESS_ID, ORGANIZATION_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, lAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
486: VALUES (p_certification_id, proc_rec.PROCESS_ID, proc_rec.ORGANIZATION_ID,G_USER_ID,SYSDATE,G_USER_ID,SYSDATE,G_LOGIN_ID);
487:
488: end if;
489: