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 762: pon_bid_headers pbh,

758: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,
759: 'Y', nvl(pbip.quantity, 1),
760: nvl(aip.quantity, 1)))
761: FROM pon_pf_supplier_formula ppsf,
762: pon_bid_headers pbh,
763: pon_auction_item_prices_all aip,
764: pon_bid_item_prices pbip
765: WHERE pbip.bid_number = pbs.bid_number
766: AND pbip.line_number = pbs.line_number

Line 861: PROCEDURE MARK_UNSOL_INFO_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)

857:
858: END LOOP;
859: END;
860:
861: PROCEDURE MARK_UNSOL_INFO_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)
862: IS
863: --Unsolicited Lines Project : Mark Unsolicited info lines.
864: Cursor infoCursor Is select auction_header_id,auction_line_number,line_number,group_line_id from pon_bid_item_prices where
865: bid_number = p_bid_number and nvl(clm_info_flag,'N') = 'Y' AND auction_line_number = -1;

Line 897: PROCEDURE publish_unsol_lines(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

893:
894: /*Unsolicited Lines Project : Populates publish_date,proxy_bid_flag,award_price,
895: * first_bid_price,bid_trading_partner_id for unsolicited lines.
896: */
897: PROCEDURE publish_unsol_lines(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
898: p_bid_number IN pon_bid_headers.bid_number%TYPE,
899: p_publish_date IN DATE,
900: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
901: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,

Line 898: p_bid_number IN pon_bid_headers.bid_number%TYPE,

894: /*Unsolicited Lines Project : Populates publish_date,proxy_bid_flag,award_price,
895: * first_bid_price,bid_trading_partner_id for unsolicited lines.
896: */
897: PROCEDURE publish_unsol_lines(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
898: p_bid_number IN pon_bid_headers.bid_number%TYPE,
899: p_publish_date IN DATE,
900: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
901: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
902: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

Line 900: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

896: */
897: PROCEDURE publish_unsol_lines(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
898: p_bid_number IN pon_bid_headers.bid_number%TYPE,
899: p_publish_date IN DATE,
900: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
901: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
902: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
903: p_rebid_flag IN VARCHAR)
904: IS

Line 902: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

898: p_bid_number IN pon_bid_headers.bid_number%TYPE,
899: p_publish_date IN DATE,
900: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
901: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
902: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
903: p_rebid_flag IN VARCHAR)
904: IS
905: l_api_name CONSTANT VARCHAR2(30) := 'publish_unsol_lines';
906: BEGIN

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

954: -- called from BidHeadersEO.publish or the concurrent publish program, this
955: -- procedure will publish the draft
956: -- -------------------------------------------------------------------------
957:
958: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
959: p_bid_number IN pon_bid_headers.bid_number%TYPE,
960: p_rebid_flag IN VARCHAR,
961: p_publish_date IN pon_bid_headers.publish_date%TYPE,
962: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

Line 959: p_bid_number IN pon_bid_headers.bid_number%TYPE,

955: -- procedure will publish the draft
956: -- -------------------------------------------------------------------------
957:
958: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
959: p_bid_number IN pon_bid_headers.bid_number%TYPE,
960: p_rebid_flag IN VARCHAR,
961: p_publish_date IN pon_bid_headers.publish_date%TYPE,
962: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
963: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,

Line 961: p_publish_date IN pon_bid_headers.publish_date%TYPE,

957:
958: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
959: p_bid_number IN pon_bid_headers.bid_number%TYPE,
960: p_rebid_flag IN VARCHAR,
961: p_publish_date IN pon_bid_headers.publish_date%TYPE,
962: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
963: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,
964: p_user_id IN NUMBER,
965: p_batch_id IN NUMBER,

Line 962: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

958: PROCEDURE publish(p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
959: p_bid_number IN pon_bid_headers.bid_number%TYPE,
960: p_rebid_flag IN VARCHAR,
961: p_publish_date IN pon_bid_headers.publish_date%TYPE,
962: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
963: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,
964: p_user_id IN NUMBER,
965: p_batch_id IN NUMBER,
966: p_request_id IN NUMBER,

Line 963: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,

959: p_bid_number IN pon_bid_headers.bid_number%TYPE,
960: p_rebid_flag IN VARCHAR,
961: p_publish_date IN pon_bid_headers.publish_date%TYPE,
962: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
963: p_tpc_id IN pon_bid_headers.trading_partner_contact_id%TYPE,
964: p_user_id IN NUMBER,
965: p_batch_id IN NUMBER,
966: p_request_id IN NUMBER,
967: p_hdr_validation_failed IN VARCHAR,

Line 975: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;

971:
972: v_auc_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
973: v_group_enabled_flag pon_auction_headers_all.group_enabled_flag%TYPE;
974: v_is_paused pon_auction_headers_all.is_paused%TYPE;
975: v_surrog_bid_receipt_date pon_bid_headers.surrog_bid_receipt_date%TYPE;
976: v_publish_date DATE;
977: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
978: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
979: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;

Line 984: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;

980: --added by Allen Yang for Surrogate Bid 2008/09/08
981: --------------------------------------------------
982: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
983: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
984: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
985: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;
986: --------------------------------------------------
987: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;
988: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;

Line 985: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;

981: --------------------------------------------------
982: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
983: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
984: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
985: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;
986: --------------------------------------------------
987: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;
988: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
989: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

Line 987: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;

983: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
984: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
985: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;
986: --------------------------------------------------
987: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;
988: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
989: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
990: v_evaluation_flag pon_bid_headers.evaluation_flag%TYPE;
991: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;

Line 988: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;

984: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
985: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;
986: --------------------------------------------------
987: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;
988: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
989: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
990: v_evaluation_flag pon_bid_headers.evaluation_flag%TYPE;
991: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;
992:

Line 989: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

985: l_submit_stage pon_bid_headers.SUBMIT_STAGE%TYPE;
986: --------------------------------------------------
987: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;
988: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
989: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
990: v_evaluation_flag pon_bid_headers.evaluation_flag%TYPE;
991: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;
992:
993: v_wf_item_key pon_bidding_parties.wf_item_key%TYPE;

Line 990: v_evaluation_flag pon_bid_headers.evaluation_flag%TYPE;

986: --------------------------------------------------
987: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;
988: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
989: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
990: v_evaluation_flag pon_bid_headers.evaluation_flag%TYPE;
991: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;
992:
993: v_wf_item_key pon_bidding_parties.wf_item_key%TYPE;
994: v_user_added_to_role VARCHAR2(1);

Line 991: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;

987: v_vendor_site_id pon_bid_headers.vendor_site_id%TYPE;
988: v_prev_bid_number pon_bid_headers.old_bid_number%TYPE;
989: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
990: v_evaluation_flag pon_bid_headers.evaluation_flag%TYPE;
991: v_tpc_name pon_bid_headers.trading_partner_contact_name%TYPE;
992:
993: v_wf_item_key pon_bidding_parties.wf_item_key%TYPE;
994: v_user_added_to_role VARCHAR2(1);
995: v_price_changed VARCHAR2(1);

Line 1039: , PON_BID_HEADERS pbh

1035: , l_surrogate_bid_flag
1036: , l_allow_unsol_lines --Unsolicited Lines Project
1037: FROM
1038: PON_AUCTION_HEADERS_ALL paha
1039: , PON_BID_HEADERS pbh
1040: WHERE paha.auction_header_id = pbh.auction_header_id
1041: AND pbh.bid_number = p_bid_number;
1042:
1043: IF ((nvl(l_two_part_flag, 'N') = 'Y') AND (nvl(l_surrogate_bid_flag, 'N') = 'Y'))

Line 1100: FROM pon_bid_headers

1096: FOR UPDATE OF CLOSE_BIDDING_DATE;
1097:
1098: SELECT vendor_site_id, old_bid_number, surrog_bid_flag, trading_partner_contact_name, evaluation_flag
1099: INTO v_vendor_site_id, v_prev_bid_number, v_surrog_bid_flag, v_tpc_name, v_evaluation_flag
1100: FROM pon_bid_headers
1101: WHERE bid_number = p_bid_number;
1102:
1103: -- (woojin) first do the validations to make sure that this
1104: -- bid is allowed to go through.

Line 1218: FROM pon_bid_headers

1214:
1215: IF (v_surrog_bid_flag = 'Y') THEN
1216: SELECT surrog_bid_receipt_date
1217: INTO v_surrog_bid_receipt_date
1218: FROM pon_bid_headers
1219: WHERE bid_number = p_bid_number;
1220: v_publish_date := v_surrog_bid_receipt_date;
1221: ELSE
1222: v_publish_date := p_publish_date;

Line 1364: UPDATE pon_bid_headers

1360: -- End Supplier Management: Bug 12369949
1361:
1362: -- unlock and publish
1363: -- if this is a draft bid then need to release lock
1364: UPDATE pon_bid_headers
1365: SET draft_locked = 'N',
1366: draft_unlocked_by = p_tp_id,
1367: draft_unlocked_by_contact_id = p_tpc_id,
1368: draft_unlocked_date = sysdate,

Line 1383: PROCEDURE MARK_INFO_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)

1379:
1380:
1381: END publish;
1382:
1383: PROCEDURE MARK_INFO_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)
1384: IS
1385:
1386: --Unsolicited Lines Project : Mark only negotiation lines. Unsolicited info lines will be marked seperately.
1387: Cursor infoCursor Is select auction_header_id,auction_line_number,line_number,group_line_id from pon_bid_item_prices where

Line 1417: PROCEDURE MARK_OPTION_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)

1413: end if;
1414: end loop;
1415: END MARK_INFO_LINES;
1416:
1417: PROCEDURE MARK_OPTION_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)
1418: IS
1419: Cursor optCursor Is select auction_header_id,auction_line_number,line_number,clm_base_line_num from pon_bid_item_prices where
1420: bid_number = p_bid_number and clm_base_line_num is not null and nvl(has_bid_flag,'N') = 'N';
1421: l_award_flag Varchar2(1);

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

1441: -- publish
1442: -- -------------------------------------------------------------------------
1443:
1444: PROCEDURE remove_empty_rows
1445: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1446: p_batch_start IN NUMBER,
1447: p_batch_end IN NUMBER)
1448:
1449: IS

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

1540: END remove_empty_rows;
1541:
1542:
1543: PROCEDURE remove_empty_rows_auto
1544: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1545: p_max_line_number IN NUMBER,
1546: p_batch_size IN NUMBER)
1547: IS
1548: PRAGMA AUTONOMOUS_TRANSACTION;

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

1595: -- bid header
1596: -- -------------------------------------------------------------------------
1597:
1598: PROCEDURE update_bid_header_fields
1599: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1600: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1601: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1602: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1603: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,

Line 1600: p_publish_date IN pon_bid_headers.publish_date%TYPE,

