APPS.HR_PERSON_DEPLOYMENT_SWI dependencies on FND_ATTACHED_DOCUMENTS

Line 920: from fnd_attached_documents

916: --
917:
918: cursor csr_get_attached_doc is
919: select *
920: from fnd_attached_documents
921: where rowid = p_rowid;
922: --
923: cursor csr_get_doc(csr_p_document_id in number) is
924: select *

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

966: close csr_get_doc_tl;
967: raise data_error;
968: END IF;
969:
970: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
971: -- Now, lock the rows.
972: fnd_attached_documents_pkg.lock_row
973: (x_rowid => p_rowid
974: ,x_attached_document_id =>

Line 972: fnd_attached_documents_pkg.lock_row

968: END IF;
969:
970: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
971: -- Now, lock the rows.
972: fnd_attached_documents_pkg.lock_row
973: (x_rowid => p_rowid
974: ,x_attached_document_id =>
975: l_attached_doc_pre_upd.attached_document_id
976: ,x_document_id => l_doc_pre_upd.document_id

Line 1040: -- Update document to fnd_attached_documents, fnd_documents,

1036: ,x_title => l_doc_tl_pre_upd.title
1037: );
1038:
1039:
1040: -- Update document to fnd_attached_documents, fnd_documents,
1041: -- fnd_documents_tl
1042: --
1043: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1044: fnd_attached_documents_pkg.update_row

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

1039:
1040: -- Update document to fnd_attached_documents, fnd_documents,
1041: -- fnd_documents_tl
1042: --
1043: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1044: fnd_attached_documents_pkg.update_row
1045: (x_rowid => p_rowid
1046: ,x_attached_document_id =>
1047: l_attached_doc_pre_upd.attached_document_id

Line 1044: fnd_attached_documents_pkg.update_row

1040: -- Update document to fnd_attached_documents, fnd_documents,
1041: -- fnd_documents_tl
1042: --
1043: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1044: fnd_attached_documents_pkg.update_row
1045: (x_rowid => p_rowid
1046: ,x_attached_document_id =>
1047: l_attached_doc_pre_upd.attached_document_id
1048: ,x_document_id => l_doc_pre_upd.document_id

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

1110: ,x_url => l_doc_pre_upd.url
1111: ,x_title => l_doc_tl_pre_upd.title
1112: );
1113:
1114: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1115: hr_utility.set_location(' Leaving:' || l_proc,50);
1116:
1117: EXCEPTION
1118: when others then

Line 1142: from fnd_attached_documents

1138: lv_entity_name constant varchar2(30) := 'HR_PERSON_DEPLOYMENTS';
1139:
1140: cursor csr_get_attached_doc is
1141: select *
1142: from fnd_attached_documents
1143: where entity_name=lv_entity_name
1144: and pk1_value=lv_pk1_value;
1145:
1146: CURSOR C (X_attached_document_id in number) IS

Line 1148: FROM fnd_attached_documents

1144: and pk1_value=lv_pk1_value;
1145:
1146: CURSOR C (X_attached_document_id in number) IS
1147: SELECT rowid
1148: FROM fnd_attached_documents
1149: WHERE attached_document_id = X_attached_document_id;
1150: --
1151: Begin
1152: hr_utility.set_location(' Entering:' || l_proc,10);