APPS.AMW_PROC_APPROVAL_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 317: update amw_control_associations

313: and object_type = 'PROCESS'
314: and deletion_date is not null
315: and deletion_approval_date is null;
316:
317: update amw_control_associations
318: set approval_date = APPROV_TXN_DATE
319: where pk1 = p_process_id
320: and object_type = 'RISK'
321: and approval_date is null;

Line 323: update amw_control_associations

319: where pk1 = p_process_id
320: and object_type = 'RISK'
321: and approval_date is null;
322:
323: update amw_control_associations
324: set deletion_approval_date = APPROV_TXN_DATE
325: where pk1 = p_process_id
326: and object_type = 'RISK'
327: and deletion_date is not null

Line 575: select control_id from amw_control_associations where pk1 = pid and object_type = 'RISK';

571: cursor ass_risks (pid number) is
572: select risk_id from amw_risk_associations where pk1 = pid and object_type = 'PROCESS';
573:
574: cursor ass_controls (pid number) is
575: select control_id from amw_control_associations where pk1 = pid and object_type = 'RISK';
576:
577: l_dummy number;
578: unappr_obj_exception exception;
579: err_msg varchar2(4000);