1596: -- -------------------------------------------------------------------------
1597:
1598: PROCEDURE update_bid_header_fields
1599: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1600: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1601: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1602: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1603: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1604: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)

Line 1601: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,

1597:
1598: PROCEDURE update_bid_header_fields
1599: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1600: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1601: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1602: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1603: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1604: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)
1605: IS

Line 1602: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

1598: PROCEDURE update_bid_header_fields
1599: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1600: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1601: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1602: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1603: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1604: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)
1605: IS
1606:

Line 1622: UPDATE pon_bid_headers

1618: l_tech_shortlist_flag := 'Y';
1619: END IF;
1620:
1621:
1622: UPDATE pon_bid_headers
1623: SET publish_date = p_publish_date,
1624: shortlist_flag = 'Y',
1625: surrog_bid_online_entry_date = p_bid_entry_date,
1626: technical_shortlist_flag = l_tech_shortlist_flag

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

1633: END update_bid_header_fields;
1634:
1635:
1636: PROCEDURE update_bid_header_fields_auto
1637: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1638: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1639: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1640: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1641: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,

Line 1638: p_publish_date IN pon_bid_headers.publish_date%TYPE,

1634:
1635:
1636: PROCEDURE update_bid_header_fields_auto
1637: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1638: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1639: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1640: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1641: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1642: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)

Line 1639: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,

1635:
1636: PROCEDURE update_bid_header_fields_auto
1637: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1638: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1639: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1640: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1641: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1642: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)
1643: IS

Line 1640: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

1636: PROCEDURE update_bid_header_fields_auto
1637: (p_bid_number IN pon_bid_headers.bid_number%TYPE,
1638: p_publish_date IN pon_bid_headers.publish_date%TYPE,
1639: p_bid_entry_date IN pon_bid_headers.publish_date%TYPE,
1640: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1641: p_two_part_flag IN pon_auction_headers_all.two_part_flag%TYPE,
1642: p_sealed_auction_status IN pon_auction_headers_all.sealed_auction_status%TYPE)
1643: IS
1644: PRAGMA AUTONOMOUS_TRANSACTION;

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

1667: -- publish processing, such as setting line-level publish date.
1668: -- -------------------------------------------------------------------------
1669:
1670: PROCEDURE publish_lines
1671: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1672: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1673: p_publish_date IN DATE,
1674: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1675: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,

Line 1672: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1668: -- -------------------------------------------------------------------------
1669:
1670: PROCEDURE publish_lines
1671: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1672: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1673: p_publish_date IN DATE,
1674: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1675: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
1676: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

Line 1674: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

1670: PROCEDURE publish_lines
1671: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1672: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1673: p_publish_date IN DATE,
1674: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1675: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
1676: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1677: p_rebid_flag IN VARCHAR,
1678: p_batch_start IN NUMBER,

Line 1676: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

1672: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1673: p_publish_date IN DATE,
1674: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1675: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
1676: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1677: p_rebid_flag IN VARCHAR,
1678: p_batch_start IN NUMBER,
1679: p_batch_end IN NUMBER)
1680:

Line 1684: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

1680:
1681: IS
1682:
1683: v_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%TYPE;
1684: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
1685: v_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
1686: v_auction_header_id NUMBER;
1687: l_api_name CONSTANT VARCHAR2(30) := 'publish_lines';
1688:

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

1745: END;
1746:
1747:
1748: PROCEDURE publish_lines_auto
1749: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1750: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1751: p_publish_date IN DATE,
1752: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1753: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,

Line 1750: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1746:
1747:
1748: PROCEDURE publish_lines_auto
1749: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1750: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1751: p_publish_date IN DATE,
1752: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1753: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
1754: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

Line 1752: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,

1748: PROCEDURE publish_lines_auto
1749: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1750: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1751: p_publish_date IN DATE,
1752: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1753: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
1754: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1755: p_rebid_flag IN VARCHAR,
1756: p_max_line_number IN NUMBER,

Line 1754: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,

1750: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1751: p_publish_date IN DATE,
1752: p_tp_id IN pon_bid_headers.trading_partner_id%TYPE,
1753: p_auc_tp_id IN pon_auction_headers_all.trading_partner_id%TYPE,
1754: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE,
1755: p_rebid_flag IN VARCHAR,
1756: p_max_line_number IN NUMBER,
1757: p_batch_size IN NUMBER)
1758: IS

Line 1853: UPDATE pon_bid_headers

1849: errbuf := 'PUBLISH_CP exited successfully';
1850: retcode := '0';
1851:
1852: -- clear out the request_id once this CP exits successfully.
1853: UPDATE pon_bid_headers
1854: SET request_id = null
1855: WHERE bid_number = p_bid_number;
1856:
1857: PON_WF_UTL_PKG.ReportConcProgramStatus (

Line 1961: UPDATE pon_bid_headers

1957: END IF;
1958: END IF;
1959:
1960: -- set bid header's bid_status to DRAFT
1961: UPDATE pon_bid_headers
1962: SET bid_status = 'DRAFT'
1963: WHERE bid_number = p_bid_number;
1964:
1965: -- commit the changes made here in the exception block

Line 1983: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

1979:
1980: PROCEDURE validate_cp
1981: (errbuf OUT NOCOPY VARCHAR2,
1982: retcode OUT NOCOPY VARCHAR2,
1983: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1984: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1985: p_user_type IN VARCHAR2,
1986: p_user_id IN NUMBER)
1987: IS

Line 1984: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1980: PROCEDURE validate_cp
1981: (errbuf OUT NOCOPY VARCHAR2,
1982: retcode OUT NOCOPY VARCHAR2,
1983: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
1984: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1985: p_user_type IN VARCHAR2,
1986: p_user_id IN NUMBER)
1987: IS
1988:

Line 2011: FROM pon_bid_headers

2007: WHERE user_id = p_user_id;
2008:
2009: SELECT decode (nvl (surrog_bid_flag, 'N'), 'Y', 'PONENQMGDR_MANAGEDRAFT_SURROG', 'PONENQMGDR_MANAGEDRAFT')
2010: INTO v_success_destination
2011: FROM pon_bid_headers
2012: WHERE bid_number = p_bid_number;
2013:
2014: -- perform line-level validation.
2015: 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);

Line 2251: FROM pon_bid_headers pbh2, pon_bid_headers pbh3

2247: pon_auction_attributes paa2
2248: WHERE pbav2.auction_header_id = p_auction_header_id
2249: AND pbav2.bid_number IN
2250: (SELECT pbh2.bid_number
2251: FROM pon_bid_headers pbh2, pon_bid_headers pbh3
2252: WHERE NVL(pbh2.evaluation_flag, 'N') = 'Y'
2253: AND pbh2.auction_header_id = p_auction_header_id
2254: AND pbh3.auction_header_id = p_auction_header_id
2255: AND pbh2.trading_partner_id = pbh3.trading_partner_id

Line 2271: FROM pon_bid_headers pbh1

2267: )
2268: WHERE pbav1.auction_header_id = p_auction_header_id
2269: AND pbav1.bid_number IN
2270: (SELECT pbh1.bid_number
2271: FROM pon_bid_headers pbh1
2272: WHERE pbh1.auction_header_id = p_auction_header_id
2273: AND NVL(pbh1.evaluation_flag, 'N') = 'N'
2274: AND pbh1.bid_status = 'ACTIVE'
2275: AND EXISTS (SELECT NULL

Line 2276: FROM pon_bid_headers pbh4

2272: WHERE pbh1.auction_header_id = p_auction_header_id
2273: AND NVL(pbh1.evaluation_flag, 'N') = 'N'
2274: AND pbh1.bid_status = 'ACTIVE'
2275: AND EXISTS (SELECT NULL
2276: FROM pon_bid_headers pbh4
2277: WHERE NVL(pbh4.evaluation_flag, 'N') = 'Y'
2278: AND pbh4.auction_header_id = p_auction_header_id
2279: AND pbh4.trading_partner_id = pbh1.trading_partner_id
2280: AND pbh4.bid_status = 'ACTIVE'