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 138: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;

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

Line 139: x_bidValue pon_bid_attribute_values.value%TYPE;

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

Line 150: FROM pon_bid_attribute_values pbav,

146:
147: CURSOR attribute_info IS
148:
149: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)), pbav.value
150: FROM pon_bid_attribute_values pbav,
151: pon_auction_attributes paa
152: WHERE pbav.auction_header_id = p_auction_header_id and
153: pbav.bid_number = p_bid_number and
154: pbav.line_number = p_line_number and

Line 250: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;

246: p_error_code OUT NOCOPY VARCHAR2,
247: p_error_msg OUT NOCOPY VARCHAR2) IS
248:
249: x_auction_title pon_auction_headers_all.auction_title%TYPE;
250: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
251: x_bidValue pon_bid_attribute_values.value%TYPE;
252: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
253: x_attachment_title varchar2(256);
254: x_document_number varchar2(240);

Line 251: x_bidValue pon_bid_attribute_values.value%TYPE;

247: p_error_msg OUT NOCOPY VARCHAR2) IS
248:
249: x_auction_title pon_auction_headers_all.auction_title%TYPE;
250: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
251: x_bidValue pon_bid_attribute_values.value%TYPE;
252: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
253: x_attachment_title varchar2(256);
254: x_document_number varchar2(240);
255: newline varchar2(256);

Line 252: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;

248:
249: x_auction_title pon_auction_headers_all.auction_title%TYPE;
250: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
251: x_bidValue pon_bid_attribute_values.value%TYPE;
252: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
253: x_attachment_title varchar2(256);
254: x_document_number varchar2(240);
255: newline varchar2(256);
256: tab varchar2(256);

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

259: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
260: x_has_real_attr VARCHAR2(1);
261:
262: /* have to retrieve display only attributes separately as they are only
263: stored in pon_bid_attribute_values after scoring has happened */
264: CURSOR attribute_info IS
265:
266: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
267: pbav.value, paa.sequence_number

Line 268: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa

264: CURSOR attribute_info IS
265:
266: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
267: pbav.value, paa.sequence_number
268: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa
269: WHERE pbav.auction_header_id = p_auction_header_id and
270: pbav.bid_number = p_bid_number and
271: pbav.line_number = -1 and
272: paa.auction_header_id = pbav.auction_header_id and

Line 350: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;

346: p_error_code OUT NOCOPY VARCHAR2,
347: p_error_msg OUT NOCOPY VARCHAR2) IS
348:
349: x_auction_title pon_auction_headers_all.auction_title%TYPE;
350: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
351: x_bidValue pon_bid_attribute_values.value%TYPE;
352: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
353: x_attachment_title varchar2(256);
354: x_document_number varchar2(240);

Line 351: x_bidValue pon_bid_attribute_values.value%TYPE;

347: p_error_msg OUT NOCOPY VARCHAR2) IS
348:
349: x_auction_title pon_auction_headers_all.auction_title%TYPE;
350: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
351: x_bidValue pon_bid_attribute_values.value%TYPE;
352: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
353: x_attachment_title varchar2(256);
354: x_document_number varchar2(240);
355: newline varchar2(256);

Line 352: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;

348:
349: x_auction_title pon_auction_headers_all.auction_title%TYPE;
350: x_attribute_name pon_bid_attribute_values.attribute_name%TYPE;
351: x_bidValue pon_bid_attribute_values.value%TYPE;
352: x_sequenceNumber pon_bid_attribute_values.sequence_number%TYPE;
353: x_attachment_title varchar2(256);
354: x_document_number varchar2(240);
355: newline varchar2(256);
356: tab varchar2(256);

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

359: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
360: x_has_real_attr VARCHAR2(1);
361:
362: /* have to retrieve display only attributes separately as they are only
363: stored in pon_bid_attribute_values after scoring has happened */
364: CURSOR attribute_info IS
365:
366: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
367: pbav.value, paa.sequence_number

Line 368: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa

364: CURSOR attribute_info IS
365:
366: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
367: pbav.value, paa.sequence_number
368: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa
369: WHERE pbav.auction_header_id = p_auction_header_id and
370: pbav.bid_number = p_bid_number and
371: pbav.line_number = -1 and
372: paa.auction_header_id = pbav.auction_header_id and