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 1336: fnd_attached_documents2_pkg.copy_attachments(

1332: ,p_pk1_value => delIdTab(i).orig_del_id) THEN
1333:
1334: -- copy attachments
1335: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
1336: fnd_attached_documents2_pkg.copy_attachments(
1337: X_from_entity_name => G_ENTITY_NAME,
1338: X_from_pk1_value => delIdTab(i).orig_del_id,
1339: X_to_entity_name => G_ENTITY_NAME,
1340: X_to_pk1_value => to_char(delIdTab(i).del_id),

Line 3139: fnd_attached_documents2_pkg.copy_attachments(

3135: '100: Copy Deliverable Attachments :'||to_char(delIdTab(i).del_id));
3136: END IF;
3137: -- copy attachments
3138: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
3139: fnd_attached_documents2_pkg.copy_attachments(
3140: X_from_entity_name => G_ENTITY_NAME,
3141: X_from_pk1_value => delIdTab(i).orig_del_id,
3142: X_to_entity_name => G_ENTITY_NAME,
3143: X_to_pk1_value => to_char(delIdTab(i).del_id),

Line 4227: fnd_attached_documents2_pkg.copy_attachments(

4223: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: create attachments');
4224: END IF;
4225: -- copy attachments
4226: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
4227: fnd_attached_documents2_pkg.copy_attachments(
4228: X_from_entity_name => G_ENTITY_NAME,
4229: X_from_pk1_value => delIdTab(j).orig_del_id,
4230: X_to_entity_name => G_ENTITY_NAME,
4231: X_to_pk1_value => to_char(delIdTab(j).del_id),

Line 4797: fnd_attached_documents2_pkg.copy_attachments(

4793: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: create attachments');
4794: END IF;
4795: -- copy attachments
4796: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
4797: fnd_attached_documents2_pkg.copy_attachments(
4798: X_from_entity_name => G_ENTITY_NAME,
4799: X_from_pk1_value => delIdTab(j).orig_del_id,
4800: X_to_entity_name => G_ENTITY_NAME,
4801: X_to_pk1_value => to_char(delIdTab(j).del_id),

Line 6513: FROM fnd_attached_documents att

6509:
6510: CURSOR att_cur IS
6511: SELECT att.attached_document_id
6512: ,doc.datatype_id
6513: FROM fnd_attached_documents att
6514: ,fnd_documents doc
6515: WHERE att.document_id = doc.document_id
6516: AND att.entity_name = p_entity_name
6517: AND att.pk1_value = p_pk1_value;

Line 6537: fnd_attached_documents3_pkg.delete_row (

6533: --delete attachments
6534: FOR att_rec IN att_cur
6535: LOOP
6536: BEGIN
6537: fnd_attached_documents3_pkg.delete_row (
6538: X_attached_document_id => att_rec.attached_document_id,
6539: X_datatype_id => att_rec.datatype_id,
6540: delete_document_flag => 'Y' );
6541: EXCEPTION

Line 11856: fnd_attached_documents2_pkg.copy_attachments(

11852: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Copy Deliverable Attachments :'||to_char(delIdTab(i).del_id));
11853: END IF;
11854: -- copy attachments
11855: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
11856: fnd_attached_documents2_pkg.copy_attachments(
11857: X_from_entity_name => G_ENTITY_NAME,
11858: X_from_pk1_value => delIdTab(i).orig_del_id,
11859: X_to_entity_name => G_ENTITY_NAME,
11860: X_to_pk1_value => to_char(delIdTab(i).del_id),

Line 12662: fnd_attached_documents2_pkg.copy_attachments(

12658: '100: Copy Deliverable Attachments :'||to_char(delIdTab(i).del_id));
12659: END IF;
12660: -- copy attachments
12661: -- bug#3667712 added X_CREATED_BY,X_LAST_UPDATE_LOGIN params
12662: fnd_attached_documents2_pkg.copy_attachments(
12663: X_from_entity_name => G_ENTITY_NAME,
12664: X_from_pk1_value => delIdTab(i).orig_del_id,
12665: X_to_entity_name => G_ENTITY_NAME,
12666: X_to_pk1_value => to_char(delIdTab(i).del_id),

Line 13295: fnd_attached_documents2_pkg.copy_attachments(

13291: 'Copying attachments from deliverable with id ' || to_char(prev_vers_del(i).deliverable_id) || ' to ' || to_char(l_deliverable_id));
13292: END IF;
13293:
13294: -- Copy attachments from prev version deliverable to current version deliverable
13295: fnd_attached_documents2_pkg.copy_attachments(
13296: X_from_entity_name => G_ENTITY_NAME,
13297: X_from_pk1_value => to_char(prev_vers_del(i).deliverable_id),
13298: X_to_entity_name => G_ENTITY_NAME,
13299: X_to_pk1_value => to_char(l_deliverable_id),