APPS.AMW_AUDIT_PROCEDURES_PVT dependencies on AMW_AP_ASSOCIATIONS

Line 958: UPDATE amw_ap_associations

954:
955: -- anmalhot - if approval status = 'A' then approve the control associations
956: if(l_dummy_audit_procedure_rec.approval_status = 'A')
957: then
958: UPDATE amw_ap_associations
959: SET approval_date = l_dummy_audit_procedure_rec.approval_date
960: WHERE audit_procedure_id = l_dummy_audit_procedure_rec.audit_procedure_id
961: AND object_type = 'CTRL';
962: end if;

Line 2848: INSERT INTO AMW_AP_ASSOCIATIONS (AP_ASSOCIATION_ID,

2844:
2845: --FOR ctrlrec IN controls_assoc
2846: --LOOP
2847:
2848: INSERT INTO AMW_AP_ASSOCIATIONS (AP_ASSOCIATION_ID,
2849: LAST_UPDATE_DATE,
2850: LAST_UPDATED_BY,
2851: CREATION_DATE,
2852: CREATED_BY,

Line 2881: (SELECT AMW_AP_ASSOCIATIONS_S.NEXTVAL,

2877: SECURITY_GROUP_ID ,
2878: OBJECT_VERSION_NUMBER,
2879: DESIGN_EFFECTIVENESS ,
2880: OP_EFFECTIVENESS)
2881: (SELECT AMW_AP_ASSOCIATIONS_S.NEXTVAL,
2882: SYSDATE,
2883: G_USER_ID,
2884: SYSDATE,
2885: G_USER_ID,

Line 2914: FROM AMW_AP_ASSOCIATIONS ctrlrec

2910: ctrlrec.SECURITY_GROUP_ID,
2911: 1,
2912: ctrlrec.DESIGN_EFFECTIVENESS,
2913: ctrlrec.OP_EFFECTIVENESS
2914: FROM AMW_AP_ASSOCIATIONS ctrlrec
2915: WHERE audit_procedure_id = x_from_ap_id);
2916: --END LOOP;
2917: IF FND_API.To_Boolean( p_commit ) THEN
2918: COMMIT WORK;

Line 3263: FROM amw_ap_associations a

3259: a.audit_procedure_id,
3260: a.design_effectiveness,
3261: a.op_effectiveness,
3262: a.object_version_number
3263: FROM amw_ap_associations a
3264: WHERE a.audit_procedure_id = c_ap_id
3265: AND a.object_type = 'CTRL'
3266: AND a.pk1 = c_control_id
3267: AND a.deletion_date is null

Line 3278: FROM amw_ap_associations a

3274: a.design_effectiveness,
3275: a.op_effectiveness,
3276: a.object_type,
3277: a.object_version_number
3278: FROM amw_ap_associations a
3279: WHERE a.audit_procedure_id = c_ap_id
3280: AND a.object_type = 'CTRL'
3281: AND a.pk1 = c_control_id
3282: AND a.deletion_date is null

Line 3344: UPDATE amw_ap_associations

3340: CLOSE c_prev_assoc_exists;
3341: if(lx_assoc_rec.ap_association_id is not null)
3342: then
3343: -- update the association
3344: UPDATE amw_ap_associations
3345: SET design_effectiveness = p_des_eff,
3346: op_effectiveness = p_op_eff,
3347: object_version_number = object_version_number + 1,
3348: approval_date = p_approval_date

Line 3353: UPDATE amw_ap_associations

3349: WHERE ap_association_id = lx_assoc_rec.ap_association_id;
3350: elsif(lx_prev_assoc_rec.ap_association_id is not null)
3351: then
3352: -- set deletion_date and insert a new row
3353: UPDATE amw_ap_associations
3354: SET deletion_date = l_date,
3355: object_version_number = object_version_number + 1,
3356: deletion_approval_date = p_approval_date
3357: WHERE ap_association_id = lx_prev_assoc_rec.ap_association_id;

Line 3359: INSERT INTO amw_ap_associations

3355: object_version_number = object_version_number + 1,
3356: deletion_approval_date = p_approval_date
3357: WHERE ap_association_id = lx_prev_assoc_rec.ap_association_id;
3358:
3359: INSERT INTO amw_ap_associations
3360: (ap_association_id
3361: ,last_update_date
3362: ,last_updated_by
3363: ,creation_date

Line 3377: VALUES (amw_ap_associations_s.NEXTVAL

3373: ,approval_date
3374: ,deletion_date
3375: ,deletion_approval_date
3376: )
3377: VALUES (amw_ap_associations_s.NEXTVAL
3378: ,SYSDATE
3379: ,p_user_id
3380: ,SYSDATE
3381: ,p_user_id

Line 3396: INSERT INTO amw_ap_associations

3392: ,null
3393: );
3394: else
3395: -- create a new assoc as it does not exist
3396: INSERT INTO amw_ap_associations
3397: (ap_association_id
3398: ,last_update_date
3399: ,last_updated_by
3400: ,creation_date

Line 3414: VALUES (amw_ap_associations_s.NEXTVAL

3410: ,approval_date
3411: ,deletion_date
3412: ,deletion_approval_date
3413: )
3414: VALUES (amw_ap_associations_s.NEXTVAL
3415: ,SYSDATE
3416: ,p_user_id
3417: ,SYSDATE
3418: ,p_user_id