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 2898: delete from pon_auc_payments_interface where batch_id = g_batch_id;

2894: -- Clear the interface tables
2895: -- What is there is an error? need to clear these always
2896: delete from pon_item_prices_interface where batch_id = g_batch_id;
2897: delete from pon_auc_attributes_interface where batch_id = g_batch_id;
2898: delete from pon_auc_payments_interface where batch_id = g_batch_id;
2899: delete from pon_auc_price_differ_int where batch_id = g_batch_id;
2900: delete from pon_auc_price_elements_int where batch_id = g_batch_id;
2901:
2902: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2989: FROM pon_auc_payments_interface papi,

2985: paps.payment_id,
2986: paps.auction_header_id,
2987: paps.line_number,
2988: papi.document_disp_line_number
2989: FROM pon_auc_payments_interface papi,
2990: pon_auction_item_prices_all pai,
2991: pon_auc_payments_shipments paps
2992: WHERE papi.auction_header_id = pai.auction_header_id
2993: AND papi.document_disp_line_number = pai.document_disp_line_number

Line 3035: FROM PON_AUC_PAYMENTS_INTERFACE ppi,

3031: 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,
3032: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, ppi.PROJECT_EXPENDITURE_TYPE)) PROJECT_EXPENDITURE_TYPE,
3033: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, porg.organization_id)) PROJECT_EXP_ORGANIZATION_ID,
3034: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, ppi.PROJECT_EXPENDITURE_ITEM_DATE)) PROJECT_EXPENDITURE_ITEM_DATE
3035: FROM PON_AUC_PAYMENTS_INTERFACE ppi,
3036: PON_AUCTION_ITEM_PRICES_ALL pai,
3037: PON_AUCTION_HEADERS_ALL pah,
3038: FND_USER fu,
3039: HR_LOCATIONS_ALL hrl,

Line 3166: delete from pon_auc_payments_interface where batch_id = p_batch_id;

3162: END LOOP;
3163:
3164: -- Clear the interface tables
3165: -- What is there is an error? need to clear these always
3166: delete from pon_auc_payments_interface where batch_id = p_batch_id;
3167:
3168: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3169: l_progress := 'delete from pon_auc_payments_interface completed for p_batch_id = '||p_batch_id||'p_auction_header_id = '||p_auction_header_id;
3170: END if;

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

3165: -- What is there is an error? need to clear these always
3166: delete from pon_auc_payments_interface where batch_id = p_batch_id;
3167:
3168: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3169: l_progress := 'delete from pon_auc_payments_interface completed for p_batch_id = '||p_batch_id||'p_auction_header_id = '||p_auction_header_id;
3170: END if;
3171:
3172: --Mark which lines are changed during amendment
3173: BEGIN