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

Line 89: if (dbms_lob.isopen(g_file_list(file_id).file_locator)<>1)

85: where file_detail_id=file_id
86: for update of blob_file_fragment;
87:
88:
89: if (dbms_lob.isopen(g_file_list(file_id).file_locator)<>1)
90: then
91: dbms_lob.open(g_file_list(file_id).file_locator, DBMS_LOB.LOB_READWRITE);
92: dbms_lob.trim(g_file_list(file_id).file_locator, 0);
93: g_file_list(file_id).position := 1;

Line 91: dbms_lob.open(g_file_list(file_id).file_locator, DBMS_LOB.LOB_READWRITE);

87:
88:
89: if (dbms_lob.isopen(g_file_list(file_id).file_locator)<>1)
90: then
91: dbms_lob.open(g_file_list(file_id).file_locator, DBMS_LOB.LOB_READWRITE);
92: dbms_lob.trim(g_file_list(file_id).file_locator, 0);
93: g_file_list(file_id).position := 1;
94: end if;
95:

Line 92: dbms_lob.trim(g_file_list(file_id).file_locator, 0);

88:
89: if (dbms_lob.isopen(g_file_list(file_id).file_locator)<>1)
90: then
91: dbms_lob.open(g_file_list(file_id).file_locator, DBMS_LOB.LOB_READWRITE);
92: dbms_lob.trim(g_file_list(file_id).file_locator, 0);
93: g_file_list(file_id).position := 1;
94: end if;
95:
96: exception

Line 135: dbms_lob.open(g_file_list(file_id).file_locator, DBMS_LOB.LOB_READWRITE);

131: from pay_file_details
132: where file_detail_id = file_id
133: for update of blob_file_fragment;
134:
135: dbms_lob.open(g_file_list(file_id).file_locator, DBMS_LOB.LOB_READWRITE);
136:
137: end;
138: --
139: if (g_head_file_ptr is not null) then

Line 290: dbms_lob.open(g_tmp_clob, DBMS_LOB.LOB_READONLY);

286: into g_tmp_clob
287: from pay_file_details
288: where file_detail_id = p_file_id;
289: --
290: dbms_lob.open(g_tmp_clob, DBMS_LOB.LOB_READONLY);
291: --
292: end open_clob_direct;
293:
294: procedure open_blob_direct(p_file_id in number)

Line 303: dbms_lob.open(g_tmp_blob, DBMS_LOB.LOB_READONLY);

299: into g_tmp_blob
300: from pay_file_details
301: where file_detail_id = p_file_id;
302: --
303: dbms_lob.open(g_tmp_blob, DBMS_LOB.LOB_READONLY);
304:
305: end open_blob_direct;
306: --
307: --------------------------- read_from_clob_direct ----------------

