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_RESPONSE_IMPORT_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 100: FROM pon_auction_headers_all ah

96: -- line_number correctly set for lines
97:
98: SELECT nvl(ah.is_paused, 'N'), ah.last_pause_date
99: INTO l_is_paused, l_paused_date
100: FROM pon_auction_headers_all ah
101: WHERE ah.auction_header_id = p_auc_header_id;
102:
103: -- Flag all lines with expired close bidding dates
104: UPDATE pon_bid_item_prices_interface bli

Line 249: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auc_header_id;

245:
246: -- Determine whether clm (Federal) is enabled
247: BEGIN
248:
249: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auc_header_id;
250:
251: SELECT
252: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
253: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

Line 624: l_two_part_flag pon_auction_headers_all.two_part_flag%type;

620: p_suffix IN VARCHAR2
621: ) IS
622: --added by Allen Yang for Surrogate Bid 2008/10/27
623: --------------------------------------------------
624: l_two_part_flag pon_auction_headers_all.two_part_flag%type;
625: l_surrogate_bid_flag pon_bid_headers.surrog_bid_flag%type;
626: l_tech_evaluation_status pon_auction_headers_all.technical_evaluation_status%type;
627: --------------------------------------------------
628: BEGIN

Line 626: l_tech_evaluation_status pon_auction_headers_all.technical_evaluation_status%type;

622: --added by Allen Yang for Surrogate Bid 2008/10/27
623: --------------------------------------------------
624: l_two_part_flag pon_auction_headers_all.two_part_flag%type;
625: l_surrogate_bid_flag pon_bid_headers.surrog_bid_flag%type;
626: l_tech_evaluation_status pon_auction_headers_all.technical_evaluation_status%type;
627: --------------------------------------------------
628: BEGIN
629: --added by Allen Yang for Surrogate Bid 2008/10/27
630: --------------------------------------------------

Line 639: FROM pon_bid_headers pbh, pon_auction_headers_all paha

635: INTO
636: l_two_part_flag,
637: l_tech_evaluation_status,
638: l_surrogate_bid_flag
639: FROM pon_bid_headers pbh, pon_auction_headers_all paha
640: WHERE pbh.bid_number = p_bid_number
641: AND paha.auction_header_id = pbh.auction_header_id;
642: --------------------------------------------------
643:

Line 1133: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1129:
1130: PROCEDURE copy_interface_to_txn_tables
1131: (
1132: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1133: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1134: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1135: p_userid IN pon_bid_item_prices.last_updated_by%TYPE,
1136: p_hdr_disp_pf IN VARCHAR2,
1137: p_blanket IN VARCHAR2,

Line 1142: p_price_tiers_indicator IN pon_auction_headers_all.PRICE_TIERS_INDICATOR%type

1138: p_mas IN VARCHAR2,
1139: p_progress_payment_type IN VARCHAR2,
1140: p_spreadsheet_type IN VARCHAR2,
1141: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
1142: p_price_tiers_indicator IN pon_auction_headers_all.PRICE_TIERS_INDICATOR%type
1143: ) IS
1144: l_module CONSTANT VARCHAR2(32) := 'copy_interface_to_txn_tables';
1145: l_result VARCHAR2(1);
1146: l_error_code VARCHAR2(200);

Line 1185: pon_auction_headers_all pah

1181: pah.recoupment_negotiable_flag,
1182: pbip.worksheet_name,
1183: pbip.worksheet_sequence_number
1184: FROM pon_bid_item_prices_interface pbip,
1185: pon_auction_headers_all pah
1186: WHERE batch_id = p_batch_id
1187: AND pah.auction_header_id = pbip.auction_header_id) bli
1188: ON (bl.bid_number = bli.bid_number
1189: AND bl.line_number = bli.line_number

Line 1525: l_two_part_flag PON_AUCTION_HEADERS_ALL.TWO_PART_FLAG%type := 'N';

1521: p_userid IN pon_bid_headers.created_by%TYPE
1522: ) IS
1523: l_seq_num NUMBER;
1524: l_target_category FND_DOCUMENT_CATEGORIES.NAME%type := pon_auction_pkg.g_supplier_attachment; -- target attachment category, default 'FromSupplier'
1525: l_two_part_flag PON_AUCTION_HEADERS_ALL.TWO_PART_FLAG%type := 'N';
1526:
1527: CURSOR attachment_lines IS
1528: SELECT bli.attachment_url,
1529: bli.attachment_desc,

Line 1543: from pon_auction_headers_all

1539: BEGIN
1540: -- get two_part_flag for RFQ
1541: select nvl(two_part_flag, 'N')
1542: into l_two_part_flag
1543: from pon_auction_headers_all
1544: where auction_header_id = p_auc_header_id;
1545:
1546: -- change target attachment category for two-part RFQ.
1547: IF l_two_part_flag = 'Y' THEN -- {

Line 1594: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;

1590: p_userid IN pon_interface_errors.created_by%TYPE,
1591: x_return_status OUT NOCOPY VARCHAR2,
1592: x_return_code OUT NOCOPY VARCHAR2
1593: ) IS
1594: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
1595:
1596: l_header_disp_pf VARCHAR2(1);
1597: l_blanket VARCHAR2(1);
1598: l_mas VARCHAR2(1);

Line 1606: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;

1602: l_supplier_user VARCHAR2(1);
1603: l_has_pe VARCHAR2(1);
1604:
1605: l_suffix VARCHAR2(2);
1606: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
1607: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
1608: BEGIN
1609:
1610: -- Determine some negotiation flags

Line 1635: FROM pon_bid_headers bh, pon_auction_headers_all ah

1631: l_supplier_user,
1632: l_has_pe,
1633: l_progress_payment_type,
1634: l_price_precision
1635: FROM pon_bid_headers bh, pon_auction_headers_all ah
1636: WHERE bh.bid_number = p_bid_number
1637: AND ah.auction_header_id = bh.auction_header_id;
1638:
1639: l_suffix := PON_LARGE_AUCTION_UTIL_PKG.get_doctype_suffix(l_auc_header_id);

Line 1732: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1728:
1729: PROCEDURE VALIDATE_HEADER
1730: (
1731: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1732: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1733: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1734: p_request_id IN pon_bid_item_prices.request_id%TYPE,
1735: p_user_id IN pon_interface_errors.created_by%TYPE
1736: ) IS

Line 2087: PON_AUCTION_HEADERS_ALL pah,

2083: pbh.old_surrog_bid_receipt_date s_old_response_recvd_time,
2084: pbh.surrog_bid_flag s_surrogate_bid_flag,
2085: pbh.number_price_decimals s_bid_price_precision
2086: FROM PON_BID_HEADERS_INTERFACE pbhi,
2087: PON_AUCTION_HEADERS_ALL pah,
2088: PON_BID_HEADERS pbh
2089: WHERE pbhi.batch_id = p_batch_id
2090: AND pbhi.bid_number = p_bid_number
2091: AND pbh.bid_number = pbhi.bid_number

Line 2099: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2095:
2096: PROCEDURE validate_xml_price_breaks
2097: (
2098: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2099: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2100: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2101: p_request_id IN pon_bid_item_prices.request_id%TYPE,
2102: p_user_id IN pon_interface_errors.created_by%TYPE
2103: )

Line 2191: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2187:
2188: PROCEDURE VALIDATE_XML
2189: (
2190: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2191: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2192: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2193: p_request_id IN pon_bid_headers.request_id%TYPE,
2194: p_user_id IN pon_bid_item_prices.last_updated_by%TYPE,
2195: p_suffix IN VARCHAR2,

Line 2197: l_attr_enabled_flag IN pon_auction_headers_all.line_attribute_enabled_flag%TYPE,

2193: p_request_id IN pon_bid_headers.request_id%TYPE,
2194: p_user_id IN pon_bid_item_prices.last_updated_by%TYPE,
2195: p_suffix IN VARCHAR2,
2196: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,
2197: l_attr_enabled_flag IN pon_auction_headers_all.line_attribute_enabled_flag%TYPE,
2198: l_req_enabled_flag IN pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,
2199: l_has_hdr_attr_flag IN pon_auction_headers_all.has_hdr_attr_flag%TYPE,
2200: p_progress_payment_type IN pon_auction_headers_all.progress_payment_type%TYPE,
2201: p_blanket IN varchar2,

Line 2198: l_req_enabled_flag IN pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,

2194: p_user_id IN pon_bid_item_prices.last_updated_by%TYPE,
2195: p_suffix IN VARCHAR2,
2196: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,
2197: l_attr_enabled_flag IN pon_auction_headers_all.line_attribute_enabled_flag%TYPE,
2198: l_req_enabled_flag IN pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,
2199: l_has_hdr_attr_flag IN pon_auction_headers_all.has_hdr_attr_flag%TYPE,
2200: p_progress_payment_type IN pon_auction_headers_all.progress_payment_type%TYPE,
2201: p_blanket IN varchar2,
2202: p_price_tiers_indicator IN pon_auction_headers_all.PRICE_TIERS_INDICATOR%type

Line 2199: l_has_hdr_attr_flag IN pon_auction_headers_all.has_hdr_attr_flag%TYPE,

2195: p_suffix IN VARCHAR2,
2196: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,
2197: l_attr_enabled_flag IN pon_auction_headers_all.line_attribute_enabled_flag%TYPE,
2198: l_req_enabled_flag IN pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,
2199: l_has_hdr_attr_flag IN pon_auction_headers_all.has_hdr_attr_flag%TYPE,
2200: p_progress_payment_type IN pon_auction_headers_all.progress_payment_type%TYPE,
2201: p_blanket IN varchar2,
2202: p_price_tiers_indicator IN pon_auction_headers_all.PRICE_TIERS_INDICATOR%type
2203: ) IS

