[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;
1414:
1415: --Delete Attachments
1416: FOR attachment_line IN lines_with_attachements LOOP
1417:
1418: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
1419: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',
1420: x_pk1_value => p_auction_header_id,
1421: x_pk2_value => attachment_line.line_number,
1422: x_pk3_value => NULL,
1790: CURSOR lines_with_attachements IS
1791: SELECT
1792: DISTINCT (TO_NUMBER(fad.pk2_value)) line_number
1793: FROM
1794: fnd_attached_documents fad,
1795: pon_auction_item_prices_all paip
1796: WHERE
1797: fad.entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND
1798: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
1817: CURSOR delete_payments_attachments IS
1818: SELECT
1819: DISTINCT (TO_NUMBER(fad.pk2_value)) line_number
1820: FROM
1821: fnd_attached_documents fad,
1822: pon_auction_item_prices_all paip
1823: WHERE
1824: fad.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS' AND
1825: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
2110: END IF;
2111:
2112: END IF;
2113:
2114: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
2115: x_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2116: x_pk1_value => p_auction_header_id,
2117: x_pk2_value => p_line_number);
2118:
2323: module => g_module_prefix || l_module_name,
2324: message => 'Deleting fnd attachments for payments for line number ' ||delete_attachments_rec.line_number||'='|| l_module_name);
2325: END IF;
2326: --delete the attachments for a payment
2327: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
2328: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
2329: x_pk1_value => p_auction_header_id,
2330: x_pk2_value => delete_attachments_rec.line_number,
2331: x_delete_document_flag => 'Y');
2481:
2482: --Delete Attachments
2483: FOR attachment_line IN lines_with_attachements LOOP
2484:
2485: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
2486: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',
2487: x_pk1_value => p_auction_header_id,
2488: x_pk2_value => attachment_line.line_number,
2489: x_pk3_value => NULL,