APPS.HR_DOR_REVIEW_SS dependencies on FND_ATTACHED_DOCUMENTS

Line 3628: from fnd_attached_documents

3624: msg_appl varchar2(10);
3625:
3626: Cursor get_attached_docs(p_value in number) is
3627: select rowid
3628: from fnd_attached_documents
3629: where entity_name = 'R_DOCUMENT_EXTRA_INFO'
3630: and pk1_value = p_value;
3631:
3632:

Line 3703: from fnd_attached_documents

3699: msg_name varchar2(1000);
3700: msg_appl varchar2(10);
3701: cursor csr_get_attached_doc is
3702: select *
3703: from fnd_attached_documents
3704: where rowid = p_rowid;
3705: cursor csr_get_doc(csr_p_document_id in number) is
3706: select *
3707: from fnd_documents

Line 3743: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);

3739: close csr_get_doc_tl;
3740: raise data_error;
3741: END IF;
3742:
3743: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
3744: fnd_attached_documents_pkg.lock_row
3745: (x_rowid => p_rowid
3746: ,x_attached_document_id =>
3747: l_attached_doc_pre_upd.attached_document_id

Line 3744: fnd_attached_documents_pkg.lock_row

3740: raise data_error;
3741: END IF;
3742:
3743: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
3744: fnd_attached_documents_pkg.lock_row
3745: (x_rowid => p_rowid
3746: ,x_attached_document_id =>
3747: l_attached_doc_pre_upd.attached_document_id
3748: ,x_document_id => l_doc_pre_upd.document_id

Line 3812: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);

3808: ,x_title => l_doc_tl_pre_upd.title
3809: );
3810:
3811:
3812: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
3813:
3814:
3815: fnd_attached_documents_pkg.update_row
3816: (x_rowid => p_rowid

Line 3815: fnd_attached_documents_pkg.update_row

3811:
3812: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
3813:
3814:
3815: fnd_attached_documents_pkg.update_row
3816: (x_rowid => p_rowid
3817: ,x_attached_document_id =>
3818: l_attached_doc_pre_upd.attached_document_id
3819: ,x_document_id => l_doc_pre_upd.document_id

Line 3885: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);

3881: ,x_url => l_doc_pre_upd.url
3882: ,x_title => l_doc_tl_pre_upd.title
3883: );
3884:
3885: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
3886: hr_utility.set_location(' Leaving:' || l_proc,50);
3887:
3888: EXCEPTION
3889: when others then