APPS.PON_AUCTION_PO_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 117: x_item_description pon_auction_item_prices_all.item_description%TYPE;

113: p_attachment OUT NOCOPY LONG,
114: p_error_code OUT NOCOPY VARCHAR2,
115: p_error_msg OUT NOCOPY VARCHAR2) IS
116:
117: x_item_description pon_auction_item_prices_all.item_description%TYPE;
118: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
119: x_bidValue pon_bid_attribute_values.value%TYPE;
120: newline varchar2(256);
121: tab varchar2(256);

Line 122: x_has_attributes_flag pon_auction_item_prices_all.has_attributes_flag%TYPE;

118: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
119: x_bidValue pon_bid_attribute_values.value%TYPE;
120: newline varchar2(256);
121: tab varchar2(256);
122: x_has_attributes_flag pon_auction_item_prices_all.has_attributes_flag%TYPE;
123: x_msg_suffix VARCHAR2(3) := '';
124: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
125: x_has_real_attr VARCHAR2(1);
126:

Line 162: FROM pon_auction_item_prices_all

158: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_ATTR_ATTACH_DESC', x_msg_suffix);
159:
160: SELECT item_description, has_attributes_flag
161: INTO x_item_description, x_has_attributes_flag
162: FROM pon_auction_item_prices_all
163: WHERE auction_header_id = p_auction_header_id and
164: line_number = p_line_number;
165:
166: IF (x_has_attributes_flag = 'N') THEN

Line 392: line_note pon_auction_item_prices_all.note_to_bidders%TYPE;

388:
389: newline varchar2(256);
390: tab varchar2(256);
391: header_note pon_auction_headers_all.note_to_bidders%TYPE;
392: line_note pon_auction_item_prices_all.note_to_bidders%TYPE;
393: msgNegHeaderNote varchar2(2000);
394: msgNegLineNote varchar2(2000);
395: x_msg_suffix VARCHAR2(3) := '';
396: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

Line 421: FROM pon_auction_headers_all pah, pon_auction_item_prices_all paip

417:
418: IF l_contract_type <> 'CONTRACT' THEN
419: SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13)), replace(paip.note_to_bidders, fnd_global.local_chr(13))
420: INTO header_note, line_note
421: FROM pon_auction_headers_all pah, pon_auction_item_prices_all paip
422: WHERE pah.auction_header_id = p_auction_header_id and
423: paip.auction_header_id = pah.auction_header_id and
424: paip.line_number = p_line_number;
425: ELSE

Line 472: x_item_description pon_auction_item_prices_all.item_description%TYPE;

468: p_error_msg OUT NOCOPY VARCHAR2) IS
469:
470: newline varchar2(256);
471: tab varchar2(256);
472: x_item_description pon_auction_item_prices_all.item_description%TYPE;
473: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;
474: x_price_element_name pon_price_element_types_tl.name%TYPE;
475: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
476: x_pricing_basis_display varchar2(2000);

Line 473: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;

469:
470: newline varchar2(256);
471: tab varchar2(256);
472: x_item_description pon_auction_item_prices_all.item_description%TYPE;
473: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;
474: x_price_element_name pon_price_element_types_tl.name%TYPE;
475: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
476: x_pricing_basis_display varchar2(2000);
477: x_msg_suffix VARCHAR2(3) := '';

Line 520: FROM pon_auction_item_prices_all

516: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_TOTAL_COST_DESC', x_msg_suffix);
517:
518: SELECT item_description, has_price_elements_flag
519: INTO x_item_description, x_has_price_elements_flag
520: FROM pon_auction_item_prices_all
521: WHERE auction_header_id = p_auction_header_id and
522: line_number = p_line_number;
523:
524: IF (x_has_price_elements_flag = 'N') THEN

Line 563: job_details pon_auction_item_prices_all.additional_job_details%TYPE;

559: p_error_msg OUT NOCOPY VARCHAR2) IS
560:
561: newline varchar2(256);
562: tab varchar2(256);
563: job_details pon_auction_item_prices_all.additional_job_details%TYPE;
564: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
565: x_msg_suffix VARCHAR2(3) := '';
566:
567: BEGIN

Line 588: FROM pon_auction_item_prices_all paip

584: p_error_msg := '';
585:
586: SELECT replace(paip.additional_job_details, fnd_global.local_chr(13))
587: INTO job_details
588: FROM pon_auction_item_prices_all paip
589: WHERE paip.auction_header_id = p_auction_header_id and
590: paip.line_number = p_line_number;
591:
592: p_attachment := job_details;