eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.PRVTPARENTCHILD dependencies on XDB$ELEMENT

Line 48: sqlStmt := ' select hextoraw(e.xmldata.property.prop_number) from xdb.xdb$element e where sys_op_r2o(e.xmldata.property.type_ref) = ';

44: IF (counter <> 0) THEN
45: sqlStmt := 'select ct.sys_nc_oid$ ' || sqlStmtBase;
46: EXECUTE IMMEDIATE sqlStmt INTO complexID ;
47:
48: sqlStmt := ' select hextoraw(e.xmldata.property.prop_number) from xdb.xdb$element e where sys_op_r2o(e.xmldata.property.type_ref) = ';
49: sqlStmt := sqlStmt || Dbms_Assert.Enquote_Literal(complexID);
50: sqlStmt := sqlStmt ;
51: counter := 1;
52: OPEN cur0 FOR sqlStmt;

Line 145: sqlStmt := ' select hextoraw(e.xmldata.property.prop_number) from xdb.xdb$element e where sys_op_r2o(e.xmldata.property.type_ref) = ';

141: IF (counter <> 0) THEN
142: sqlStmt := 'select ct.sys_nc_oid$ ' || sqlStmtBase;
143: EXECUTE IMMEDIATE sqlStmt INTO complexID ;
144:
145: sqlStmt := ' select hextoraw(e.xmldata.property.prop_number) from xdb.xdb$element e where sys_op_r2o(e.xmldata.property.type_ref) = ';
146: sqlStmt := sqlStmt || Dbms_Assert.Enquote_Literal(complexID);
147: sqlStmt := sqlStmt ;
148:
149: counter := 1;

Line 229: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$choice_model sm,

225: kidClause varchar2(100);
226: BEGIN
227: counter := 0;
228: -- choice
229: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$choice_model sm,
230: table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
231: IF ( counter <> 0 ) THEN
232: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$choice_model sm, table(sm.xmldata.elements)t where
233: ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;

Line 232: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$choice_model sm, table(sm.xmldata.elements)t where

228: -- choice
229: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$choice_model sm,
230: table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
231: IF ( counter <> 0 ) THEN
232: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$choice_model sm, table(sm.xmldata.elements)t where
233: ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
234: choiceKid := TRUE;
235: ELSE
236: -- sequence

Line 237: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$sequence_model sm,

233: ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
234: choiceKid := TRUE;
235: ELSE
236: -- sequence
237: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$sequence_model sm,
238: table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
239: IF ( counter <> 0 ) THEN
240: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$sequence_model sm, table(sm.xmldata.elements)t where
241: ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;

Line 240: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$sequence_model sm, table(sm.xmldata.elements)t where

236: -- sequence
237: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$sequence_model sm,
238: table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
239: IF ( counter <> 0 ) THEN
240: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$sequence_model sm, table(sm.xmldata.elements)t where
241: ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
242: seqKid := TRUE;
243: ELSE
244: -- all

Line 245: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$all_model sm,

241: ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
242: seqKid := TRUE;
243: ELSE
244: -- all
245: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$all_model sm,
246: table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
247: IF ( counter <> 0 ) THEN
248: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$all_model sm, table(sm.xmldata.elements)t where
249: ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;

Line 248: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$all_model sm, table(sm.xmldata.elements)t where

244: -- all
245: select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$all_model sm,
246: table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
247: IF ( counter <> 0 ) THEN
248: select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$all_model sm, table(sm.xmldata.elements)t where
249: ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;
250: allKid := TRUE;
251: ELSE
252: RETURN NULL;