eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 1209: AND fnd.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS';

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';
1210: BEGIN
1211:
1212: l_module_name := 'Delete_Payment_Attachments';
1213:

Line 1235: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

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');
1239: END LOOP;

Line 1491: pon_auc_payments_shipments

1487: END IF;
1488:
1489: --complex work -delete payments
1490: DELETE FROM
1491: pon_auc_payments_shipments
1492: WHERE
1493: auction_header_id = p_auction_header_id AND
1494: line_number >= l_batch_start AND
1495: line_number <= l_batch_end;

Line 1889: fad.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS' AND

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
1891: paip.auction_header_id = p_auction_header_id AND
1892: fad.pk2_value = paip.line_number AND
1893: (paip.line_number = p_line_number OR paip.parent_line_number = p_line_number);

Line 2098: message => 'Delete attachments for pon_auc_payments_shipments');

2094:
2095: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2096: FND_LOG.string (log_level => FND_LOG.level_statement,
2097: module => g_module_prefix || l_module_name,
2098: message => 'Delete attachments for pon_auc_payments_shipments');
2099: END IF;
2100:
2101: --delete payment attachments
2102:

Line 2112: message => 'Deleted the attachments for pon_auc_payments_shipments');

2108:
2109: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2110: FND_LOG.string (log_level => FND_LOG.level_statement,
2111: module => g_module_prefix || l_module_name,
2112: message => 'Deleted the attachments for pon_auc_payments_shipments');
2113: END IF;
2114:
2115: DELETE FROM
2116: pon_auc_payments_shipments

Line 2116: pon_auc_payments_shipments

2112: message => 'Deleted the attachments for pon_auc_payments_shipments');
2113: END IF;
2114:
2115: DELETE FROM
2116: pon_auc_payments_shipments
2117: WHERE
2118: auction_header_id = p_auction_header_id AND
2119: line_number = p_line_number;
2120:

Line 2124: message => 'Deleted the entry in pon_auc_payments_shipments');

2120:
2121: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2122: FND_LOG.string (log_level => FND_LOG.level_statement,
2123: module => g_module_prefix || l_module_name,
2124: message => 'Deleted the entry in pon_auc_payments_shipments');
2125: END IF;
2126: END IF;--if neg has payments }
2127:
2128: DELETE FROM

Line 2448: message => 'Delete attachments for pon_auc_payments_shipments');

2444:
2445: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2446: FND_LOG.string (log_level => FND_LOG.level_statement,
2447: module => g_module_prefix || l_module_name,
2448: message => 'Delete attachments for pon_auc_payments_shipments');
2449: END IF;
2450:
2451: --delete payment attachments
2452: FOR delete_attachments_rec IN delete_payments_attachments LOOP

Line 2460: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

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');
2464: END LOOP;

Line 2469: message => 'Deleted the attachments for pon_auc_payments_shipments');

2465:
2466: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2467: FND_LOG.string (log_level => FND_LOG.level_statement,
2468: module => g_module_prefix || l_module_name,
2469: message => 'Deleted the attachments for pon_auc_payments_shipments');
2470: END IF;
2471:
2472: DELETE FROM
2473: pon_auc_payments_shipments paps

Line 2473: pon_auc_payments_shipments paps

2469: message => 'Deleted the attachments for pon_auc_payments_shipments');
2470: END IF;
2471:
2472: DELETE FROM
2473: pon_auc_payments_shipments paps
2474: WHERE
2475: paps.auction_header_id = p_auction_header_id AND (
2476: paps.line_number = p_line_number OR
2477: EXISTS

Line 2493: message => 'Deleted the entry in pon_auc_payments_shipments');

2489:
2490: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2491: FND_LOG.string (log_level => FND_LOG.level_statement,
2492: module => g_module_prefix || l_module_name,
2493: message => 'Deleted the entry in pon_auc_payments_shipments');
2494: END IF;
2495: END IF;--if neg has payments
2496:
2497: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN