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_ATTACHED_DOCUMENTS

Line 1287: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE

1283: ,p_creation_date out nocopy varchar2) is
1284: --
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;

Line 1294: l_seq_num fnd_attached_documents.seq_num%type default 0;

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
1298: hr_utility.set_location('Entering: '|| l_proc,5);

Line 1363: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE;

1359: ,p_name in fnd_document_categories_tl.name%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

Line 1392: fnd_attached_documents.attached_document_id%TYPE

1388: ,p_pk1_value in varchar2 default null
1389: ,p_name in fnd_document_categories_tl.name%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

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 1407: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE

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
1411: default null;

Line 1414: l_seq_num fnd_attached_documents.seq_num%type;

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';
1414: l_seq_num fnd_attached_documents.seq_num%type;
1415: l_attachment_text long;
1416: l_proc constant varchar2(100) := g_package || ' insert_attachment';
1417: cursor csr_get_seq_num is
1418: select nvl(max(seq_num),0) + 10

Line 1419: from fnd_attached_documents

1415: l_attachment_text long;
1416: l_proc constant varchar2(100) := g_package || ' insert_attachment';
1417: cursor csr_get_seq_num is
1418: select nvl(max(seq_num),0) + 10
1419: from fnd_attached_documents
1420: where entity_name = p_entity_name
1421: and pk1_value = p_pk1_value
1422: and pk2_value is null
1423: and pk3_value is null

Line 1460: select fnd_attached_documents_s.nextval

1456: end if;
1457: close csr_get_category_id;
1458: --
1459: -- get sequence id for attached_document_id
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

Line 1466: fnd_attached_documents_pkg.insert_row

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
1469: ,x_document_id => l_document_id
1470: ,x_creation_date => trunc(sysdate)

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 1563: from fnd_attached_documents

1559: -- preserve the values entered in 10SC GUI after the update.
1560: -- -------------------------------------------------------------
1561: cursor csr_get_attached_doc is
1562: select *
1563: from fnd_attached_documents
1564: where rowid = p_rowid;
1565: --
1566: cursor csr_get_doc(csr_p_document_id in number) is
1567: select *

Line 1617: fnd_attached_documents_pkg.lock_row

1613: raise data_error;
1614: END IF;
1615:
1616: -- Now, lock the rows.
1617: fnd_attached_documents_pkg.lock_row
1618: (x_rowid => p_rowid
1619: ,x_attached_document_id =>
1620: l_attached_doc_pre_upd.attached_document_id
1621: ,x_document_id => l_doc_pre_upd.document_id

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 1685: fnd_attached_documents_pkg.update_row

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 =>
1688: l_attached_doc_pre_upd.attached_document_id
1689: ,x_document_id => l_doc_pre_upd.document_id

Line 1776: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE;

1772: ,p_name in fnd_document_categories_tl.name%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;

Line 1780: l_seq_num fnd_attached_documents.seq_num%type;

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
1784: hr_utility.set_location('Entering: '|| l_proc,5);

Line 1821: fnd_attached_documents.attached_document_id%TYPE

1817: ,p_entity_name in varchar2 default null
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

Line 1826: ,p_seq_num out nocopy fnd_attached_documents.seq_num%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
1830: DEFAULT 'HR_RESUME'

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 1838: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE

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

Line 1846: l_seq_num fnd_attached_documents.seq_num%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;
1849: l_proc constant varchar2(100) := g_package || ' get_attachment';
1850: cursor csr_get_category_id (csr_p_lang in varchar2) is

Line 1859: from fnd_attached_documents fatd

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

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