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

Line 351: l_begining := DBMS_LOB.GETLENGTH(l_note);

347: if csr_offer_notes%found then
348: --
349: -- convert clob data to varchar2
350: --
351: l_begining := DBMS_LOB.GETLENGTH(l_note);
352: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
353: end if;
354: close csr_offer_notes;
355:

Line 352: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);

348: --
349: -- convert clob data to varchar2
350: --
351: l_begining := DBMS_LOB.GETLENGTH(l_note);
352: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
353: end if;
354: close csr_offer_notes;
355:
356: open csr_send_offer_rcvd(l_offer_id);

Line 1011: l_begining := DBMS_LOB.GETLENGTH(l_note);

1007: if csr_offer_notes%found then
1008: --
1009: -- convert clob data to varchar2
1010: --
1011: l_begining := DBMS_LOB.GETLENGTH(l_note);
1012: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1013: end if;
1014: close csr_offer_notes;
1015:

Line 1012: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);

1008: --
1009: -- convert clob data to varchar2
1010: --
1011: l_begining := DBMS_LOB.GETLENGTH(l_note);
1012: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1013: end if;
1014: close csr_offer_notes;
1015:
1016: -- build html body for applicant

Line 1457: l_begining := DBMS_LOB.GETLENGTH(l_note);

1453: if csr_offer_notes%found then
1454: --
1455: -- convert clob data to varchar2
1456: --
1457: l_begining := DBMS_LOB.GETLENGTH(l_note);
1458: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1459: end if;
1460: close csr_offer_notes;
1461:

Line 1458: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);

1454: --
1455: -- convert clob data to varchar2
1456: --
1457: l_begining := DBMS_LOB.GETLENGTH(l_note);
1458: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1459: end if;
1460: close csr_offer_notes;
1461:
1462: hr_utility.set_location(l_proc, 55);

Line 1758: l_begining := DBMS_LOB.GETLENGTH(l_note);

1754: if csr_offer_notes%found then
1755: --
1756: -- convert clob data to varchar2
1757: --
1758: l_begining := DBMS_LOB.GETLENGTH(l_note);
1759: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1760: end if;
1761: close csr_offer_notes;
1762:

Line 1759: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);

1755: --
1756: -- convert clob data to varchar2
1757: --
1758: l_begining := DBMS_LOB.GETLENGTH(l_note);
1759: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1760: end if;
1761: close csr_offer_notes;
1762:
1763: -- get the decline reason