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$SEQUENCE_MODEL

Line 109: sqlStmtBase := 'from xdb.xdb$sequence_model sm, table(sm.xmldata.groups) t where sys_op_r2o(t.column_value) = ';

105: sqlStmt := ' select sm.sys_nc_oid$ ' || sqlStmtBase;
106: EXECUTE IMMEDIATE sqlStmt INTO modelID ;
107: choiceKid := TRUE;
108: ELSE
109: sqlStmtBase := 'from xdb.xdb$sequence_model sm, table(sm.xmldata.groups) t where sys_op_r2o(t.column_value) = ';
110: sqlStmtBase := sqlStmtBase || Dbms_Assert.Enquote_Literal(elementID);
111: sqlStmt := ' select count(*) ' || sqlStmtBase;
112: EXECUTE IMMEDIATE sqlStmt INTO counter ;
113: IF ( counter <> 0 ) THEN

Line 186: sqlStmt := 'select count(*) from xdb.xdb$sequence_model sm, ' || sqlStmtBase;

182: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$choice_model sm, ' || sqlStmtBase;
183: EXECUTE IMMEDIATE sqlStmt INTO modelID ;
184: choicekid := TRUE; seqKid := FALSE; allKid := FALSE;
185: ELSE
186: sqlStmt := 'select count(*) from xdb.xdb$sequence_model sm, ' || sqlStmtBase;
187: EXECUTE IMMEDIATE sqlStmt INTO counter;
188: IF (counter <> 0) THEN
189: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$sequence_model sm, ' || sqlStmtBase;
190: EXECUTE IMMEDIATE sqlStmt INTO modelID ;

Line 189: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$sequence_model sm, ' || sqlStmtBase;

185: ELSE
186: sqlStmt := 'select count(*) from xdb.xdb$sequence_model sm, ' || sqlStmtBase;
187: EXECUTE IMMEDIATE sqlStmt INTO counter;
188: IF (counter <> 0) THEN
189: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$sequence_model sm, ' || sqlStmtBase;
190: EXECUTE IMMEDIATE sqlStmt INTO modelID ;
191: choicekid := FALSE; seqKid := TRUE; allKid := FALSE;
192: ELSE
193: sqlStmt := 'select count(*) from xdb.xdb$all_model sm, ' || sqlStmtBase;

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 274: sqlStmt := 'select count(*) from xdb.xdb$sequence_model sm, ' || sqlStmtBase;

270: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$choice_model sm, ' || sqlStmtBase;
271: EXECUTE IMMEDIATE sqlStmt INTO modelID ;
272: choicekid := TRUE; seqKid := FALSE; allKid := FALSE;
273: ELSE
274: sqlStmt := 'select count(*) from xdb.xdb$sequence_model sm, ' || sqlStmtBase;
275: EXECUTE IMMEDIATE sqlStmt INTO counter;
276: IF (counter <> 0) THEN
277: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$sequence_model sm, ' || sqlStmtBase;
278: EXECUTE IMMEDIATE sqlStmt INTO modelID ;

Line 277: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$sequence_model sm, ' || sqlStmtBase;

273: ELSE
274: sqlStmt := 'select count(*) from xdb.xdb$sequence_model sm, ' || sqlStmtBase;
275: EXECUTE IMMEDIATE sqlStmt INTO counter;
276: IF (counter <> 0) THEN
277: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$sequence_model sm, ' || sqlStmtBase;
278: EXECUTE IMMEDIATE sqlStmt INTO modelID ;
279: choicekid := FALSE; seqKid := TRUE; allKid := FALSE;
280: ELSE
281: sqlStmt := 'select count(*) from xdb.xdb$all_model sm, ' || sqlStmtBase;