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_LOB

Line 122: dbms_lob.append(l_finalXML,l_tmpXML);

118: l_finalXML := '
119: ';
120: l_tmpXML := '' || p_appshortName || '
121: ';
122: dbms_lob.append(l_finalXML,l_tmpXML);
123:
124: if (p_concatVar IS NOT NULL) then
125: l_tmpXML := '' || p_concatVar || '
126: ';

Line 131: dbms_lob.append(l_finalXML,l_tmpXML);

127: else
128: l_tmpXML := '0
129: ';
130: end if;
131: dbms_lob.append(l_finalXML,l_tmpXML);
132:
133: /* vkhatri bug 4929568 */
134: if ( p_objMode = 'type' ) then
135: l_tmpXML := '

Line 137: dbms_lob.append(l_finalXML,l_tmpXML);

133: /* vkhatri bug 4929568 */
134: if ( p_objMode = 'type' ) then
135: l_tmpXML := '
136: ';
137: dbms_lob.append(l_finalXML,l_tmpXML);
138: get_type_attr(p_objName,p_schemaName,p_appshortName,l_tmpXML);
139: dbms_lob.append(l_finalXML,l_tmpXML);
140: get_type_method(p_objName,p_schemaName,p_appshortName,l_tmpXML);
141: dbms_lob.append(l_finalXML,l_tmpXML);

Line 139: dbms_lob.append(l_finalXML,l_tmpXML);

135: l_tmpXML := '
136: ';
137: dbms_lob.append(l_finalXML,l_tmpXML);
138: get_type_attr(p_objName,p_schemaName,p_appshortName,l_tmpXML);
139: dbms_lob.append(l_finalXML,l_tmpXML);
140: get_type_method(p_objName,p_schemaName,p_appshortName,l_tmpXML);
141: dbms_lob.append(l_finalXML,l_tmpXML);
142: l_tmpXML := '
143: ';

Line 141: dbms_lob.append(l_finalXML,l_tmpXML);

137: dbms_lob.append(l_finalXML,l_tmpXML);
138: get_type_attr(p_objName,p_schemaName,p_appshortName,l_tmpXML);
139: dbms_lob.append(l_finalXML,l_tmpXML);
140: get_type_method(p_objName,p_schemaName,p_appshortName,l_tmpXML);
141: dbms_lob.append(l_finalXML,l_tmpXML);
142: l_tmpXML := '
143: ';
144: dbms_lob.append(l_finalXML,l_tmpXML);
145: end if;

Line 144: dbms_lob.append(l_finalXML,l_tmpXML);

140: get_type_method(p_objName,p_schemaName,p_appshortName,l_tmpXML);
141: dbms_lob.append(l_finalXML,l_tmpXML);
142: l_tmpXML := '
143: ';
144: dbms_lob.append(l_finalXML,l_tmpXML);
145: end if;
146:
147: /* Extracting aol metadata for table */
148: if ( p_objMode = 'table' ) then

Line 152: dbms_lob.append(l_finalXML,l_tmpXML);

148: if ( p_objMode = 'table' ) then
149: /* is_temp_iot( p_objName, p_schemaName, p_typ); // added support for aol metadata for IOT and GTT
150: if(p_typ = 'N') then */
151: l_tmpXML := '';
152: dbms_lob.append(l_finalXML,l_tmpXML);
153: get_fnd_table_metadata(p_objName,p_schemaName,p_appshortName,l_tmpXML);
154: dbms_lob.append(l_finalXML,l_tmpXML);
155: l_tmpXML := '
156: ';

Line 154: dbms_lob.append(l_finalXML,l_tmpXML);

150: if(p_typ = 'N') then */
151: l_tmpXML := '';
152: dbms_lob.append(l_finalXML,l_tmpXML);
153: get_fnd_table_metadata(p_objName,p_schemaName,p_appshortName,l_tmpXML);
154: dbms_lob.append(l_finalXML,l_tmpXML);
155: l_tmpXML := '
156: ';
157: dbms_lob.append(l_finalXML,l_tmpXML);
158: --end if;

Line 157: dbms_lob.append(l_finalXML,l_tmpXML);

