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_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_PAYMENTS_INTERFACE

Line 3160: delete from pon_auc_payments_interface where batch_id = g_batch_id;

3156: -- What is there is an error? need to clear these always
3157: IF(Nvl(p_commit,'Y') = 'Y') then
3158: delete from pon_item_prices_interface where batch_id = g_batch_id;
3159: delete from pon_auc_attributes_interface where batch_id = g_batch_id;
3160: delete from pon_auc_payments_interface where batch_id = g_batch_id;
3161: delete from pon_auc_price_differ_int where batch_id = g_batch_id;
3162: delete from pon_auc_price_elements_int where batch_id = g_batch_id;
3163:
3164:

Line 3284: FROM pon_auc_payments_interface papi,

3280: paps.payment_id,
3281: paps.auction_header_id,
3282: paps.line_number,
3283: papi.document_disp_line_number
3284: FROM pon_auc_payments_interface papi,
3285: pon_auction_item_prices_all pai,
3286: pon_auc_payments_shipments paps
3287: WHERE papi.auction_header_id = pai.auction_header_id
3288: AND papi.document_disp_line_number = pai.document_disp_line_number

Line 3330: FROM PON_AUC_PAYMENTS_INTERFACE ppi,

3326: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, (SELECT award_id FROM GMS_AWARDS_BASIC_V award WHERE award.award_number = ppi.project_award_number))) PROJECT_AWARD_ID,
3327: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, ppi.PROJECT_EXPENDITURE_TYPE)) PROJECT_EXPENDITURE_TYPE,
3328: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, porg.organization_id)) PROJECT_EXP_ORGANIZATION_ID,
3329: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, ppi.PROJECT_EXPENDITURE_ITEM_DATE)) PROJECT_EXPENDITURE_ITEM_DATE
3330: FROM PON_AUC_PAYMENTS_INTERFACE ppi,
3331: PON_AUCTION_ITEM_PRICES_ALL pai,
3332: PON_AUCTION_HEADERS_ALL pah,
3333: FND_USER fu,
3334: HR_LOCATIONS_ALL hrl,

Line 3461: delete from pon_auc_payments_interface where batch_id = p_batch_id;

3457: END LOOP;
3458:
3459: -- Clear the interface tables
3460: -- What is there is an error? need to clear these always
3461: delete from pon_auc_payments_interface where batch_id = p_batch_id;
3462:
3463: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3464: l_progress := 'delete from pon_auc_payments_interface completed for p_batch_id = '||p_batch_id||'p_auction_header_id = '||p_auction_header_id;
3465: END if;

Line 3464: l_progress := 'delete from pon_auc_payments_interface completed for p_batch_id = '||p_batch_id||'p_auction_header_id = '||p_auction_header_id;

3460: -- What is there is an error? need to clear these always
3461: delete from pon_auc_payments_interface where batch_id = p_batch_id;
3462:
3463: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3464: l_progress := 'delete from pon_auc_payments_interface completed for p_batch_id = '||p_batch_id||'p_auction_header_id = '||p_auction_header_id;
3465: END if;
3466:
3467: --Mark which lines are changed during amendment
3468: BEGIN