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.

APPS.FND_ODF_GEN dependencies on DBMS_XMLGEN

Line 756: l_queryCtx DBMS_XMLGEN.ctxType;

752: p_owner IN VARCHAR2,
753: p_ASNAME IN VARCHAR2,
754: p_retXml OUT NOCOPY CLOB)
755: IS
756: l_queryCtx DBMS_XMLGEN.ctxType;
757: l_result0 XmlType;
758: l_finalresult CLOB;
759: l_str varchar2(2000);
760: l_refcur SYS_REFCURSOR;

Line 774: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

770: ' and b.application_short_name = :2 ';
771:
772:
773: open l_refcur FOR l_str using p_viewName , p_asname;
774: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
775: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');
776: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_VIEWS');
777:
778:

Line 775: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');

771:
772:
773: open l_refcur FOR l_str using p_viewName , p_asname;
774: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
775: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');
776: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_VIEWS');
777:
778:
779: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);

Line 776: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_VIEWS');

772:
773: open l_refcur FOR l_str using p_viewName , p_asname;
774: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
775: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');
776: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_VIEWS');
777:
778:
779: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);
780:

Line 779: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);

775: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');
776: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_VIEWS');
777:
778:
779: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);
780:
781: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
782: if ( l_noOfRows = 0 ) then
783: l_result0 := xmltype('

Line 781: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

777:
778:
779: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);
780:
781: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
782: if ( l_noOfRows = 0 ) then
783: l_result0 := xmltype('
784:
785: SEED

Line 795: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

791:
792: l_finalresult := l_result0.getclobval();
793: --printClobOut(l_finalresult);
794: close l_refcur;
795: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
796:
797: p_retXml := l_finalresult;
798:
799: END get_fnd_view_metadata;

Line 922: l_queryCtx DBMS_XMLGEN.ctxType;

918: p_owner IN VARCHAR2,
919: p_ASNAME IN VARCHAR2,
920: p_retXml OUT NOCOPY CLOB)
921: IS
922: l_queryCtx DBMS_XMLGEN.ctxType;
923: l_queryCtx1 DBMS_XMLGEN.ctxType;
924: l_result0 XmlType;
925: l_result1 xmlType;
926: l_finalresult CLOB;

Line 923: l_queryCtx1 DBMS_XMLGEN.ctxType;

919: p_ASNAME IN VARCHAR2,
920: p_retXml OUT NOCOPY CLOB)
921: IS
922: l_queryCtx DBMS_XMLGEN.ctxType;
923: l_queryCtx1 DBMS_XMLGEN.ctxType;
924: l_result0 XmlType;
925: l_result1 xmlType;
926: l_finalresult CLOB;
927: l_str varchar2(2500);

Line 955: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

951: ' and a.application_id = b.application_id ' ||
952: ' and b.application_short_name = :3 ';
953:
954: open l_refcur FOR l_str using l_comments, p_objName , p_asname;
955: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
956: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');
957: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_TABLES');
958:
959:

Line 956: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');

952: ' and b.application_short_name = :3 ';
953:
954: open l_refcur FOR l_str using l_comments, p_objName , p_asname;
955: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
956: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');
957: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_TABLES');
958:
959:
960: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);

Line 957: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_TABLES');

953:
954: open l_refcur FOR l_str using l_comments, p_objName , p_asname;
955: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
956: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');
957: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_TABLES');
958:
959:
960: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);
961:

Line 960: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);

956: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_AOL_METADATA');
957: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_TABLES');
958:
959:
960: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);
961:
962: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
963: if ( l_noOfRows <> 0 ) then
964: l_fndtabxml := xmltype.extract(l_result0,'APPS_AOL_METADATA/APPS_FND_TABLES');

Line 962: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

