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 XMLTYPE

Line 30: l_indexNameXML sys.XMLtype;

26: l_commentCtr NUMBER;
27: l_ctr NUMBER;
28: l_finalXML CLOB;
29: l_tmpXML CLOB;
30: l_indexNameXML sys.XMLtype;
31: l_objXMLs sys.XMLType;
32: l_eobjXMLs sys.XMLType;
33: l_indexXMLs sys.XMLType;
34: l_triggerXMLs sys.XMLType;

Line 31: l_objXMLs sys.XMLType;

27: l_ctr NUMBER;
28: l_finalXML CLOB;
29: l_tmpXML CLOB;
30: l_indexNameXML sys.XMLtype;
31: l_objXMLs sys.XMLType;
32: l_eobjXMLs sys.XMLType;
33: l_indexXMLs sys.XMLType;
34: l_triggerXMLs sys.XMLType;
35: l_sysNameXML sys.XMLType;

Line 32: l_eobjXMLs sys.XMLType;

28: l_finalXML CLOB;
29: l_tmpXML CLOB;
30: l_indexNameXML sys.XMLtype;
31: l_objXMLs sys.XMLType;
32: l_eobjXMLs sys.XMLType;
33: l_indexXMLs sys.XMLType;
34: l_triggerXMLs sys.XMLType;
35: l_sysNameXML sys.XMLType;
36: l_commentXMLs sys.XMLType;

Line 33: l_indexXMLs sys.XMLType;

29: l_tmpXML CLOB;
30: l_indexNameXML sys.XMLtype;
31: l_objXMLs sys.XMLType;
32: l_eobjXMLs sys.XMLType;
33: l_indexXMLs sys.XMLType;
34: l_triggerXMLs sys.XMLType;
35: l_sysNameXML sys.XMLType;
36: l_commentXMLs sys.XMLType;
37: l_policyXMLs sys.XMLType; --added by adusange

Line 34: l_triggerXMLs sys.XMLType;

30: l_indexNameXML sys.XMLtype;
31: l_objXMLs sys.XMLType;
32: l_eobjXMLs sys.XMLType;
33: l_indexXMLs sys.XMLType;
34: l_triggerXMLs sys.XMLType;
35: l_sysNameXML sys.XMLType;
36: l_commentXMLs sys.XMLType;
37: l_policyXMLs sys.XMLType; --added by adusange
38: parsedItems sys.ku$_parsed_items;

Line 35: l_sysNameXML sys.XMLType;

31: l_objXMLs sys.XMLType;
32: l_eobjXMLs sys.XMLType;
33: l_indexXMLs sys.XMLType;
34: l_triggerXMLs sys.XMLType;
35: l_sysNameXML sys.XMLType;
36: l_commentXMLs sys.XMLType;
37: l_policyXMLs sys.XMLType; --added by adusange
38: parsedItems sys.ku$_parsed_items;
39: l_tableName VARCHAR2(30);

Line 36: l_commentXMLs sys.XMLType;

32: l_eobjXMLs sys.XMLType;
33: l_indexXMLs sys.XMLType;
34: l_triggerXMLs sys.XMLType;
35: l_sysNameXML sys.XMLType;
36: l_commentXMLs sys.XMLType;
37: l_policyXMLs sys.XMLType; --added by adusange
38: parsedItems sys.ku$_parsed_items;
39: l_tableName VARCHAR2(30);
40: l_buf VARCHAR2(32000);

Line 37: l_policyXMLs sys.XMLType; --added by adusange

33: l_indexXMLs sys.XMLType;
34: l_triggerXMLs sys.XMLType;
35: l_sysNameXML sys.XMLType;
36: l_commentXMLs sys.XMLType;
37: l_policyXMLs sys.XMLType; --added by adusange
38: parsedItems sys.ku$_parsed_items;
39: l_tableName VARCHAR2(30);
40: l_buf VARCHAR2(32000);
41: l_tmpBuf VARCHAR2(30);

Line 194: l_eobjXMLs := XMLType.extract(l_objXMLs,'ROWSET/ROW');

