APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_PRICE_ELEMENTS_INT

Line 92: pon_auc_attributes_interface and pon_auc_price_elements_int

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

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

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

Line 360: update pon_auc_price_elements_int pe_int

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

Line 1181: PON_AUC_PRICE_ELEMENTS_INT corresponding to the new lines

1177:
1178: PARAMETERS: NONE
1179:
1180: COMMENT : This procedure will add the supplier price factors in
1181: PON_AUC_PRICE_ELEMENTS_INT corresponding to the new lines
1182: from the PON_ITEM_PRICES_INTERFACE interface table to the
1183: PON_PRICE_ELEMENTS transaction tables. The following sql
1184: will be used for the same. The logic for this is present
1185: in copyPriceElement method in NegItemSpreadsheetAMImpl.

Line 1229: pon_auc_price_elements_int pe_int,

1225: g_user_id,
1226: sysdate,
1227: g_user_id
1228: from
1229: pon_auc_price_elements_int pe_int,
1230: pon_item_prices_interface p1
1231: where
1232: pe_int.batch_id = g_batch_id
1233: and p1.batch_id = pe_int.batch_id

Line 2029: PON_AUC_PRICE_ELEMENTS_INT pe_int

2025: and not exists
2026: (select 1
2027: from
2028: PON_ITEM_PRICES_INTERFACE paip_int,
2029: PON_AUC_PRICE_ELEMENTS_INT pe_int
2030: where
2031: paip_int.action = g_update_action
2032: and paip_int.batch_id = g_batch_id
2033: and paip_int.batch_id = pe_int.batch_id

Line 2057: PON_AUC_PRICE_ELEMENTS_INT pe_int,

2053: l_pricing_basis,
2054: l_value,
2055: l_display_target_flag
2056: from
2057: PON_AUC_PRICE_ELEMENTS_INT pe_int,
2058: PON_ITEM_PRICES_INTERFACE paip_int
2059: where
2060: paip_int.action = g_update_action
2061: and paip_int.batch_id = g_batch_id

Line 2114: pon_auc_price_elements_int pe_int,

2110: g_user_id,
2111: sysdate,
2112: g_user_id
2113: from
2114: pon_auc_price_elements_int pe_int,
2115: pon_item_prices_interface paip_int
2116: where
2117: paip_int.action = g_update_action
2118: and paip_int.batch_id = g_batch_id

Line 2900: delete from pon_auc_price_elements_int where batch_id = g_batch_id;

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;
2904: END if;