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

Line 50: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

46: FUNCTION get_header_close_bidding_date
47: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE)
48: RETURN DATE
49: IS
50: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
51: v_pause_date pon_auction_headers_all.last_pause_date%TYPE;
52: v_is_paused pon_auction_headers_all.is_paused%TYPE;
53:
54: l_api_name CONSTANT VARCHAR2(30) := 'get_header_close_bidding_date';

Line 51: v_pause_date pon_auction_headers_all.last_pause_date%TYPE;

47: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE)
48: RETURN DATE
49: IS
50: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
51: v_pause_date pon_auction_headers_all.last_pause_date%TYPE;
52: v_is_paused pon_auction_headers_all.is_paused%TYPE;
53:
54: l_api_name CONSTANT VARCHAR2(30) := 'get_header_close_bidding_date';
55:

Line 52: v_is_paused pon_auction_headers_all.is_paused%TYPE;

48: RETURN DATE
49: IS
50: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
51: v_pause_date pon_auction_headers_all.last_pause_date%TYPE;
52: v_is_paused pon_auction_headers_all.is_paused%TYPE;
53:
54: l_api_name CONSTANT VARCHAR2(30) := 'get_header_close_bidding_date';
55:
56: BEGIN

Line 60: FROM pon_auction_headers_all a

56: BEGIN
57:
58: SELECT a.close_bidding_date, a.last_pause_date, a.is_paused
59: INTO v_auc_close_bidding_date, v_pause_date, v_is_paused
60: FROM pon_auction_headers_all a
61: WHERE a.auction_header_id = p_auction_header_id;
62:
63: IF v_is_paused = 'Y' THEN
64: RETURN (sysdate + (v_auc_close_bidding_date - v_pause_date));

Line 74: p_is_paused IN pon_auction_headers_all.is_paused%TYPE,

70:
71: FUNCTION get_line_close_bidding_date
72: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
73: p_line_number IN pon_bid_item_prices.line_number%TYPE,
74: p_is_paused IN pon_auction_headers_all.is_paused%TYPE,
75: p_pause_date IN pon_auction_headers_all.last_pause_date%TYPE)
76: RETURN DATE
77: IS
78: v_line_close_bidding_date pon_auction_item_prices_all.close_bidding_date%TYPE;

Line 75: p_pause_date IN pon_auction_headers_all.last_pause_date%TYPE)

71: FUNCTION get_line_close_bidding_date
72: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
73: p_line_number IN pon_bid_item_prices.line_number%TYPE,
74: p_is_paused IN pon_auction_headers_all.is_paused%TYPE,
75: p_pause_date IN pon_auction_headers_all.last_pause_date%TYPE)
76: RETURN DATE
77: IS
78: v_line_close_bidding_date pon_auction_item_prices_all.close_bidding_date%TYPE;
79: l_api_name CONSTANT VARCHAR2(30) := 'get_line_close_bidding_date';

Line 121: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

117: p_batch_id IN pon_bid_item_prices.batch_id%TYPE)
118: IS
119:
120: l_api_name CONSTANT VARCHAR2(30) := 'calculate_group_amounts';
121: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
122: v_contract_type pon_auction_headers_all.contract_type%TYPE;
123: v_doctype VARCHAR2(7);
124:
125: BEGIN

Line 122: v_contract_type pon_auction_headers_all.contract_type%TYPE;

118: IS
119:
120: l_api_name CONSTANT VARCHAR2(30) := 'calculate_group_amounts';
121: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
122: v_contract_type pon_auction_headers_all.contract_type%TYPE;
123: v_doctype VARCHAR2(7);
124:
125: BEGIN
126:

Line 142: pon_auction_headers_all paha

138: INTO v_supplier_view_type,
139: v_contract_type,
140: v_doctype
141: FROM pon_bid_headers pbh,
142: pon_auction_headers_all paha
143: WHERE pbh.bid_number = p_bid_number
144: AND paha.auction_header_id = pbh.auction_header_id;
145:
146: -- if the negotiation is an RFI or is UNtransformed, then

Line 197: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

193: p_group_amount OUT NOCOPY NUMBER)
194: IS
195:
196: l_api_name CONSTANT VARCHAR2(50) := 'calculate_group_amounts (single-line)';
197: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
198: v_contract_type pon_auction_headers_all.contract_type%TYPE;
199: v_doctype VARCHAR2(7);
200:
201: BEGIN

Line 198: v_contract_type pon_auction_headers_all.contract_type%TYPE;

194: IS
195:
196: l_api_name CONSTANT VARCHAR2(50) := 'calculate_group_amounts (single-line)';
197: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
198: v_contract_type pon_auction_headers_all.contract_type%TYPE;
199: v_doctype VARCHAR2(7);
200:
201: BEGIN
202:

Line 217: pon_auction_headers_all paha

213: INTO v_supplier_view_type,
214: v_contract_type,
215: v_doctype
216: FROM pon_bid_headers pbh,
217: pon_auction_headers_all paha
218: WHERE pbh.bid_number = p_bid_number
219: AND paha.auction_header_id = pbh.auction_header_id;
220:
221: -- if the negotiation is an RFI or is UNtransformed, then

Line 306: v_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;

302: v_rate NUMBER;
303: v_is_paused VARCHAR2(1);
304: v_paused_date DATE;
305: v_surrog_bid_flag VARCHAR2(1);
306: v_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
307: v_is_blanket VARCHAR2(1);
308: v_source_bid pon_bid_headers.old_bid_number%TYPE;
309: v_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
310:

Line 309: v_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;

305: v_surrog_bid_flag VARCHAR2(1);
306: v_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
307: v_is_blanket VARCHAR2(1);
308: v_source_bid pon_bid_headers.old_bid_number%TYPE;
309: v_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
310:
311: v_batch_start NUMBER;
312: v_batch_end NUMBER;
313: v_batch_size NUMBER;

Line 330: FROM pon_auction_headers_all a

326: decode(a.contract_type, 'BLANKET', 'Y', 'CONTRACT', 'Y', 'N'),
327: a.price_tiers_indicator
328: INTO v_is_paused, v_paused_date, v_max_line_number,
329: v_is_blanket,v_price_tiers_indicator
330: FROM pon_auction_headers_all a
331: WHERE a.auction_header_id = v_auction_header_id;
332:
333: v_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
334: v_batch_start := 1;

Line 356: PON_AUCTION_HEADERS_ALL pah

