APPS.AMW_ASSOC_POST_TXN dependencies on AMW_CONTROL_ASSOCIATIONS

Line 39: SELECT control_association_id ,control_id from amw_control_associations

35: l_risk_assoc_id number;
36: -- abb added
37:
38: cursor cc5 IS
39: SELECT control_association_id ,control_id from amw_control_associations
40: where object_type='RISK_ORG'
41: and pk1 In (
42: select risk_association_id
43: from amw_risk_associations

Line 87: insert into amw_control_associations

83: IF (p_object = 'RISK_ORG') THEN
84:
85: select risk_association_id into l_risk_assoc_id from amw_risk_associations where risk_id = p_risk_id and pk1 = p_process_organization_id and object_type = 'PROCESS_ORG';
86:
87: insert into amw_control_associations
88: (CONTROL_ASSOCIATION_ID,
89: LAST_UPDATE_DATE,
90: LAST_UPDATED_BY,
91: CREATION_DATE,

Line 117: amw_control_associations_s.nextval,

113: OBJECT_VERSION_NUMBER,
114: EFFECTIVE_DATE_FROM,
115: EFFECTIVE_DATE_TO )
116: ( select
117: amw_control_associations_s.nextval,
118: sysdate,
119: FND_GLOBAL.USER_ID,
120: sysdate,
121: FND_GLOBAL.USER_ID,

Line 145: from amw_control_associations

141: ATTRIBUTE15,
142: 1,
143: EFFECTIVE_DATE_FROM,
144: EFFECTIVE_DATE_TO
145: from amw_control_associations
146: where object_type = 'RISK'
147: and pk1 = p_risk_id);
148:
149: SELECT organization_id into l_org_id2 from amw_process_organization where process_organization_id = p_process_organization_id;

Line 216: and pk1 in (select control_id from amw_control_associations

212: DESIGN_EFFECTIVENESS,
213: OP_EFFECTIVENESS
214: from amw_ap_associations
215: where object_type = 'CTRL'
216: and pk1 in (select control_id from amw_control_associations
217: where object_type = 'RISK'
218: and pk1 = p_risk_id));
219:
220: ELSIF (p_object = 'CONTROL_ORG') THEN

Line 322: not exists ( select control_id from amw_control_associations aca, amw_risk_associations ara

318: and pk2 = ( SELECT process_id from amw_process_organization
319: where process_organization_id = p_process_organization_id )
320: AND pk3 = delete_ctrl_org.control_id
321: and
322: not exists ( select control_id from amw_control_associations aca, amw_risk_associations ara
323: where aca.pk1= ara.risk_association_id
324: and ara.object_type = 'PROCESS_ORG'
325: and aca.object_type = 'RISK_ORG'
326: and control_id = delete_ctrl_org.control_id ) ;

Line 328: delete from amw_control_associations

324: and ara.object_type = 'PROCESS_ORG'
325: and aca.object_type = 'RISK_ORG'
326: and control_id = delete_ctrl_org.control_id ) ;
327:
328: delete from amw_control_associations
329: where control_association_id = delete_ctrl_org.control_association_id ;
330: END LOOP ;
331: CLOSE cc5 ;
332: AMW_WF_HIERARCHY_PKG.reset_proc_org_risk_ctrl_count(l_org_id);

Line 343: not exists ( select control_id from amw_control_associations aca, amw_risk_associations ara

339: and pk2 = ( SELECT process_id from amw_process_organization
340: where process_organization_id = p_process_organization_id )
341: AND pk3 = p_control_id
342: and
343: not exists ( select control_id from amw_control_associations aca, amw_risk_associations ara
344: where aca.pk1= ara.risk_association_id
345: and ara.object_type = 'PROCESS_ORG'
346: and aca.object_type = 'RISK_ORG'
347: and control_id = p_control_id );