958:
959:
960: l_result0 := DBMS_XMLGEN.getXMLType(l_queryCtx);
961:
962: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
963: if ( l_noOfRows <> 0 ) then
964: l_fndtabxml := xmltype.extract(l_result0,'APPS_AOL_METADATA/APPS_FND_TABLES');
965: else
966: l_fndtabxml := xmltype('

Line 978: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

974:
975: l_finalresult := l_fndtabxml.getclobval();
976: --printClobOut(l_finalresult);
977: close l_refcur;
978: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
979:
980: if ( l_noOfRows = 0 ) then
981: l_str := 'select column_name as apps_column_name, ' ||
982: ' nvl((select nvl(substr(ltrim(rtrim(c.comments)), 1, 240),'' '') '||

Line 1079: l_queryCtx1 := DBMS_XMLGEN.newContext(l_refcur);

1075:
1076: end if;
1077:
1078:
1079: l_queryCtx1 := DBMS_XMLGEN.newContext(l_refcur);
1080: DBMS_XMLGEN.setRowsetTag(l_queryCtx1,'APPS_FND_COLUMNS');
1081: DBMS_XMLGEN.setRowTag(l_queryCtx1,'APPS_FND_COLUMN_ITEM');
1082:
1083:

Line 1080: DBMS_XMLGEN.setRowsetTag(l_queryCtx1,'APPS_FND_COLUMNS');

1076: end if;
1077:
1078:
1079: l_queryCtx1 := DBMS_XMLGEN.newContext(l_refcur);
1080: DBMS_XMLGEN.setRowsetTag(l_queryCtx1,'APPS_FND_COLUMNS');
1081: DBMS_XMLGEN.setRowTag(l_queryCtx1,'APPS_FND_COLUMN_ITEM');
1082:
1083:
1084: -- get the result..!

Line 1081: DBMS_XMLGEN.setRowTag(l_queryCtx1,'APPS_FND_COLUMN_ITEM');

1077:
1078:
1079: l_queryCtx1 := DBMS_XMLGEN.newContext(l_refcur);
1080: DBMS_XMLGEN.setRowsetTag(l_queryCtx1,'APPS_FND_COLUMNS');
1081: DBMS_XMLGEN.setRowTag(l_queryCtx1,'APPS_FND_COLUMN_ITEM');
1082:
1083:
1084: -- get the result..!
1085: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx1);

Line 1085: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx1);

1081: DBMS_XMLGEN.setRowTag(l_queryCtx1,'APPS_FND_COLUMN_ITEM');
1082:
1083:
1084: -- get the result..!
1085: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx1);
1086: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx1);
1087: if(l_noOfRows = 0) then
1088: l_fndtabxml := xmlType('
1089:

Line 1086: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx1);

1082:
1083:
1084: -- get the result..!
1085: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx1);
1086: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx1);
1087: if(l_noOfRows = 0) then
1088: l_fndtabxml := xmlType('
1089:
1090:

Line 1103: DBMS_XMLGEN.closeContext(l_queryCtx1); -- you must close the query handle..

1099: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_COLUMNS');
1100: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1101: end if;
1102:
1103: DBMS_XMLGEN.closeContext(l_queryCtx1); -- you must close the query handle..
1104: close l_refcur;
1105:
1106: p_retXml := l_finalresult;
1107:

Line 1115: l_queryCtx DBMS_XMLGEN.ctxType;

1111: p_owner IN VARCHAR2,
1112: p_ASNAME IN VARCHAR2,
1113: p_retXml OUT NOCOPY CLOB)
1114: IS
1115: l_queryCtx DBMS_XMLGEN.ctxType;
1116: l_result1 xmlType;
1117: l_finalresult CLOB;
1118: l_str varchar2(2500);
1119: l_refcur SYS_REFCURSOR;

Line 1145: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1141: 'and P.APPLICATION_ID = T.APPLICATION_ID ' ||
1142: 'order by 1 ';
1143:
1144: open l_refcur for l_str using p_asname, p_objName;
1145: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1146: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PRIMARY_KEYS');
1147: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PRIMARY_KEY_ITEMS');
1148: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1149: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1146: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PRIMARY_KEYS');

1142: 'order by 1 ';
1143:
1144: open l_refcur for l_str using p_asname, p_objName;
1145: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1146: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PRIMARY_KEYS');
1147: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PRIMARY_KEY_ITEMS');
1148: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1149: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1150: if ( l_noOfRows <> 0 ) then