190: /* Main loop for master objects */
191: l_objXMLs := sys.ad_dbms_metadata.fetch_xml(l_objOpenHandle);
192: EXIT WHEN l_objXMLs IS NULL;
193:
194: l_eobjXMLs := XMLType.extract(l_objXMLs,'ROWSET/ROW');
195:
196: if ( p_objMode = 'table' ) then
197: /* check if the constraints are system generated */
198: l_sysNameXML := XMLType.extract(l_objXMLs,'ROWSET/ROW/TABLE_T/CON1_LIST/CON1_LIST_ITEM/NAME');

Line 198: l_sysNameXML := XMLType.extract(l_objXMLs,'ROWSET/ROW/TABLE_T/CON1_LIST/CON1_LIST_ITEM/NAME');

194: l_eobjXMLs := XMLType.extract(l_objXMLs,'ROWSET/ROW');
195:
196: if ( p_objMode = 'table' ) then
197: /* check if the constraints are system generated */
198: l_sysNameXML := XMLType.extract(l_objXMLs,'ROWSET/ROW/TABLE_T/CON1_LIST/CON1_LIST_ITEM/NAME');
199: if (NOT l_sysNameXML IS NULL ) then
200: l_consName := l_sysNameXML.getStringVal();
201:
202: if (instr(l_consName,'>SYS_') <> 0) then

Line 208: l_sysNameXML := XMLType.extract(l_objXMLs,'ROWSET/ROW/TABLE_T/CON2_LIST/CON2_LIST_ITEM/NAME');

204: end if;
205: end if;
206:
207: if ( p_sysName <> 1 ) then
208: l_sysNameXML := XMLType.extract(l_objXMLs,'ROWSET/ROW/TABLE_T/CON2_LIST/CON2_LIST_ITEM/NAME');
209: if (NOT l_sysNameXML IS NULL ) then
210: l_consName := l_sysNameXML.getStringVal();
211: if (instr(l_consName,'>SYS_') <> 0) then
212: p_sysName := 1;

Line 278: l_eobjXMLs := XMLType.extract(l_indexXMLs,'ROWSET/ROW');

274: ' || ' ' || l_mlogName
275: || '
276: ';
277:
278: l_eobjXMLs := XMLType.extract(l_indexXMLs,'ROWSET/ROW');
279: l_tmpXML := l_eobjXMLs.getClobVal();
280: dbms_lob.append(l_finalXML,l_tmpXML);
281:
282: /* get the indexes on mviewlogs */

Line 304: l_eobjXMLs := XMLType.extract(l_indexXMLs,'ROWSET/ROW');

300: THEN RAISE_APPLICATION_ERROR(
301: -20001, 'Internal sys.ad_dbms_metadata.fetch_xml error', TRUE);
302: END;
303:
304: l_eobjXMLs := XMLType.extract(l_indexXMLs,'ROWSET/ROW');
305:
306: SELECT extractValue(l_indexXMLs,'ROWSET/ROW/INDEX_T/SCHEMA_OBJ/NAME')
307: INTO l_indexName
308: FROM DUAL;

Line 383: l_eobjXMLs := XMLType.extract(l_indexXMLs,'ROWSET/ROW');

379: l_indexCtr := 0;
380: EXIT;
381: end;
382:
383: l_eobjXMLs := XMLType.extract(l_indexXMLs,'ROWSET/ROW');
384: SELECT extractValue(l_indexXMLs,'ROWSET/ROW/INDEX_T/SCHEMA_OBJ/NAME')
385: INTO l_indexName
386: FROM DUAL;
387:

Line 389: -- l_indexNameXML := XMLType.extract(l_indexXMLs,'ROWSET/ROW/INDEX_T/SCHEMA_OBJ/NAME');

