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

Line 1289: l_document_id fnd_documents.document_id%TYPE default null;

1285: l_person_id per_people_f.person_id%type;
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 long default null;
1292: l_rowid varchar2(50) default null;
1293: l_category_id fnd_documents.category_id%type default null;

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 long default null;
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 1293: l_category_id fnd_documents.category_id%type 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 long default null;
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

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

1291: l_attachment_text long default null;
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 1364: l_document_id fnd_documents.document_id%TYPE;

1360: ,p_rowid out nocopy varchar2
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);

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 1394: fnd_documents.document_id%TYPE

1390: default 'HR_RESUME'
1391: ,p_attached_document_id out
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

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 1401: -- Call fnd_attached_documents_pkg.insert_row api to insert into fnd_documents

1397: ,p_rowid out nocopy varchar2
1398: ,p_login_person_id in number) is -- 10/14/97 Changed
1399:
1400: -- [CUSTOMIZE]
1401: -- Call fnd_attached_documents_pkg.insert_row api to insert into fnd_documents
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;

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 1409: l_document_id fnd_documents.document_id%TYPE default null;

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
1411: default null;
1412: l_datatype_id fnd_document_datatypes.datatype_id%TYPE default 2;
1413: l_language varchar2(30) default 'AMERICAN';

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 1547: -- Call fnd_attached_documents_pkg.update_row api to update fnd_documents

1543: ,p_rowid in varchar2
1544: ,p_login_person_id in number) is -- 10/14/97 Changed
1545:
1546: -- [CUSTOMIZE]
1547: -- Call fnd_attached_documents_pkg.update_row api to update fnd_documents
1548: -- table. If customer uses third party software to store the resume, modify
1549: -- the code here.
1550:
1551: l_rowid varchar2(50);

Line 1568: from fnd_documents

1564: where rowid = p_rowid;
1565: --
1566: cursor csr_get_doc(csr_p_document_id in number) is
1567: select *
1568: from fnd_documents
1569: where document_id = csr_p_document_id;
1570: --
1571: cursor csr_get_doc_tl (csr_p_lang in varchar2
1572: ,csr_p_document_id in number) is

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 1682: -- Update document to fnd_attached_documents, fnd_documents,

1678: ,x_doc_attribute14 => l_doc_tl_pre_upd.doc_attribute14
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

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 1777: l_document_id fnd_documents.document_id%TYPE;

1773: ,p_rowid out nocopy varchar2
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;

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 1779: l_category_id fnd_documents.category_id%type;

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';
1783: begin

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 1822: ,p_document_id out nocopy fnd_documents.document_id%TYPE

1818: ,p_pk1_value in varchar2 default null
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

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 1825: ,p_category_id out nocopy fnd_documents.category_id%type

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
1828: ,p_user_name in
1829: fnd_document_categories_tl.user_name%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 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 1840: l_document_id fnd_documents.document_id%TYPE default null;

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;
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 long default null;
1843: l_rowid varchar2(50) default null;
1844: l_category_id fnd_documents.category_id%type default null;

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 long default null;
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 1844: l_category_id fnd_documents.category_id%type 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 long default null;
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';
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;

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 1860: ,fnd_documents fd

1856: cursor csr_attached_documents (csr_p_cat_id in number) is
1857: select fatd.rowid, fatd.attached_document_id, fatd.document_id, fatd.seq_num
1858: ,fd.last_update_date
1859: from fnd_attached_documents fatd
1860: ,fnd_documents fd
1861: where fd.category_id = csr_p_cat_id
1862: and fatd.entity_name = p_entity_name
1863: and fatd.pk1_value = p_pk1_value
1864: and fatd.document_id = fd.document_id

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 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 1892: -- the table join of fnd_attached_documents and fnd_documents. The

1888: -- -------------------------------------------------------------------------
1889: -- Retrieving a resume requires 4 steps:
1890: -- 1) Get Category ID.
1891: -- 2) Get the attached_document_id, document_id and other fields from
1892: -- the table join of fnd_attached_documents and fnd_documents. The
1893: -- result set can have more than 1 row and is sorted by descending
1894: -- order of the last_update_date. So, if there are multipe resumes
1895: -- returned (which could be possible because a user in 10SC Person
1896: -- form can add an attachment with the category of 'Resume'. When

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: --

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.