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_LARGE_AUCTION_UTIL_PKG dependencies on PON_BID_PAYMENTS_SHIPMENTS

Line 64: pon_bid_payments_shipments pay

60:
61: CURSOR bid_payments_with_attachments IS
62: SELECT pay.bid_payment_id, pay.bid_number, pay.bid_line_number
63: FROM fnd_attached_documents ad,
64: pon_bid_payments_shipments pay
65: WHERE ad.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'
66: AND ad.pk1_value = pay.bid_number
67: AND ad.pk2_value = pay.bid_line_number
68: AND ad.pk3_value = pay.bid_payment_id

Line 65: WHERE ad.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'

61: CURSOR bid_payments_with_attachments IS
62: SELECT pay.bid_payment_id, pay.bid_number, pay.bid_line_number
63: FROM fnd_attached_documents ad,
64: pon_bid_payments_shipments pay
65: WHERE ad.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'
66: AND ad.pk1_value = pay.bid_number
67: AND ad.pk2_value = pay.bid_line_number
68: AND ad.pk3_value = pay.bid_payment_id
69: AND pay.bid_number = p_bid_number

Line 89: (x_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

85: END IF;
86:
87:
88: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
89: (x_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
90: x_pk1_value => payment.bid_number,
91: x_pk2_value => payment.bid_line_number,
92: x_pk3_value => payment.bid_payment_id,
93: x_delete_document_flag => 'Y');

Line 178: DELETE FROM pon_bid_payments_shipments

174: l_batch_start,
175: l_batch_end);
176:
177: -- Delete Payments
178: DELETE FROM pon_bid_payments_shipments
179: WHERE bid_number = p_bid_number
180: AND bid_line_number BETWEEN l_batch_start AND l_batch_end;
181:
182: -- Delete line attachments