[Home] [Help]
133: p_attachment OUT NOCOPY LONG,
134: p_error_code OUT NOCOPY VARCHAR2,
135: p_error_msg OUT NOCOPY VARCHAR2) IS
136:
137: x_item_description pon_auction_item_prices_all.item_description%TYPE;
138: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
139: x_bidValue pon_bid_attribute_values.value%TYPE;
140: newline varchar2(256);
141: tab varchar2(256);
138: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
139: x_bidValue pon_bid_attribute_values.value%TYPE;
140: newline varchar2(256);
141: tab varchar2(256);
142: x_has_attributes_flag pon_auction_item_prices_all.has_attributes_flag%TYPE;
143: x_msg_suffix VARCHAR2(3) := '';
144: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
145: x_has_real_attr VARCHAR2(1);
146:
178: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_ATTR_ATTACH_DESC', x_msg_suffix);
179:
180: SELECT item_description, has_attributes_flag
181: INTO x_item_description, x_has_attributes_flag
182: FROM pon_auction_item_prices_all
183: WHERE auction_header_id = p_auction_header_id and
184: line_number = p_line_number;
185:
186: IF (x_has_attributes_flag = 'N') THEN
215: p_attachment := null;
216: END IF;
217:
218: EXCEPTION
219: /* Unsolicited Lines Project : sql on pon_auction_item_prices_all table
220: * throws no data exception for unsolicited lines.
221: */
222: WHEN No_Data_Found THEN
223: p_error_code := 'SUCCESS';
520:
521: newline varchar2(256);
522: tab varchar2(256);
523: header_note pon_auction_headers_all.note_to_bidders%TYPE;
524: line_note pon_auction_item_prices_all.note_to_bidders%TYPE;
525: msgNegHeaderNote varchar2(2000);
526: msgNegLineNote varchar2(2000);
527: x_msg_suffix VARCHAR2(3) := '';
528: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
549:
550: IF l_contract_type <> 'CONTRACT' THEN
551: SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13)), replace(paip.note_to_bidders, fnd_global.local_chr(13))
552: INTO header_note, line_note
553: FROM pon_auction_headers_all pah, pon_auction_item_prices_all paip
554: WHERE pah.auction_header_id = p_auction_header_id and
555: paip.auction_header_id = pah.auction_header_id and
556: paip.line_number = p_line_number;
557: ELSE
581: END IF;
582: END IF;
583:
584: EXCEPTION
585: /* Unsolicited Lines Project : sql on pon_auction_item_prices_all table
586: * throws no data exception for unsolicited lines.
587: */
588: WHEN No_Data_Found THEN
589: p_error_code := 'SUCCESS';
606: p_error_msg OUT NOCOPY VARCHAR2) IS
607:
608: newline varchar2(256);
609: tab varchar2(256);
610: x_item_description pon_auction_item_prices_all.item_description%TYPE;
611: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;
612: x_price_element_name pon_price_element_types_tl.name%TYPE;
613: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
614: x_negative_cost_factor_flag pon_bid_price_elements.NEGATIVE_COST_FACTOR_FLAG%TYPE;
607:
608: newline varchar2(256);
609: tab varchar2(256);
610: x_item_description pon_auction_item_prices_all.item_description%TYPE;
611: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;
612: x_price_element_name pon_price_element_types_tl.name%TYPE;
613: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
614: x_negative_cost_factor_flag pon_bid_price_elements.NEGATIVE_COST_FACTOR_FLAG%TYPE;
615: x_pricing_basis_display varchar2(2000);
656: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_TOTAL_COST_DESC', x_msg_suffix);
657:
658: SELECT item_description, has_price_elements_flag
659: INTO x_item_description, x_has_price_elements_flag
660: FROM pon_auction_item_prices_all
661: WHERE auction_header_id = p_auction_header_id and
662: line_number = p_line_number;
663:
664: IF (x_has_price_elements_flag = 'N') THEN
684: END LOOP;
685: CLOSE total_cost_info;
686:
687: EXCEPTION
688: /* Unsolicited Lines Project : sql on pon_auction_item_prices_all table
689: * throws no data exception for unsolicited lines.
690: */
691: WHEN No_Data_Found THEN
692: p_error_code := 'SUCCESS';
715: p_error_msg OUT NOCOPY VARCHAR2) IS
716:
717: newline varchar2(256);
718: tab varchar2(256);
719: job_details pon_auction_item_prices_all.additional_job_details%TYPE;
720: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
721: x_msg_suffix VARCHAR2(3) := '';
722:
723: BEGIN
740: p_error_msg := '';
741:
742: SELECT replace(paip.additional_job_details, fnd_global.local_chr(13))
743: INTO job_details
744: FROM pon_auction_item_prices_all paip
745: WHERE paip.auction_header_id = p_auction_header_id and
746: paip.line_number = p_line_number;
747:
748: p_attachment := job_details;
747:
748: p_attachment := job_details;
749:
750: EXCEPTION
751: /* Unsolicited Lines Project : sql on pon_auction_item_prices_all table
752: * throws no data exception for unsolicited lines.
753: */
754: WHEN No_Data_Found THEN
755: p_error_code := 'SUCCESS';