APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 497: update amw_control_associations

493: and object_type = 'PROCESS_ORG'
494: and deletion_date is not null
495: and deletion_approval_date is null;
496:
497: update amw_control_associations
498: set approval_date = APPROV_TXN_DATE
499: where pk2 = p_process_id
500: and pk1 = p_org_id
501: and object_type = 'RISK_ORG'

Line 504: update amw_control_associations

500: and pk1 = p_org_id
501: and object_type = 'RISK_ORG'
502: and approval_date is null;
503:
504: update amw_control_associations
505: set deletion_approval_date = APPROV_TXN_DATE
506: where pk2 = p_process_id
507: and pk1 = p_org_id
508: and object_type = 'RISK_ORG'

Line 557: amw_control_associations

553: and pk1 = p_org_id
554: and pk2 = p_process_id
555: and association_creation_date is not null
556: and pk3 not in ( SELECT control_id from
557: amw_control_associations
558: where object_type = 'RISK_ORG'
559: AND PK1 = p_org_id
560: AND PK2 = p_process_id
561: AND approval_date is not null

Line 783: select control_id from amw_control_associations where pk2 = pid and pk1 = poid and object_type = 'RISK_ORG';

779: cursor ass_risks (pid number, poid number) is
780: select risk_id from amw_risk_associations where pk2 = pid and pk1 = poid and object_type = 'PROCESS_ORG';
781:
782: cursor ass_controls (pid number, poid number) is
783: select control_id from amw_control_associations where pk2 = pid and pk1 = poid and object_type = 'RISK_ORG';
784:
785: l_dummy number;
786: unappr_obj_exception exception;
787: err_msg varchar2(4000);