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 234: p_request_id IN pon_bid_headers.request_id%TYPE,

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

Line 617: p_request_id IN pon_bid_headers.request_id%TYPE,

613: (
614: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
615: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
616: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
617: p_request_id IN pon_bid_headers.request_id%TYPE,
618: p_userid IN pon_interface_errors.created_by%TYPE,
619: p_has_pe IN VARCHAR2,
620: p_suffix IN VARCHAR2
621: ) IS

Line 625: l_surrogate_bid_flag pon_bid_headers.surrog_bid_flag%type;

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
629: --added by Allen Yang for Surrogate Bid 2008/10/27

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 959: p_request_id IN pon_bid_headers.request_id%TYPE,

955: (
956: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
957: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
958: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
959: p_request_id IN pon_bid_headers.request_id%TYPE,
960: p_userid IN pon_interface_errors.created_by%TYPE,
961: p_has_pe IN VARCHAR2,
962: p_suffix IN VARCHAR2
963: ) IS

Line 1063: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1059: PROCEDURE default_from_auction
1060: (
1061: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1062: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
1063: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1064: p_full_qty IN VARCHAR2,
1065: p_blanket IN VARCHAR2,
1066: p_auc_closed IN VARCHAR2
1067: ) IS

Line 1134: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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,
1138: p_mas IN VARCHAR2,

Line 1141: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,

1137: p_blanket IN VARCHAR2,
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);

Line 1458: UPDATE PON_BID_HEADERS pbh

1454:
1455: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
1456: --Update bid header table with Xml Spreadsheet header info
1457: BEGIN
1458: UPDATE PON_BID_HEADERS pbh
1459: SET (pbh.SURROG_BID_RECEIPT_DATE,
1460: pbh.BIDDERS_BID_NUMBER,
1461: pbh.BID_EXPIRATION_DATE,
1462: pbh.NOTE_TO_AUCTION_OWNER,

Line 1469: FROM PON_BID_HEADERS_INTERFACE pbhi

1465: pbhi.BIDDERS_BID_NUMBER,
1466: pbhi.BID_EXPIRATION_DATE,
1467: pbhi.NOTE_TO_AUCTION_OWNER,
1468: pbhi.MIN_BID_CHANGE
1469: FROM PON_BID_HEADERS_INTERFACE pbhi
1470: WHERE batch_id = p_batch_id)
1471: WHERE pbh.bid_number = p_bid_number;
1472:
1473: --Delete from header interface

Line 1474: DELETE FROM PON_BID_HEADERS_INTERFACE WHERE batch_id = p_batch_id;