352: AND pbip.copy_price_for_proxy_flag = 'N'
353: AND ((nvl(p_powerbidlosinglines,'N') = 'Y'
354: AND pbip.line_number IN (SELECT line_number
355: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
356: PON_AUCTION_HEADERS_ALL pah
357: WHERE pah.auction_header_id = paip.auction_header_id
358: AND DECODE(pah.bid_ranking, 'MULTI_ATTRIBUTE_SCORING',paip.best_bid_bid_number,paip.best_bid_number) <> p_previous_bid_number
359: AND paip.auction_header_id = pbip.auction_header_id
360: AND paip.line_number = pbip.line_number))

Line 388: PON_AUCTION_HEADERS_ALL pah

384: AND pbip.copy_price_for_proxy_flag = 'N')
385: AND ((nvl(p_powerbidlosinglines,'N') = 'Y'
386: AND pbs.line_number IN (SELECT line_number
387: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
388: PON_AUCTION_HEADERS_ALL pah
389: WHERE pah.auction_header_id = paip.auction_header_id
390: AND DECODE(pah.bid_ranking, 'MULTI_ATTRIBUTE_SCORING',paip.best_bid_bid_number,paip.best_bid_number) <> p_previous_bid_number
391: AND paip.auction_header_id = pbs.auction_header_id
392: AND paip.line_number = pbs.line_number))

Line 412: PON_AUCTION_HEADERS_ALL pah

408: AND pbip.copy_price_for_proxy_flag = 'N')
409: AND ((nvl(p_powerbidlosinglines,'N') = 'Y'
410: AND pbs.line_number IN (SELECT line_number
411: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
412: PON_AUCTION_HEADERS_ALL pah
413: WHERE pah.auction_header_id = paip.auction_header_id
414: AND DECODE(pah.bid_ranking, 'MULTI_ATTRIBUTE_SCORING',paip.best_bid_bid_number,paip.best_bid_number) <> p_previous_bid_number
415: AND paip.auction_header_id = pbs.auction_header_id
416: AND paip.line_number = pbs.line_number))

Line 469: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

465: v_rate NUMBER;
466: v_precision NUMBER;
467: v_fnd_precision NUMBER;
468: v_display_price_factors_flag pon_bid_item_prices.display_price_factors_flag%TYPE;
469: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
470: v_contract_type pon_auction_headers_all.contract_type%TYPE;
471: v_is_spo_transformed VARCHAR(1);
472: v_auction_header_id NUMBER;
473: v_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;

Line 470: v_contract_type pon_auction_headers_all.contract_type%TYPE;

466: v_precision NUMBER;
467: v_fnd_precision NUMBER;
468: v_display_price_factors_flag pon_bid_item_prices.display_price_factors_flag%TYPE;
469: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
470: v_contract_type pon_auction_headers_all.contract_type%TYPE;
471: v_is_spo_transformed VARCHAR(1);
472: v_auction_header_id NUMBER;
473: v_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
474: v_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;

Line 473: v_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;

469: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
470: v_contract_type pon_auction_headers_all.contract_type%TYPE;
471: v_is_spo_transformed VARCHAR(1);
472: v_auction_header_id NUMBER;
473: v_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
474: v_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
475: v_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;
476: v_batch_start NUMBER;
477: v_batch_end NUMBER;

Line 474: v_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;

470: v_contract_type pon_auction_headers_all.contract_type%TYPE;
471: v_is_spo_transformed VARCHAR(1);
472: v_auction_header_id NUMBER;
473: v_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
474: v_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
475: v_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;
476: v_batch_start NUMBER;
477: v_batch_end NUMBER;
478: v_batch_size NUMBER;

Line 475: v_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;

471: v_is_spo_transformed VARCHAR(1);
472: v_auction_header_id NUMBER;
473: v_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
474: v_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
475: v_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;
476: v_batch_start NUMBER;
477: v_batch_end NUMBER;
478: v_batch_size NUMBER;
479: v_max_line_number NUMBER;

Line 510: pon_auction_headers_all paha

506: v_advance_negotiable,
507: v_max_rtng_negotiable
508: FROM pon_bid_headers pbh,
509: fnd_currencies fnd,
510: pon_auction_headers_all paha
511: WHERE pbh.bid_number = p_bid_number
512: AND paha.auction_header_id = pbh.auction_header_id
513: AND fnd.currency_code = pbh.bid_currency_code;
514:

Line 877: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

873: x_return_status OUT NOCOPY NUMBER,
874: x_return_code OUT NOCOPY VARCHAR)
875: IS
876:
877: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
878: v_group_enabled_flag pon_auction_headers_all.group_enabled_flag%TYPE;
879: v_is_paused pon_auction_headers_all.is_paused%TYPE;
880: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;
881: v_publish_date DATE;

Line 878: v_group_enabled_flag pon_auction_headers_all.group_enabled_flag%TYPE;

874: x_return_code OUT NOCOPY VARCHAR)
875: IS
876:
877: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
878: v_group_enabled_flag pon_auction_headers_all.group_enabled_flag%TYPE;
879: v_is_paused pon_auction_headers_all.is_paused%TYPE;
880: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;
881: v_publish_date DATE;
882: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;

Line 879: v_is_paused pon_auction_headers_all.is_paused%TYPE;

875: IS
876:
877: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
878: v_group_enabled_flag pon_auction_headers_all.group_enabled_flag%TYPE;
879: v_is_paused pon_auction_headers_all.is_paused%TYPE;
880: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;
881: v_publish_date DATE;
882: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
883: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

Line 882: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;

878: v_group_enabled_flag pon_auction_headers_all.group_enabled_flag%TYPE;
879: v_is_paused pon_auction_headers_all.is_paused%TYPE;
880: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;
881: v_publish_date DATE;
882: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
883: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
884: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
885: --added by Allen Yang for Surrogate Bid 2008/09/08
886: --------------------------------------------------

Line 883: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

879: v_is_paused pon_auction_headers_all.is_paused%TYPE;
880: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;
881: v_publish_date DATE;
882: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
883: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
884: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
885: --added by Allen Yang for Surrogate Bid 2008/09/08
886: --------------------------------------------------
887: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;

Line 884: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;

