APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_PRICE_DIFFER_INT

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

1469:
1470: PARAMETERS: NONE
1471:
1472: COMMENT : This procedure will add the price differentials corresponding
1473: to the new lines from the PON_AUC_PRICE_DIFFER_INT interface table
1474: to the PON_PRICE_DIFFERENTIALS transaction tables.
1475: ======================================================================*/
1476: PROCEDURE ADD_PRICE_DIFFERENTIALS is
1477:

Line 1512: pon_auc_price_differ_int pdf_int,

1508: sysdate,
1509: g_user_id,
1510: fnd_global.login_id
1511: from
1512: pon_auc_price_differ_int pdf_int,
1513: pon_item_prices_interface p1
1514: where
1515: pdf_int.batch_id = g_batch_id
1516: and p1.batch_id = pdf_int.batch_id

Line 2224: pon_auc_price_differ_int price_diff_int

2220: g_user_id,
2221: fnd_global.login_id
2222: FROM
2223: pon_item_prices_interface paip_int,
2224: pon_auc_price_differ_int price_diff_int
2225: WHERE
2226: paip_int.batch_id = g_batch_id
2227: and price_diff_int.batch_id = paip_int.batch_id
2228: and price_diff_int.auction_line_number = paip_int.auction_line_number

Line 3161: delete from pon_auc_price_differ_int where batch_id = g_batch_id;

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:
3165: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN