APPS.HR_PERSON_INTERNAL dependencies on FND_ATTACHED_DOCUMENTS

Line 1464: FROM fnd_attached_documents

1460: FOR UPDATE;
1461: --
1462: CURSOR attached_docs_cursor1 IS
1463: SELECT attached_document_id
1464: FROM fnd_attached_documents
1465: WHERE pk1_value = l_pk1_value1;
1466: --
1467: cursor delattachments_cursor1 (x_attached_document_id in number) is
1468: select datatype_id

Line 1718: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,

1714: if delattachments_cursor1%NOTFOUND then
1715: return;
1716: end if;
1717: l_datatype_id := deldatarec1.datatype_id ;
1718: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,
1719: l_datatype_id,
1720: 'Y' );
1721: CLOSE delattachments_cursor1;
1722: END LOOP;

Line 1760: FROM fnd_attached_documents

1756: FOR UPDATE;
1757: --
1758: CURSOR attached_docs_cursor2 IS
1759: SELECT attached_document_id
1760: FROM fnd_attached_documents
1761: WHERE pk1_value = l_pk1_value2;
1762: --
1763: cursor delattachments_cursor2 (x_attached_document_id in number) is
1764: select datatype_id

Line 1921: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,

1917: if delattachments_cursor2%NOTFOUND then
1918: return;
1919: end if;
1920: l_datatype_id := deldatarec2.datatype_id ;
1921: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,
1922: l_datatype_id,
1923: 'Y' );
1924: CLOSE delattachments_cursor2;
1925: END LOOP;

Line 2006: FROM fnd_attached_documents

2002: WHERE person_id = p_person_id;
2003: --
2004: CURSOR attached_docs_cursor IS
2005: SELECT attached_document_id
2006: FROM fnd_attached_documents
2007: WHERE pk1_value = l_pk1_value3;
2008: --
2009: cursor delattachments_cursor (x_attached_document_id in number) is
2010: select datatype_id

Line 3737: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,

3733: if delattachments_cursor%NOTFOUND then
3734: return;
3735: end if;
3736: l_datatype_id := deldatarec.datatype_id ;
3737: FND_ATTACHED_DOCUMENTS3_PKG.delete_row (l_attached_document_id,
3738: l_datatype_id,
3739: 'Y' );
3740: CLOSE delattachments_cursor;
3741: END LOOP;