Line 1147: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PRIMARY_KEY_ITEMS');

1143:
1144: open l_refcur for l_str using p_asname, p_objName;
1145: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1146: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PRIMARY_KEYS');
1147: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PRIMARY_KEY_ITEMS');
1148: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1149: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1150: if ( l_noOfRows <> 0 ) then
1151: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_PRIMARY_KEYS');

Line 1148: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);

1144: open l_refcur for l_str using p_asname, p_objName;
1145: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1146: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PRIMARY_KEYS');
1147: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PRIMARY_KEY_ITEMS');
1148: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1149: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1150: if ( l_noOfRows <> 0 ) then
1151: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_PRIMARY_KEYS');
1152: l_finalresult := l_fndtabxml.getclobval();

Line 1149: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1145: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1146: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PRIMARY_KEYS');
1147: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PRIMARY_KEY_ITEMS');
1148: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1149: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1150: if ( l_noOfRows <> 0 ) then
1151: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_PRIMARY_KEYS');
1152: l_finalresult := l_fndtabxml.getclobval();
1153: else

Line 1168: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1164: ');
1165: l_finalresult := l_fndtabxml.getclobval();
1166: end if;
1167: --printClobOut(l_finalresult);
1168: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1169: close l_refcur;
1170:
1171:
1172: /* get the primary key column info */

Line 1200: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1196: 'order by 1 ';
1197:
1198:
1199: open l_refcur for l_str using p_asname, p_objName;
1200: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1201: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PK_COLUMNS');
1202: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PK_COLUMN_ITEMS');
1203: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1204: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1201: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PK_COLUMNS');

1197:
1198:
1199: open l_refcur for l_str using p_asname, p_objName;
1200: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1201: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PK_COLUMNS');
1202: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PK_COLUMN_ITEMS');
1203: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1204: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1205: if ( l_noOfRows <> 0 ) then

Line 1202: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PK_COLUMN_ITEMS');

1198:
1199: open l_refcur for l_str using p_asname, p_objName;
1200: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1201: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PK_COLUMNS');
1202: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PK_COLUMN_ITEMS');
1203: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1204: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1205: if ( l_noOfRows <> 0 ) then
1206: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_PK_COLUMNS');

Line 1203: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);

1199: open l_refcur for l_str using p_asname, p_objName;
1200: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1201: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PK_COLUMNS');
1202: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PK_COLUMN_ITEMS');
1203: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1204: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1205: if ( l_noOfRows <> 0 ) then
1206: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_PK_COLUMNS');
1207: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

Line 1204: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1200: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1201: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_PK_COLUMNS');
1202: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_PK_COLUMN_ITEMS');
1203: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1204: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1205: if ( l_noOfRows <> 0 ) then
1206: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_PK_COLUMNS');
1207: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1208: end if;

Line 1209: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1205: if ( l_noOfRows <> 0 ) then
1206: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_PK_COLUMNS');
1207: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1208: end if;
1209: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1210: close l_refcur;
1211:
1212: end if;
1213:

Line 1239: l_queryCtx DBMS_XMLGEN.ctxType;

1235: p_owner IN VARCHAR2,
1236: p_ASNAME IN VARCHAR2,
1237: p_retXml OUT NOCOPY CLOB)
1238: IS
1239: l_queryCtx DBMS_XMLGEN.ctxType;
1240: l_result1 xmlType;
1241: l_finalresult CLOB;
1242: l_str varchar2(2500);
1243: l_refcur SYS_REFCURSOR;

Line 1283: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1279: ' and F.PRIMARY_KEY_ID = P.PRIMARY_KEY_ID ' ||
1280: ' order by 1 ';
1281:
1282: open l_refcur for l_str using p_asname, p_objName;
1283: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1284: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FOREIGN_KEYS');
1285: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FOREIGN_KEY_ITEMS');
1286: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1287: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1284: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FOREIGN_KEYS');

