APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_CONTROL_ASSOCIATIONS

Line 58: UPDATE amw_control_associations assoc

54: OPEN c_obj_opin_type_id ('AMW_ORG_CONTROL');
55: FETCH c_obj_opin_type_id INTO l_obj_opinion_type_id;
56: CLOSE c_obj_opin_type_id;
57:
58: UPDATE amw_control_associations assoc
59: SET last_update_date = sysdate,
60: last_updated_by = fnd_global.user_id,
61: last_update_login = fnd_global.conc_login_id,
62: pk5 = (SELECT max(opinion_log_id)

Line 262: FROM amw_certification_b cert, amw_control_associations assoc,

258: AND assoc.pk4 = opin.opinion_log_id(+);
259:
260: CURSOR c_cert_with_ctrl (c_ctrl_id NUMBER, c_org_id NUMBER) IS
261: SELECT cert.certification_id, opin.audit_result_code old_eval
262: FROM amw_certification_b cert, amw_control_associations assoc,
263: amw_opinions_log_v opin
264: WHERE cert.certification_status in ('ACTIVE','DRAFT')
265: AND cert.certification_id = assoc.pk1
266: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'

Line 910: FROM amw_execution_scope --, amw_control_associations assoc

906: WHERE certification_id = ctrl_rec.certification_id
907: AND organization_id = l_pk3
908: AND process_id IN (
909: SELECT process_id
910: FROM amw_execution_scope --, amw_control_associations assoc
911: START WITH process_id IN (
912: SELECT pk3
913: FROM amw_control_associations
914: WHERE object_type = 'BUSIPROC_CERTIFICATION'

Line 913: FROM amw_control_associations

909: SELECT process_id
910: FROM amw_execution_scope --, amw_control_associations assoc
911: START WITH process_id IN (
912: SELECT pk3
913: FROM amw_control_associations
914: WHERE object_type = 'BUSIPROC_CERTIFICATION'
915: AND control_id = l_pk1
916: AND pk1 = ctrl_rec.certification_id
917: AND pk2 = l_pk3) -- organization_id

Line 969: FROM amw_execution_scope --, amw_control_associations assoc

965: WHERE certification_id = ctrl_rec.certification_id
966: AND organization_id = l_pk3
967: AND process_id IN (
968: SELECT process_id
969: FROM amw_execution_scope --, amw_control_associations assoc
970: START WITH process_id IN (
971: SELECT pk3
972: FROM amw_control_associations
973: WHERE object_type = 'BUSIPROC_CERTIFICATION'

Line 972: FROM amw_control_associations

968: SELECT process_id
969: FROM amw_execution_scope --, amw_control_associations assoc
970: START WITH process_id IN (
971: SELECT pk3
972: FROM amw_control_associations
973: WHERE object_type = 'BUSIPROC_CERTIFICATION'
974: AND control_id = l_pk1
975: AND pk1 = ctrl_rec.certification_id
976: AND pk2 = l_pk3) -- organization_id

Line 1025: FROM amw_execution_scope --, amw_control_associations assoc

1021: WHERE certification_id = ctrl_rec.certification_id
1022: AND organization_id = l_pk3
1023: AND process_id IN (
1024: SELECT process_id
1025: FROM amw_execution_scope --, amw_control_associations assoc
1026: START WITH process_id IN (
1027: SELECT pk3
1028: FROM amw_control_associations
1029: WHERE object_type = 'BUSIPROC_CERTIFICATION'

Line 1028: FROM amw_control_associations

1024: SELECT process_id
1025: FROM amw_execution_scope --, amw_control_associations assoc
1026: START WITH process_id IN (
1027: SELECT pk3
1028: FROM amw_control_associations
1029: WHERE object_type = 'BUSIPROC_CERTIFICATION'
1030: AND control_id = l_pk1
1031: AND pk1 = ctrl_rec.certification_id
1032: AND pk2 = l_pk3) -- organization_id

Line 1089: FROM amw_execution_scope --, amw_control_associations assoc

1085: WHERE certification_id = ctrl_rec.certification_id
1086: AND organization_id = l_pk3
1087: AND process_id IN (
1088: SELECT process_id
1089: FROM amw_execution_scope --, amw_control_associations assoc
1090: START WITH process_id IN (
1091: SELECT pk3
1092: FROM amw_control_associations
1093: WHERE object_type = 'BUSIPROC_CERTIFICATION'

Line 1092: FROM amw_control_associations

1088: SELECT process_id
1089: FROM amw_execution_scope --, amw_control_associations assoc
1090: START WITH process_id IN (
1091: SELECT pk3
1092: FROM amw_control_associations
1093: WHERE object_type = 'BUSIPROC_CERTIFICATION'
1094: AND control_id = l_pk1
1095: AND pk1 = ctrl_rec.certification_id
1096: AND pk2 = l_pk3) -- organization_id

Line 1125: UPDATE amw_control_associations

1121: END IF;
1122: END LOOP;
1123:
1124: -- update amw_contrl_associations.pk5 with evaluation_opinion_log_id
1125: UPDATE amw_control_associations
1126: SET last_update_date = sysdate,
1127: last_updated_by = fnd_global.user_id,
1128: last_update_login = fnd_global.conc_login_id,
1129: pk5 = l_opin_log_id

Line 1135: FROM amw_certification_b cert, amw_control_associations assoc

1131: AND control_id = l_pk1
1132: AND pk2 = l_pk3 -- organization_id
1133: AND pk1 IN (
1134: SELECT assoc.pk1
1135: FROM amw_certification_b cert, amw_control_associations assoc
1136: WHERE cert.certification_status in ('ACTIVE','DRAFT')
1137: AND cert.certification_id = assoc.pk1
1138: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'
1139: AND assoc.control_id = l_pk1