116: SELECT jtf_rs_table_attributes_s.nextval
117: INTO l_attribute_id
118: FROM dual;
119:
120: JTF_RS_TABLE_ATTRIBUTES_PKG.INSERT_ROW(
121: X_ROWID => l_rowid,
122: X_ATTRIBUTE_ID => l_attribute_id,
123: X_ATTRIBUTE_NAME => l_attribute_name,
124: X_ATTRIBUTE_ACCESS_LEVEL => l_attribute_access_level,
448: END IF;
449:
450: BEGIN
451:
452: jtf_rs_table_attributes_pkg.lock_row(
453: x_attribute_id => l_attribute_id,
454: x_object_version_number => p_object_version_num
455: );
456:
466:
467:
468: l_object_version_number := l_object_version_number +1;
469:
470: jtf_rs_table_attributes_pkg.update_row(X_ATTRIBUTE_ID => l_attribute_id,
471: X_ATTRIBUTE_NAME => l_attribute_name,
472: X_ATTRIBUTE_ACCESS_LEVEL => l_attribute_access_level,
473: X_USER_ATTRIBUTE_NAME => l_user_attribute_name,
474: X_OBJECT_VERSION_NUMBER => l_object_version_number ,
598: FETCH chk_att_exist_cur INTO chk_att_exist_rec;
599: IF (chk_att_exist_cur%FOUND)
600: THEN
601:
602: JTF_RS_TABLE_ATTRIBUTES_PKG.DELETE_ROW(
603: X_ATTRIBUTE_ID => l_attribute_id);
604:
605: ELSIF (chk_att_exist_cur%notfound) THEN
606: x_return_status := fnd_api.g_ret_sts_error;