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_S

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

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 CLOB; -- Bug#13375642
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 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 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 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 1846: l_seq_num fnd_attached_documents.seq_num%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';
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