APPS.AMW_LOAD_RC_DATA dependencies on AMW_AP_ASSOCIATIONS

Line 1115: FROM AMW_AP_ASSOCIATIONS

1111: --FOR EXISTING AP 2 CTRL ASSOCIATION
1112: BEGIN
1113: SELECT AP_ASSOCIATION_ID,APPROVAL_DATE
1114: INTO L_AP_ASSOCIATION_ID,L_AP_APPROVAL_DATE
1115: FROM AMW_AP_ASSOCIATIONS
1116: WHERE AUDIT_PROCEDURE_ID=RC_REC.AP_NAME
1117: AND PK1=LX_CONTROL_ID
1118: AND OBJECT_TYPE='CTRL'
1119: AND DELETION_DATE IS NULL;

Line 1182: ,'AMW_AP_ASSOCIATIONS'

1178: p_encoded => fnd_api.g_false), 1,100);
1179: end if;
1180: END LOOP;
1181: update_interface_with_error (v_err_msg
1182: ,'AMW_AP_ASSOCIATIONS'
1183: ,v_interface_id);
1184: END IF;
1185: fnd_file.PUT_LINE(fnd_file.log, 'CREATE_AMW_AP_ASSOC END');
1186: ELSE

Line 1197: UPDATE AMW_AP_ASSOCIATIONS

1193: --THIS MEANS THAT THIS IS LATEST REVISION FOR THIS ASSOCIATION
1194: --AND IS APPROVED, SO
1195: fnd_file.PUT_LINE(fnd_file.log, 'UPSERTING AP 2 CTRL ASSOCIATION');
1196: BEGIN
1197: UPDATE AMW_AP_ASSOCIATIONS
1198: SET DELETION_DATE=SYSDATE
1199: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1200: ,LAST_UPDATE_DATE=SYSDATE
1201: ,LAST_UPDATED_BY=G_USER_ID

Line 1225: ,'AMW_AP_ASSOCIATIONS'

1221: p_encoded => fnd_api.g_false), 1,100);
1222: end if;
1223: END LOOP;
1224: update_interface_with_error (v_err_msg
1225: ,'AMW_AP_ASSOCIATIONS'
1226: ,v_interface_id);
1227: END IF;
1228: EXCEPTION
1229: WHEN OTHERS THEN

Line 1240: UPDATE AMW_AP_ASSOCIATIONS

1236: --SIMPLY UPDATE THE ASSOCIATION ATTRIBUTES HERE
1237: fnd_file.PUT_LINE(fnd_file.log, 'UPDATING AP 2 CTRL ASSOCIATION --> L_AP_ASSOCIATION_ID: '||L_AP_ASSOCIATION_ID);
1238: --IF(L_ASSOC_AP_TO_CTRL) THEN
1239: BEGIN
1240: UPDATE AMW_AP_ASSOCIATIONS
1241: SET DESIGN_EFFECTIVENESS=rc_rec.design_effectiveness
1242: ,OP_EFFECTIVENESS=rc_rec.op_effectiveness
1243: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1244: ,LAST_UPDATE_DATE=SYSDATE

Line 2673: INSERT INTO amw_ap_associations(

2669: x_msg_data => x_msg_data
2670: );
2671:
2672: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)THEN
2673: INSERT INTO amw_ap_associations(
2674: ap_association_id
2675: ,last_update_date
2676: ,last_updated_by
2677: ,creation_date

Line 2688: AMW_AP_ASSOCIATIONS_S.NEXTVAL

2684: ,op_effectiveness
2685: ,object_version_number
2686: ,ASSOCIATION_CREATION_DATE)
2687: VALUES (
2688: AMW_AP_ASSOCIATIONS_S.NEXTVAL
2689: ,SYSDATE
2690: ,v_user_id
2691: ,SYSDATE
2692: ,v_user_id