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_AUC_DOCTYPES

Line 124: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

120: newline varchar2(256);
121: tab varchar2(256);
122: x_has_attributes_flag pon_auction_item_prices_all.has_attributes_flag%TYPE;
123: x_msg_suffix VARCHAR2(3) := '';
124: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
125: x_has_real_attr VARCHAR2(1);
126:
127: CURSOR attribute_info IS
128:

Line 152: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

148: p_error_msg := '';
149:
150: SELECT dt.doctype_group_name
151: INTO x_doctype_group_name
152: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
153: WHERE auh.auction_header_id = p_auction_header_id and
154: auh.doctype_id = dt.doctype_id;
155:
156: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 221: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

217: newline varchar2(256);
218: tab varchar2(256);
219: x_has_attributes_flag pon_auction_headers_all.has_hdr_attr_flag%TYPE;
220: x_msg_suffix VARCHAR2(3) := '';
221: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
222: x_has_real_attr VARCHAR2(1);
223:
224: /* have to retrieve display only attributes separately as they are only
225: stored in pon_bid_attribute_values after scoring has happened */

Line 258: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

254: p_error_msg := '';
255:
256: SELECT dt.doctype_group_name
257: INTO x_doctype_group_name
258: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
259: WHERE auh.auction_header_id = p_auction_header_id and
260: auh.doctype_id = dt.doctype_id;
261:
262: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 326: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

322: line_note pon_bid_item_prices.note_to_auction_owner%TYPE;
323: msgBidHeaderNote varchar2(2000);
324: msgBidLineNote varchar2(2000);
325: x_msg_suffix VARCHAR2(3) := '';
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;

Line 335: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

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
336: WHERE auh.auction_header_id = p_auction_header_id and
337: auh.doctype_id = dt.doctype_id;
338:
339: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 396: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

392: line_note pon_auction_item_prices_all.note_to_bidders%TYPE;
393: msgNegHeaderNote varchar2(2000);
394: msgNegLineNote varchar2(2000);
395: x_msg_suffix VARCHAR2(3) := '';
396: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
397: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
398:
399: BEGIN
400: p_attachment := null;

Line 410: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

406: p_error_msg := '';
407:
408: SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')
409: INTO x_doctype_group_name, l_contract_type
410: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
411: WHERE auh.auction_header_id = p_auction_header_id and
412: auh.doctype_id = dt.doctype_id;
413:
414: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 478: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

474: x_price_element_name pon_price_element_types_tl.name%TYPE;
475: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
476: x_pricing_basis_display varchar2(2000);
477: x_msg_suffix VARCHAR2(3) := '';
478: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
479:
480: CURSOR total_cost_info IS
481:
482: SELECT ppet.name,

Line 510: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

506: p_error_msg := '';
507:
508: SELECT dt.doctype_group_name
509: INTO x_doctype_group_name
510: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
511: WHERE auh.auction_header_id = p_auction_header_id and
512: auh.doctype_id = dt.doctype_id;
513:
514: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 564: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

560:
561: newline varchar2(256);
562: tab varchar2(256);
563: job_details pon_auction_item_prices_all.additional_job_details%TYPE;
564: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
565: x_msg_suffix VARCHAR2(3) := '';
566:
567: BEGIN
568: p_attachment := null;

Line 574: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

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
575: WHERE auh.auction_header_id = p_auction_header_id and
576: auh.doctype_id = dt.doctype_id;
577:
578: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);