44: (
45: AHL_MR_VISIT_TYPES_S.NEXTVAL,
46: 1,
47: SYSDATE,
48: FND_GLOBAL.user_ID,
49: SYSDATE,
50: FND_GLOBAL.USER_ID,
51: FND_GLOBAL.LOGIN_ID,
52: P_X_MR_VISIT_TYPE_REC.MR_VISIT_TYPE_CODE,
46: 1,
47: SYSDATE,
48: FND_GLOBAL.user_ID,
49: SYSDATE,
50: FND_GLOBAL.USER_ID,
51: FND_GLOBAL.LOGIN_ID,
52: P_X_MR_VISIT_TYPE_REC.MR_VISIT_TYPE_CODE,
53: P_X_MR_VISIT_TYPE_REC.MR_HEADER_ID,
54: P_X_MR_VISIT_TYPE_REC.ATTRIBUTE_CATEGORY,
47: SYSDATE,
48: FND_GLOBAL.user_ID,
49: SYSDATE,
50: FND_GLOBAL.USER_ID,
51: FND_GLOBAL.LOGIN_ID,
52: P_X_MR_VISIT_TYPE_REC.MR_VISIT_TYPE_CODE,
53: P_X_MR_VISIT_TYPE_REC.MR_HEADER_ID,
54: P_X_MR_VISIT_TYPE_REC.ATTRIBUTE_CATEGORY,
55: P_X_MR_VISIT_TYPE_REC.ATTRIBUTE1,
98: ATTRIBUTE13 =P_MR_VISIT_TYPE_REC.ATTRIBUTE13,
99: ATTRIBUTE14 =P_MR_VISIT_TYPE_REC.ATTRIBUTE14,
100: ATTRIBUTE15 =P_MR_VISIT_TYPE_REC.ATTRIBUTE15,
101: LAST_UPDATE_DATE =sysdate,
102: LAST_UPDATED_BY =fnd_global.user_id,
103: LAST_UPDATE_LOGIN =fnd_global.login_id
104: WHERE MR_VISIT_TYPE_ID=P_MR_VISIT_TYPE_REC.mr_visit_type_ID
105: and object_version_number=P_MR_VISIT_TYPE_REC.object_version_number;
106: if (sql%ROWCOUNT=0)
99: ATTRIBUTE14 =P_MR_VISIT_TYPE_REC.ATTRIBUTE14,
100: ATTRIBUTE15 =P_MR_VISIT_TYPE_REC.ATTRIBUTE15,
101: LAST_UPDATE_DATE =sysdate,
102: LAST_UPDATED_BY =fnd_global.user_id,
103: LAST_UPDATE_LOGIN =fnd_global.login_id
104: WHERE MR_VISIT_TYPE_ID=P_MR_VISIT_TYPE_REC.mr_visit_type_ID
105: and object_version_number=P_MR_VISIT_TYPE_REC.object_version_number;
106: if (sql%ROWCOUNT=0)
107: then