[Home] [Help]
1020: --'Y' for x_automatically_added_flag as we want to delete only
1021: --those attachment references that have been added automatically
1022: --in procedure reference_attachments
1023: --first delete all references on PO_IN_GA_LINES
1024: fnd_attached_documents2_pkg.delete_attachments('PO_IN_GA_LINES',
1025: p_po_line_id,
1026: '', '', '', '', 'N', 'Y');
1027:
1028: --Copy reference from entity 'PO_LINES' to enity 'PO_IN_GA_LINES'
1121: THEN
1122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1123: END IF;
1124:
1125: --Insert new records in fnd_attached_documents table to create
1126: --reference from p_from_entity_name to p_to_entity_name
1127: INSERT INTO fnd_attached_documents(
1128: ATTACHED_DOCUMENT_ID,
1129: DOCUMENT_ID,
1123: END IF;
1124:
1125: --Insert new records in fnd_attached_documents table to create
1126: --reference from p_from_entity_name to p_to_entity_name
1127: INSERT INTO fnd_attached_documents(
1128: ATTACHED_DOCUMENT_ID,
1129: DOCUMENT_ID,
1130: CREATION_DATE,
1131: CREATED_BY,
1163: COLUMN1,
1164: APP_SOURCE_VERSION,
1165: CATEGORY_ID,
1166: STATUS)
1167: SELECT fnd_attached_documents_s.nextval,
1168: fad.DOCUMENT_ID,
1169: fad.CREATION_DATE,
1170: fad.CREATED_BY,
1171: fad.LAST_UPDATE_DATE,
1202: COLUMN1,
1203: fad.APP_SOURCE_VERSION,
1204: fad.CATEGORY_ID,
1205: fad.STATUS
1206: FROM fnd_attached_documents fad, fnd_documents fd, financials_system_parameters fsp
1207: WHERE entity_name = p_from_entity_name
1208: AND pk1_value = p_from_pk1_value
1209: AND (p_from_pk2_value IS NULL
1210: OR p_from_pk2_value = pk2_value)