APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_PRICE_ELEMENTS_INT

Line 94: pon_auc_attributes_interface and pon_auc_price_elements_int

90: IN : p_auction_header_id NUMBER auction header id
91: IN : p_batch_id NUMBER batch id for which the defaulting will be done.
92:
93: COMMENT : This procedure will default various field in pon_item_prices_interface,
94: pon_auc_attributes_interface and pon_auc_price_elements_int
95: for lines being updated based on various conditions.
96: ======================================================================*/
97: procedure DEFAULT_PREV_ROUND_AMEND_LINES(
98: p_auction_header_id IN NUMBER,

Line 361: -- Update display_target_flag in pon_auc_price_elements_int for existing price elements

357: and auction_attributes.line_number = interface_attribute.auction_line_number
358: and auction_attributes.attribute_name = interface_attribute.attribute_name
359: and auction_attributes.sequence_number in (-10,-20));
360:
361: -- Update display_target_flag in pon_auc_price_elements_int for existing price elements
362: -- for lines that were present in the previous amendment.
363: if l_is_amendment = 'Y' then
364:
365: update pon_auc_price_elements_int pe_int

Line 365: update pon_auc_price_elements_int pe_int

361: -- Update display_target_flag in pon_auc_price_elements_int for existing price elements
362: -- for lines that were present in the previous amendment.
363: if l_is_amendment = 'Y' then
364:
365: update pon_auc_price_elements_int pe_int
366: set pe_int.DISPLAY_TARGET_FLAG = (select pe1.display_target_flag
367: from pon_price_elements pe1
368: where
369: pe_int.auction_line_number = pe1.line_number

Line 1402: PON_AUC_PRICE_ELEMENTS_INT corresponding to the new lines

1398:
1399: PARAMETERS: NONE
1400:
1401: COMMENT : This procedure will add the supplier price factors in
1402: PON_AUC_PRICE_ELEMENTS_INT corresponding to the new lines
1403: from the PON_ITEM_PRICES_INTERFACE interface table to the
1404: PON_PRICE_ELEMENTS transaction tables. The following sql
1405: will be used for the same. The logic for this is present
1406: in copyPriceElement method in NegItemSpreadsheetAMImpl.

Line 1450: pon_auc_price_elements_int pe_int,

1446: g_user_id,
1447: sysdate,
1448: g_user_id
1449: from
1450: pon_auc_price_elements_int pe_int,
1451: pon_item_prices_interface p1
1452: where
1453: pe_int.batch_id = g_batch_id
1454: and p1.batch_id = pe_int.batch_id

Line 2290: PON_AUC_PRICE_ELEMENTS_INT pe_int

2286: and not exists
2287: (select 1
2288: from
2289: PON_ITEM_PRICES_INTERFACE paip_int,
2290: PON_AUC_PRICE_ELEMENTS_INT pe_int
2291: where
2292: paip_int.action = g_update_action
2293: and paip_int.batch_id = g_batch_id
2294: and paip_int.batch_id = pe_int.batch_id

Line 2318: PON_AUC_PRICE_ELEMENTS_INT pe_int,

2314: l_pricing_basis,
2315: l_value,
2316: l_display_target_flag
2317: from
2318: PON_AUC_PRICE_ELEMENTS_INT pe_int,
2319: PON_ITEM_PRICES_INTERFACE paip_int
2320: where
2321: paip_int.action = g_update_action
2322: and paip_int.batch_id = g_batch_id

Line 2375: pon_auc_price_elements_int pe_int,

2371: g_user_id,
2372: sysdate,
2373: g_user_id
2374: from
2375: pon_auc_price_elements_int pe_int,
2376: pon_item_prices_interface paip_int
2377: where
2378: paip_int.action = g_update_action
2379: and paip_int.batch_id = g_batch_id

Line 3162: delete from pon_auc_price_elements_int where batch_id = g_batch_id;

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