APPS.HR_OFFER_CUSTOM dependencies on FND_DOCUMENTS_TL

Line 836: fnd_documents_tl.media_id%TYPE

832: fnd_attached_documents.attached_document_id%TYPE
833: ,p_document_id out nocopy
834: fnd_documents.document_id%TYPE
835: ,p_media_id out nocopy
836: fnd_documents_tl.media_id%TYPE
837: ,p_rowid out nocopy varchar2
838: ,p_login_person_id in number) is -- 10/14/97 Changed
839:
840: -- [CUSTOMIZE]

Line 846: l_media_id fnd_documents_tl.media_id%TYPE;

842: -- table. If customer uses third party software to store the resume, modify
843: -- the code here.
844:
845: l_rowid varchar2(50) default null;
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

Line 1008: from fnd_documents_tl

1004: --
1005: cursor csr_get_doc_tl (csr_p_lang in varchar2
1006: ,csr_p_document_id in number) is
1007: select *
1008: from fnd_documents_tl
1009: where document_id = csr_p_document_id
1010: and language = csr_p_lang;
1011: --
1012: l_attached_doc_pre_upd csr_get_attached_doc%rowtype;

Line 1113: -- fnd_documents_tl and fnd_documents_long_text

1109: ,x_doc_attribute15 => l_doc_tl_pre_upd.doc_attribute15);
1110:
1111:
1112: -- Update document to fnd_attached_documents, fnd_documents,
1113: -- fnd_documents_tl and fnd_documents_long_text
1114: --
1115: fnd_attached_documents_pkg.update_row
1116: (x_rowid => p_rowid
1117: ,x_attached_document_id =>

Line 1205: ,p_media_id out nocopy fnd_documents_tl.media_id%TYPE

1201: ,p_effective_date in varchar2
1202: ,p_attached_document_id out nocopy
1203: fnd_attached_documents.attached_document_id%TYPE
1204: ,p_document_id out nocopy fnd_documents.document_id%TYPE
1205: ,p_media_id out nocopy fnd_documents_tl.media_id%TYPE
1206: ,p_rowid out nocopy varchar2
1207: ,p_category_id out nocopy fnd_documents.category_id%type
1208: ,p_seq_num out nocopy fnd_attached_documents.seq_num%type) is
1209:

Line 1211: -- Call fnd_attached_documents, fnd_documents_tl and

1207: ,p_category_id out nocopy fnd_documents.category_id%type
1208: ,p_seq_num out nocopy fnd_attached_documents.seq_num%type) is
1209:
1210: -- [CUSTOMIZE]
1211: -- Call fnd_attached_documents, fnd_documents_tl and
1212: -- fnd_documents_long_text tables. If customer uses third party
1213: -- software to store the resumes, modify the code here.
1214:
1215: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE

Line 1218: l_media_id fnd_documents_tl.media_id%TYPE default null;

1214:
1215: l_attached_document_id fnd_attached_documents.attached_document_id%TYPE
1216: default null;
1217: l_document_id fnd_documents.document_id%TYPE default null;
1218: l_media_id fnd_documents_tl.media_id%TYPE default null;
1219: l_attachment_text clob default null; -- Bug#13362792
1220: l_rowid varchar2(50) default null;
1221: l_category_id fnd_documents.category_id%type default null;
1222: l_language varchar2(30) default 'AMERICAN';

Line 1256: from fnd_documents_tl

1252: ,fd.last_update_date desc; -- retrieve the one updated the last
1253:
1254: cursor csr_documents_tl (csr_p_document_id in number) is
1255: select media_id
1256: from fnd_documents_tl
1257: where document_id = csr_p_document_id;
1258:
1259: cursor csr_documents_long_text (csr_p_media_id in number) is
1260: select long_text

Line 1280: -- get the media_id from fnd_documents_tl.

1276: -- returned (which could be possible because a user in 10SC Person
1277: -- form can add an attachment with the category of 'Resume'. When
1278: -- that happens, we only want the one which is updated most recently.
1279: -- 3) Use the document_id obtained from the 1st record of step 2 to
1280: -- get the media_id from fnd_documents_tl.
1281: -- 4) Use the media_id from step 3 to obtain the resume text from
1282: -- fnd_documents_long_text.
1283: -- -------------------------------------------------------------------------
1284: --