eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_PO_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 118: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;

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);
122: x_has_attributes_flag pon_auction_item_prices_all.has_attributes_flag%TYPE;

Line 119: x_bidValue pon_bid_attribute_values.value%TYPE;

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);
122: x_has_attributes_flag pon_auction_item_prices_all.has_attributes_flag%TYPE;
123: x_msg_suffix VARCHAR2(3) := '';

Line 130: FROM pon_bid_attribute_values pbav,

126:
127: CURSOR attribute_info IS
128:
129: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)), pbav.value
130: FROM pon_bid_attribute_values pbav,
131: pon_auction_attributes paa
132: WHERE pbav.auction_header_id = p_auction_header_id and
133: pbav.bid_number = p_bid_number and
134: pbav.line_number = p_line_number and

Line 212: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;

208: p_error_code OUT NOCOPY VARCHAR2,
209: p_error_msg OUT NOCOPY VARCHAR2) IS
210:
211: x_auction_title pon_auction_headers_all.auction_title%TYPE;
212: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
213: x_bidValue pon_bid_attribute_values.value%TYPE;
214: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
215: x_attachment_title varchar2(256);
216: x_document_number varchar2(240);

Line 213: x_bidValue pon_bid_attribute_values.value%TYPE;

209: p_error_msg OUT NOCOPY VARCHAR2) IS
210:
211: x_auction_title pon_auction_headers_all.auction_title%TYPE;
212: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
213: x_bidValue pon_bid_attribute_values.value%TYPE;
214: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
215: x_attachment_title varchar2(256);
216: x_document_number varchar2(240);
217: newline varchar2(256);

Line 214: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;

210:
211: x_auction_title pon_auction_headers_all.auction_title%TYPE;
212: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
213: x_bidValue pon_bid_attribute_values.value%TYPE;
214: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
215: x_attachment_title varchar2(256);
216: x_document_number varchar2(240);
217: newline varchar2(256);
218: tab varchar2(256);

Line 225: stored in pon_bid_attribute_values after scoring has happened */

221: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
222: x_has_real_attr VARCHAR2(1);
223:
224: /* have to retrieve display only attributes separately as they are only
225: stored in pon_bid_attribute_values after scoring has happened */
226: CURSOR attribute_info IS
227:
228: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
229: pbav.value, paa.sequence_number

Line 230: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa

226: CURSOR attribute_info IS
227:
228: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
229: pbav.value, paa.sequence_number
230: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa
231: WHERE pbav.auction_header_id = p_auction_header_id and
232: pbav.bid_number = p_bid_number and
233: pbav.line_number = -1 and
234: paa.auction_header_id = pbav.auction_header_id and