APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_ATTRIBUTE_SCORES

Line 5529: INTO PON_ATTRIBUTE_SCORES

5525:
5526: BEGIN
5527: --{
5528: INSERT
5529: INTO PON_ATTRIBUTE_SCORES
5530: ( AUCTION_HEADER_ID,
5531: LINE_NUMBER,
5532: ATTRIBUTE_SEQUENCE_NUMBER,
5533: VALUE,

Line 5558: FROM PON_ATTRIBUTE_SCORES pas,

5554: SYSDATE, -- CREATION_DATE
5555: p_user_id, -- CREATED_BY
5556: SYSDATE, -- LAST_UPDATE_DATE
5557: p_user_id -- LAST_UPDATED_BY
5558: FROM PON_ATTRIBUTE_SCORES pas,
5559: PON_AUCTION_ATTRIBUTES paa
5560: WHERE pas.AUCTION_HEADER_ID = p_source_auction_header_id
5561: AND pas.auction_header_id = paa.auction_header_id
5562: AND pas.line_number = paa.line_number

Line 5609: INTO PON_ATTRIBUTE_SCORES

5605:
5606: IF (g_auc_doctype_rule_data.BID_RANKING = 'MULTI_ATTRIBUTE_SCORING' ) THEN
5607: --{
5608: INSERT
5609: INTO PON_ATTRIBUTE_SCORES
5610: ( AUCTION_HEADER_ID,
5611: LINE_NUMBER,
5612: ATTRIBUTE_SEQUENCE_NUMBER,
5613: VALUE,

Line 5638: FROM PON_ATTRIBUTE_SCORES pas,

5634: SYSDATE, -- CREATION_DATE
5635: p_user_id, -- CREATED_BY
5636: SYSDATE, -- LAST_UPDATE_DATE
5637: p_user_id -- LAST_UPDATED_BY
5638: FROM PON_ATTRIBUTE_SCORES pas,
5639: PON_AUCTION_ATTRIBUTES paa
5640: WHERE pas.AUCTION_HEADER_ID = p_source_auction_header_id
5641: AND pas.auction_header_id = paa.auction_header_id
5642: AND pas.line_number = paa.line_number

Line 10291: DELETE FROM pon_attribute_scores pas

10287: IF (l_contract_type in ('BLANKET', 'CONTRACT') and
10288: p_copy_type in (g_active_neg_copy, g_draft_neg_copy) and
10289: p_doctype_id <> g_rfi_doctype_id) THEN
10290:
10291: DELETE FROM pon_attribute_scores pas
10292: WHERE pas.auction_header_id = l_auction_header_id and
10293: not exists (select null
10294: from pon_auction_attributes
10295: where auction_header_id = pas.auction_header_id and

Line 12278: delete from pon_attribute_scores

12274: and ip.group_type in ('LOT', 'LOT_LINE')
12275: or p_group_enabled = 'N'
12276: and ip.group_type in ('GROUP', 'GROUP_LINE')));
12277:
12278: delete from pon_attribute_scores
12279: where auction_header_id = p_auction_header_id
12280: and line_number in
12281: (select ip.line_number
12282: from pon_auction_item_prices_all ip