APPS.HR_UTIL_MISC_WEB dependencies on FND_DOCUMENTS_LONG_TEXT

Line 1464: -- Insert document to fnd_documents_long_text

1460: select fnd_attached_documents_s.nextval
1461: into l_attached_document_id
1462: from sys.dual;
1463:
1464: -- Insert document to fnd_documents_long_text
1465: --
1466: fnd_attached_documents_pkg.insert_row
1467: (x_rowid => l_rowid
1468: ,x_attached_document_id => l_attached_document_id

Line 1508: -- Now insert into fnd_documents_long_text using the media_id

1504: ,x_doc_attribute14 => null
1505: ,x_doc_attribute15 => null);
1506: --
1507:
1508: -- Now insert into fnd_documents_long_text using the media_id
1509: -- generated from the above api call
1510: --
1511: --replace chr(13)chr(10) with chr(10)
1512: l_attachment_text := replace(p_attachment_text,

Line 1514: insert into fnd_documents_long_text

1510: --
1511: --replace chr(13)chr(10) with chr(10)
1512: l_attachment_text := replace(p_attachment_text,
1513: g_carriage_return||g_line_feed,g_line_feed);
1514: insert into fnd_documents_long_text
1515: (media_id
1516: ,long_text)
1517: values
1518: (l_media_id

Line 1683: -- fnd_documents_tl and fnd_documents_long_text

1679: ,x_doc_attribute15 => l_doc_tl_pre_upd.doc_attribute15);
1680:
1681:
1682: -- Update document to fnd_attached_documents, fnd_documents,
1683: -- fnd_documents_tl and fnd_documents_long_text
1684: --
1685: fnd_attached_documents_pkg.update_row
1686: (x_rowid => p_rowid
1687: ,x_attached_document_id =>

Line 1756: update fnd_documents_long_text

1752: -- remove chr(13)
1753: l_attachment_text := replace(p_attachment_text,
1754: g_carriage_return||g_line_feed,g_line_feed);
1755: -- Now update the long text table
1756: update fnd_documents_long_text
1757: set long_text = l_attachment_text
1758: where media_id = l_doc_tl_pre_upd.media_id;
1759: hr_utility.set_location('Leaving: '|| l_proc,25);
1760: EXCEPTION

Line 1835: -- fnd_documents_long_text tables. If customer uses third party

1831: ) is
1832:
1833: -- [CUSTOMIZE]
1834: -- Call fnd_attached_documents, fnd_documents_tl and
1835: -- fnd_documents_long_text tables. If customer uses third party
1836: -- software to store the resumes, modify the code here.
1837:
1838: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE
1839: default null;

Line 1879: from fnd_documents_long_text

1875: and media_id is not null;
1876:
1877: cursor csr_documents_long_text (csr_p_media_id in number) is
1878: select long_text
1879: from fnd_documents_long_text
1880: where media_id = csr_p_media_id;
1881:
1882: Begin
1883: hr_utility.set_location('Entering: '|| l_proc,5);

Line 1901: -- fnd_documents_long_text.

1897: -- that happens, we only want the one which is updated most recently.
1898: -- 3) Use the document_id obtained from the 1st record of step 2 to
1899: -- get the media_id from fnd_documents_tl.
1900: -- 4) Use the media_id from step 3 to obtain the resume text from
1901: -- fnd_documents_long_text.
1902: -- -------------------------------------------------------------------------
1903: --
1904: -- -------------------------------------------------------------------------
1905: -- 1) Get Category ID.