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

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

115: sqlStmt := ' select sm.sys_nc_oid$ ' || sqlStmtBase;
116: EXECUTE IMMEDIATE sqlStmt INTO modelID ;
117: seqKid := TRUE;
118: ELSE
119: sqlStmtBase := 'from xdb.xdb$all_model sm, table(sm.xmldata.groups) t where sys_op_r2o(t.column_value) = ';
120: sqlStmtBase := sqlStmtBase || Dbms_Assert.Enquote_Literal(elementID);
121: sqlStmt := ' select count(*) ' || sqlStmtBase;
122: IF ( counter <> 0 ) THEN
123:

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

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;
194: EXECUTE IMMEDIATE sqlStmt INTO counter ;
195: IF (counter <> 0) THEN
196: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$all_model sm, ' || sqlStmtBase;
197: EXECUTE IMMEDIATE sqlStmt INTO modelID;

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

192: ELSE
193: sqlStmt := 'select count(*) from xdb.xdb$all_model sm, ' || sqlStmtBase;
194: EXECUTE IMMEDIATE sqlStmt INTO counter ;
195: IF (counter <> 0) THEN
196: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$all_model sm, ' || sqlStmtBase;
197: EXECUTE IMMEDIATE sqlStmt INTO modelID;
198: choicekid := FALSE; seqKid := FALSE; allKid := TRUE;
199: ELSE -- group
200: RETURN getParentIDFromModelID(modelID);

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;

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

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;
282: EXECUTE IMMEDIATE sqlStmt INTO counter ;
283: IF (counter <> 0) THEN
284: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$all_model sm, ' || sqlStmtBase;
285: EXECUTE IMMEDIATE sqlStmt INTO modelID;

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

280: ELSE
281: sqlStmt := 'select count(*) from xdb.xdb$all_model sm, ' || sqlStmtBase;
282: EXECUTE IMMEDIATE sqlStmt INTO counter ;
283: IF (counter <> 0) THEN
284: sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$all_model sm, ' || sqlStmtBase;
285: EXECUTE IMMEDIATE sqlStmt INTO modelID;
286: choicekid := FALSE; seqKid := FALSE; allKid := TRUE;
287: ELSE -- group
288: IF (seqKid = TRUE) THEN kidClause := 'sequence_kid';