[Home] [Help]
1201: l_module_name VARCHAR2 (30);
1202:
1203: CURSOR delete_attachments IS
1204: SELECT distinct (TO_NUMBER(pk2_value)) line_number
1205: FROM FND_ATTACHED_DOCUMENTS fnd
1206: WHERE
1207: fnd.pk1_value = p_auction_header_id
1208: AND fnd.pk2_value between to_char(p_curr_from_line_number) and to_char(p_curr_to_line_number)
1209: AND fnd.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS';
1219:
1220: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1221: FND_LOG.string (log_level => FND_LOG.level_procedure,
1222: module => g_module_prefix || l_module_name,
1223: message => 'before Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
1224: END IF;
1225:
1226: -- delete attachments for the payments if any
1227: FOR delete_attachments_rec IN delete_attachments LOOP
1230: module => g_module_prefix || l_module_name,
1231: message => 'Deleting fnd attachments for all the payments for line ' ||delete_attachments_rec.line_number||'='|| l_module_name);
1232: END IF;
1233: --delete the attachments for a payment
1234: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
1235: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
1236: x_pk1_value => p_auction_header_id,
1237: x_pk2_value => delete_attachments_rec.line_number,
1238: x_delete_document_flag => 'Y');
1240:
1241: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1242: FND_LOG.string (log_level => FND_LOG.level_procedure,
1243: module => g_module_prefix || l_module_name,
1244: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
1245: END IF;
1246:
1247: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1248: FND_LOG.string (log_level => FND_LOG.level_procedure,
1273: CURSOR lines_with_attachements IS
1274: SELECT
1275: DISTINCT (TO_NUMBER(pk2_value)) line_number
1276: FROM
1277: fnd_attached_documents
1278: WHERE
1279: entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND
1280: pk1_value = to_char(p_auction_header_id) AND
1281: pk2_value IS NOT NULL;
1434:
1435: --Delete Attachments
1436: FOR attachment_line IN lines_with_attachements LOOP
1437:
1438: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
1439: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',
1440: x_pk1_value => p_auction_header_id,
1441: x_pk2_value => attachment_line.line_number,
1442: x_pk3_value => NULL,
1855: CURSOR lines_with_attachements IS
1856: SELECT
1857: DISTINCT (TO_NUMBER(fad.pk2_value)) line_number
1858: FROM
1859: fnd_attached_documents fad,
1860: pon_auction_item_prices_all paip
1861: WHERE
1862: fad.entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND
1863: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
1882: CURSOR delete_payments_attachments IS
1883: SELECT
1884: DISTINCT (TO_NUMBER(fad.pk2_value)) line_number
1885: FROM
1886: fnd_attached_documents fad,
1887: pon_auction_item_prices_all paip
1888: WHERE
1889: fad.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS' AND
1890: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
2225: END IF;
2226:
2227: END IF;
2228:
2229: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
2230: x_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2231: x_pk1_value => p_auction_header_id,
2232: x_pk2_value => p_line_number);
2233:
2455: module => g_module_prefix || l_module_name,
2456: message => 'Deleting fnd attachments for payments for line number ' ||delete_attachments_rec.line_number||'='|| l_module_name);
2457: END IF;
2458: --delete the attachments for a payment
2459: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
2460: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
2461: x_pk1_value => p_auction_header_id,
2462: x_pk2_value => delete_attachments_rec.line_number,
2463: x_delete_document_flag => 'Y');
2613:
2614: --Delete Attachments
2615: FOR attachment_line IN lines_with_attachements LOOP
2616:
2617: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
2618: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',
2619: x_pk1_value => p_auction_header_id,
2620: x_pk2_value => attachment_line.line_number,
2621: x_pk3_value => NULL,