153: get_fnd_table_metadata(p_objName,p_schemaName,p_appshortName,l_tmpXML);
154: dbms_lob.append(l_finalXML,l_tmpXML);
155: l_tmpXML := '
156: ';
157: dbms_lob.append(l_finalXML,l_tmpXML);
158: --end if;
159: end if;
160:
161:

Line 165: dbms_lob.append(l_finalXML,l_tmpXML);

161:
162: /* Extracting aol metadata for views */
163: if ( p_objMode = 'view' ) then
164: get_fnd_view_metadata(p_objName,p_schemaName,p_appshortName,l_tmpXML);
165: dbms_lob.append(l_finalXML,l_tmpXML);
166: end if;
167:
168: /* Extracting AOL metadata for mview */
169:

Line 172: dbms_lob.append(l_finalXML,l_tmpXML);

168: /* Extracting AOL metadata for mview */
169:
170: if ( p_objMode = 'mview' ) then
171: l_tmpXML := '';
172: dbms_lob.append(l_finalXML,l_tmpXML);
173: get_fnd_mview_metadata(p_objName,p_schemaName,p_appshortName,l_tmpXML);
174: dbms_lob.append(l_finalXML,l_tmpXML);
175: l_tmpXML := '';
176: dbms_lob.append(l_finalXML,l_tmpXML);

Line 174: dbms_lob.append(l_finalXML,l_tmpXML);

170: if ( p_objMode = 'mview' ) then
171: l_tmpXML := '';
172: dbms_lob.append(l_finalXML,l_tmpXML);
173: get_fnd_mview_metadata(p_objName,p_schemaName,p_appshortName,l_tmpXML);
174: dbms_lob.append(l_finalXML,l_tmpXML);
175: l_tmpXML := '';
176: dbms_lob.append(l_finalXML,l_tmpXML);
177: end if;
178:

Line 176: dbms_lob.append(l_finalXML,l_tmpXML);

172: dbms_lob.append(l_finalXML,l_tmpXML);
173: get_fnd_mview_metadata(p_objName,p_schemaName,p_appshortName,l_tmpXML);
174: dbms_lob.append(l_finalXML,l_tmpXML);
175: l_tmpXML := '';
176: dbms_lob.append(l_finalXML,l_tmpXML);
177: end if;
178:
179:
180:

Line 184: dbms_lob.append(l_finalXML,l_tmpXML);

180:
181: if ( p_objMode = 'policy' ) then
182: get_xml_policy(p_objName,p_schemaName,p_includePolicy,p_policyCtr, l_policyListing,l_tmpXML);
183: if ( l_tmpXML is not null ) then
184: dbms_lob.append(l_finalXML,l_tmpXML);
185: end if;
186:
187: else
188:

Line 221: dbms_lob.append(l_finalXML,l_tmpXML);

