CTXSYS.VALIDATE_INDEX_METADATA dependencies on DRIOBJ

Line 23: and oat_cla_id = DRIOBJ.CLASS_SECTION_GROUP

19: begin
20: for c1 in (select ixv_idx_id, ixv_value, ixv_oat_id, oat_name, driv.rowid
21: from dr$index_value driv, dr$object_attribute
22: where ixv_oat_id = oat_id
23: and oat_cla_id = DRIOBJ.CLASS_SECTION_GROUP
24: and ixv_value like '%:%:%') loop
25:
26: -- c1.ixv_value = SECNAME:TAG:FID:VISIBLE[T]
27: pos := instr(c1.ixv_value, ':');

Line 56: drixmd.GetIndexObject(c1.ixv_idx_id, DRIOBJ.CLASS_SECTION_GROUP,

52: tmp := substr(tmp, 1, pos -1);
53:
54: sec_tag := tmp;
55:
56: drixmd.GetIndexObject(c1.ixv_idx_id, DRIOBJ.CLASS_SECTION_GROUP,
57: l_objid, l_acnt);
58: l_oat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION_GROUP, l_objid,
59: 'SECTION_ATTRIBUTE');
60:

Line 58: l_oat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION_GROUP, l_objid,

54: sec_tag := tmp;
55:
56: drixmd.GetIndexObject(c1.ixv_idx_id, DRIOBJ.CLASS_SECTION_GROUP,
57: l_objid, l_acnt);
58: l_oat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION_GROUP, l_objid,
59: 'SECTION_ATTRIBUTE');
60:
61: l_noat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
62: DRIOBJ.OBJ_BASIC_SECTION, 'SECTION_NAME');

Line 61: l_noat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,

57: l_objid, l_acnt);
58: l_oat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION_GROUP, l_objid,
59: 'SECTION_ATTRIBUTE');
60:
61: l_noat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
62: DRIOBJ.OBJ_BASIC_SECTION, 'SECTION_NAME');
63: l_toat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
64: DRIOBJ.OBJ_BASIC_SECTION, 'TAG');
65: -- If this row is already split into individual attributes

Line 62: DRIOBJ.OBJ_BASIC_SECTION, 'SECTION_NAME');

58: l_oat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION_GROUP, l_objid,
59: 'SECTION_ATTRIBUTE');
60:
61: l_noat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
62: DRIOBJ.OBJ_BASIC_SECTION, 'SECTION_NAME');
63: l_toat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
64: DRIOBJ.OBJ_BASIC_SECTION, 'TAG');
65: -- If this row is already split into individual attributes
66: -- delete and re-insert to be sure.

Line 63: l_toat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,

59: 'SECTION_ATTRIBUTE');
60:
61: l_noat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
62: DRIOBJ.OBJ_BASIC_SECTION, 'SECTION_NAME');
63: l_toat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
64: DRIOBJ.OBJ_BASIC_SECTION, 'TAG');
65: -- If this row is already split into individual attributes
66: -- delete and re-insert to be sure.
67: -- Get section id from name and tag

Line 64: DRIOBJ.OBJ_BASIC_SECTION, 'TAG');

60:
61: l_noat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
62: DRIOBJ.OBJ_BASIC_SECTION, 'SECTION_NAME');
63: l_toat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION,
64: DRIOBJ.OBJ_BASIC_SECTION, 'TAG');
65: -- If this row is already split into individual attributes
66: -- delete and re-insert to be sure.
67: -- Get section id from name and tag
68: sec_id := 0;

Line 93: where ixo_cla_id = DRIOBJ.CLASS_SECTION_GROUP

89: and ixv_value = to_char(sec_id);
90: -- update ixo_acnt in dr$index_object for section group class
91: update dr$index_object
92: set ixo_acnt = ixo_acnt - rcnt
93: where ixo_cla_id = DRIOBJ.CLASS_SECTION_GROUP
94: and ixo_idx_id = c1.ixv_idx_id;
95: end loop;
96:
97: if (sec_id = 0) then

Line 111: sec_oat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION_GROUP, l_objid,

107: end;
108: end if;
109:
110:
111: sec_oat_id := dripref.get_oat_id(DRIOBJ.CLASS_SECTION_GROUP, l_objid,
112: upper(c1.oat_name));
113:
114: -- insert section id row
115: insert into dr$index_value