APPS.HR_UTIL_MISC_WEB dependencies on FND_DOCUMENT_CATEGORIES

Line 1359: ,p_name in fnd_document_categories_tl.name%TYPE

1355: procedure insert_attachment_v4
1356: (p_attachment_text in CLOB default null -- Bug#13375642
1357: ,p_entity_name in varchar2 default null
1358: ,p_pk1_value in varchar2 default null
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;

Line 1389: ,p_name in fnd_document_categories_tl.name%TYPE

1385: procedure insert_attachment
1386: (p_attachment_text in CLOB default null -- Bug#13375642
1387: ,p_entity_name in varchar2 default null
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

Line 1410: l_category_id fnd_document_categories.category_id%TYPE

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';
1414: l_seq_num fnd_attached_documents.seq_num%type;

Line 1429: from fnd_document_categories_tl

1425: and pk5_value is null;
1426:
1427: cursor csr_get_category_id (csr_p_lang in varchar2) is
1428: select category_id
1429: from fnd_document_categories_tl
1430: where language = csr_p_lang
1431: and name = p_name;
1432: --
1433:

Line 1772: ,p_name in fnd_document_categories_tl.name%TYPE

1768: (p_attachment_text out nocopy CLOB -- Bug#13375642
1769: ,p_entity_name in varchar2 default null
1770: ,p_pk1_value in varchar2 default null
1771: ,p_effective_date in date
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;

Line 1829: fnd_document_categories_tl.user_name%TYPE

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
1832:
1833: -- [CUSTOMIZE]

Line 1852: from fnd_document_categories_tl

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
1853: where language = csr_p_lang
1854: and name = p_user_name;
1855:
1856: cursor csr_attached_documents (csr_p_cat_id in number) is