APPS.HR_OFFER_CUSTOM dependencies on FND_DOCUMENTS_LONG_TEXT

Line 901: -- Insert document to fnd_documents_long_text

897: select fnd_attached_documents_s.nextval
898: into l_attached_document_id
899: from sys.dual;
900:
901: -- Insert document to fnd_documents_long_text
902: --
903: fnd_attached_documents_pkg.insert_row
904: (x_rowid => l_rowid
905: ,x_attached_document_id => l_attached_document_id

Line 945: -- Now insert into fnd_documents_long_text using the media_id

941: ,x_doc_attribute14 => null
942: ,x_doc_attribute15 => null);
943: --
944:
945: -- Now insert into fnd_documents_long_text using the media_id
946: -- generated from the above api call
947: --
948: insert into fnd_documents_long_text
949: (media_id

Line 948: insert into fnd_documents_long_text

944:
945: -- Now insert into fnd_documents_long_text using the media_id
946: -- generated from the above api call
947: --
948: insert into fnd_documents_long_text
949: (media_id
950: ,long_text)
951: values
952: (l_media_id

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 1183: update fnd_documents_long_text

1179: ,x_doc_attribute14 => l_doc_tl_pre_upd.doc_attribute14
1180: ,x_doc_attribute15 => l_doc_tl_pre_upd.doc_attribute15);
1181:
1182: -- Now update the long text table
1183: update fnd_documents_long_text
1184: set long_text = p_attachment_text
1185: where media_id = l_doc_tl_pre_upd.media_id;
1186:
1187: EXCEPTION

Line 1212: -- fnd_documents_long_text tables. If customer uses third party

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

Line 1261: from fnd_documents_long_text

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
1261: from fnd_documents_long_text
1262: where media_id = csr_p_media_id;
1263:
1264: Begin
1265: --

Line 1282: -- fnd_documents_long_text.

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: --
1285: -- -------------------------------------------------------------------------
1286: -- 1) Get Category ID.