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 499: l_begining := DBMS_LOB.GETLENGTH(l_note);

495: if csr_offer_notes%found then
496: --
497: -- convert clob data to varchar2
498: --
499: l_begining := DBMS_LOB.GETLENGTH(l_note);
500: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
501: end if;
502: close csr_offer_notes;
503:

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

496: --
497: -- convert clob data to varchar2
498: --
499: l_begining := DBMS_LOB.GETLENGTH(l_note);
500: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
501: end if;
502: close csr_offer_notes;
503:
504: open csr_send_offer_rcvd(l_offer_id);

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

1529: if csr_offer_notes%found then
1530: --
1531: -- convert clob data to varchar2
1532: --
1533: l_begining := DBMS_LOB.GETLENGTH(l_note);
1534: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1535: end if;
1536: close csr_offer_notes;
1537:

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

1530: --
1531: -- convert clob data to varchar2
1532: --
1533: l_begining := DBMS_LOB.GETLENGTH(l_note);
1534: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
1535: end if;
1536: close csr_offer_notes;
1537:
1538: -- build html body for applicant

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

2081: if csr_offer_notes%found then
2082: --
2083: -- convert clob data to varchar2
2084: --
2085: l_begining := DBMS_LOB.GETLENGTH(l_note);
2086: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
2087: end if;
2088: close csr_offer_notes;
2089:

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

2082: --
2083: -- convert clob data to varchar2
2084: --
2085: l_begining := DBMS_LOB.GETLENGTH(l_note);
2086: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
2087: end if;
2088: close csr_offer_notes;
2089:
2090: hr_utility.set_location(l_proc, 55);

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

2454: if csr_offer_notes%found then
2455: --
2456: -- convert clob data to varchar2
2457: --
2458: l_begining := DBMS_LOB.GETLENGTH(l_note);
2459: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
2460: end if;
2461: close csr_offer_notes;
2462:

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

2455: --
2456: -- convert clob data to varchar2
2457: --
2458: l_begining := DBMS_LOB.GETLENGTH(l_note);
2459: DBMS_LOB.READ(l_note, l_begining, l_end, l_note_text);
2460: end if;
2461: close csr_offer_notes;
2462:
2463: -- get the decline reason