APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_PRICE_DIFFER_INT

Line 1252: to the new lines from the PON_AUC_PRICE_DIFFER_INT interface table

1248:
1249: PARAMETERS: NONE
1250:
1251: COMMENT : This procedure will add the price differentials corresponding
1252: to the new lines from the PON_AUC_PRICE_DIFFER_INT interface table
1253: to the PON_PRICE_DIFFERENTIALS transaction tables.
1254: ======================================================================*/
1255: PROCEDURE ADD_PRICE_DIFFERENTIALS is
1256:

Line 1291: pon_auc_price_differ_int pdf_int,

1287: sysdate,
1288: g_user_id,
1289: fnd_global.login_id
1290: from
1291: pon_auc_price_differ_int pdf_int,
1292: pon_item_prices_interface p1
1293: where
1294: pdf_int.batch_id = g_batch_id
1295: and p1.batch_id = pdf_int.batch_id

Line 1964: pon_auc_price_differ_int price_diff_int

1960: g_user_id,
1961: fnd_global.login_id
1962: FROM
1963: pon_item_prices_interface paip_int,
1964: pon_auc_price_differ_int price_diff_int
1965: WHERE
1966: paip_int.batch_id = g_batch_id
1967: and price_diff_int.batch_id = paip_int.batch_id
1968: and price_diff_int.auction_line_number = paip_int.auction_line_number

Line 2899: delete from pon_auc_price_differ_int where batch_id = g_batch_id;

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
2903: l_progress := 'delete completed p_auction_header_id = '||p_auction_header_id;