APPS.AMW_PROJECT_EVENT_PVT dependencies on AMW_AUDIT_SCOPE_ORGANIZATIONS

Line 27: FROM AMW_AUDIT_SCOPE_ORGANIZATIONS

23: ) return VARCHAR2
24: IS
25: CURSOR c_new_org(c_audit_proj_id NUMBER) IS
26: SELECT organization_id
27: FROM AMW_AUDIT_SCOPE_ORGANIZATIONS
28: WHERE audit_project_id = c_audit_proj_id
29: AND unmitigated_risks IS NULL;
30:
31: CURSOR c_proj_org(c_audit_proj_id NUMBER) IS

Line 33: FROM AMW_AUDIT_SCOPE_ORGANIZATIONS

29: AND unmitigated_risks IS NULL;
30:
31: CURSOR c_proj_org(c_audit_proj_id NUMBER) IS
32: SELECT organization_id
33: FROM AMW_AUDIT_SCOPE_ORGANIZATIONS
34: WHERE audit_project_id = c_audit_proj_id;
35:
36:
37: CURSOR c_new_proc(c_audit_proj_id NUMBER) IS

Line 184: UPDATE amw_audit_scope_organizations

180: into l_ineff_diff
181: from dual;
182:
183: IF l_obj_name = 'AMW_ORGANIZATION' THEN
184: UPDATE amw_audit_scope_organizations
185: SET last_update_date = sysdate,
186: last_updated_by = fnd_global.user_id,
187: last_update_login = fnd_global.conc_login_id,
188: evaluation_opinion_id = l_opin_id

Line 192: UPDATE amw_audit_scope_organizations

188: evaluation_opinion_id = l_opin_id
189: WHERE organization_id = l_pk1
190: AND audit_project_id = l_pk2;
191:
192: UPDATE amw_audit_scope_organizations
193: SET last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.conc_login_id,
196: sub_orgs_evaluated = least(sub_orgs_evaluated+l_evaluated_diff,total_sub_orgs),

Line 222: UPDATE amw_audit_scope_organizations

218: WHERE process_id = l_pk1
219: AND audit_project_id = l_pk2
220: AND organization_id = l_pk3;
221:
222: UPDATE amw_audit_scope_organizations
223: SET last_update_date = sysdate,
224: last_updated_by = fnd_global.user_id,
225: last_update_login = fnd_global.conc_login_id,
226: processes_evaluated = least(processes_evaluated+l_evaluated_diff,total_processes),

Line 232: UPDATE amw_audit_scope_organizations

228: least(greatest(0,ineffective_processes+l_ineff_diff),processes_evaluated+l_evaluated_diff,total_processes)
229: WHERE audit_project_id = l_pk2
230: AND organization_id = l_pk3;
231: ELSIF l_obj_name = 'AMW_ORG_PROCESS_RISK' THEN
232: UPDATE amw_audit_scope_organizations
233: SET last_update_date = sysdate,
234: last_updated_by = fnd_global.user_id,
235: last_update_login = fnd_global.conc_login_id,
236: risks_evaluated =

Line 266: UPDATE amw_audit_scope_organizations

262: AND entity_type = PRIOR entity_type);
263:
264: ELSIF l_obj_name = 'AMW_ORG_CONTROL' THEN
265:
266: UPDATE amw_audit_scope_organizations
267: SET last_update_date = sysdate,
268: last_updated_by = fnd_global.user_id,
269: last_update_login = fnd_global.conc_login_id,
270: controls_evaluated =

Line 560: UPDATE amw_audit_scope_organizations

556: 'PROJECT', p_audit_project_id,
557: null, null,
558: null, null, null, null);
559:
560: UPDATE amw_audit_scope_organizations
561: SET sub_orgs_evaluated = l_evaluated_sub_orgs,
562: ineffective_sub_orgs = l_ineff_sub_orgs,
563: total_sub_orgs = l_total_sub_orgs,
564: processes_evaluated = l_evaluated_processes,

Line 581: INSERT INTO amw_audit_scope_organizations (

577: WHERE audit_project_id = p_audit_project_id
578: AND organization_id = p_org_id;
579:
580: IF (SQL%NOTFOUND) THEN
581: INSERT INTO amw_audit_scope_organizations (
582: audit_project_id,
583: subsidiary_vs,
584: subsidiary_code,
585: lob_vs,

Line 904: FROM AMW_AUDIT_SCOPE_ORGANIZATIONS

900: where AUDIT_PROJECT_STATUS = 'ACTI';
901:
902: CURSOR c_scope_org(l_audit_project_id NUMBER) IS
903: SELECT organization_id
904: FROM AMW_AUDIT_SCOPE_ORGANIZATIONS
905: WHERE audit_project_id = l_audit_project_id;
906:
907: CURSOR c_org_proc(l_audit_project_id NUMBER, l_org_id NUMBER) IS
908: SELECT process_id