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.HR_UTIL_MISC_WEB dependencies on FND_DOCUMENTS_TL

Line 1290: l_media_id fnd_documents_tl.media_id%TYPE default null;

1286: l_resume_from_database varchar2(32000);
1287: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE
1288: default null;
1289: l_document_id fnd_documents.document_id%TYPE default null;
1290: l_media_id fnd_documents_tl.media_id%TYPE default null;
1291: l_attachment_text CLOB default null; -- Bug#13375642
1292: l_rowid varchar2(50) default null;
1293: l_category_id fnd_documents.category_id%type default null;
1294: l_seq_num fnd_attached_documents.seq_num%type default 0;

Line 1295: l_creation_date fnd_documents_tl.creation_date%TYPE default null;

1291: l_attachment_text CLOB default null; -- Bug#13375642
1292: l_rowid varchar2(50) default null;
1293: l_category_id fnd_documents.category_id%type default null;
1294: l_seq_num fnd_attached_documents.seq_num%type default 0;
1295: l_creation_date fnd_documents_tl.creation_date%TYPE default null;
1296: l_proc constant varchar2(100) := g_package || ' get_resume';
1297: begin
1298: hr_utility.set_location('Entering: '|| l_proc,5);
1299: ----------------------------------------------------------------------------

Line 1365: l_media_id fnd_documents_tl.media_id%TYPE;

1361: ,p_login_person_id in number) is
1362:
1363: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE;
1364: l_document_id fnd_documents.document_id%TYPE;
1365: l_media_id fnd_documents_tl.media_id%TYPE;
1366: l_proc constant varchar2(100) := g_package || ' insert_attachment_v4';
1367: begin
1368: hr_utility.set_location('Entering: '|| l_proc,5);
1369: insert_attachment

Line 1396: fnd_documents_tl.media_id%TYPE

1392: fnd_attached_documents.attached_document_id%TYPE
1393: ,p_document_id out
1394: fnd_documents.document_id%TYPE
1395: ,p_media_id out
1396: fnd_documents_tl.media_id%TYPE
1397: ,p_rowid out nocopy varchar2
1398: ,p_login_person_id in number) is -- 10/14/97 Changed
1399:
1400: -- [CUSTOMIZE]

Line 1406: l_media_id fnd_documents_tl.media_id%TYPE;

1402: -- table. If customer uses third party software to store the resume, modify
1403: -- the code here.
1404:
1405: l_rowid varchar2(50) default null;
1406: l_media_id fnd_documents_tl.media_id%TYPE;
1407: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE
1408: default null;
1409: l_document_id fnd_documents.document_id%TYPE default null;
1410: l_category_id fnd_document_categories.category_id%TYPE

Line 1574: from fnd_documents_tl

1570: --
1571: cursor csr_get_doc_tl (csr_p_lang in varchar2
1572: ,csr_p_document_id in number) is
1573: select *
1574: from fnd_documents_tl
1575: where document_id = csr_p_document_id
1576: and language = csr_p_lang;
1577: --
1578: l_attached_doc_pre_upd csr_get_attached_doc%rowtype;

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 1778: l_media_id fnd_documents_tl.media_id%TYPE;

1774: ) is
1775:
1776: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE;
1777: l_document_id fnd_documents.document_id%TYPE;
1778: l_media_id fnd_documents_tl.media_id%TYPE;
1779: l_category_id fnd_documents.category_id%type;
1780: l_seq_num fnd_attached_documents.seq_num%type;
1781: l_creation_date fnd_documents_tl.creation_date%type;
1782: l_proc constant varchar2(100) := g_package || ' get_attachment_v4';

Line 1781: l_creation_date fnd_documents_tl.creation_date%type;

1777: l_document_id fnd_documents.document_id%TYPE;
1778: l_media_id fnd_documents_tl.media_id%TYPE;
1779: l_category_id fnd_documents.category_id%type;
1780: l_seq_num fnd_attached_documents.seq_num%type;
1781: l_creation_date fnd_documents_tl.creation_date%type;
1782: l_proc constant varchar2(100) := g_package || ' get_attachment_v4';
1783: begin
1784: hr_utility.set_location('Entering: '|| l_proc,5);
1785: get_attachment

Line 1823: ,p_media_id out nocopy fnd_documents_tl.media_id%TYPE

1819: ,p_effective_date in varchar2
1820: ,p_attached_document_id out
1821: fnd_attached_documents.attached_document_id%TYPE
1822: ,p_document_id out nocopy fnd_documents.document_id%TYPE
1823: ,p_media_id out nocopy fnd_documents_tl.media_id%TYPE
1824: ,p_rowid out nocopy varchar2
1825: ,p_category_id out nocopy fnd_documents.category_id%type
1826: ,p_seq_num out nocopy fnd_attached_documents.seq_num%type
1827: ,p_creation_date out nocopy fnd_documents_tl.creation_date%type

Line 1827: ,p_creation_date out nocopy fnd_documents_tl.creation_date%type

1823: ,p_media_id out nocopy fnd_documents_tl.media_id%TYPE
1824: ,p_rowid out nocopy varchar2
1825: ,p_category_id out nocopy fnd_documents.category_id%type
1826: ,p_seq_num out nocopy fnd_attached_documents.seq_num%type
1827: ,p_creation_date out nocopy fnd_documents_tl.creation_date%type
1828: ,p_user_name in
1829: fnd_document_categories_tl.user_name%TYPE
1830: DEFAULT 'HR_RESUME'
1831: ) is

Line 1834: -- Call fnd_attached_documents, fnd_documents_tl and

1830: DEFAULT 'HR_RESUME'
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

Line 1841: l_media_id fnd_documents_tl.media_id%TYPE default null;

1837:
1838: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE
1839: default null;
1840: l_document_id fnd_documents.document_id%TYPE default null;
1841: l_media_id fnd_documents_tl.media_id%TYPE default null;
1842: l_attachment_text CLOB default null; -- Bug#13375642
1843: l_rowid varchar2(50) default null;
1844: l_category_id fnd_documents.category_id%type default null;
1845: l_language varchar2(30) default 'AMERICAN';

Line 1848: l_creation_date fnd_documents_tl.creation_date%TYPE default null;

1844: l_category_id fnd_documents.category_id%type default null;
1845: l_language varchar2(30) default 'AMERICAN';
1846: l_seq_num fnd_attached_documents.seq_num%type default null;
1847: l_update_date date default null;
1848: l_creation_date fnd_documents_tl.creation_date%TYPE default null;
1849: l_proc constant varchar2(100) := g_package || ' get_attachment';
1850: cursor csr_get_category_id (csr_p_lang in varchar2) is
1851: select category_id
1852: from fnd_document_categories_tl

Line 1873: from fnd_documents_tl

1869: fd.document_id desc; -- retrieve the one updated the last
1870:
1871: cursor csr_documents_tl (csr_p_document_id in number) is
1872: select media_id , creation_date
1873: from fnd_documents_tl
1874: where document_id = csr_p_document_id
1875: and media_id is not null;
1876:
1877: cursor csr_documents_long_text (csr_p_media_id in number) is

Line 1899: -- get the media_id from fnd_documents_tl.

1895: -- returned (which could be possible because a user in 10SC Person
1896: -- form can add an attachment with the category of 'Resume'. When
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: --