APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_ATTRIBUTE_SCORES

Line 686: PON_ATTRIBUTE_SCORES

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

Line 754: --delete from PON_ATTRIBUTE_SCORES

750:
751: --delete from PON_AUCTION_ATTRIBUTES
752: if(g_line_attribute_enabled = 'Y') then
753:
754: --delete from PON_ATTRIBUTE_SCORES
755: if(g_attribute_score_enabled_flag = 'Y') then
756: delete from pon_attribute_scores auction_scores
757: where
758: auction_header_id = g_auction_header_id

Line 756: delete from pon_attribute_scores auction_scores

752: if(g_line_attribute_enabled = 'Y') then
753:
754: --delete from PON_ATTRIBUTE_SCORES
755: if(g_attribute_score_enabled_flag = 'Y') then
756: delete from pon_attribute_scores auction_scores
757: where
758: auction_header_id = g_auction_header_id
759: and exists
760: (select

Line 1435: insert into pon_attribute_scores

1431: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1432: print_debug_log(l_module,'ADD_ATTRIBUTE_SCORES START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1433: END IF;
1434:
1435: insert into pon_attribute_scores
1436: fields
1437: (AUCTION_HEADER_ID,
1438: LINE_NUMBER,
1439: ATTRIBUTE_SEQUENCE_NUMBER,

Line 1468: pon_attribute_scores template_attribute_score,

1464: g_user_id
1465: FROM
1466: pon_auction_headers_all pah1,
1467: pon_auction_headers_all template,
1468: pon_attribute_scores template_attribute_score,
1469: pon_auction_attributes template_attribute,
1470: pon_auction_attributes auction_attributes,
1471: pon_auc_attributes_interface interface_attributes
1472: WHERE

Line 1650: from pon_attribute_scores

1646: -- 1) delete scores first
1647:
1648: delete from
1649: (select *
1650: from pon_attribute_scores
1651: where auction_header_id = g_auction_header_id and
1652: line_number in (select paip.line_number
1653: from pon_item_prices_interface p1,
1654: pon_auction_item_prices_all paip

Line 2225: delete from pon_attribute_scores attribute_scores

2221: and interface_attributes.datatype = auction_attributes.datatype);
2222:
2223:
2224: FORALL x in 1..l_line_number.COUNT
2225: delete from pon_attribute_scores attribute_scores
2226: where
2227: attribute_scores.auction_header_id = g_auction_header_id
2228: and attribute_scores.line_number = l_line_number(x)
2229: and attribute_scores.attribute_sequence_number = l_attribute_seq_number(x);