APPS.HR_OFFER_CUSTOM dependencies on FND_DOCUMENT_CATEGORIES

Line 850: l_category_id fnd_document_categories.category_id%TYPE

846: l_media_id fnd_documents_tl.media_id%TYPE;
847: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE
848: default null;
849: l_document_id fnd_documents.document_id%TYPE default null;
850: l_category_id fnd_document_categories.category_id%TYPE
851: default null;
852: l_datatype_id fnd_document_datatypes.datatype_id%TYPE default 2;
853: l_language varchar2(30) default 'AMERICAN';
854: l_seq_num fnd_attached_documents.seq_num%type;

Line 869: from fnd_document_categories_tl

865: and pk5_value is null;
866:
867: cursor csr_get_category_id (csr_p_lang in varchar2) is
868: select category_id
869: from fnd_document_categories_tl
870: where language = csr_p_lang
871: and name = 'HR_RESUME'; -- updated for bug no:2533461
872: --
873:

Line 1228: from fnd_document_categories_tl

1224: l_update_date date default null;
1225:
1226: cursor csr_get_category_id (csr_p_lang in varchar2) is
1227: select category_id
1228: from fnd_document_categories_tl
1229: where language = csr_p_lang
1230: and name = 'HR_RESUME'; -- updated for bug no:2533461
1231:
1232: ------------------------------------------------------------------------------