APPS.HR_OFFER_CUSTOM dependencies on FND_ATTACHED_DOCUMENTS_PKG

Line 841: -- Call fnd_attached_documents_pkg.insert_row api to insert into fnd_documents

837: ,p_rowid out nocopy varchar2
838: ,p_login_person_id in number) is -- 10/14/97 Changed
839:
840: -- [CUSTOMIZE]
841: -- Call fnd_attached_documents_pkg.insert_row api to insert into fnd_documents
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;

Line 903: fnd_attached_documents_pkg.insert_row

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
906: ,x_document_id => l_document_id
907: ,x_creation_date => trunc(sysdate)

Line 982: -- Call fnd_attached_documents_pkg.update_row api to update fnd_documents

978: ,p_rowid in varchar2
979: ,p_login_person_id in number) is -- 10/14/97 Changed
980:
981: -- [CUSTOMIZE]
982: -- Call fnd_attached_documents_pkg.update_row api to update fnd_documents
983: -- table. If customer uses third party software to store the resume, modify
984: -- the code here.
985:
986: l_rowid varchar2(50);

Line 1047: fnd_attached_documents_pkg.lock_row

1043: raise data_error;
1044: END IF;
1045:
1046: -- Now, lock the rows.
1047: fnd_attached_documents_pkg.lock_row
1048: (x_rowid => p_rowid
1049: ,x_attached_document_id =>
1050: l_attached_doc_pre_upd.attached_document_id
1051: ,x_document_id => l_doc_pre_upd.document_id

Line 1115: fnd_attached_documents_pkg.update_row

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 =>
1118: l_attached_doc_pre_upd.attached_document_id
1119: ,x_document_id => l_doc_pre_upd.document_id

Line 1234: -- In closer look at the FND api, the fnd_attached_documents_pkg.insert_row

1230: and name = 'HR_RESUME'; -- updated for bug no:2533461
1231:
1232: ------------------------------------------------------------------------------
1233: -- Jan. 11, 2001 Bug Fix 1576603:
1234: -- In closer look at the FND api, the fnd_attached_documents_pkg.insert_row
1235: -- (AFAKAADB.pls) always sets start_date_active and end_date_active to null in
1236: -- call to fnd_documents_pkg.insert_row (AFAKADCB.pls). Therefore, the
1237: -- comparision of p_effective_date to start_date_active and end_date_active in
1238: -- the cursor is futile. Therefore, remove the p_effective_date comparision