217: end if;
218:
219:
220: l_tmpXML := l_eobjXMLs.getClobVal();
221: dbms_lob.append(l_finalXML,l_tmpXML);
222:
223: if( p_objMode <> 'index' and
224: p_objMode <> 'policy' and
225: p_objMode <> 'context' and

Line 280: dbms_lob.append(l_finalXML,l_tmpXML);

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 */
283: l_indexOpenHandle1 := sys.ad_dbms_metadata.open('INDEX');
284: l_depInfo := l_depInfo || 'Indexes on Materialized view log of ' || p_objMode

Line 314: dbms_lob.append(l_finalXML,l_tmpXML);

310: if (instr(l_indexName,'I_SNAP$')= 0) then
311: l_indexCtr := l_indexCtr + 1;
312: l_depInfo := l_depInfo || ' ' || l_indexName || '
313: ';
314: dbms_lob.append(l_finalXML,l_tmpXML);
315: end if;
316: END LOOP; -- end of index loop.
317:
318: if ( l_indexCtr = 0 ) then

Line 396: dbms_lob.append(l_finalXML,l_tmpXML);

392: if (instr(l_indexName,'I_SNAP$')= 0) then
393: l_depInfo := l_depInfo || ' ' || l_indexName || '
394: ';
395: l_indexCtr := l_indexCtr + 1;
396: dbms_lob.append(l_finalXML,l_tmpXML);
397: end if;
398: END LOOP;
399:
400: if ( l_indexCtr = 0 ) then

Line 466: dbms_lob.append(l_finalXML,l_tmpXML);

462: FROM DUAL;
463:
464: if ((l_ctr = 1) or (instr(p_includeTrigger,l_triggerName) <> 0)) then
465: l_tmpXML := l_eobjXMLs.getClobVal();
466: dbms_lob.append(l_finalXML,l_tmpXML);
467: l_depInfo := l_depInfo || ' ' || l_triggerName || '
468: ';
469: p_triggerCtr := p_triggerCtr + 1;
470: end if;

Line 504: dbms_lob.append(l_finalXML,l_tmpXML);

500: else
501: l_depInfo := l_depInfo || l_seqListing ;
502: end if;
503: if ( l_tmpXML is not null ) then
504: dbms_lob.append(l_finalXML,l_tmpXML);
505: end if;
506: end if;
507:
508: -- start of adusange code for policies generation.

Line 522: dbms_lob.append(l_finalXML,l_tmpXML);

518: else
519: l_depInfo := l_depInfo || l_policyListing || ' ';
520: end if;
521: if ( l_tmpXML is not null ) then
522: dbms_lob.append(l_finalXML,l_tmpXML);
523: end if;
524: end if;
525: --end of adusange code.
526:

Line 546: dbms_lob.append(l_finalXML,'

542: EXIT;
543: end;
544: l_commentCtr := l_commentCtr + 1;
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();

Line 551: dbms_lob.append(l_finalXML,l_tmpXML);

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:
554: if ( l_commentCtr <> 0 ) then
555: dbms_lob.append(l_finalXML,'

Line 555: dbms_lob.append(l_finalXML,'

551: dbms_lob.append(l_finalXML,l_tmpXML);
552: END LOOP;
553:
554: if ( l_commentCtr <> 0 ) then
555: dbms_lob.append(l_finalXML,'
556: ');
557: end if;
558:
559: sys.ad_dbms_metadata.close(l_commentOpenHandle);

Line 566: dbms_lob.append(l_finalXML,l_tmpXML);

562:
563: /*
564: get_ddl_comment( p_objName,p_schemaName, l_tmpXML);
565: if ( l_tmpXML is not null ) then
566: dbms_lob.append(l_finalXML,l_tmpXML);
567: end if;
568: */
569:
570: END LOOP;

Line 576: dbms_lob.append(l_finalXML,l_tmpXML);

572: end if;
573:
574: l_tmpXML := '
575: ';
576: dbms_lob.append(l_finalXML,l_tmpXML);
577: sys.ad_dbms_metadata.close(l_objOpenHandle);
578: p_objInfo := l_depInfo;
579: p_retXML := l_finalXML;
580:

Line 642: dbms_lob.append(l_finalXML,l_tmpXML);

638: l_tmpXML := l_eobjXMLs.getClobVal();
639: if ( l_finalXML is null ) then
640: l_finalXML := l_tmpXML;
641: else
642: dbms_lob.append(l_finalXML,l_tmpXML);
643: end if;
644: END LOOP;
645:
646: sys.ad_dbms_metadata.close(l_objXMLOpenHandle);

Line 711: dbms_lob.append(l_finalXML,l_tmpXML);

707: l_tmpXML := l_eobjXMLs.getClobVal();
708: if ( l_finalXML is null ) then
709: l_finalXML := l_tmpXML;
710: else
711: dbms_lob.append(l_finalXML,l_tmpXML);
712: end if;
713: end if;
714: END LOOP;
715:

Line 736: dbms_lob.append(l_finalresult,l_tmpresult);

732: /* Extracting metadata from fnd_tables and fnd_columns */
733: get_fnd_tab_col_metadata(p_tableName,p_owner,p_ASNAME,l_finalresult);
734:
735: get_fnd_primary_key_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
736: dbms_lob.append(l_finalresult,l_tmpresult);
737:
738: get_fnd_foreign_key_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
739: dbms_lob.append(l_finalresult,l_tmpresult);
740:

Line 739: dbms_lob.append(l_finalresult,l_tmpresult);

735: get_fnd_primary_key_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
736: dbms_lob.append(l_finalresult,l_tmpresult);
737:
738: get_fnd_foreign_key_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
739: dbms_lob.append(l_finalresult,l_tmpresult);
740:
741: get_fnd_histogram_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
742: dbms_lob.append(l_finalresult,l_tmpresult);
743:

Line 742: dbms_lob.append(l_finalresult,l_tmpresult);

738: get_fnd_foreign_key_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
739: dbms_lob.append(l_finalresult,l_tmpresult);
740:
741: get_fnd_histogram_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
742: dbms_lob.append(l_finalresult,l_tmpresult);
743:
744: get_fnd_tablespace_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
745: dbms_lob.append(l_finalresult,l_tmpresult);
746:

Line 745: dbms_lob.append(l_finalresult,l_tmpresult);

741: get_fnd_histogram_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
742: dbms_lob.append(l_finalresult,l_tmpresult);
743:
744: get_fnd_tablespace_metadata(p_tableName,p_owner,p_ASNAME,l_tmpresult);
745: dbms_lob.append(l_finalresult,l_tmpresult);
746:
747: p_retXml := l_finalresult;
748:
749: END get_fnd_table_metadata;

Line 815: dbms_lob.append(l_finalresult,l_tmpresult);

811: /* Extracting metadata from fnd_tables and fnd_columns */
812: get_fnd_tab_col_metadata(p_mviewName,p_owner,p_ASNAME,l_finalresult);
813:
814: get_fnd_histogram_metadata(p_mviewName,p_owner,p_ASNAME,l_tmpresult);
815: dbms_lob.append(l_finalresult,l_tmpresult);
816:
817: p_retXml := l_finalresult;
818:
819: END get_fnd_mview_metadata;

Line 896: dbms_lob.append(l_finalXML,l_ddl.ddltext);

892: l_ddl := l_ddls(1);
893: if ( l_finalXML is null ) then
894: l_finalXML := l_ddl.ddltext;
895: else
896: dbms_lob.append(l_finalXML,l_ddl.ddltext);
897: end if;
898:
899: END LOOP;
900: if ( l_finalXML is not null ) then

Line 904: dbms_lob.append(l_tmpXML,l_finalXML);

900: if ( l_finalXML is not null ) then
901: l_tmpXML := '
902:
903: ';
904: dbms_lob.append(l_tmpXML,l_finalXML);
905: dbms_lob.append(l_tmpXML,'
906: ');
907: dbms_lob.append(l_tmpXML,'
908: ');

Line 905: dbms_lob.append(l_tmpXML,'

901: l_tmpXML := '
902:
903: ';
904: dbms_lob.append(l_tmpXML,l_finalXML);
905: dbms_lob.append(l_tmpXML,'
906: ');
907: dbms_lob.append(l_tmpXML,'
908: ');
909: end if;

Line 907: dbms_lob.append(l_tmpXML,'

903: ';
904: dbms_lob.append(l_tmpXML,l_finalXML);
905: dbms_lob.append(l_tmpXML,'
906: ');
907: dbms_lob.append(l_tmpXML,'
908: ');
909: end if;
910:
911: sys.ad_dbms_metadata.close(l_objXMLOpenHandle);

Line 1097: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

1093: SEED
1094: '|| l_ludate ||'
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;

Line 1100: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

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..
1104: close l_refcur;

Line 1207: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

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;
1211:

Line 1225: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

1221: '|| l_ludate ||'
1222:
1223:
1224: ');
1225: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1226:
1227: end if;
1228:
1229: --printClobOut(l_finalresult);

Line 1348: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

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;
1352:

Line 1366: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

1362: '|| l_ludate ||'
1363:
1364:
1365: ');
1366: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());
1367: end if;
1368:
1369:
1370: p_retXml := l_finalresult;

Line 1505: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

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('
1509: N

Line 1524: dbms_lob.append(l_finalresult,l_fndtabxml.getclobval());

1520: l_fndtabxml := xmlType('
1521: TRANSACTION_TABLES
1522:
1523: ');
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..

Line 1634: dbms_lob.append(l_finalresult,l_tmpXML);

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);
1635: end if;
1636:
1637: p_retXml := l_finalresult;
1638:

Line 1714: dbms_lob.append(l_finalresult,l_tmpXML);

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;
1717:
1718: END get_type_method_params_results;