APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_OBJECTIVE_ASSOCIATIONS

Line 527: update amw_objective_associations

523: and object_type = 'PROCESS_ORG'
524: and deletion_date is not null
525: and deletion_approval_date is null;
526: --ko Approve Process Objectives and Control Objectives Associations..
527: update amw_objective_associations
528: set approval_date = APPROV_TXN_DATE
529: where pk1 = p_org_id
530: and pk2 = p_process_id
531: and object_type in ( 'PROCESS_ORG' , 'CONTROL_ORG')

Line 534: update amw_objective_associations

530: and pk2 = p_process_id
531: and object_type in ( 'PROCESS_ORG' , 'CONTROL_ORG')
532: and approval_date is null;
533:
534: update amw_objective_associations
535: set deletion_approval_date = APPROV_TXN_DATE
536: where pk1 = p_org_id
537: and pk2 = p_process_id
538: and object_type in ( 'PROCESS_ORG' , 'CONTROL_ORG')

Line 564: /* update amw_objective_associations

560: AND PK2 = p_process_id
561: AND approval_date is not null
562: and deletion_approval_date is null);
563:
564: /* update amw_objective_associations
565: set approval_date = APPROV_TXN_DATE
566: where pk1 = p_process_id
567: and object_type = 'PROCESS_ORG'
568: and approval_date is null;

Line 570: update amw_objective_associations

566: where pk1 = p_process_id
567: and object_type = 'PROCESS_ORG'
568: and approval_date is null;
569:
570: update amw_objective_associations
571: set deletion_approval_date = APPROV_TXN_DATE
572: where pk1 = p_process_id
573: and object_type = 'PROCESS_ORG'
574: and deletion_date is not null