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.

[Home] [Help]

APPS.PON_AUCTION_PO_PKG dependencies on PON_AUC_DOCTYPES

Line 144: x_doctype_group_name pon_auc_doctypes.doctype_group_name%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) := '';
144: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
145: x_has_real_attr VARCHAR2(1);
146:
147: CURSOR attribute_info IS
148:

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 259: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

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:
262: /* have to retrieve display only attributes separately as they are only
263: stored in pon_bid_attribute_values after scoring has happened */

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 359: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

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:
362: /* have to retrieve display only attributes separately as they are only
363: stored in pon_bid_attribute_values after scoring has happened */

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 458: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

454: line_note pon_bid_item_prices.note_to_auction_owner%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;

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 528: x_doctype_group_name pon_auc_doctypes.doctype_group_name%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) := '';
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;

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 617: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

613: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
614: x_negative_cost_factor_flag pon_bid_price_elements.NEGATIVE_COST_FACTOR_FLAG%TYPE;
615: x_pricing_basis_display varchar2(2000);
616: x_msg_suffix VARCHAR2(3) := '';
617: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
618:
619: CURSOR total_cost_info IS
620:
621: SELECT ppet.name,

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 720: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

716:
717: newline varchar2(256);
718: tab varchar2(256);
719: job_details pon_auction_item_prices_all.additional_job_details%TYPE;
720: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
721: x_msg_suffix VARCHAR2(3) := '';
722:
723: BEGIN
724: p_attachment := null;

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