APPS.HR_PERSON_INTERNAL dependencies on FND_ATTACHED_DOCUMENTS

Line 1493: FROM fnd_attached_documents

1489: FOR UPDATE;
1490: --
1491: CURSOR attached_docs_cursor1 IS
1492: SELECT attached_document_id
1493: FROM fnd_attached_documents
1494: WHERE pk1_value = l_pk1_value1
1495: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745
1496: --
1497: cursor delattachments_cursor1 (x_attached_document_id in number) is

Line 1748: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,

1744: if delattachments_cursor1%NOTFOUND then
1745: return;
1746: end if;
1747: l_datatype_id := deldatarec1.datatype_id ;
1748: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,
1749: l_datatype_id,
1750: 'Y' );
1751: CLOSE delattachments_cursor1;
1752: END LOOP;

Line 1790: FROM fnd_attached_documents

1786: FOR UPDATE;
1787: --
1788: CURSOR attached_docs_cursor2 IS
1789: SELECT attached_document_id
1790: FROM fnd_attached_documents
1791: WHERE pk1_value = l_pk1_value2
1792: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745
1793: --
1794: cursor delattachments_cursor2 (x_attached_document_id in number) is

Line 1952: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,

1948: if delattachments_cursor2%NOTFOUND then
1949: return;
1950: end if;
1951: l_datatype_id := deldatarec2.datatype_id ;
1952: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,
1953: l_datatype_id,
1954: 'Y' );
1955: CLOSE delattachments_cursor2;
1956: END LOOP;

Line 2037: FROM fnd_attached_documents

2033: WHERE person_id = p_person_id;
2034: --
2035: CURSOR attached_docs_cursor IS
2036: SELECT attached_document_id
2037: FROM fnd_attached_documents
2038: WHERE pk1_value = l_pk1_value3
2039: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745
2040: --
2041: cursor delattachments_cursor (x_attached_document_id in number) is

Line 3790: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,

3786: if delattachments_cursor%NOTFOUND then
3787: return;
3788: end if;
3789: l_datatype_id := deldatarec.datatype_id ;
3790: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,
3791: l_datatype_id,
3792: 'Y' );
3793: CLOSE delattachments_cursor;
3794: END LOOP;