APPS.HR_PERSON_ABSENCE_SWI dependencies on FND_ATTACHED_DOCUMENTS

Line 1214: from fnd_attached_documents

1210: --
1211:
1212: cursor csr_get_attached_doc is
1213: select *
1214: from fnd_attached_documents
1215: where rowid = p_rowid;
1216: --
1217: cursor csr_get_doc(csr_p_document_id in number) is
1218: select *

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

1260: close csr_get_doc_tl;
1261: raise data_error;
1262: END IF;
1263:
1264: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
1265: -- Now, lock the rows.
1266: fnd_attached_documents_pkg.lock_row
1267: (x_rowid => p_rowid
1268: ,x_attached_document_id =>

Line 1266: fnd_attached_documents_pkg.lock_row

1262: END IF;
1263:
1264: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
1265: -- Now, lock the rows.
1266: fnd_attached_documents_pkg.lock_row
1267: (x_rowid => p_rowid
1268: ,x_attached_document_id =>
1269: l_attached_doc_pre_upd.attached_document_id
1270: ,x_document_id => l_doc_pre_upd.document_id

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

1330: ,x_title => l_doc_tl_pre_upd.title
1331: );
1332:
1333:
1334: -- Update document to fnd_attached_documents, fnd_documents,
1335: -- fnd_documents_tl
1336: --
1337: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1338: fnd_attached_documents_pkg.update_row

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

1333:
1334: -- Update document to fnd_attached_documents, fnd_documents,
1335: -- fnd_documents_tl
1336: --
1337: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1338: fnd_attached_documents_pkg.update_row
1339: (x_rowid => p_rowid
1340: ,x_attached_document_id =>
1341: l_attached_doc_pre_upd.attached_document_id

Line 1338: fnd_attached_documents_pkg.update_row

1334: -- Update document to fnd_attached_documents, fnd_documents,
1335: -- fnd_documents_tl
1336: --
1337: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1338: fnd_attached_documents_pkg.update_row
1339: (x_rowid => p_rowid
1340: ,x_attached_document_id =>
1341: l_attached_doc_pre_upd.attached_document_id
1342: ,x_document_id => l_doc_pre_upd.document_id

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

1404: ,x_url => l_doc_pre_upd.url
1405: ,x_title => l_doc_tl_pre_upd.title
1406: );
1407:
1408: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1409: hr_utility.set_location(' Leaving:' || l_proc,50);
1410:
1411: EXCEPTION
1412: when others then

Line 1432: from fnd_attached_documents

1428: lv_entity_name constant varchar2(30) := 'PER_ABSENCE_ATTENDANCES';
1429:
1430: cursor csr_get_attached_doc is
1431: select *
1432: from fnd_attached_documents
1433: where entity_name=lv_entity_name
1434: and pk1_value=lv_pk1_value;
1435:
1436: CURSOR C (X_attached_document_id in number) IS

Line 1438: FROM fnd_attached_documents

1434: and pk1_value=lv_pk1_value;
1435:
1436: CURSOR C (X_attached_document_id in number) IS
1437: SELECT rowid
1438: FROM fnd_attached_documents
1439: WHERE attached_document_id = X_attached_document_id;
1440: --
1441: Begin
1442: hr_utility.set_location(' Entering:' || l_proc,10);