1470: WHERE batch_id = p_batch_id)
1471: WHERE pbh.bid_number = p_bid_number;
1472:
1473: --Delete from header interface
1474: DELETE FROM PON_BID_HEADERS_INTERFACE WHERE batch_id = p_batch_id;
1475:
1476: -- Copy payments to transaction tables
1477: IF p_progress_payment_type <> 'NONE' THEN
1478: PON_VALIDATE_PAYMENTS_INT.COPY_PAYMENTS_FROM_INT_TO_TXN(p_batch_id,

Line 1519: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

1515:
1516: PROCEDURE create_url_attachments
1517: (
1518: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1519: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1521: p_userid IN pon_bid_headers.created_by%TYPE
1522: ) IS
1523: l_seq_num NUMBER;

Line 1520: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1516: PROCEDURE create_url_attachments
1517: (
1518: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1519: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
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'

Line 1521: p_userid IN pon_bid_headers.created_by%TYPE

1517: (
1518: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1519: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
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';

Line 1588: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1584:
1585: PROCEDURE process_spreadsheet_data
1586: (
1587: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1588: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1589: p_request_id IN pon_bid_headers.request_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

Line 1589: p_request_id IN pon_bid_headers.request_id%TYPE,

1585: PROCEDURE process_spreadsheet_data
1586: (
1587: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1588: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1589: p_request_id IN pon_bid_headers.request_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

Line 1607: l_price_precision pon_bid_headers.number_price_decimals%TYPE;

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
1611: SELECT sysdate + g_exp_days_offset,

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 1733: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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

Line 2086: FROM PON_BID_HEADERS_INTERFACE pbhi,

2082: pah.close_bidding_date s_close_bidding_date,
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

Line 2088: PON_BID_HEADERS pbh

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
2092: AND pah.auction_header_id = pbh.auction_header_id;

Line 2100: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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: )
2104: IS

Line 2192: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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,
2196: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,

Line 2193: p_request_id IN pon_bid_headers.request_id%TYPE,

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

Line 2418: p_request_id IN pon_bid_headers.request_id%TYPE,

2414: PROCEDURE remove_xml_skipped_lines
2415: (
2416: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
2417: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2418: p_request_id IN pon_bid_headers.request_id%TYPE,
2419: p_userid IN pon_interface_errors.created_by%TYPE,
2420: p_full_qty IN VARCHAR2,
2421: p_buyer_user IN VARCHAR2,
2422: p_suffix IN VARCHAR2

Line 2895: p_bid_number IN pon_bid_headers.bid_number%TYPE,

2891:
2892: PROCEDURE copy_shipment_interface_to_txn
2893: (
2894: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2895: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2896: p_userid IN pon_bid_item_prices.last_updated_by%TYPE,
2897: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
2898: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE
2899: )

Line 2897: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,

2893: (
2894: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2895: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2896: p_userid IN pon_bid_item_prices.last_updated_by%TYPE,
2897: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
2898: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE
2899: )
2900: is
2901: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';

Line 3256: p_bid_number IN pon_bid_headers.bid_number%TYPE,

3252:
3253: PROCEDURE process_xml_spreadsheet_data
3254: (
3255: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3256: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3257: p_request_id IN pon_bid_headers.request_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

Line 3257: p_request_id IN pon_bid_headers.request_id%TYPE,

3253: PROCEDURE process_xml_spreadsheet_data
3254: (
3255: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3256: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3257: p_request_id IN pon_bid_headers.request_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

Line 3277: l_price_precision pon_bid_headers.number_price_decimals%TYPE;

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:
3281: SELECT sysdate + g_exp_days_offset,

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

Line 3414: p_bid_number IN pon_bid_headers.bid_number%TYPE,

3410: (
3411: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3412: --bug 16654950
3413: p_transaction_id IN po_uda_interface.transaction_id%TYPE,
3414: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3415: p_request_id IN pon_bid_headers.request_id%TYPE,
3416: p_userid IN pon_interface_errors.created_by%TYPE,
3417: x_return_status OUT NOCOPY VARCHAR2
3418: )

Line 3415: p_request_id IN pon_bid_headers.request_id%TYPE,

3411: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3412: --bug 16654950
3413: p_transaction_id IN po_uda_interface.transaction_id%TYPE,
3414: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3415: p_request_id IN pon_bid_headers.request_id%TYPE,
3416: p_userid IN pon_interface_errors.created_by%TYPE,
3417: x_return_status OUT NOCOPY VARCHAR2
3418: )
3419: Is

Line 3424: l_template_id pon_bid_headers.uda_template_id%TYPE;

3420: po_uda_array PO_UDA_USAGE_OBJECT_ARRAY := PO_UDA_USAGE_OBJECT_ARRAY();
3421: ego_value_pairs_table ego_col_name_value_pair_table ;
3422: -- attr_group_id_table PO_TBL_NUMBER;
3423: ego_value_obj ego_col_name_value_pair_obj;
3424: l_template_id pon_bid_headers.uda_template_id%TYPE;
3425: l_uda_data_present BOOLEAN;
3426: msgData varchar2(240);
3427: msgCount Number;
3428: l_errorcode Number;