Line 2200: p_progress_payment_type IN pon_auction_headers_all.progress_payment_type%TYPE,

2196: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,
2197: l_attr_enabled_flag IN pon_auction_headers_all.line_attribute_enabled_flag%TYPE,
2198: l_req_enabled_flag IN pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,
2199: l_has_hdr_attr_flag IN pon_auction_headers_all.has_hdr_attr_flag%TYPE,
2200: p_progress_payment_type IN pon_auction_headers_all.progress_payment_type%TYPE,
2201: p_blanket IN varchar2,
2202: p_price_tiers_indicator IN pon_auction_headers_all.PRICE_TIERS_INDICATOR%type
2203: ) IS
2204: BEGIN

Line 2202: p_price_tiers_indicator IN pon_auction_headers_all.PRICE_TIERS_INDICATOR%type

2198: l_req_enabled_flag IN pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,
2199: l_has_hdr_attr_flag IN pon_auction_headers_all.has_hdr_attr_flag%TYPE,
2200: p_progress_payment_type IN pon_auction_headers_all.progress_payment_type%TYPE,
2201: p_blanket IN varchar2,
2202: p_price_tiers_indicator IN pon_auction_headers_all.PRICE_TIERS_INDICATOR%type
2203: ) IS
2204: BEGIN
2205:
2206: --Validate header fields

Line 3262: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;

3258: p_user_id IN pon_interface_errors.created_by%TYPE,
3259: x_return_status OUT NOCOPY NUMBER,
3260: x_return_code OUT NOCOPY VARCHAR2
3261: ) IS
3262: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3263:
3264: l_header_disp_pf VARCHAR2(1);
3265: l_blanket VARCHAR2(1);
3266: l_mas VARCHAR2(1);

Line 3276: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;

3272: l_attr_enabled_flag VARCHAR2(1);
3273: l_req_enabled_flag VARCHAR2(1);
3274: l_has_hdr_attr_flag VARCHAR2(1);
3275: l_suffix VARCHAR2(2);
3276: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
3277: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
3278: l_price_tiers_indicator pon_auction_headers_all.PRICE_TIERS_INDICATOR%TYPE;
3279: BEGIN
3280:

Line 3278: l_price_tiers_indicator pon_auction_headers_all.PRICE_TIERS_INDICATOR%TYPE;

3274: l_has_hdr_attr_flag VARCHAR2(1);
3275: l_suffix VARCHAR2(2);
3276: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
3277: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
3278: l_price_tiers_indicator pon_auction_headers_all.PRICE_TIERS_INDICATOR%TYPE;
3279: BEGIN
3280:
3281: SELECT sysdate + g_exp_days_offset,
3282: ah.auction_header_id,

Line 3313: FROM pon_bid_headers bh, pon_auction_headers_all ah

3309: l_buyer_user,
3310: l_supplier_user,
3311: l_has_pe,
3312: l_price_tiers_indicator
3313: FROM pon_bid_headers bh, pon_auction_headers_all ah
3314: WHERE bh.bid_number = p_bid_number
3315: AND ah.auction_header_id = bh.auction_header_id;
3316:
3317: l_suffix := PON_LARGE_AUCTION_UTIL_PKG.get_doctype_suffix(l_auc_header_id);