385: INTO l_indexName
386: FROM DUAL;
387:
388:
389: -- l_indexNameXML := XMLType.extract(l_indexXMLs,'ROWSET/ROW/INDEX_T/SCHEMA_OBJ/NAME');
390: -- l_indexName := l_indexNameXML.getStringVal();
391: l_tmpXML := l_eobjXMLs.getClobVal();
392: if (instr(l_indexName,'I_SNAP$')= 0) then
393: l_depInfo := l_depInfo || ' ' || l_indexName || '

Line 458: l_eobjXMLs := XMLType.extract(l_triggerXMLs,'ROWSET/ROW');

454: when others then
455: p_triggerCtr := 0;
456: EXIT;
457: end;
458: l_eobjXMLs := XMLType.extract(l_triggerXMLs,'ROWSET/ROW');
459:
460: SELECT extractValue(l_triggerXMLs,'ROWSET/ROW/TRIGGER_T/SCHEMA_OBJ/NAME')
461: INTO l_triggerName
462: FROM DUAL;

Line 549: l_eobjXMLs := XMLType.extract(l_commentXMLs,'ROWSET/ROW/COMMENT_T');

545: if ( l_commentCtr = 1 ) then
546: dbms_lob.append(l_finalXML,'
547: ');
548: end if;
549: l_eobjXMLs := XMLType.extract(l_commentXMLs,'ROWSET/ROW/COMMENT_T');
550: l_tmpXML := l_eobjXMLs.getClobVal();
551: dbms_lob.append(l_finalXML,l_tmpXML);
552: END LOOP;
553:

Line 597: l_eobjXMLs sys.XMLType;

593: l_seqList DBMS_UTILITY.UNCL_ARRAY;
594: finalInSt VARCHAR2(1000);
595: l_finalXML CLOB;
596: l_tmpXML CLOB;
597: l_eobjXMLs sys.XMLType;
598: l_sequenceXML sys.XMLType;
599: l_SeqName VARCHAR2(50);
600:
601: BEGIN

Line 598: l_sequenceXML sys.XMLType;

594: finalInSt VARCHAR2(1000);
595: l_finalXML CLOB;
596: l_tmpXML CLOB;
597: l_eobjXMLs sys.XMLType;
598: l_sequenceXML sys.XMLType;
599: l_SeqName VARCHAR2(50);
600:
601: BEGIN
602:

Line 632: l_eobjXMLs := XMLType.extract(l_sequenceXML,'ROWSET/ROW');

628: p_seqCount := 0;
629: EXIT;
630: end;
631: p_seqCount := p_seqCount + 1;
632: l_eobjXMLs := XMLType.extract(l_sequenceXML,'ROWSET/ROW');
633: SELECT extractValue(l_sequenceXML,'ROWSET/ROW/SEQUENCE_T/SCHEMA_OBJ/NAME')
634: INTO l_SeqName
635: FROM DUAL;
636: p_SeqListing := p_SeqListing || ' ' || l_SeqName || '

Line 669: l_eobjXMLs sys.XMLType;

665: l_policyList DBMS_UTILITY.UNCL_ARRAY;
666: finalInSt VARCHAR2(1000);
667: l_finalXML CLOB;
668: l_tmpXML CLOB;
669: l_eobjXMLs sys.XMLType;
670: l_policyXML sys.XMLType;
671: l_ctr NUMBER;
672: l_policyName VARCHAR2(50);
673:

Line 670: l_policyXML sys.XMLType;

666: finalInSt VARCHAR2(1000);
667: l_finalXML CLOB;
668: l_tmpXML CLOB;
669: l_eobjXMLs sys.XMLType;
670: l_policyXML sys.XMLType;
671: l_ctr NUMBER;
672: l_policyName VARCHAR2(50);
673:
674: BEGIN

Line 698: l_eobjXMLs := XMLType.extract(l_policyXML,'ROWSET/ROW');

694: p_policyCount := 0;
695: EXIT;
696: end;
697:
698: l_eobjXMLs := XMLType.extract(l_policyXML,'ROWSET/ROW');
699: SELECT extractValue(l_policyXML,'ROWSET/ROW/RLS_POLICY_T/NAME')
700: INTO l_policyName
701: FROM DUAL;
702:

Line 757: l_result0 XmlType;

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;
761: l_noOfRows number;

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 783: l_result0 := xmltype('

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
786: ' || l_ludate || '
787:

Line 924: l_result0 XmlType;

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);
928: l_refcur SYS_REFCURSOR;

Line 925: l_result1 xmlType;

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);
928: l_refcur SYS_REFCURSOR;
929: l_fndtabxml XMLType;

