APPS.AMW_DELETE_OBJECT_PVT dependencies on AMW_AP_ASSOCIATIONS

Line 29: ,G_VARCHAR_VARRAY('select object_type from amw_ap_associations where ( object_type = ''CTRL'' and pk1 =:1 ) or (object_type = ''CTRL_ORG'' and pk3 =:1) ','Y')

25:
26: -- Control query check list
27: t_ctrl_dynamic_sql_list G_VARRAY_TABLE := G_VARRAY_TABLE(
28: G_VARCHAR_VARRAY('select control_id from amw_control_associations where control_id = :1','Y')
29: ,G_VARCHAR_VARRAY('select object_type from amw_ap_associations where ( object_type = ''CTRL'' and pk1 =:1 ) or (object_type = ''CTRL_ORG'' and pk3 =:1) ','Y')
30: );
31:
32:
33: -- Audit Procedure query check list

Line 38: ||' FROM amw_ap_associations '

34: t_ap_dynamic_sql_list G_VARRAY_TABLE := G_VARRAY_TABLE(
35: G_VARCHAR_VARRAY( 'SELECT control_id '
36: ||' FROM amw_control_associations WHERE control_id IN ( '
37: ||' SELECT pk1 '
38: ||' FROM amw_ap_associations '
39: ||' WHERE audit_procedure_id = :1 '
40: ||' AND object_type = ''CTRL'' '
41: ||' UNION '
42: ||' SELECT pk2 '

Line 43: ||' FROM amw_ap_associations '

39: ||' WHERE audit_procedure_id = :1 '
40: ||' AND object_type = ''CTRL'' '
41: ||' UNION '
42: ||' SELECT pk2 '
43: ||' FROM amw_ap_associations '
44: ||' WHERE object_type =''ENTITY_AP'' '
45: ||' AND audit_procedure_id = :1 '
46: ||' AND deletion_date IS NULL '
47: ||' UNION '

Line 49: ||' FROM amw_ap_associations '

45: ||' AND audit_procedure_id = :1 '
46: ||' AND deletion_date IS NULL '
47: ||' UNION '
48: ||' SELECT pk3 '
49: ||' FROM amw_ap_associations '
50: ||' WHERE object_type =''PROJECT'' '
51: ||' AND audit_procedure_id = :1 '
52: ||' AND deletion_date IS NULL '
53: ||' UNION '

Line 55: ||' FROM amw_ap_associations '

51: ||' AND audit_procedure_id = :1 '
52: ||' AND deletion_date IS NULL '
53: ||' UNION '
54: ||' SELECT pk3 '
55: ||' FROM amw_ap_associations '
56: ||' WHERE object_type in (''CTRL_ORG'',''CTRL_FINCERT'',''BUSIPROC_CERTIFICATION'') '
57: ||' AND audit_procedure_id = :1 ) ','Y')
58: );
59:

Line 383: DELETE FROM AMW_AP_ASSOCIATIONS WHERE audit_procedure_id = p_ap_id;

379: FORALL i IN l_ap_rev_id_list.FIRST .. l_ap_rev_id_list.LAST
380: DELETE FROM AMW_AUDIT_PROCEDURES_TL WHERE audit_procedure_rev_id = l_ap_rev_id_list(i);
381:
382: DELETE FROM AMW_AUDIT_PROCEDURES_B WHERE audit_procedure_id = p_ap_id;
383: DELETE FROM AMW_AP_ASSOCIATIONS WHERE audit_procedure_id = p_ap_id;
384:
385: FND_FILE.put_line(fnd_file.log, 'Delete Audit Procedure : audit_procedure_id = '||p_ap_id);
386:
387: