APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 521: FROM fnd_attached_documents

517: ) RETURN BOOLEAN
518: IS
519: CURSOR att_cur IS
520: SELECT 'X'
521: FROM fnd_attached_documents
522: WHERE entity_name = p_entity_name
523: AND pk1_value = p_pk1_value;
524:
525: att_rec att_cur%ROWTYPE;

Line 1254: fnd_attached_documents2_pkg.copy_attachments(

1250: ,p_pk1_value => delIdTab(i).orig_del_id) THEN
1251:
1252: -- copy attachments
1253: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
1254: fnd_attached_documents2_pkg.copy_attachments(
1255: X_from_entity_name => G_ENTITY_NAME,
1256: X_from_pk1_value => delIdTab(i).orig_del_id,
1257: X_to_entity_name => G_ENTITY_NAME,
1258: X_to_pk1_value => to_char(delIdTab(i).del_id),

Line 2963: fnd_attached_documents2_pkg.copy_attachments(

2959: '100: Copy Deliverable Attachments :'||to_char(delIdTab(i).del_id));
2960: END IF;
2961: -- copy attachments
2962: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
2963: fnd_attached_documents2_pkg.copy_attachments(
2964: X_from_entity_name => G_ENTITY_NAME,
2965: X_from_pk1_value => delIdTab(i).orig_del_id,
2966: X_to_entity_name => G_ENTITY_NAME,
2967: X_to_pk1_value => to_char(delIdTab(i).del_id),

Line 3989: fnd_attached_documents2_pkg.copy_attachments(

3985: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: create attachments');
3986: END IF;
3987: -- copy attachments
3988: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
3989: fnd_attached_documents2_pkg.copy_attachments(
3990: X_from_entity_name => G_ENTITY_NAME,
3991: X_from_pk1_value => delIdTab(j).orig_del_id,
3992: X_to_entity_name => G_ENTITY_NAME,
3993: X_to_pk1_value => to_char(delIdTab(j).del_id),

Line 4510: fnd_attached_documents2_pkg.copy_attachments(

4506: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: create attachments');
4507: END IF;
4508: -- copy attachments
4509: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
4510: fnd_attached_documents2_pkg.copy_attachments(
4511: X_from_entity_name => G_ENTITY_NAME,
4512: X_from_pk1_value => delIdTab(j).orig_del_id,
4513: X_to_entity_name => G_ENTITY_NAME,
4514: X_to_pk1_value => to_char(delIdTab(j).del_id),

Line 6192: FROM fnd_attached_documents att

6188:
6189: CURSOR att_cur IS
6190: SELECT att.attached_document_id
6191: ,doc.datatype_id
6192: FROM fnd_attached_documents att
6193: ,fnd_documents doc
6194: WHERE att.document_id = doc.document_id
6195: AND att.entity_name = p_entity_name
6196: AND att.pk1_value = p_pk1_value;

Line 6216: fnd_attached_documents3_pkg.delete_row (

6212: OPEN att_cur;
6213: FETCH att_cur INTO att_rec;
6214:
6215: --delete attachments
6216: fnd_attached_documents3_pkg.delete_row (
6217: X_attached_document_id => att_rec.attached_document_id,
6218: X_datatype_id => att_rec.datatype_id,
6219: delete_document_flag => 'Y' );
6220: CLOSE att_cur;

Line 10837: fnd_attached_documents2_pkg.copy_attachments(

10833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Copy Deliverable Attachments :'||to_char(delIdTab(i).del_id));
10834: END IF;
10835: -- copy attachments
10836: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
10837: fnd_attached_documents2_pkg.copy_attachments(
10838: X_from_entity_name => G_ENTITY_NAME,
10839: X_from_pk1_value => delIdTab(i).orig_del_id,
10840: X_to_entity_name => G_ENTITY_NAME,
10841: X_to_pk1_value => to_char(delIdTab(i).del_id),

Line 11616: fnd_attached_documents2_pkg.copy_attachments(

11612: '100: Copy Deliverable Attachments :'||to_char(delIdTab(i).del_id));
11613: END IF;
11614: -- copy attachments
11615: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
11616: fnd_attached_documents2_pkg.copy_attachments(
11617: X_from_entity_name => G_ENTITY_NAME,
11618: X_from_pk1_value => delIdTab(i).orig_del_id,
11619: X_to_entity_name => G_ENTITY_NAME,
11620: X_to_pk1_value => to_char(delIdTab(i).del_id),

Line 12195: fnd_attached_documents2_pkg.copy_attachments(

12191: 'Copying attachments from deliverable with id ' || to_char(prev_vers_del(i).deliverable_id) || ' to ' || to_char(l_deliverable_id));
12192: END IF;
12193:
12194: -- Copy attachments from prev version deliverable to current version deliverable
12195: fnd_attached_documents2_pkg.copy_attachments(
12196: X_from_entity_name => G_ENTITY_NAME,
12197: X_from_pk1_value => to_char(prev_vers_del(i).deliverable_id),
12198: X_to_entity_name => G_ENTITY_NAME,
12199: X_to_pk1_value => to_char(l_deliverable_id),