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.OKC_REP_CONTRACT_TEXT_IDX_PVT dependencies on DBMS_LOB

Line 93: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );

89: FETCH con_cur BULK COLLECT INTO org_name, contract_number, contract_name, description, keywords, version_comments;
90:
91: IF org_name.COUNT <> 0 THEN
92: FOR i IN org_name.FIRST..org_name.LAST LOOP
93: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
94: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
95: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
96: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
97: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );

Line 94: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );

90:
91: IF org_name.COUNT <> 0 THEN
92: FOR i IN org_name.FIRST..org_name.LAST LOOP
93: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
94: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
95: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
96: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
97: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
98: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );

Line 95: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );

91: IF org_name.COUNT <> 0 THEN
92: FOR i IN org_name.FIRST..org_name.LAST LOOP
93: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
94: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
95: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
96: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
97: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
98: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );
99: END LOOP;

Line 96: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );

92: FOR i IN org_name.FIRST..org_name.LAST LOOP
93: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
94: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
95: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
96: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
97: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
98: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );
99: END LOOP;
100: END IF;

Line 97: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );

93: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
94: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
95: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
96: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
97: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
98: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );
99: END LOOP;
100: END IF;
101:

Line 98: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );

94: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
95: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
96: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
97: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
98: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );
99: END LOOP;
100: END IF;
101:
102: CLOSE con_cur;

Line 132: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );

128: FETCH con_cur BULK COLLECT INTO party_name;
129:
130: IF party_name.COUNT <> 0 THEN
131: FOR i IN party_name.FIRST..party_name.LAST LOOP
132: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );
133: END LOOP;
134: END IF;
135:
136: CLOSE con_cur;

Line 163: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );

159: FETCH con_cur BULK COLLECT INTO party_name;
160:
161: IF party_name.COUNT <> 0 THEN
162: FOR i IN party_name.FIRST..party_name.LAST LOOP
163: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );
164: END LOOP;
165: END IF;
166:
167: CLOSE con_cur;

Line 193: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );

189: FETCH con_cur BULK COLLECT INTO party_name;
190:
191: IF party_name.COUNT <> 0 THEN
192: FOR i IN party_name.FIRST..party_name.LAST LOOP
193: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );
194: END LOOP;
195: END IF;
196:
197:

Line 228: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ');

224: FETCH con_cur BULK COLLECT INTO contact_name;
225:
226: IF contact_name.COUNT <> 0 THEN
227: FOR i IN contact_name.FIRST..contact_name.LAST LOOP
228: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ');
229: END LOOP;
230: END IF;
231:
232: CLOSE con_cur;

Line 258: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ' );

254: FETCH con_cur BULK COLLECT INTO contact_name;
255:
256: IF contact_name.COUNT <> 0 THEN
257: FOR i IN contact_name.FIRST..contact_name.LAST LOOP
258: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ' );
259: END LOOP;
260: END IF;
261:
262: CLOSE con_cur;

Line 288: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ' );

284: FETCH con_cur BULK COLLECT INTO contact_name;
285:
286: IF contact_name.COUNT <> 0 THEN
287: FOR i IN contact_name.FIRST..contact_name.LAST LOOP
288: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ' );
289: END LOOP;
290: END IF;
291:
292: CLOSE con_cur;

Line 382: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );

378: FETCH con_cur BULK COLLECT INTO org_name, contract_number, contract_name, description, keywords, version_comments;
379:
380: IF org_name.COUNT <> 0 THEN
381: FOR i IN org_name.FIRST..org_name.LAST LOOP
382: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
383: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
384: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
385: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
386: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );

Line 383: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );

379:
380: IF org_name.COUNT <> 0 THEN
381: FOR i IN org_name.FIRST..org_name.LAST LOOP
382: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
383: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
384: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
385: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
386: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
387: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );

Line 384: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );

380: IF org_name.COUNT <> 0 THEN
381: FOR i IN org_name.FIRST..org_name.LAST LOOP
382: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
383: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
384: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
385: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
386: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
387: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );
388: END LOOP;

Line 385: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );

381: FOR i IN org_name.FIRST..org_name.LAST LOOP
382: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
383: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
384: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
385: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
386: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
387: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );
388: END LOOP;
389: END IF;

Line 386: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );

382: DBMS_LOB.WRITEAPPEND( md_lob, length(org_name(i))+1, org_name(i) || ' ' );
383: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
384: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
385: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
386: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
387: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );
388: END LOOP;
389: END IF;
390:

Line 387: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );

383: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_number(i))+1, contract_number(i) || ' ' );
384: DBMS_LOB.WRITEAPPEND( md_lob, length(contract_name(i))+1, contract_name(i) || ' ' );
385: DBMS_LOB.WRITEAPPEND( md_lob, length(description(i))+1, description(i) || ' ' );
386: DBMS_LOB.WRITEAPPEND( md_lob, length(keywords(i))+1, keywords(i) || ' ' );
387: DBMS_LOB.WRITEAPPEND( md_lob, length(version_comments(i))+1, version_comments(i) || ' ' );
388: END LOOP;
389: END IF;
390:
391: CLOSE con_cur;

Line 421: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );

417: FETCH con_cur BULK COLLECT INTO party_name;
418:
419: IF party_name.COUNT <> 0 THEN
420: FOR i IN party_name.FIRST..party_name.LAST LOOP
421: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );
422: END LOOP;
423: END IF;
424:
425: CLOSE con_cur;

Line 452: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );

448: FETCH con_cur BULK COLLECT INTO party_name;
449:
450: IF party_name.COUNT <> 0 THEN
451: FOR i IN party_name.FIRST..party_name.LAST LOOP
452: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );
453: END LOOP;
454: END IF;
455:
456: CLOSE con_cur;

Line 482: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );

478: FETCH con_cur BULK COLLECT INTO party_name;
479:
480: IF party_name.COUNT <> 0 THEN
481: FOR i IN party_name.FIRST..party_name.LAST LOOP
482: DBMS_LOB.WRITEAPPEND( md_lob, length(party_name(i))+1, party_name(i) || ' ' );
483: END LOOP;
484: END IF;
485:
486:

Line 517: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ');

513: FETCH con_cur BULK COLLECT INTO contact_name;
514:
515: IF contact_name.COUNT <> 0 THEN
516: FOR i IN contact_name.FIRST..contact_name.LAST LOOP
517: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ');
518: END LOOP;
519: END IF;
520:
521: CLOSE con_cur;

Line 547: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ' );

543: FETCH con_cur BULK COLLECT INTO contact_name;
544:
545: IF contact_name.COUNT <> 0 THEN
546: FOR i IN contact_name.FIRST..contact_name.LAST LOOP
547: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ' );
548: END LOOP;
549: END IF;
550:
551: CLOSE con_cur;

Line 577: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ' );

573: FETCH con_cur BULK COLLECT INTO contact_name;
574:
575: IF contact_name.COUNT <> 0 THEN
576: FOR i IN contact_name.FIRST..contact_name.LAST LOOP
577: DBMS_LOB.WRITEAPPEND( md_lob, length(contact_name(i))+1, contact_name(i) || ' ' );
578: END LOOP;
579: END IF;
580:
581: CLOSE con_cur;