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 66: pon_bid_payments_shipments pay

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

Line 67: WHERE ad.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'

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

Line 91: (x_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

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

Line 192: DELETE FROM pon_bid_payments_shipments

188: l_batch_start,
189: l_batch_end);
190:
191: -- Delete Payments
192: DELETE FROM pon_bid_payments_shipments
193: WHERE bid_number = p_bid_number
194: AND bid_line_number BETWEEN l_batch_start AND l_batch_end;
195:
196: -- Delete line attachments