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_AUCTION_HEADERS_ALL

Line 58: FROM pon_bid_headers pbh, pon_auction_headers_all pah

54: x_number_of_pos := 0;
55:
56: SELECT count(*)
57: INTO x_number_of_pos
58: FROM pon_bid_headers pbh, pon_auction_headers_all pah
59: WHERE pbh.order_number = po_number and
60: nvl(pah.org_id, -9999) = nvl(org_id,-9999) and
61: pbh.auction_header_id = pah.auction_header_id and
62: pbh.bid_number <> nvl(p_bid_number, -1);

Line 172: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

168: p_error_msg := '';
169:
170: SELECT dt.doctype_group_name
171: INTO x_doctype_group_name
172: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
173: WHERE auh.auction_header_id = p_auction_header_id and
174: auh.doctype_id = dt.doctype_id;
175:
176: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 249: x_auction_title pon_auction_headers_all.auction_title%TYPE;

245: p_attachment OUT NOCOPY LONG,
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);

Line 257: x_has_attributes_flag pon_auction_headers_all.has_hdr_attr_flag%TYPE;

253: x_attachment_title varchar2(256);
254: x_document_number varchar2(240);
255: newline varchar2(256);
256: tab varchar2(256);
257: x_has_attributes_flag pon_auction_headers_all.has_hdr_attr_flag%TYPE;
258: x_msg_suffix VARCHAR2(3) := '';
259: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
260: x_has_real_attr VARCHAR2(1);
261:

Line 296: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

292: p_error_msg := '';
293:
294: SELECT dt.doctype_group_name
295: INTO x_doctype_group_name
296: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
297: WHERE auh.auction_header_id = p_auction_header_id and
298: auh.doctype_id = dt.doctype_id;
299:
300: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 306: FROM pon_auction_headers_all

302: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);
303:
304: SELECT auction_title, document_number, has_hdr_attr_flag
305: INTO x_auction_title, x_document_number, x_has_attributes_flag
306: FROM pon_auction_headers_all
307: WHERE auction_header_id = p_auction_header_id;
308:
309: IF (x_has_attributes_flag = 'N') THEN
310: p_attachment := null;

Line 349: x_auction_title pon_auction_headers_all.auction_title%TYPE;

345: p_attachment OUT NOCOPY CLOB,
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);

Line 357: x_has_attributes_flag pon_auction_headers_all.has_hdr_attr_flag%TYPE;

353: x_attachment_title varchar2(256);
354: x_document_number varchar2(240);
355: newline varchar2(256);
356: tab varchar2(256);
357: x_has_attributes_flag pon_auction_headers_all.has_hdr_attr_flag%TYPE;
358: x_msg_suffix VARCHAR2(3) := '';
359: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
360: x_has_real_attr VARCHAR2(1);
361:

Line 396: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

392: p_error_msg := '';
393:
394: SELECT dt.doctype_group_name
395: INTO x_doctype_group_name
396: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
397: WHERE auh.auction_header_id = p_auction_header_id and
398: auh.doctype_id = dt.doctype_id;
399:
400: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 406: FROM pon_auction_headers_all

402: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);
403:
404: SELECT auction_title, document_number, has_hdr_attr_flag
405: INTO x_auction_title, x_document_number, x_has_attributes_flag
406: FROM pon_auction_headers_all
407: WHERE auction_header_id = p_auction_header_id;
408:
409: IF (x_has_attributes_flag = 'N') THEN
410: p_attachment := null;

Line 459: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;

455: msgBidHeaderNote varchar2(2000);
456: msgBidLineNote varchar2(2000);
457: x_msg_suffix VARCHAR2(3) := '';
458: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
459: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
460: BEGIN
461: p_attachment := null;
462: newline := fnd_global.newline;
463: tab := fnd_global.tab;

Line 467: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

463: tab := fnd_global.tab;
464:
465: SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')
466: INTO x_doctype_group_name, l_contract_type
467: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
468: WHERE auh.auction_header_id = p_auction_header_id and
469: auh.doctype_id = dt.doctype_id;
470:
471: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 523: header_note pon_auction_headers_all.note_to_bidders%TYPE;

519: p_line_or_header IN VARCHAR2) IS
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) := '';

Line 529: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%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;
529: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
530:
531: BEGIN
532: p_attachment := null;
533: newline := fnd_global.newline;

Line 542: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

538: p_error_msg := '';
539:
540: SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')
541: INTO x_doctype_group_name, l_contract_type
542: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
543: WHERE auh.auction_header_id = p_auction_header_id and
544: auh.doctype_id = dt.doctype_id;
545:
546: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 553: FROM pon_auction_headers_all pah, pon_auction_item_prices_all paip

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

Line 561: FROM pon_auction_headers_all pah

557: ELSE
558:
559: SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13))
560: INTO header_note
561: FROM pon_auction_headers_all pah
562: WHERE pah.auction_header_id = p_auction_header_id;
563:
564: END IF;
565:

Line 650: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

646: p_error_msg := '';
647:
648: SELECT dt.doctype_group_name
649: INTO x_doctype_group_name
650: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
651: WHERE auh.auction_header_id = p_auction_header_id and
652: auh.doctype_id = dt.doctype_id;
653:
654: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 730: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

726: tab := fnd_global.tab;
727:
728: SELECT dt.doctype_group_name
729: INTO x_doctype_group_name
730: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
731: WHERE auh.auction_header_id = p_auction_header_id and
732: auh.doctype_id = dt.doctype_id;
733:
734: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);