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_BID_HEADERS

Line 47: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE)

43: -- paused
44: -- -------------------------------------------------------------------------
45:
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;

Line 72: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

68:
69: END get_header_close_bidding_date;
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

Line 141: FROM pon_bid_headers pbh,

137: DECODE(paha.doctype_id, 21, 'RFI', 5, 'RFQ', 1, 'AUCTION') document_type
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:

Line 216: FROM pon_bid_headers pbh,

212: DECODE(paha.doctype_id, 21, 'RFI', 5, 'RFQ', 1, 'AUCTION')
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:

Line 298: p_previous_bid_number IN pon_bid_headers.old_bid_number%TYPE)

294: PROCEDURE change_bid_by_percentage
295: (p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
296: p_power_percentage IN NUMBER,
297: p_powerbidlosinglines IN VARCHAR2,
298: p_previous_bid_number IN pon_bid_headers.old_bid_number%TYPE)
299: IS
300:
301: v_precision NUMBER;
302: v_rate NUMBER;

Line 308: v_source_bid pon_bid_headers.old_bid_number%TYPE;

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:
311: v_batch_start NUMBER;
312: v_batch_end NUMBER;

Line 322: FROM pon_bid_headers

318: BEGIN
319:
320: SELECT number_price_decimals, rate, auction_header_id, surrog_bid_flag, old_bid_number
321: INTO v_precision, v_rate, v_auction_header_id, v_surrog_bid_flag, v_source_bid
322: FROM pon_bid_headers
323: WHERE bid_number=p_bid_number;
324:
325: SELECT a.is_paused, a.last_pause_date, a.max_internal_line_num,
326: decode(a.contract_type, 'BLANKET', 'Y', 'CONTRACT', 'Y', 'N'),

Line 508: FROM pon_bid_headers pbh,

504: v_max_line_number,
505: v_progress_payment_type,
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

Line 606: pon_bid_headers pbh,

602: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,
603: 'Y', nvl(pbip.quantity, 1),
604: nvl(aip.quantity, 1)))
605: FROM pon_pf_supplier_formula ppsf,
606: pon_bid_headers pbh,
607: pon_auction_item_prices_all aip
608: WHERE ppsf.auction_header_id = pbip.auction_header_id
609: AND ppsf.line_number = pbip.line_number
610: AND pbip.bid_number = pbh.bid_number

Line 755: pon_bid_headers pbh,

751: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,
752: 'Y', nvl(pbip.quantity, 1),
753: nvl(aip.quantity, 1)))
754: FROM pon_pf_supplier_formula ppsf,
755: pon_bid_headers pbh,
756: pon_auction_item_prices_all aip,
757: pon_bid_item_prices pbip
758: WHERE pbip.bid_number = pbs.bid_number
759: AND pbip.line_number = pbs.line_number

Line 863: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

859: -- called from BidHeadersEO.publish or the concurrent publish program, this
860: -- procedure will publish the draft
861: -- -------------------------------------------------------------------------
862:
863: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
864: p_bid_number IN pon_bid_headers.bid_number%TYPE,
865: p_rebid_flag IN VARCHAR,
866: p_publish_date IN pon_bid_headers.publish_date%TYPE,
867: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

Line 864: p_bid_number IN pon_bid_headers.bid_number%TYPE,

860: -- procedure will publish the draft
861: -- -------------------------------------------------------------------------
862:
863: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
864: p_bid_number IN pon_bid_headers.bid_number%TYPE,
865: p_rebid_flag IN VARCHAR,
866: p_publish_date IN pon_bid_headers.publish_date%TYPE,
867: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
868: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,

Line 866: p_publish_date IN pon_bid_headers.publish_date%TYPE,

862:
863: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
864: p_bid_number IN pon_bid_headers.bid_number%TYPE,
865: p_rebid_flag IN VARCHAR,
866: p_publish_date IN pon_bid_headers.publish_date%TYPE,
867: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
868: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,
869: p_user_id IN NUMBER,
870: p_batch_id IN NUMBER,

Line 867: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

863: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
864: p_bid_number IN pon_bid_headers.bid_number%TYPE,
865: p_rebid_flag IN VARCHAR,
866: p_publish_date IN pon_bid_headers.publish_date%TYPE,
867: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
868: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,
869: p_user_id IN NUMBER,
870: p_batch_id IN NUMBER,
871: p_request_id IN NUMBER,

Line 868: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,

864: p_bid_number IN pon_bid_headers.bid_number%TYPE,
865: p_rebid_flag IN VARCHAR,
866: p_publish_date IN pon_bid_headers.publish_date%TYPE,
867: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
868: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,
869: p_user_id IN NUMBER,
870: p_batch_id IN NUMBER,
871: p_request_id IN NUMBER,
872: p_hdr_validation_failed IN VARCHAR,

Line 880: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;

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;
884: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;

Line 889: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%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;
893: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;

Line 890: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;

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;
893: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
894: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

Line 892: v_vendor_site_id pon_bid_headers.vendor_site_id%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;
893: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
894: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
895: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;
896:

Line 893: v_prev_bid_number pon_bid_headers.old_bid_number%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;
893: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
894: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
895: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;
896:
897: v_wf_item_key pon_bidding_parties.wf_item_key%TYPE;

Line 894: v_surrog_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;
893: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
894: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
895: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;
896:
897: v_wf_item_key pon_bidding_parties.wf_item_key%TYPE;
898: v_user_added_to_role VARCHAR2(1);

Line 895: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;

891: --------------------------------------------------
892: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;
893: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
894: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
895: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;
896:
897: v_wf_item_key pon_bidding_parties.wf_item_key%TYPE;
898: v_user_added_to_role VARCHAR2(1);
899: v_price_changed VARCHAR2(1);

Line 938: , PON_BID_HEADERS pbh

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:
942: IF ((nvl(l_two_part_flag, 'N') = 'Y') AND (nvl(l_surrogate_bid_flag, 'N') = 'Y'))

Line 999: FROM pon_bid_headers

995: FOR UPDATE OF CLOSE_BIDDING_DATE;
996:
997: SELECT vendor_site_id, old_bid_number, surrog_bid_flag, trading_partner_contact_name
998: INTO v_vendor_site_id, v_prev_bid_number, v_surrog_bid_flag, v_tpc_name
999: FROM pon_bid_headers
1000: WHERE bid_number = p_bid_number;
1001:
1002: -- (woojin) first do the validations to make sure that this
1003: -- bid is allowed to go through.

Line 1099: FROM pon_bid_headers

1095:
1096: IF (v_surrog_bid_flag = 'Y') THEN
1097: SELECT surrog_bid_receipt_date
1098: INTO v_surrog_bid_receipt_date
1099: FROM pon_bid_headers
1100: WHERE bid_number = p_bid_number;
1101: v_publish_date := v_surrog_bid_receipt_date;
1102: ELSE
1103: v_publish_date := p_publish_date;

Line 1233: UPDATE pon_bid_headers

1229: END IF;
1230:
1231: -- unlock and publish
1232: -- if this is a draft bid then need to release lock
1233: UPDATE pon_bid_headers
1234: SET draft_locked = 'N',
1235: draft_unlocked_by = p_tp_id,
1236: draft_unlocked_by_contact_id = p_tpc_id,
1237: draft_unlocked_date = sysdate,

Line 1264: (p_bid_number IN pon_bid_headers.bid_number%TYPE,

1260: -- publish
1261: -- -------------------------------------------------------------------------
1262:
1263: PROCEDURE remove_empty_rows
1264: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1265: p_batch_start IN NUMBER,
1266: p_batch_end IN NUMBER)
1267:
1268: IS

Line 1363: (p_bid_number IN pon_bid_headers.bid_number%TYPE,

1359: END remove_empty_rows;
1360:
1361:
1362: PROCEDURE remove_empty_rows_auto
1363: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1364: p_max_line_number IN NUMBER,
1365: p_batch_size IN NUMBER)
1366: IS
1367: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1418: (p_bid_number IN pon_bid_headers.bid_number%TYPE,

1414: -- bid header
1415: -- -------------------------------------------------------------------------
1416:
1417: PROCEDURE update_bid_header_fields
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,

Line 1419: p_publish_date IN pon_bid_headers.publish_date%TYPE,

1415: -- -------------------------------------------------------------------------
1416:
1417: PROCEDURE update_bid_header_fields
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)

Line 1420: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,

1416:
1417: PROCEDURE update_bid_header_fields
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

Line 1421: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

1417: PROCEDURE update_bid_header_fields
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:

Line 1441: UPDATE pon_bid_headers

1437: l_tech_shortlist_flag := 'Y';
1438: END IF;
1439:
1440:
1441: UPDATE pon_bid_headers
1442: SET publish_date = p_publish_date,
1443: shortlist_flag = 'Y',
1444: surrog_bid_online_entry_date = p_bid_entry_date,
1445: technical_shortlist_flag = l_tech_shortlist_flag

Line 1456: (p_bid_number IN pon_bid_headers.bid_number%TYPE,

1452: END update_bid_header_fields;
1453:
1454:
1455: PROCEDURE update_bid_header_fields_auto
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,

Line 1457: p_publish_date IN pon_bid_headers.publish_date%TYPE,

1453:
1454:
1455: PROCEDURE update_bid_header_fields_auto
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)

Line 1458: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,

1454:
1455: PROCEDURE update_bid_header_fields_auto
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

Line 1459: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

1455: PROCEDURE update_bid_header_fields_auto
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;

Line 1490: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

1486: -- publish processing, such as setting line-level publish date.
1487: -- -------------------------------------------------------------------------
1488:
1489: PROCEDURE publish_lines
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,

Line 1491: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1487: -- -------------------------------------------------------------------------
1488:
1489: PROCEDURE publish_lines
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,

Line 1493: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

1489: PROCEDURE publish_lines
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,

Line 1495: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%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)
1499:

Line 1503: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

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';
1507:

Line 1557: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

1553: END;
1554:
1555:
1556: PROCEDURE publish_lines_auto
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,

Line 1558: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1554:
1555:
1556: PROCEDURE publish_lines_auto
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,

Line 1560: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

1556: PROCEDURE publish_lines_auto
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,

Line 1562: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%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)
1566: IS

Line 1661: UPDATE pon_bid_headers

1657: errbuf := 'PUBLISH_CP exited successfully';
1658: retcode := '0';
1659:
1660: -- clear out the request_id once this CP exits successfully.
1661: UPDATE pon_bid_headers
1662: SET request_id = null
1663: WHERE bid_number = p_bid_number;
1664:
1665: PON_WF_UTL_PKG.ReportConcProgramStatus (

Line 1769: UPDATE pon_bid_headers

1765: END IF;
1766: END IF;
1767:
1768: -- set bid header's bid_status to DRAFT
1769: UPDATE pon_bid_headers
1770: SET bid_status = 'DRAFT'
1771: WHERE bid_number = p_bid_number;
1772:
1773: -- commit the changes made here in the exception block

Line 1791: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

1787:
1788: PROCEDURE validate_cp
1789: (errbuf OUT NOCOPY VARCHAR2,
1790: retcode OUT NOCOPY VARCHAR2,
1791: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1792: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1793: p_user_type IN VARCHAR2,
1794: p_user_id IN NUMBER)
1795: IS

Line 1792: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1788: PROCEDURE validate_cp
1789: (errbuf OUT NOCOPY VARCHAR2,
1790: retcode OUT NOCOPY VARCHAR2,
1791: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1792: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1793: p_user_type IN VARCHAR2,
1794: p_user_id IN NUMBER)
1795: IS
1796:

Line 1819: FROM pon_bid_headers

1815: WHERE user_id = p_user_id;
1816:
1817: SELECT decode (nvl (surrog_bid_flag, 'N'), 'Y', 'PONENQMGDR_MANAGEDRAFT_SURROG', 'PONENQMGDR_MANAGEDRAFT')
1818: INTO v_success_destination
1819: FROM pon_bid_headers
1820: WHERE bid_number = p_bid_number;
1821:
1822: -- perform line-level validation.
1823: pon_bid_validations_pkg.validate_bid(p_auction_header_id, p_bid_number, 'VALIDATEBID', p_user_id, null, v_request_id, v_subroutine_return_status, v_subroutine_return_code);