APPS.HR_UTIL_MISC_SS dependencies on FND_ATTACHED_DOCUMENTS

Line 1447: from fnd_attached_documents

1443: data_error exception;
1444:
1445: cursor csr_get_attached_doc is
1446: select *
1447: from fnd_attached_documents
1448: where rowid = p_rowid;
1449: cursor csr_get_doc(csr_p_document_id in number) is
1450: select *
1451: from fnd_documents

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

1483: close csr_get_doc_tl;
1484: raise data_error;
1485: END IF;
1486:
1487: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
1488: fnd_attached_documents_pkg.lock_row
1489: (x_rowid => p_rowid
1490: ,x_attached_document_id =>
1491: l_attached_doc_pre_upd.attached_document_id

Line 1488: fnd_attached_documents_pkg.lock_row

1484: raise data_error;
1485: END IF;
1486:
1487: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
1488: fnd_attached_documents_pkg.lock_row
1489: (x_rowid => p_rowid
1490: ,x_attached_document_id =>
1491: l_attached_doc_pre_upd.attached_document_id
1492: ,x_document_id => l_doc_pre_upd.document_id

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

1552: ,x_title => l_doc_tl_pre_upd.title
1553: );
1554:
1555:
1556: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1557: fnd_attached_documents_pkg.update_row
1558: (x_rowid => p_rowid
1559: ,x_attached_document_id =>
1560: l_attached_doc_pre_upd.attached_document_id

Line 1557: fnd_attached_documents_pkg.update_row

1553: );
1554:
1555:
1556: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1557: fnd_attached_documents_pkg.update_row
1558: (x_rowid => p_rowid
1559: ,x_attached_document_id =>
1560: l_attached_doc_pre_upd.attached_document_id
1561: ,x_document_id => l_doc_pre_upd.document_id

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

1623: ,x_url => l_doc_pre_upd.url
1624: ,x_title => l_doc_tl_pre_upd.title
1625: );
1626:
1627: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1628: hr_utility.set_location(' Leaving:' || l_proc,50);
1629:
1630: EXCEPTION
1631: when others then

Line 1657: from fnd_attached_documents

1653:
1654:
1655: cursor csr_get_attached_doc(source_pk1_value in varchar2) is
1656: select *
1657: from fnd_attached_documents
1658: where entity_name=p_source_entity_name
1659: and pk1_value=source_pk1_value;
1660:
1661: CURSOR C (X_attached_document_id in number) IS

Line 1663: FROM fnd_attached_documents

1659: and pk1_value=source_pk1_value;
1660:
1661: CURSOR C (X_attached_document_id in number) IS
1662: SELECT rowid
1663: FROM fnd_attached_documents
1664: WHERE attached_document_id = X_attached_document_id;
1665:
1666: cursor csr_get_itemkey(source_pk1_value in varchar2) is
1667: select item_type, item_key

Line 1700: , fnd_attached_documents fads

1696: BEGIN
1697: SELECT hat.SELECTED_PERSON_ID, hatv2.number_value irc_doc_id
1698: INTO l_person_id,l_irc_doc_id
1699: FROM hr_api_transactions hat
1700: , fnd_attached_documents fads
1701: , hr_api_transaction_steps hats
1702: , hr_api_transaction_values hatv1
1703: , hr_api_transaction_values hatv2
1704: WHERE hat.transaction_id = l_source_pk1_value