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_BID_HEADERS

Line 87: p_request_id IN pon_bid_headers.request_id%TYPE,

83: PROCEDURE validate_close_bidding_date
84: (
85: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
86: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
87: p_request_id IN pon_bid_headers.request_id%TYPE,
88: p_userid IN pon_interface_errors.created_by%TYPE,
89: p_suffix IN VARCHAR2
90: ) IS
91: l_is_paused VARCHAR2(1);

Line 232: p_request_id IN pon_bid_headers.request_id%TYPE,

228: PROCEDURE remove_invalid_skipped_lines
229: (
230: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
231: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
232: p_request_id IN pon_bid_headers.request_id%TYPE,
233: p_userid IN pon_interface_errors.created_by%TYPE,
234: p_full_qty IN VARCHAR2,
235: p_buyer_user IN VARCHAR2,
236: p_suffix IN VARCHAR2

Line 540: p_request_id IN pon_bid_headers.request_id%TYPE,

536: (
537: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
538: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
539: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
540: p_request_id IN pon_bid_headers.request_id%TYPE,
541: p_userid IN pon_interface_errors.created_by%TYPE,
542: p_has_pe IN VARCHAR2,
543: p_suffix IN VARCHAR2
544: ) IS

Line 548: l_surrogate_bid_flag pon_bid_headers.surrog_bid_flag%type;

544: ) IS
545: --added by Allen Yang for Surrogate Bid 2008/10/27
546: --------------------------------------------------
547: l_two_part_flag pon_auction_headers_all.two_part_flag%type;
548: l_surrogate_bid_flag pon_bid_headers.surrog_bid_flag%type;
549: l_tech_evaluation_status pon_auction_headers_all.technical_evaluation_status%type;
550: --------------------------------------------------
551: BEGIN
552: --added by Allen Yang for Surrogate Bid 2008/10/27

Line 562: FROM pon_bid_headers pbh, pon_auction_headers_all paha

558: INTO
559: l_two_part_flag,
560: l_tech_evaluation_status,
561: l_surrogate_bid_flag
562: FROM pon_bid_headers pbh, pon_auction_headers_all paha
563: WHERE pbh.bid_number = p_bid_number
564: AND paha.auction_header_id = pbh.auction_header_id;
565: --------------------------------------------------
566:

Line 880: p_bid_number IN pon_bid_headers.bid_number%TYPE,

876: PROCEDURE default_from_auction
877: (
878: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
879: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
880: p_bid_number IN pon_bid_headers.bid_number%TYPE,
881: p_full_qty IN VARCHAR2,
882: p_blanket IN VARCHAR2,
883: p_auc_closed IN VARCHAR2
884: ) IS

Line 951: p_bid_number IN pon_bid_headers.bid_number%TYPE,

947: PROCEDURE copy_interface_to_txn_tables
948: (
949: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
950: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
951: p_bid_number IN pon_bid_headers.bid_number%TYPE,
952: p_userid IN pon_bid_item_prices.last_updated_by%TYPE,
953: p_hdr_disp_pf IN VARCHAR2,
954: p_blanket IN VARCHAR2,
955: p_mas IN VARCHAR2,

Line 958: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,

954: p_blanket IN VARCHAR2,
955: p_mas IN VARCHAR2,
956: p_progress_payment_type IN VARCHAR2,
957: p_spreadsheet_type IN VARCHAR2,
958: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
959: p_price_tiers_indicator IN pon_auction_headers_all.PRICE_TIERS_INDICATOR%type
960: ) IS
961: l_module CONSTANT VARCHAR2(32) := 'copy_interface_to_txn_tables';
962: l_result VARCHAR2(1);

Line 1259: UPDATE PON_BID_HEADERS pbh

1255:
1256: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
1257: --Update bid header table with Xml Spreadsheet header info
1258: BEGIN
1259: UPDATE PON_BID_HEADERS pbh
1260: SET (pbh.SURROG_BID_RECEIPT_DATE,
1261: pbh.BIDDERS_BID_NUMBER,
1262: pbh.BID_EXPIRATION_DATE,
1263: pbh.NOTE_TO_AUCTION_OWNER,

Line 1270: FROM PON_BID_HEADERS_INTERFACE pbhi

1266: pbhi.BIDDERS_BID_NUMBER,
1267: pbhi.BID_EXPIRATION_DATE,
1268: pbhi.NOTE_TO_AUCTION_OWNER,
1269: pbhi.MIN_BID_CHANGE
1270: FROM PON_BID_HEADERS_INTERFACE pbhi
1271: WHERE batch_id = p_batch_id)
1272: WHERE pbh.bid_number = p_bid_number;
1273:
1274: --Delete from header interface

Line 1275: DELETE FROM PON_BID_HEADERS_INTERFACE WHERE batch_id = p_batch_id;

1271: WHERE batch_id = p_batch_id)
1272: WHERE pbh.bid_number = p_bid_number;
1273:
1274: --Delete from header interface
1275: DELETE FROM PON_BID_HEADERS_INTERFACE WHERE batch_id = p_batch_id;
1276:
1277: -- Copy payments to transaction tables
1278: IF p_progress_payment_type <> 'NONE' THEN
1279: PON_VALIDATE_PAYMENTS_INT.COPY_PAYMENTS_FROM_INT_TO_TXN(p_batch_id,

Line 1320: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

1316:
1317: PROCEDURE create_url_attachments
1318: (
1319: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1320: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1321: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1322: p_userid IN pon_bid_headers.created_by%TYPE
1323: ) IS
1324: l_seq_num NUMBER;

Line 1321: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1317: PROCEDURE create_url_attachments
1318: (
1319: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1320: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1321: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1322: p_userid IN pon_bid_headers.created_by%TYPE
1323: ) IS
1324: l_seq_num NUMBER;
1325: l_target_category FND_DOCUMENT_CATEGORIES.NAME%type := pon_auction_pkg.g_supplier_attachment; -- target attachment category, default 'FromSupplier'

Line 1322: p_userid IN pon_bid_headers.created_by%TYPE

1318: (
1319: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1320: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1321: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1322: p_userid IN pon_bid_headers.created_by%TYPE
1323: ) IS
1324: l_seq_num NUMBER;
1325: l_target_category FND_DOCUMENT_CATEGORIES.NAME%type := pon_auction_pkg.g_supplier_attachment; -- target attachment category, default 'FromSupplier'
1326: l_two_part_flag PON_AUCTION_HEADERS_ALL.TWO_PART_FLAG%type := 'N';

Line 1385: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1381:
1382: PROCEDURE process_spreadsheet_data
1383: (
1384: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1385: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1386: p_request_id IN pon_bid_headers.request_id%TYPE,
1387: p_userid IN pon_interface_errors.created_by%TYPE,
1388: x_return_status OUT NOCOPY VARCHAR2,
1389: x_return_code OUT NOCOPY VARCHAR2

Line 1386: p_request_id IN pon_bid_headers.request_id%TYPE,

1382: PROCEDURE process_spreadsheet_data
1383: (
1384: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1385: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1386: p_request_id IN pon_bid_headers.request_id%TYPE,
1387: p_userid IN pon_interface_errors.created_by%TYPE,
1388: x_return_status OUT NOCOPY VARCHAR2,
1389: x_return_code OUT NOCOPY VARCHAR2
1390: ) IS

Line 1404: l_price_precision pon_bid_headers.number_price_decimals%TYPE;

1400: l_has_pe VARCHAR2(1);
1401:
1402: l_suffix VARCHAR2(2);
1403: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
1404: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
1405: BEGIN
1406:
1407: -- Determine some negotiation flags
1408: SELECT sysdate + g_exp_days_offset,

Line 1432: FROM pon_bid_headers bh, pon_auction_headers_all ah

1428: l_supplier_user,
1429: l_has_pe,
1430: l_progress_payment_type,
1431: l_price_precision
1432: FROM pon_bid_headers bh, pon_auction_headers_all ah
1433: WHERE bh.bid_number = p_bid_number
1434: AND ah.auction_header_id = bh.auction_header_id;
1435:
1436: l_suffix := PON_LARGE_AUCTION_UTIL_PKG.get_doctype_suffix(l_auc_header_id);

Line 1520: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1516: PROCEDURE VALIDATE_HEADER
1517: (
1518: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1519: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1521: p_request_id IN pon_bid_item_prices.request_id%TYPE,
1522: p_user_id IN pon_interface_errors.created_by%TYPE
1523: ) IS
1524:

Line 1873: FROM PON_BID_HEADERS_INTERFACE pbhi,

1869: pah.close_bidding_date s_close_bidding_date,
1870: pbh.old_surrog_bid_receipt_date s_old_response_recvd_time,
1871: pbh.surrog_bid_flag s_surrogate_bid_flag,
1872: pbh.number_price_decimals s_bid_price_precision
1873: FROM PON_BID_HEADERS_INTERFACE pbhi,
1874: PON_AUCTION_HEADERS_ALL pah,
1875: PON_BID_HEADERS pbh
1876: WHERE pbhi.batch_id = p_batch_id
1877: AND pbhi.bid_number = p_bid_number

Line 1875: PON_BID_HEADERS pbh

1871: pbh.surrog_bid_flag s_surrogate_bid_flag,
1872: pbh.number_price_decimals s_bid_price_precision
1873: FROM PON_BID_HEADERS_INTERFACE pbhi,
1874: PON_AUCTION_HEADERS_ALL pah,
1875: PON_BID_HEADERS pbh
1876: WHERE pbhi.batch_id = p_batch_id
1877: AND pbhi.bid_number = p_bid_number
1878: AND pbh.bid_number = pbhi.bid_number
1879: AND pah.auction_header_id = pbh.auction_header_id;

Line 1887: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1883: PROCEDURE validate_xml_price_breaks
1884: (
1885: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1886: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1887: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1888: p_request_id IN pon_bid_item_prices.request_id%TYPE,
1889: p_user_id IN pon_interface_errors.created_by%TYPE
1890: )
1891: IS

Line 1979: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1975: PROCEDURE VALIDATE_XML
1976: (
1977: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1978: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1979: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1980: p_request_id IN pon_bid_headers.request_id%TYPE,
1981: p_user_id IN pon_bid_item_prices.last_updated_by%TYPE,
1982: p_suffix IN VARCHAR2,
1983: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,

Line 1980: p_request_id IN pon_bid_headers.request_id%TYPE,

1976: (
1977: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1978: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1979: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1980: p_request_id IN pon_bid_headers.request_id%TYPE,
1981: p_user_id IN pon_bid_item_prices.last_updated_by%TYPE,
1982: p_suffix IN VARCHAR2,
1983: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,
1984: l_attr_enabled_flag IN pon_auction_headers_all.line_attribute_enabled_flag%TYPE,

Line 2205: p_request_id IN pon_bid_headers.request_id%TYPE,

2201: PROCEDURE remove_xml_skipped_lines
2202: (
2203: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
2204: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2205: p_request_id IN pon_bid_headers.request_id%TYPE,
2206: p_userid IN pon_interface_errors.created_by%TYPE,
2207: p_full_qty IN VARCHAR2,
2208: p_buyer_user IN VARCHAR2,
2209: p_suffix IN VARCHAR2

Line 2682: p_bid_number IN pon_bid_headers.bid_number%TYPE,

2678:
2679: PROCEDURE copy_shipment_interface_to_txn
2680: (
2681: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2682: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2683: p_userid IN pon_bid_item_prices.last_updated_by%TYPE,
2684: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
2685: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE
2686: )

Line 2684: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,

2680: (
2681: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2682: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2683: p_userid IN pon_bid_item_prices.last_updated_by%TYPE,
2684: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
2685: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE
2686: )
2687: is
2688: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';

Line 3043: p_bid_number IN pon_bid_headers.bid_number%TYPE,

3039:
3040: PROCEDURE process_xml_spreadsheet_data
3041: (
3042: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3043: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3044: p_request_id IN pon_bid_headers.request_id%TYPE,
3045: p_user_id IN pon_interface_errors.created_by%TYPE,
3046: x_return_status OUT NOCOPY NUMBER,
3047: x_return_code OUT NOCOPY VARCHAR2

Line 3044: p_request_id IN pon_bid_headers.request_id%TYPE,

3040: PROCEDURE process_xml_spreadsheet_data
3041: (
3042: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3043: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3044: p_request_id IN pon_bid_headers.request_id%TYPE,
3045: p_user_id IN pon_interface_errors.created_by%TYPE,
3046: x_return_status OUT NOCOPY NUMBER,
3047: x_return_code OUT NOCOPY VARCHAR2
3048: ) IS

Line 3064: l_price_precision pon_bid_headers.number_price_decimals%TYPE;

3060: l_req_enabled_flag VARCHAR2(1);
3061: l_has_hdr_attr_flag VARCHAR2(1);
3062: l_suffix VARCHAR2(2);
3063: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
3064: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
3065: l_price_tiers_indicator pon_auction_headers_all.PRICE_TIERS_INDICATOR%TYPE;
3066: BEGIN
3067:
3068: SELECT sysdate + g_exp_days_offset,

Line 3100: FROM pon_bid_headers bh, pon_auction_headers_all ah

3096: l_buyer_user,
3097: l_supplier_user,
3098: l_has_pe,
3099: l_price_tiers_indicator
3100: FROM pon_bid_headers bh, pon_auction_headers_all ah
3101: WHERE bh.bid_number = p_bid_number
3102: AND ah.auction_header_id = bh.auction_header_id;
3103:
3104: l_suffix := PON_LARGE_AUCTION_UTIL_PKG.get_doctype_suffix(l_auc_header_id);