1280: ' order by 1 ';
1281:
1282: open l_refcur for l_str using p_asname, p_objName;
1283: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1284: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FOREIGN_KEYS');
1285: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FOREIGN_KEY_ITEMS');
1286: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1287: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1288: if ( l_noOfRows <> 0 ) then

Line 1285: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FOREIGN_KEY_ITEMS');

1281:
1282: open l_refcur for l_str using p_asname, p_objName;
1283: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1284: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FOREIGN_KEYS');
1285: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FOREIGN_KEY_ITEMS');
1286: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1287: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1288: if ( l_noOfRows <> 0 ) then
1289: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_FOREIGN_KEYS');

Line 1286: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);

1282: open l_refcur for l_str using p_asname, p_objName;
1283: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1284: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FOREIGN_KEYS');
1285: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FOREIGN_KEY_ITEMS');
1286: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1287: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1288: if ( l_noOfRows <> 0 ) then
1289: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_FOREIGN_KEYS');
1290: l_finalresult := l_fndtabxml.getclobval();

Line 1287: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1283: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1284: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FOREIGN_KEYS');
1285: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FOREIGN_KEY_ITEMS');
1286: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1287: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1288: if ( l_noOfRows <> 0 ) then
1289: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_FOREIGN_KEYS');
1290: l_finalresult := l_fndtabxml.getclobval();
1291: else

Line 1309: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1305:
1306: ');
1307: l_finalresult := l_fndtabxml.getclobval();
1308: end if;
1309: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1310: close l_refcur;
1311:
1312:
1313: if ( l_noOfRows <> 0 ) then

Line 1341: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1337: ' and C.COLUMN_ID = FC.COLUMN_ID ' ||
1338: ' order by 1 ';
1339:
1340: open l_refcur for l_str using p_asname, p_objName;
1341: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1342: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FK_COLUMNS');
1343: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FK_COLUMN_ITEMS');
1344: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1345: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1342: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FK_COLUMNS');

1338: ' order by 1 ';
1339:
1340: open l_refcur for l_str using p_asname, p_objName;
1341: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1342: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FK_COLUMNS');
1343: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FK_COLUMN_ITEMS');
1344: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1345: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1346: if ( l_noOfRows <> 0 ) then

Line 1343: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FK_COLUMN_ITEMS');

1339:
1340: open l_refcur for l_str using p_asname, p_objName;
1341: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1342: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FK_COLUMNS');
1343: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FK_COLUMN_ITEMS');
1344: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1345: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1346: if ( l_noOfRows <> 0 ) then
1347: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_FK_COLUMNS');

Line 1344: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);

1340: open l_refcur for l_str using p_asname, p_objName;
1341: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1342: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FK_COLUMNS');
1343: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FK_COLUMN_ITEMS');
1344: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1345: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1346: if ( l_noOfRows <> 0 ) then
1347: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_FK_COLUMNS');
1348: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

Line 1345: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1341: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1342: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_FK_COLUMNS');
1343: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_FK_COLUMN_ITEMS');
1344: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1345: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1346: if ( l_noOfRows <> 0 ) then
1347: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_FK_COLUMNS');
1348: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1349: end if;

Line 1350: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1346: if ( l_noOfRows <> 0 ) then
1347: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_FK_COLUMNS');
1348: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1349: end if;
1350: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1351: close l_refcur;
1352:
1353: end if;
1354:

Line 1379: l_queryCtx DBMS_XMLGEN.ctxType;

1375: p_owner IN VARCHAR2,
1376: p_ASNAME IN VARCHAR2,
1377: p_retXml OUT NOCOPY CLOB)
1378: IS
1379: l_queryCtx DBMS_XMLGEN.ctxType;
1380: l_result1 xmlType;
1381: l_finalresult CLOB;
1382: l_str varchar2(2500);
1383: l_refcur SYS_REFCURSOR;

Line 1408: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1404: ' and C.APPLICATION_ID = T.APPLICATION_ID ' ||
1405: ' order by 1 ';
1406:
1407: open l_refcur for l_str using p_asname, p_objName;
1408: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1409: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_HISTOGRAM');
1410: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_HISTOGRAM_ITEMS');
1411: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1412: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1409: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_HISTOGRAM');

1405: ' order by 1 ';
1406:
1407: open l_refcur for l_str using p_asname, p_objName;
1408: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1409: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_HISTOGRAM');
1410: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_HISTOGRAM_ITEMS');
1411: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1412: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1413: if ( l_noOfRows <> 0 ) then

Line 1410: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_HISTOGRAM_ITEMS');

1406:
1407: open l_refcur for l_str using p_asname, p_objName;
1408: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1409: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_HISTOGRAM');
1410: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_HISTOGRAM_ITEMS');
1411: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1412: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1413: if ( l_noOfRows <> 0 ) then
1414: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_HISTOGRAM');

Line 1411: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);

1407: open l_refcur for l_str using p_asname, p_objName;
1408: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1409: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_HISTOGRAM');
1410: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_HISTOGRAM_ITEMS');
1411: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1412: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1413: if ( l_noOfRows <> 0 ) then
1414: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_HISTOGRAM');
1415: l_finalresult := l_fndtabxml.getclobval();

Line 1412: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1408: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1409: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_HISTOGRAM');
1410: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_HISTOGRAM_ITEMS');
1411: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1412: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1413: if ( l_noOfRows <> 0 ) then
1414: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_HISTOGRAM');
1415: l_finalresult := l_fndtabxml.getclobval();
1416: else

Line 1430: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1426: ');
1427: l_finalresult := l_fndtabxml.getclobval();
1428: end if;
1429:
1430: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1431: close l_refcur;
1432:
1433: -- printClobOut(l_finalresult);
1434:

Line 1445: l_queryCtx DBMS_XMLGEN.ctxType;

1441: p_owner IN VARCHAR2,
1442: p_ASNAME IN VARCHAR2,
1443: p_retXml OUT NOCOPY CLOB)
1444: IS
1445: l_queryCtx DBMS_XMLGEN.ctxType;
1446: l_result1 xmlType;
1447: l_finalresult CLOB;
1448: l_str varchar2(2500);
1449: l_refcur SYS_REFCURSOR;

Line 1498: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1494: ' and object_name = :2 ';
1495: */
1496:
1497: open l_refcur for l_str using p_asname, p_objName;
1498: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1499: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_OBJECT_TS');
1500: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_OBJECT_TABLESPACE');
1501: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1502: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1499: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_OBJECT_TS');

1495: */
1496:
1497: open l_refcur for l_str using p_asname, p_objName;
1498: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1499: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_OBJECT_TS');
1500: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_OBJECT_TABLESPACE');
1501: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1502: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1503: if ( l_noOfRows <> 0 ) then

Line 1500: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_OBJECT_TABLESPACE');

1496:
1497: open l_refcur for l_str using p_asname, p_objName;
1498: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1499: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_OBJECT_TS');
1500: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_OBJECT_TABLESPACE');
1501: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1502: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1503: if ( l_noOfRows <> 0 ) then
1504: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_OBJECT_TS/APPS_FND_OBJECT_TABLESPACE');

Line 1501: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);

1497: open l_refcur for l_str using p_asname, p_objName;
1498: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1499: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_OBJECT_TS');
1500: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_OBJECT_TABLESPACE');
1501: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1502: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1503: if ( l_noOfRows <> 0 ) then
1504: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_OBJECT_TS/APPS_FND_OBJECT_TABLESPACE');
1505: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

Line 1502: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1498: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1499: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_FND_OBJECT_TS');
1500: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_FND_OBJECT_TABLESPACE');
1501: l_result1:= DBMS_XMLGEN.getXMLType(l_queryCtx);
1502: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1503: if ( l_noOfRows <> 0 ) then
1504: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_OBJECT_TS/APPS_FND_OBJECT_TABLESPACE');
1505: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1506: else

Line 1528: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1524: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1525:
1526: end if;
1527:
1528: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1529: close l_refcur;
1530:
1531: p_retXml := l_finalresult;
1532:

Line 1542: l_queryCtx DBMS_XMLGEN.ctxType;

1538: p_owner IN VARCHAR2,
1539: p_ASNAME IN VARCHAR2,
1540: p_retXml OUT NOCOPY CLOB)
1541: IS
1542: l_queryCtx DBMS_XMLGEN.ctxType;
1543: l_result XmlType;
1544: l_finalresult CLOB;
1545: l_str varchar2(2500);
1546: l_refcur SYS_REFCURSOR;

Line 1561: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1557: ' INHERITED as INHERITED ' ||
1558: ' from ALL_TYPE_ATTRS where owner=:1 and type_name=:2 ';
1559:
1560: open l_refcur FOR l_str using p_owner, p_typeName;
1561: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1562: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE');
1563: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE_ITEMS');
1564:
1565: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);

Line 1562: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE');

1558: ' from ALL_TYPE_ATTRS where owner=:1 and type_name=:2 ';
1559:
1560: open l_refcur FOR l_str using p_owner, p_typeName;
1561: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1562: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE');
1563: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE_ITEMS');
1564:
1565: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1566:

Line 1563: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE_ITEMS');

1559:
1560: open l_refcur FOR l_str using p_owner, p_typeName;
1561: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1562: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE');
1563: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE_ITEMS');
1564:
1565: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1566:
1567: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1565: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);

1561: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1562: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE');
1563: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE_ITEMS');
1564:
1565: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1566:
1567: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1568: if ( l_noOfRows <> 0 ) then
1569: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_ATTRIBUTE');

Line 1567: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1563: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_ATTRIBUTE_ITEMS');
1564:
1565: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1566:
1567: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1568: if ( l_noOfRows <> 0 ) then
1569: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_ATTRIBUTE');
1570: else
1571: l_fndtypexml := xmlType('

Line 1578: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1574:
1575: l_finalresult := l_fndtypexml.getclobval();
1576:
1577: close l_refcur;
1578: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1579:
1580: p_retXml := l_finalresult;
1581:
1582: END get_type_attr;

Line 1591: l_queryCtx DBMS_XMLGEN.ctxType;

1587: p_owner IN VARCHAR2,
1588: p_ASNAME IN VARCHAR2,
1589: p_retXml OUT NOCOPY CLOB)
1590: IS
1591: l_queryCtx DBMS_XMLGEN.ctxType;
1592: l_result XmlType;
1593: l_finalresult CLOB;
1594: l_tmpXML CLOB;
1595: l_str varchar2(2500);

Line 1613: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1609: ' INHERITED as INHERITED ' ||
1610: ' from ALL_TYPE_METHODS where owner=:1 and type_name=:2';
1611:
1612: open l_refcur FOR l_str using p_owner, p_typeName;
1613: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1614: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD');
1615: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_ITEMS');
1616:
1617: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);

Line 1614: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD');

1610: ' from ALL_TYPE_METHODS where owner=:1 and type_name=:2';
1611:
1612: open l_refcur FOR l_str using p_owner, p_typeName;
1613: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1614: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD');
1615: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_ITEMS');
1616:
1617: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1618:

Line 1615: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_ITEMS');

1611:
1612: open l_refcur FOR l_str using p_owner, p_typeName;
1613: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1614: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD');
1615: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_ITEMS');
1616:
1617: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1618:
1619: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1617: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);

1613: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1614: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD');
1615: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_ITEMS');
1616:
1617: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1618:
1619: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1620: if ( l_noOfRows <> 0 ) then
1621: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD');

Line 1619: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1615: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_ITEMS');
1616:
1617: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1618:
1619: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1620: if ( l_noOfRows <> 0 ) then
1621: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD');
1622: else
1623: l_fndtypexml := xmlType('

Line 1630: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1626:
1627: l_finalresult := l_fndtypexml.getclobval();
1628:
1629: close l_refcur;
1630: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1631:
1632: if ( l_noOfRows <> 0 ) then
1633: get_type_method_params_results(p_typeName,p_owner,p_ASNAME,l_tmpXML);
1634: dbms_lob.append(l_finalresult,l_tmpXML);

Line 1648: l_queryCtx DBMS_XMLGEN.ctxType;

1644: p_owner IN VARCHAR2,
1645: p_ASNAME IN VARCHAR2,
1646: p_retXml OUT NOCOPY CLOB)
1647: IS
1648: l_queryCtx DBMS_XMLGEN.ctxType;
1649: l_result XmlType;
1650: l_finalresult CLOB;
1651: l_tmpXML CLOB;
1652: l_str varchar2(2500);

Line 1668: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1664: ' PARAM_TYPE_NAME as PARAM_TYPE_NAME ' ||
1665: ' from ALL_METHOD_PARAMS where owner=:1 and type_name=:2';
1666:
1667: open l_refcur FOR l_str using p_owner, p_typeName;
1668: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1669: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM');
1670: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM_ITEMS');
1671:
1672: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);

Line 1669: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM');

1665: ' from ALL_METHOD_PARAMS where owner=:1 and type_name=:2';
1666:
1667: open l_refcur FOR l_str using p_owner, p_typeName;
1668: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1669: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM');
1670: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM_ITEMS');
1671:
1672: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1673:

Line 1670: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM_ITEMS');

1666:
1667: open l_refcur FOR l_str using p_owner, p_typeName;
1668: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1669: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM');
1670: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM_ITEMS');
1671:
1672: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1673:
1674: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1672: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);

1668: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1669: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM');
1670: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM_ITEMS');
1671:
1672: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1673:
1674: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1675: if ( l_noOfRows <> 0 ) then
1676: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD_PARAM');

Line 1674: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1670: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_PARAM_ITEMS');
1671:
1672: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1673:
1674: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1675: if ( l_noOfRows <> 0 ) then
1676: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD_PARAM');
1677: else
1678: l_fndtypexml := xmlType('

Line 1685: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..

1681:
1682: l_finalresult := l_fndtypexml.getclobval();
1683:
1684: close l_refcur;
1685: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1686:
1687:
1688: l_str := 'select METHOD_NAME as METHOD_NAME, ' ||
1689: ' METHOD_NO as METHOD_NO, ' ||

Line 1695: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);

1691: ' RESULT_TYPE_NAME as RESULT_TYPE_NAME ' ||
1692: ' from ALL_METHOD_RESULTS where owner=:1 and type_name=:2';
1693:
1694: open l_refcur FOR l_str using p_owner, p_typeName;
1695: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1696: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT');
1697: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT_ITEMS');
1698:
1699: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);

Line 1696: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT');

1692: ' from ALL_METHOD_RESULTS where owner=:1 and type_name=:2';
1693:
1694: open l_refcur FOR l_str using p_owner, p_typeName;
1695: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1696: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT');
1697: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT_ITEMS');
1698:
1699: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1700:

Line 1697: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT_ITEMS');

1693:
1694: open l_refcur FOR l_str using p_owner, p_typeName;
1695: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1696: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT');
1697: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT_ITEMS');
1698:
1699: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1700:
1701: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

Line 1699: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);

1695: l_queryCtx := DBMS_XMLGEN.newContext(l_refcur);
1696: DBMS_XMLGEN.setRowsetTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT');
1697: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT_ITEMS');
1698:
1699: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1700:
1701: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1702: if ( l_noOfRows <> 0 ) then
1703: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD_RESULT');

Line 1701: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);

1697: DBMS_XMLGEN.setRowTag(l_queryCtx,'APPS_TYPE_METHOD_RESULT_ITEMS');
1698:
1699: l_result := DBMS_XMLGEN.getXMLType(l_queryCtx);
1700:
1701: l_noOfRows := DBMS_XMLGEN.getNumRowsProcessed(l_queryCtx);
1702: if ( l_noOfRows <> 0 ) then
1703: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD_RESULT');
1704: else
1705: l_fndtypexml := xmlType('

Line 1712: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle

1708:
1709: l_tmpXML := l_fndtypexml.getclobval();
1710:
1711: close l_refcur;
1712: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle
1713:
1714: dbms_lob.append(l_finalresult,l_tmpXML);
1715:
1716: p_retXml := l_finalresult;