880: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;
881: v_publish_date DATE;
882: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
883: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
884: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
885: --added by Allen Yang for Surrogate Bid 2008/09/08
886: --------------------------------------------------
887: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
888: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;

Line 887: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;

883: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
884: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
885: --added by Allen Yang for Surrogate Bid 2008/09/08
886: --------------------------------------------------
887: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
888: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
889: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
890: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;
891: --------------------------------------------------

Line 888: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;

884: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
885: --added by Allen Yang for Surrogate Bid 2008/09/08
886: --------------------------------------------------
887: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
888: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
889: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
890: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;
891: --------------------------------------------------
892: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;

Line 937: PON_AUCTION_HEADERS_ALL paha

933: l_two_part_flag
934: , l_technical_evaluation_status
935: , l_surrogate_bid_flag
936: FROM
937: PON_AUCTION_HEADERS_ALL paha
938: , PON_BID_HEADERS pbh
939: WHERE paha.auction_header_id = pbh.auction_header_id
940: AND pbh.bid_number = p_bid_number;
941:

Line 993: FROM pon_auction_headers_all

989: SELECT close_bidding_date, group_enabled_flag,
990: max_internal_line_num, trading_partner_id, sealed_auction_status, two_part_flag
991: INTO v_auc_close_bidding_date, v_group_enabled_flag,
992: v_maxLineNumber, v_auc_tp_id, v_sealed_auction_status, v_two_part_flag
993: FROM pon_auction_headers_all
994: WHERE auction_header_id = p_auction_header_id
995: FOR UPDATE OF CLOSE_BIDDING_DATE;
996:
997: SELECT vendor_site_id, old_bid_number, surrog_bid_flag, trading_partner_contact_name

Line 1422: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,

1418: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1419: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1420: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1421: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1422: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1423: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)
1424: IS
1425:
1426: l_api_name CONSTANT VARCHAR2(30) := 'update_bid_header_fields';

Line 1423: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)

1419: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1420: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1421: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1422: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1423: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)
1424: IS
1425:
1426: l_api_name CONSTANT VARCHAR2(30) := 'update_bid_header_fields';
1427: l_tech_shortlist_flag VARCHAR2(1) := null;

Line 1460: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,

1456: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1457: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1458: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1459: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1460: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1461: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)
1462: IS
1463: PRAGMA AUTONOMOUS_TRANSACTION;
1464:

Line 1461: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)

1457: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1458: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1459: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1460: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1461: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)
1462: IS
1463: PRAGMA AUTONOMOUS_TRANSACTION;
1464:
1465: l_api_name CONSTANT VARCHAR2(30) := 'update_bid_header_fields_auto';

Line 1494: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,

1490: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1491: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1492: p_publish_date IN DATE,
1493: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1494: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
1495: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1496: p_rebid_flag IN VARCHAR,
1497: p_batch_start IN NUMBER,
1498: p_batch_end IN NUMBER)

Line 1502: v_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%TYPE;

1498: p_batch_end IN NUMBER)
1499:
1500: IS
1501:
1502: v_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%TYPE;
1503: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
1504: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
1505: v_auction_header_id NUMBER;
1506: l_api_name CONSTANT VARCHAR2(30) := 'publish_lines';

Line 1504: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;

1500: IS
1501:
1502: v_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%TYPE;
1503: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
1504: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
1505: v_auction_header_id NUMBER;
1506: l_api_name CONSTANT VARCHAR2(30) := 'publish_lines';
1507:
1508: BEGIN

Line 1561: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,

1557: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1558: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1559: p_publish_date IN DATE,
1560: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1561: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
1562: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1563: p_rebid_flag IN VARCHAR,
1564: p_max_line_number IN NUMBER,
1565: p_batch_size IN NUMBER)

Line 1939: FROM pon_auction_headers_all

1935: SELECT message_suffix
1936: INTO v_suffix
1937: FROM pon_auc_doctypes
1938: WHERE doctype_id = (SELECT doctype_id
1939: FROM pon_auction_headers_all
1940: WHERE auction_header_id = p_auction_header_id);
1941:
1942: IF p_msg_code = 'DISQ_REBID' THEN
1943: x_msg_name := 'PON_BID_DISQUALIFIED_REBID_' || v_suffix;