Line 325: dbms_lob.read(p_clob,

321: is
322: --
323: begin
324: --
325: dbms_lob.read(p_clob,
326: p_size,
327: p_position,
328: p_text
329: );

Line 349: dbms_lob.read(p_blob,

345: raw_data raw(8000); --changed raw_data size from 2000 bug no 4775422
346: --
347: begin
348: --
349: dbms_lob.read(p_blob,
350: p_size,
351: p_position,
352: raw_data
353: );

Line 374: dbms_lob.close(g_tmp_clob);

370: procedure close_clob_direct
371: is
372: begin
373: --
374: dbms_lob.close(g_tmp_clob);
375: g_tmp_clob := null;
376: --
377: end close_clob_direct;
378: --

Line 384: dbms_lob.close(g_tmp_blob);

380: procedure close_blob_direct
381: is
382: begin
383: --
384: dbms_lob.close(g_tmp_blob);
385: g_tmp_blob := null;
386: --
387: end close_blob_direct;
388: --

Line 489: dbms_lob.read(g_tmp_blob,

485: end if;
486: --
487: Begin
488: l_size := p_size;
489: dbms_lob.read(g_tmp_blob,
490: l_size,
491: p_position,
492: raw_data
493: );

Line 534: dbms_lob.write(g_file_list(p_file_id).file_locator,

530: text_size:=utl_raw.length(raw_data);
531: hr_utility.trace('p_text size = ' || to_char(length(p_text)));
532: hr_utility.trace('raw_data Size = ' || text_size);
533:
534: dbms_lob.write(g_file_list(p_file_id).file_locator,
535: text_size,
536: g_file_list(p_file_id).position,
537: raw_data
538: );

Line 542: to_char(dbms_lob.getlength(g_file_list(p_file_id).file_locator)));

538: );
539: g_file_list(p_file_id).position := g_file_list(p_file_id).position
540: + text_size;
541: hr_utility.trace('Blob Size = ' ||
542: to_char(dbms_lob.getlength(g_file_list(p_file_id).file_locator)));
543: --
544: end write_to_file;
545: --
546: --------------------------- write_to_file_raw -------------------------

Line 573: dbms_lob.write(g_file_list(p_file_id).file_locator,

569: text_size:=utl_raw.length(raw_data);
570: hr_utility.trace('p_text size = ' || to_char(length(p_text)));
571: hr_utility.trace('raw_data Size = ' || text_size);
572:
573: dbms_lob.write(g_file_list(p_file_id).file_locator,
574: text_size,
575: g_file_list(p_file_id).position,
576: raw_data
577: );

Line 581: to_char(dbms_lob.getlength(g_file_list(p_file_id).file_locator)));

577: );
578: g_file_list(p_file_id).position := g_file_list(p_file_id).position
579: + text_size;
580: hr_utility.trace('Blob Size = ' ||
581: to_char(dbms_lob.getlength(g_file_list(p_file_id).file_locator)));
582: --
583: end write_to_file_raw;
584: --
585: --------------------------- close_file -------------------------

Line 602: dbms_lob.close(g_file_list(p_file_id).file_locator);

598: prvptr number;
599: nxtptr number;
600: begin
601: --
602: dbms_lob.close(g_file_list(p_file_id).file_locator);
603:
604: --
605: prvptr := g_file_list(p_file_id).prvptr ;
606: nxtptr := g_file_list(p_file_id).nxtptr ;

Line 635: dbms_lob.createtemporary(p_file, TRUE);

631: procedure open_temp_file
632: (p_file in out nocopy clob)
633: is
634: begin
635: dbms_lob.createtemporary(p_file, TRUE);
636: end open_temp_file;
637: --
638: --------------------------- close_temp_file -------------------------
639: /*

Line 650: dbms_lob.freetemporary(p_file);

646: */
647: procedure close_temp_file(p_file in out nocopy clob)
648: is
649: begin
650: dbms_lob.freetemporary(p_file);
651: end close_temp_file;
652: --
653: -- Added for Bug # 3688801.
654: --------------------------- form_read_clob ---------------------

Line 687: dbms_lob.open(l_clob, DBMS_LOB.LOB_READONLY);

683: p_text := null;
684: return;
685: end if;
686: --
687: dbms_lob.open(l_clob, DBMS_LOB.LOB_READONLY);
688: --
689: l_size := p_size;
690: read_from_clob_direct
691: (l_clob,

Line 697: dbms_lob.close(l_clob);

693: p_position,
694: p_text
695: );
696: --
697: dbms_lob.close(l_clob);
698: --
699: p_size := l_size;
700: --
701: end form_read_clob;

Line 731: dbms_lob.open(l_clob, DBMS_LOB.LOB_READONLY);

727: if l_clob is null then
728: return null;
729: end if;
730: --
731: dbms_lob.open(l_clob, DBMS_LOB.LOB_READONLY);
732: --
733: l_length := DBMS_LOB.GETLENGTH(l_clob);
734:
735: dbms_lob.close(l_clob);

Line 733: l_length := DBMS_LOB.GETLENGTH(l_clob);

729: end if;
730: --
731: dbms_lob.open(l_clob, DBMS_LOB.LOB_READONLY);
732: --
733: l_length := DBMS_LOB.GETLENGTH(l_clob);
734:
735: dbms_lob.close(l_clob);
736: --
737: return l_length;

Line 735: dbms_lob.close(l_clob);

731: dbms_lob.open(l_clob, DBMS_LOB.LOB_READONLY);
732: --
733: l_length := DBMS_LOB.GETLENGTH(l_clob);
734:
735: dbms_lob.close(l_clob);
736: --
737: return l_length;
738: --
739: end return_clob_length;

Line 760: dbms_lob.open(l_blob, DBMS_LOB.LOB_READONLY);

756: if l_blob is null then
757: return null;
758: end if;
759: --
760: dbms_lob.open(l_blob, DBMS_LOB.LOB_READONLY);
761: --
762: l_length := DBMS_LOB.GETLENGTH(l_blob);
763:
764: dbms_lob.close(l_blob);

Line 762: l_length := DBMS_LOB.GETLENGTH(l_blob);

758: end if;
759: --
760: dbms_lob.open(l_blob, DBMS_LOB.LOB_READONLY);
761: --
762: l_length := DBMS_LOB.GETLENGTH(l_blob);
763:
764: dbms_lob.close(l_blob);
765: --
766: return l_length;

Line 764: dbms_lob.close(l_blob);

760: dbms_lob.open(l_blob, DBMS_LOB.LOB_READONLY);
761: --
762: l_length := DBMS_LOB.GETLENGTH(l_blob);
763:
764: dbms_lob.close(l_blob);
765: --
766: return l_length;
767: --
768: end return_length;

Line 777: dbms_lob.writeappend(pay_mag_tape.g_blob_value,

773: raw_data raw(32767);
774: begin
775: raw_data:=utl_raw.cast_to_raw(p_text);
776: text_size:=utl_raw.length(raw_data);
777: dbms_lob.writeappend(pay_mag_tape.g_blob_value,
778: text_size,
779: raw_data
780: );
781: end;

Line 786: dbms_lob.append(pay_mag_tape.g_blob_value,

782:
783: procedure write_to_magtape_lob(p_data in blob)
784: is
785: begin
786: dbms_lob.append(pay_mag_tape.g_blob_value,
787: p_data);
788: end;
789:
790: --