2: IS
3:
4: Function getParentIDFromModelID
5: ( modelID IN varchar2 )
6: RETURN PARENTIDARRAY
7: IS
8: parentElementID PARENTIDARRAY := PARENTIDARRAY();
9: cur0 refCursor;
10: pID RAW(200);
4: Function getParentIDFromModelID
5: ( modelID IN varchar2 )
6: RETURN PARENTIDARRAY
7: IS
8: parentElementID PARENTIDARRAY := PARENTIDARRAY();
9: cur0 refCursor;
10: pID RAW(200);
11: sqlStmtBase varchar2(2000);
12: sqlStmt varchar2(2000);
71: END;
72:
73: Function getParentIDFromGroupID
74: ( groupID IN varchar2 )
75: RETURN PARENTIDARRAY
76: IS
77: modelID varchar2(200);
78: complexID varchar2(200);
79: counter number(38);
83: choiceKid boolean := FALSE;
84: allKid boolean := FALSE;
85: kidClause varchar2(100);
86: elementID varchar2(200);
87: parentElementID PARENTIDARRAY := PARENTIDARRAY();
88: cur0 refCursor;
89: pID RAW(200);
90: BEGIN
91: counter := 0;
210: END;
211:
212: Function getParentID
213: ( elementID IN varchar2 )
214: RETURN PARENTIDARRAY
215: IS
216: modelID varchar2(200);
217: complexID varchar2(200);
218: counter number(38);
313:
314: Function sizeArray ( elementID IN varchar2 )
315: RETURN NUMBER
316: IS
317: p parentidarray;
318: BEGIN
319: p := PrvtParentChild.getparentID(elementID);
320: IF (p IS NULL) THEN
321: RETURN 0;