APPS.HR_PERSON_ABSENCE_SWI dependencies on FND_ATTACHED_DOCUMENTS

Line 934: from fnd_attached_documents

930: --
931:
932: cursor csr_get_attached_doc is
933: select *
934: from fnd_attached_documents
935: where rowid = p_rowid;
936: --
937: cursor csr_get_doc(csr_p_document_id in number) is
938: select *

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

980: close csr_get_doc_tl;
981: raise data_error;
982: END IF;
983:
984: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
985: -- Now, lock the rows.
986: fnd_attached_documents_pkg.lock_row
987: (x_rowid => p_rowid
988: ,x_attached_document_id =>

Line 986: fnd_attached_documents_pkg.lock_row

982: END IF;
983:
984: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
985: -- Now, lock the rows.
986: fnd_attached_documents_pkg.lock_row
987: (x_rowid => p_rowid
988: ,x_attached_document_id =>
989: l_attached_doc_pre_upd.attached_document_id
990: ,x_document_id => l_doc_pre_upd.document_id

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

1050: ,x_title => l_doc_tl_pre_upd.title
1051: );
1052:
1053:
1054: -- Update document to fnd_attached_documents, fnd_documents,
1055: -- fnd_documents_tl
1056: --
1057: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1058: fnd_attached_documents_pkg.update_row

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

1053:
1054: -- Update document to fnd_attached_documents, fnd_documents,
1055: -- fnd_documents_tl
1056: --
1057: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1058: fnd_attached_documents_pkg.update_row
1059: (x_rowid => p_rowid
1060: ,x_attached_document_id =>
1061: l_attached_doc_pre_upd.attached_document_id

Line 1058: fnd_attached_documents_pkg.update_row

1054: -- Update document to fnd_attached_documents, fnd_documents,
1055: -- fnd_documents_tl
1056: --
1057: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1058: fnd_attached_documents_pkg.update_row
1059: (x_rowid => p_rowid
1060: ,x_attached_document_id =>
1061: l_attached_doc_pre_upd.attached_document_id
1062: ,x_document_id => l_doc_pre_upd.document_id

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

1124: ,x_url => l_doc_pre_upd.url
1125: ,x_title => l_doc_tl_pre_upd.title
1126: );
1127:
1128: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1129: hr_utility.set_location(' Leaving:' || l_proc,50);
1130:
1131: EXCEPTION
1132: when others then

Line 1152: from fnd_attached_documents

1148: lv_entity_name constant varchar2(30) := 'PER_ABSENCE_ATTENDANCES';
1149:
1150: cursor csr_get_attached_doc is
1151: select *
1152: from fnd_attached_documents
1153: where entity_name=lv_entity_name
1154: and pk1_value=lv_pk1_value;
1155:
1156: CURSOR C (X_attached_document_id in number) IS

Line 1158: FROM fnd_attached_documents

1154: and pk1_value=lv_pk1_value;
1155:
1156: CURSOR C (X_attached_document_id in number) IS
1157: SELECT rowid
1158: FROM fnd_attached_documents
1159: WHERE attached_document_id = X_attached_document_id;
1160: --
1161: Begin
1162: hr_utility.set_location(' Entering:' || l_proc,10);