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 129: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)), pbav.value

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

Line 145: newline := fnd_global.newline;

141:
142:
143: BEGIN
144: p_attachment := null;
145: newline := fnd_global.newline;
146: tab := fnd_global.tab;
147: p_error_code := 'SUCCESS';
148: p_error_msg := '';
149:

Line 146: tab := fnd_global.tab;

142:
143: BEGIN
144: p_attachment := null;
145: newline := fnd_global.newline;
146: tab := fnd_global.tab;
147: p_error_code := 'SUCCESS';
148: p_error_msg := '';
149:
150: SELECT dt.doctype_group_name

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

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

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

236: paa.sequence_number = pbav.sequence_number and
237: nvl(paa.internal_attr_flag, 'N') = 'N' and
238: nvl(paa.display_only_flag, 'N') = 'N'
239: UNION
240: SELECT replace(paa.attribute_name, fnd_global.local_chr(13)),
241: paa.value, paa.sequence_number
242: FROM pon_auction_attributes paa
243: WHERE paa.auction_header_id = p_auction_header_id and
244: paa.line_number = -1 and

Line 251: newline := fnd_global.newline;

247:
248:
249: BEGIN
250: p_attachment := null;
251: newline := fnd_global.newline;
252: tab := fnd_global.tab;
253: p_error_code := 'SUCCESS';
254: p_error_msg := '';
255:

Line 252: tab := fnd_global.tab;

248:
249: BEGIN
250: p_attachment := null;
251: newline := fnd_global.newline;
252: tab := fnd_global.tab;
253: p_error_code := 'SUCCESS';
254: p_error_msg := '';
255:
256: SELECT dt.doctype_group_name

Line 330: newline := fnd_global.newline;

326: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
327: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
328: BEGIN
329: p_attachment := null;
330: newline := fnd_global.newline;
331: tab := fnd_global.tab;
332:
333: SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')
334: INTO x_doctype_group_name, l_contract_type

Line 331: tab := fnd_global.tab;

327: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
328: BEGIN
329: p_attachment := null;
330: newline := fnd_global.newline;
331: tab := fnd_global.tab;
332:
333: SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')
334: INTO x_doctype_group_name, l_contract_type
335: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

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

345: p_error_code := 'SUCCESS';
346: p_error_msg := '';
347:
348: IF l_contract_type <> 'CONTRACT' THEN
349: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13)), replace(pbip.note_to_auction_owner, fnd_global.local_chr(13))
350: INTO header_note, line_note
351: FROM pon_bid_headers pbh, pon_bid_item_prices pbip
352: WHERE pbh.auction_header_id = p_auction_header_id and
353: pbh.bid_number = p_bid_number and

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

353: pbh.bid_number = p_bid_number and
354: pbip.bid_number = pbh.bid_number and
355: pbip.line_number = p_line_number;
356: ELSE
357: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13))
358: INTO header_note
359: FROM pon_bid_headers pbh
360: WHERE pbh.auction_header_id = p_auction_header_id and
361: pbh.bid_number = p_bid_number;

Line 401: newline := fnd_global.newline;

397: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
398:
399: BEGIN
400: p_attachment := null;
401: newline := fnd_global.newline;
402: tab := fnd_global.tab;
403: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');
404: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');
405: p_error_code := 'SUCCESS';

Line 402: tab := fnd_global.tab;

398:
399: BEGIN
400: p_attachment := null;
401: newline := fnd_global.newline;
402: tab := fnd_global.tab;
403: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');
404: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');
405: p_error_code := 'SUCCESS';
406: p_error_msg := '';

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

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

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

423: paip.auction_header_id = pah.auction_header_id and
424: paip.line_number = p_line_number;
425: ELSE
426:
427: SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13))
428: INTO header_note
429: FROM pon_auction_headers_all pah
430: WHERE pah.auction_header_id = p_auction_header_id;
431:

Line 502: newline := fnd_global.newline;

498: ORDER BY sequence_number;
499:
500: BEGIN
501: p_attachment := null;
502: newline := fnd_global.newline;
503: tab := fnd_global.tab;
504:
505: p_error_code := 'SUCCESS';
506: p_error_msg := '';

Line 503: tab := fnd_global.tab;

499:
500: BEGIN
501: p_attachment := null;
502: newline := fnd_global.newline;
503: tab := fnd_global.tab;
504:
505: p_error_code := 'SUCCESS';
506: p_error_msg := '';
507:

Line 569: newline := fnd_global.newline;

565: x_msg_suffix VARCHAR2(3) := '';
566:
567: BEGIN
568: p_attachment := null;
569: newline := fnd_global.newline;
570: tab := fnd_global.tab;
571:
572: SELECT dt.doctype_group_name
573: INTO x_doctype_group_name

Line 570: tab := fnd_global.tab;

566:
567: BEGIN
568: p_attachment := null;
569: newline := fnd_global.newline;
570: tab := fnd_global.tab;
571:
572: SELECT dt.doctype_group_name
573: INTO x_doctype_group_name
574: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

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

582:
583: p_error_code := 'SUCCESS';
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;

Line 618: newline := fnd_global.newline;

614: msgNegPymntNote varchar2(2000);
615:
616: BEGIN
617: p_attachment := null;
618: newline := fnd_global.newline;
619: tab := fnd_global.tab;
620: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');
621: p_error_code := 'SUCCESS';
622: p_error_msg := '';

Line 619: tab := fnd_global.tab;

615:
616: BEGIN
617: p_attachment := null;
618: newline := fnd_global.newline;
619: tab := fnd_global.tab;
620: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');
621: p_error_code := 'SUCCESS';
622: p_error_msg := '';
623:

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

622: p_error_msg := '';
623:
624: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_PYMNT_NOTE_SUPP_DESC');
625:
626: SELECT replace(pys.note_to_bidders, fnd_global.local_chr(13))
627: INTO pymt_note
628: FROM pon_auc_payments_shipments pys
629: WHERE payment_id= p_auction_payment_id;
630: