[Home] [Help]
216: LINE_NUMBER
217: INTO
218: l_line_number
219: FROM
220: PON_PRICE_ELEMENTS
221: WHERE
222: AUCTION_HEADER_ID = p_auction_header_id AND
223: (PRICING_BASIS = 'FIXED_AMOUNT' OR PRICING_BASIS = 'PER_UNIT') AND
224: ROWNUM = 1;
291: INTO
292: l_line_number
293: FROM
294: PON_AUCTION_ITEM_PRICES_ALL PAIP,
295: PON_PRICE_ELEMENTS PPE
296: WHERE
297: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
298: PPE.AUCTION_HEADER_ID = p_auction_header_id AND
299: PAIP.LINE_NUMBER = PPE.LINE_NUMBER AND
729: 'Y'
730: INTO
731: x_has_price_elements
732: FROM
733: pon_price_elements
734: WHERE
735: auction_header_id = p_auction_header_id AND
736: rownum = 1;
737:
799: 'Y'
800: INTO
801: x_has_supplier_price_elements
802: FROM
803: pon_price_elements
804: WHERE
805: auction_header_id = p_auction_header_id AND
806: pf_type = 'SUPPLIER' AND
807: rownum = 1;
870: 'Y'
871: INTO
872: x_has_buyer_price_elements
873: FROM
874: pon_price_elements
875: WHERE
876: auction_header_id = p_auction_header_id AND
877: pf_type = 'BUYER' AND
878: rownum = 1;
964: supplier_seq_number,value,creation_date,created_by,last_update_date,last_updated_by,last_update_login)
965: select distinct PPE.auction_header_id,PPE.price_element_type_id,PPE.pricing_basis,
966: PBP.sequence,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id
967: from
968: PON_PRICE_ELEMENTS PPE, PON_BIDDING_PARTIES PBP
969: where
970: PPE.auction_header_id = p_auction_header_id and
971: PBP.auction_header_id = p_auction_header_id and
972: PPE.line_number = p_line_number and
995: auction_header_id = p_auction_header_id and
996: not exists (
997: select PPE.price_element_type_id,PPE.pricing_basis
998: from
999: PON_PRICE_ELEMENTS PPE
1000: where auction_header_id = p_auction_header_id
1001: and PPE.price_element_type_id = pf_values.price_element_type_id
1002: and PPE.pricing_basis = pf_values.pricing_basis
1003: and PPE.pf_type = 'BUYER'
1128:
1129: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1130: FND_LOG.string (log_level => FND_LOG.level_statement,
1131: module => g_module_prefix || l_module_name,
1132: message => 'adding the price factors with the help of PON_PRICE_ELEMENTS'
1133: );
1134: END IF;
1135:
1136: insert into PON_LARGE_NEG_PF_VALUES (auction_header_id,price_element_type_id,pricing_basis,
1137: supplier_seq_number,value,creation_date,created_by,last_update_date,last_updated_by,last_update_login)
1138: select distinct auction_header_id,price_element_type_id,pricing_basis,
1139: p_supplier_seq_num,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id
1140: from
1141: PON_PRICE_ELEMENTS
1142: where
1143: auction_header_id = p_auction_header_id and
1144: pf_type = 'BUYER';
1145:
1556: IF (l_pf_type_allowed <> 'NONE') THEN --{
1557:
1558: -- Delete the price elements
1559: DELETE FROM
1560: pon_price_elements
1561: WHERE
1562: auction_header_id = p_auction_header_id AND
1563: line_number >= l_batch_start AND
1564: line_number <= l_batch_end;
2053: message => 'Deleted the entry in pon_pf_supplier_values');
2054: END IF;
2055:
2056: DELETE FROM
2057: pon_price_elements
2058: WHERE
2059: auction_header_id = p_auction_header_id AND
2060: line_number = p_line_number;
2061:
2061:
2062: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2063: FND_LOG.string (log_level => FND_LOG.level_statement,
2064: module => g_module_prefix || l_module_name,
2065: message => 'Deleted the entry in pon_price_elements');
2066: END IF;
2067:
2068: DELETE FROM
2069: pon_price_differentials
2418:
2419: -- Delete the cost factors that belong to this
2420: -- lot/group and also its children
2421: DELETE FROM
2422: pon_price_elements ppe
2423: WHERE
2424: ppe.auction_header_id = p_auction_header_id AND
2425: (
2426: ppe.line_number = p_line_number OR