APPS.AMW_ASSOC_POST_TXN dependencies on AMW_WF_HIERARCHY_PKG

Line 299: AMW_WF_HIERARCHY_PKG.reset_process_risk_ctrl_count;

295:
296:
297: IF (p_association_mode = 'ASSOCIATE') THEN
298: IF ( (p_object = 'RISK') OR (p_object = 'CONTROL') ) THEN
299: AMW_WF_HIERARCHY_PKG.reset_process_risk_ctrl_count;
300: ELSIF ( (p_object = 'RISK_ORG') OR (p_object = 'CONTROL_ORG') ) THEN
301: AMW_WF_HIERARCHY_PKG.reset_proc_org_risk_ctrl_count(l_org_id);
302: END IF;
303:

Line 301: AMW_WF_HIERARCHY_PKG.reset_proc_org_risk_ctrl_count(l_org_id);

297: IF (p_association_mode = 'ASSOCIATE') THEN
298: IF ( (p_object = 'RISK') OR (p_object = 'CONTROL') ) THEN
299: AMW_WF_HIERARCHY_PKG.reset_process_risk_ctrl_count;
300: ELSIF ( (p_object = 'RISK_ORG') OR (p_object = 'CONTROL_ORG') ) THEN
301: AMW_WF_HIERARCHY_PKG.reset_proc_org_risk_ctrl_count(l_org_id);
302: END IF;
303:
304: ELSIF (p_association_mode = 'DISASSOCIATE') THEN
305: IF ( (p_object = 'RISK') OR (p_object = 'CONTROL') )THEN

Line 306: AMW_WF_HIERARCHY_PKG.reset_process_risk_ctrl_count;

302: END IF;
303:
304: ELSIF (p_association_mode = 'DISASSOCIATE') THEN
305: IF ( (p_object = 'RISK') OR (p_object = 'CONTROL') )THEN
306: AMW_WF_HIERARCHY_PKG.reset_process_risk_ctrl_count;
307: ELSIF (p_object = 'RISK_ORG') THEN
308: OPEN cc5;
309: LOOP
310: FETCH cc5 INTO delete_ctrl_org;

Line 332: AMW_WF_HIERARCHY_PKG.reset_proc_org_risk_ctrl_count(l_org_id);

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);
333: ELSIF (p_object = 'CONTROL_ORG') THEN
334: -- added mpande 11/14/2003
335: delete from amw_ap_associations
336: where object_type='CTRL_ORG'

Line 348: AMW_WF_HIERARCHY_PKG.reset_proc_org_risk_ctrl_count(l_org_id);

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 );
348: AMW_WF_HIERARCHY_PKG.reset_proc_org_risk_ctrl_count(l_org_id);
349:
350: END IF;
351: END IF;
352: