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 1471: pon_auc_payments_shipments

1467: END IF;
1468:
1469: --complex work -delete payments
1470: DELETE FROM
1471: pon_auc_payments_shipments
1472: WHERE
1473: auction_header_id = p_auction_header_id AND
1474: line_number >= l_batch_start AND
1475: line_number <= l_batch_end;

Line 1824: fad.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS' AND

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

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

2027:
2028: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2029: FND_LOG.string (log_level => FND_LOG.level_statement,
2030: module => g_module_prefix || l_module_name,
2031: message => 'Delete attachments for pon_auc_payments_shipments');
2032: END IF;
2033:
2034: --delete payment attachments
2035:

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

2041:
2042: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2043: FND_LOG.string (log_level => FND_LOG.level_statement,
2044: module => g_module_prefix || l_module_name,
2045: message => 'Deleted the attachments for pon_auc_payments_shipments');
2046: END IF;
2047:
2048: DELETE FROM
2049: pon_auc_payments_shipments

Line 2049: pon_auc_payments_shipments

2045: message => 'Deleted the attachments for pon_auc_payments_shipments');
2046: END IF;
2047:
2048: DELETE FROM
2049: pon_auc_payments_shipments
2050: WHERE
2051: auction_header_id = p_auction_header_id AND
2052: line_number = p_line_number;
2053:

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

2053:
2054: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2055: FND_LOG.string (log_level => FND_LOG.level_statement,
2056: module => g_module_prefix || l_module_name,
2057: message => 'Deleted the entry in pon_auc_payments_shipments');
2058: END IF;
2059: END IF;--if neg has payments }
2060:
2061: DELETE FROM

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

2312:
2313: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2314: FND_LOG.string (log_level => FND_LOG.level_statement,
2315: module => g_module_prefix || l_module_name,
2316: message => 'Delete attachments for pon_auc_payments_shipments');
2317: END IF;
2318:
2319: --delete payment attachments
2320: FOR delete_attachments_rec IN delete_payments_attachments LOOP

Line 2328: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

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

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

2333:
2334: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2335: FND_LOG.string (log_level => FND_LOG.level_statement,
2336: module => g_module_prefix || l_module_name,
2337: message => 'Deleted the attachments for pon_auc_payments_shipments');
2338: END IF;
2339:
2340: DELETE FROM
2341: pon_auc_payments_shipments paps

Line 2341: pon_auc_payments_shipments paps

2337: message => 'Deleted the attachments for pon_auc_payments_shipments');
2338: END IF;
2339:
2340: DELETE FROM
2341: pon_auc_payments_shipments paps
2342: WHERE
2343: paps.auction_header_id = p_auction_header_id AND (
2344: paps.line_number = p_line_number OR
2345: EXISTS

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

2357:
2358: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2359: FND_LOG.string (log_level => FND_LOG.level_statement,
2360: module => g_module_prefix || l_module_name,
2361: message => 'Deleted the entry in pon_auc_payments_shipments');
2362: END IF;
2363: END IF;--if neg has payments
2364:
2365: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN