DBA Data[Home] [Help]

SYS.PRVTPARENTCHILD dependencies on XDB$GROUP_DEF

Line 93: select count(*) INTO counter from xdb.xdb$group_ref rg, xdb.xdb$group_def dg where ref(dg) = rg.xmldata.groupref_ref and dg.sys_nc_oid$= groupID;

89: pID RAW(200);
90: BEGIN
91: counter := 0;
92: -- Get the reference ID from the def ID
93: select count(*) INTO counter from xdb.xdb$group_ref rg, xdb.xdb$group_def dg where ref(dg) = rg.xmldata.groupref_ref and dg.sys_nc_oid$= groupID;
94: IF (counter <> 0) THEN
95: select rg.sys_nc_oid$ INTO elementID from xdb.xdb$group_ref rg, xdb.xdb$group_def dg where ref(dg) = rg.xmldata.groupref_ref and dg.sys_nc_oid$= groupID;
96: ELSE
97: RETURN NULL;

Line 95: select rg.sys_nc_oid$ INTO elementID from xdb.xdb$group_ref rg, xdb.xdb$group_def dg where ref(dg) = rg.xmldata.groupref_ref and dg.sys_nc_oid$= groupID;

91: counter := 0;
92: -- Get the reference ID from the def ID
93: select count(*) INTO counter from xdb.xdb$group_ref rg, xdb.xdb$group_def dg where ref(dg) = rg.xmldata.groupref_ref and dg.sys_nc_oid$= groupID;
94: IF (counter <> 0) THEN
95: select rg.sys_nc_oid$ INTO elementID from xdb.xdb$group_ref rg, xdb.xdb$group_def dg where ref(dg) = rg.xmldata.groupref_ref and dg.sys_nc_oid$= groupID;
96: ELSE
97: RETURN NULL;
98: END IF;
99: -- choice

Line 292: sqlStmtBase := ' from xdb.xdb$group_def sm where sys_op_r2o(sm.xmldata. ' || kidClause || ') =';

288: IF (seqKid = TRUE) THEN kidClause := 'sequence_kid';
289: ELSIF (choiceKid = TRUE) THEN kidClause := 'choice_kid';
290: ELSE kidClause := 'all_kid';
291: END IF;
292: sqlStmtBase := ' from xdb.xdb$group_def sm where sys_op_r2o(sm.xmldata. ' || kidClause || ') =';
293: sqlStmtBase := sqlStmtBase || Dbms_Assert.Enquote_Literal(modelID);
294: sqlStmt := 'select count(*) ' || sqlStmtBase;
295: EXECUTE IMMEDIATE sqlStmt INTO counter ;
296: IF (counter <> 0) THEN