[Home] [Help]
4478:
4479: BEGIN
4480: --{
4481: INSERT
4482: INTO PON_ATTRIBUTE_SCORES
4483: ( AUCTION_HEADER_ID,
4484: LINE_NUMBER,
4485: ATTRIBUTE_SEQUENCE_NUMBER,
4486: VALUE,
4507: SYSDATE, -- CREATION_DATE
4508: p_user_id, -- CREATED_BY
4509: SYSDATE, -- LAST_UPDATE_DATE
4510: p_user_id -- LAST_UPDATED_BY
4511: FROM PON_ATTRIBUTE_SCORES pas,
4512: PON_AUCTION_ATTRIBUTES paa
4513: WHERE pas.AUCTION_HEADER_ID = p_source_auction_header_id
4514: AND pas.auction_header_id = paa.auction_header_id
4515: AND pas.line_number = paa.line_number
4558:
4559: IF (g_auc_doctype_rule_data.BID_RANKING = 'MULTI_ATTRIBUTE_SCORING' ) THEN
4560: --{
4561: INSERT
4562: INTO PON_ATTRIBUTE_SCORES
4563: ( AUCTION_HEADER_ID,
4564: LINE_NUMBER,
4565: ATTRIBUTE_SEQUENCE_NUMBER,
4566: VALUE,
4587: SYSDATE, -- CREATION_DATE
4588: p_user_id, -- CREATED_BY
4589: SYSDATE, -- LAST_UPDATE_DATE
4590: p_user_id -- LAST_UPDATED_BY
4591: FROM PON_ATTRIBUTE_SCORES pas,
4592: PON_AUCTION_ATTRIBUTES paa
4593: WHERE pas.AUCTION_HEADER_ID = p_source_auction_header_id
4594: AND pas.auction_header_id = paa.auction_header_id
4595: AND pas.line_number = paa.line_number
9090: IF (l_contract_type in ('BLANKET', 'CONTRACT') and
9091: p_copy_type in (g_active_neg_copy, g_draft_neg_copy) and
9092: p_doctype_id <> g_rfi_doctype_id) THEN
9093:
9094: DELETE FROM pon_attribute_scores pas
9095: WHERE pas.auction_header_id = l_auction_header_id and
9096: not exists (select null
9097: from pon_auction_attributes
9098: where auction_header_id = pas.auction_header_id and
10833: and ip.group_type in ('LOT', 'LOT_LINE')
10834: or p_group_enabled = 'N'
10835: and ip.group_type in ('GROUP', 'GROUP_LINE')));
10836:
10837: delete from pon_attribute_scores
10838: where auction_header_id = p_auction_header_id
10839: and line_number in
10840: (select ip.line_number
10841: from pon_auction_item_prices_all ip