Line 929: l_fndtabxml XMLType;

925: l_result1 xmlType;
926: l_finalresult CLOB;
927: l_str varchar2(2500);
928: l_refcur SYS_REFCURSOR;
929: l_fndtabxml XMLType;
930: l_noOfRows number;
931: l_ludate varchar2(30);
932: l_comments varchar2(240);
933: BEGIN

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 964: l_fndtabxml := xmltype.extract(l_result0,'APPS_AOL_METADATA/APPS_FND_TABLES');

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('
967: T
968: '||l_comments||'

Line 966: l_fndtabxml := xmltype('

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('
967: T
968: '||l_comments||'
969: SEED
970: ' || l_ludate || '

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 1088: l_fndtabxml := xmlType('

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:
1091:
1092:

Line 1099: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_COLUMNS');

1095:
1096: ');
1097: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1098: else
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..

Line 1116: l_result1 xmlType;

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;
1120: l_fndtabxml XMLType;

Line 1120: l_fndtabxml XMLType;

1116: l_result1 xmlType;
1117: l_finalresult CLOB;
1118: l_str varchar2(2500);
1119: l_refcur SYS_REFCURSOR;
1120: l_fndtabxml XMLType;
1121: l_noOfRows number;
1122: l_ludate varchar2(30);
1123: BEGIN
1124:

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 1151: l_fndtabxml := xmltype.extract(l_result1,'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
1154: l_fndtabxml := xmlType('
1155:

Line 1154: l_fndtabxml := xmlType('

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
1154: l_fndtabxml := xmlType('
1155:
1156:
1157:
1158: N

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 1206: l_fndtabxml := xmltype.extract(l_result1,'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;
1209: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1210: close l_refcur;

Line 1215: l_fndtabxml := xmlType('

1211:
1212: end if;
1213:
1214: if ( l_noOfRows = 0 ) then
1215: l_fndtabxml := xmlType('
1216:
1217:
1218:
1219:

Line 1240: l_result1 xmlType;

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;
1244: l_fndtabxml XMLType;

Line 1244: l_fndtabxml XMLType;

1240: l_result1 xmlType;
1241: l_finalresult CLOB;
1242: l_str varchar2(2500);
1243: l_refcur SYS_REFCURSOR;
1244: l_fndtabxml XMLType;
1245: l_noOfRows number;
1246: l_ludate varchar2(30);
1247: BEGIN
1248:

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 1289: l_fndtabxml := xmltype.extract(l_result1,'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
1292: l_fndtabxml := xmlType('
1293:

Line 1292: l_fndtabxml := xmlType('

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
1292: l_fndtabxml := xmlType('
1293:
1294:
1295:
1296:

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 1347: l_fndtabxml := xmltype.extract(l_result1,'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;
1350: DBMS_XMLGEN.closeContext(l_queryCtx); -- you must close the query handle..
1351: close l_refcur;

Line 1356: l_fndtabxml := xmlType('

1352:
1353: end if;
1354:
1355: if ( l_noOfRows = 0 ) then
1356: l_fndtabxml := xmlType('
1357:
1358:
1359:
1360:

Line 1380: l_result1 xmlType;

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;
1384: l_fndtabxml XMLType;

Line 1384: l_fndtabxml XMLType;

1380: l_result1 xmlType;
1381: l_finalresult CLOB;
1382: l_str varchar2(2500);
1383: l_refcur SYS_REFCURSOR;
1384: l_fndtabxml XMLType;
1385: l_noOfRows number;
1386: l_ludate varchar2(30);
1387: --l_comments varchar2(240);
1388: BEGIN

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 1414: l_fndtabxml := xmltype.extract(l_result1,'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
1417: l_fndtabxml := xmlType('
1418:

Line 1417: l_fndtabxml := xmlType('

1413: if ( l_noOfRows <> 0 ) then
1414: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_HISTOGRAM');
1415: l_finalresult := l_fndtabxml.getclobval();
1416: else
1417: l_fndtabxml := xmlType('
1418:
1419:
1420:
1421:

Line 1446: l_result1 xmlType;

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;
1450: l_fndtabxml XMLType;

Line 1450: l_fndtabxml XMLType;

1446: l_result1 xmlType;
1447: l_finalresult CLOB;
1448: l_str varchar2(2500);
1449: l_refcur SYS_REFCURSOR;
1450: l_fndtabxml XMLType;
1451: l_noOfRows number;
1452: BEGIN
1453: /* get the tablespace info */
1454:

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 1504: l_fndtabxml := xmltype.extract(l_result1,'APPS_FND_OBJECT_TS/APPS_FND_OBJECT_TABLESPACE');

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
1507: /*
1508: l_fndtabxml := xmlType('

Line 1508: l_fndtabxml := xmlType('

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
1507: /*
1508: l_fndtabxml := xmlType('
1509: N
1510: N
1511: N
1512: N

Line 1520: l_fndtabxml := xmlType('

1516:
1517: ');
1518: */
1519:
1520: l_fndtabxml := xmlType('
1521: TRANSACTION_TABLES
1522:
1523: ');
1524: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

Line 1543: l_result XmlType;

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;
1547: l_fndtypexml XMLType;

Line 1547: l_fndtypexml XMLType;

1543: l_result XmlType;
1544: l_finalresult CLOB;
1545: l_str varchar2(2500);
1546: l_refcur SYS_REFCURSOR;
1547: l_fndtypexml XMLType;
1548: l_noOfRows number;
1549: BEGIN
1550:
1551: l_str := 'select ATTR_NAME as ATTRIBUTE_NAME, ' ||

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 1569: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_ATTRIBUTE');

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('
1572: ');
1573: end if;

Line 1571: l_fndtypexml := xmlType('

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('
1572: ');
1573: end if;
1574:
1575: l_finalresult := l_fndtypexml.getclobval();

Line 1592: l_result XmlType;

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);
1596: l_refcur SYS_REFCURSOR;

Line 1597: l_fndtypexml XMLType;

1593: l_finalresult CLOB;
1594: l_tmpXML CLOB;
1595: l_str varchar2(2500);
1596: l_refcur SYS_REFCURSOR;
1597: l_fndtypexml XMLType;
1598: l_noOfRows number;
1599: BEGIN
1600:
1601: l_str := 'select METHOD_NAME as METHOD_NAME, ' ||

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 1621: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD');

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('
1624: ');
1625: end if;

Line 1623: l_fndtypexml := xmlType('

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('
1624: ');
1625: end if;
1626:
1627: l_finalresult := l_fndtypexml.getclobval();

Line 1649: l_result XmlType;

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);
1653: l_refcur SYS_REFCURSOR;

Line 1654: l_fndtypexml XMLType;

1650: l_finalresult CLOB;
1651: l_tmpXML CLOB;
1652: l_str varchar2(2500);
1653: l_refcur SYS_REFCURSOR;
1654: l_fndtypexml XMLType;
1655: l_noOfRows number;
1656: BEGIN
1657:
1658: l_str := 'select METHOD_NAME as METHOD_NAME, ' ||

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 1676: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD_PARAM');

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('
1679: ');
1680: end if;

Line 1678: l_fndtypexml := xmlType('

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('
1679: ');
1680: end if;
1681:
1682: l_finalresult := l_fndtypexml.getclobval();

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 1703: l_fndtypexml := xmltype.extract(l_result,'APPS_TYPE_METHOD_RESULT');

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('
1706: ');
1707: end if;

Line 1705: l_fndtypexml := xmlType('

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('
1706: ');
1707: end if;
1708:
1709: l_tmpXML := l_fndtypexml.getclobval();