APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_ATTRIBUTE_SCORES

Line 691: PON_ATTRIBUTE_SCORES

687: COMMENT : The procedure delete_lines_with_children will delete those lines
688: that were marked as deleted in the spreadsheet. The records will
689: be deleted from the tables in the following order. For LOTS and
690: GROUP marked as deleted the corresponding children are also deleted.
691: PON_ATTRIBUTE_SCORES
692: PON_AUCTION_ATTRIBUTES
693: PON_PF_SUPPLIER_VALUES
694: PON_PRICE_ELEMENTS
695: PON_PRICE_DIFFERENTIALS

Line 766: --delete from PON_ATTRIBUTE_SCORES

762:
763: --delete from PON_AUCTION_ATTRIBUTES
764: if(g_line_attribute_enabled = 'Y') then
765:
766: --delete from PON_ATTRIBUTE_SCORES
767: if(g_attribute_score_enabled_flag = 'Y') then
768: delete from pon_attribute_scores auction_scores
769: where
770: auction_header_id = g_auction_header_id

Line 768: delete from pon_attribute_scores auction_scores

764: if(g_line_attribute_enabled = 'Y') then
765:
766: --delete from PON_ATTRIBUTE_SCORES
767: if(g_attribute_score_enabled_flag = 'Y') then
768: delete from pon_attribute_scores auction_scores
769: where
770: auction_header_id = g_auction_header_id
771: and exists
772: (select

Line 1657: insert into pon_attribute_scores

1653: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1654: print_debug_log(l_module,'ADD_ATTRIBUTE_SCORES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1655: END IF;
1656:
1657: insert into pon_attribute_scores
1658: fields
1659: (AUCTION_HEADER_ID,
1660: LINE_NUMBER,
1661: ATTRIBUTE_SEQUENCE_NUMBER,

Line 1690: pon_attribute_scores template_attribute_score,

1686: g_user_id
1687: FROM
1688: pon_auction_headers_all pah1,
1689: pon_auction_headers_all template,
1690: pon_attribute_scores template_attribute_score,
1691: pon_auction_attributes template_attribute,
1692: pon_auction_attributes auction_attributes,
1693: pon_auc_attributes_interface interface_attributes
1694: WHERE

Line 1883: from pon_attribute_scores

1879: -- 1) delete scores first
1880:
1881: delete from
1882: (select *
1883: from pon_attribute_scores
1884: where auction_header_id = g_auction_header_id and
1885: line_number in (select paip.line_number
1886: from pon_item_prices_interface p1,
1887: pon_auction_item_prices_all paip

Line 2486: delete from pon_attribute_scores attribute_scores

2482: and interface_attributes.datatype = auction_attributes.datatype);
2483:
2484:
2485: FORALL x in 1..l_line_number.COUNT
2486: delete from pon_attribute_scores attribute_scores
2487: where
2488: attribute_scores.auction_header_id = g_auction_header_id
2489: and attribute_scores.line_number = l_line_number(x)
2490: and attribute_scores.attribute_sequence_number = l_attribute_seq_number(x);