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 FND_GLOBAL

Line 149: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)), pbav.value

145: x_has_real_attr VARCHAR2(1);
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

Line 165: newline := fnd_global.newline;

161:
162:
163: BEGIN
164: p_attachment := null;
165: newline := fnd_global.newline;
166: tab := fnd_global.tab;
167: p_error_code := 'SUCCESS';
168: p_error_msg := '';
169:

Line 166: tab := fnd_global.tab;

162:
163: BEGIN
164: p_attachment := null;
165: newline := fnd_global.newline;
166: tab := fnd_global.tab;
167: p_error_code := 'SUCCESS';
168: p_error_msg := '';
169:
170: SELECT dt.doctype_group_name

Line 266: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),

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
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

Line 278: SELECT replace(paa.attribute_name, fnd_global.local_chr(13)),

274: paa.sequence_number = pbav.sequence_number and
275: nvl(paa.internal_attr_flag, 'N') = 'N' and
276: nvl(paa.display_only_flag, 'N') = 'N'
277: UNION
278: SELECT replace(paa.attribute_name, fnd_global.local_chr(13)),
279: paa.value, paa.sequence_number
280: FROM pon_auction_attributes paa
281: WHERE paa.auction_header_id = p_auction_header_id and
282: paa.line_number = -1 and

Line 289: newline := fnd_global.newline;

285:
286:
287: BEGIN
288: p_attachment := null;
289: newline := fnd_global.newline;
290: tab := fnd_global.tab;
291: p_error_code := 'SUCCESS';
292: p_error_msg := '';
293:

Line 290: tab := fnd_global.tab;

286:
287: BEGIN
288: p_attachment := null;
289: newline := fnd_global.newline;
290: tab := fnd_global.tab;
291: p_error_code := 'SUCCESS';
292: p_error_msg := '';
293:
294: SELECT dt.doctype_group_name

Line 366: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),

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
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

Line 378: SELECT replace(paa.attribute_name, fnd_global.local_chr(13)),

374: paa.sequence_number = pbav.sequence_number and
375: nvl(paa.internal_attr_flag, 'N') = 'N' and
376: nvl(paa.display_only_flag, 'N') = 'N'
377: UNION
378: SELECT replace(paa.attribute_name, fnd_global.local_chr(13)),
379: paa.value, paa.sequence_number
380: FROM pon_auction_attributes paa
381: WHERE paa.auction_header_id = p_auction_header_id and
382: paa.line_number = -1 and

Line 389: newline := fnd_global.newline;

385:
386:
387: BEGIN
388: p_attachment := null;
389: newline := fnd_global.newline;
390: tab := fnd_global.tab;
391: p_error_code := 'SUCCESS';
392: p_error_msg := '';
393:

Line 390: tab := fnd_global.tab;

386:
387: BEGIN
388: p_attachment := null;
389: newline := fnd_global.newline;
390: tab := fnd_global.tab;
391: p_error_code := 'SUCCESS';
392: p_error_msg := '';
393:
394: SELECT dt.doctype_group_name

Line 462: newline := fnd_global.newline;

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;
464:
465: SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')
466: INTO x_doctype_group_name, l_contract_type

Line 463: tab := fnd_global.tab;

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;
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

Line 481: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13)), replace(pbip.note_to_auction_owner, fnd_global.local_chr(13))

477: p_error_code := 'SUCCESS';
478: p_error_msg := '';
479:
480: IF l_contract_type <> 'CONTRACT' THEN
481: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13)), replace(pbip.note_to_auction_owner, fnd_global.local_chr(13))
482: INTO header_note, line_note
483: FROM pon_bid_headers pbh, pon_bid_item_prices pbip
484: WHERE pbh.auction_header_id = p_auction_header_id and
485: pbh.bid_number = p_bid_number and

Line 489: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13))

485: pbh.bid_number = p_bid_number and
486: pbip.bid_number = pbh.bid_number and
487: pbip.line_number = p_line_number;
488: ELSE
489: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13))
490: INTO header_note
491: FROM pon_bid_headers pbh
492: WHERE pbh.auction_header_id = p_auction_header_id and
493: pbh.bid_number = p_bid_number;

Line 533: newline := fnd_global.newline;

529: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
530:
531: BEGIN
532: p_attachment := null;
533: newline := fnd_global.newline;
534: tab := fnd_global.tab;
535: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');
536: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');
537: p_error_code := 'SUCCESS';

Line 534: tab := fnd_global.tab;

530:
531: BEGIN
532: p_attachment := null;
533: newline := fnd_global.newline;
534: tab := fnd_global.tab;
535: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');
536: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');
537: p_error_code := 'SUCCESS';
538: p_error_msg := '';

Line 551: SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13)), replace(paip.note_to_bidders, fnd_global.local_chr(13))

547:
548: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_SUPP_DESC', x_msg_suffix);
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

Line 559: SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13))

555: paip.auction_header_id = pah.auction_header_id and
556: paip.line_number = p_line_number;
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:

Line 642: newline := fnd_global.newline;

638: ORDER BY sequence_number;
639:
640: BEGIN
641: p_attachment := null;
642: newline := fnd_global.newline;
643: tab := fnd_global.tab;
644:
645: p_error_code := 'SUCCESS';
646: p_error_msg := '';

Line 643: tab := fnd_global.tab;

639:
640: BEGIN
641: p_attachment := null;
642: newline := fnd_global.newline;
643: tab := fnd_global.tab;
644:
645: p_error_code := 'SUCCESS';
646: p_error_msg := '';
647:

Line 725: newline := fnd_global.newline;

721: x_msg_suffix VARCHAR2(3) := '';
722:
723: BEGIN
724: p_attachment := null;
725: newline := fnd_global.newline;
726: tab := fnd_global.tab;
727:
728: SELECT dt.doctype_group_name
729: INTO x_doctype_group_name

Line 726: tab := fnd_global.tab;

722:
723: BEGIN
724: p_attachment := null;
725: newline := fnd_global.newline;
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

Line 742: SELECT replace(paip.additional_job_details, fnd_global.local_chr(13))

738:
739: p_error_code := 'SUCCESS';
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;

Line 780: newline := fnd_global.newline;

776: msgNegPymntNote varchar2(2000);
777:
778: BEGIN
779: p_attachment := null;
780: newline := fnd_global.newline;
781: tab := fnd_global.tab;
782: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');
783: p_error_code := 'SUCCESS';
784: p_error_msg := '';

Line 781: tab := fnd_global.tab;

777:
778: BEGIN
779: p_attachment := null;
780: newline := fnd_global.newline;
781: tab := fnd_global.tab;
782: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');
783: p_error_code := 'SUCCESS';
784: p_error_msg := '';
785:

Line 788: SELECT replace(pys.note_to_bidders, fnd_global.local_chr(13))

784: p_error_msg := '';
785:
786: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_PYMNT_NOTE_SUPP_DESC');
787:
788: SELECT replace(pys.note_to_bidders, fnd_global.local_chr(13))
789: INTO pymt_note
790: FROM pon_auc_payments_shipments pys
791: WHERE payment_id= p_auction_payment_id;
792: