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_BID_DEFAULTING_PKG dependencies on PON_BID_HEADERS

Line 7: g_bid_rate PON_BID_HEADERS.RATE%TYPE;

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_BID_DEFAULTING_PKG';
5: g_debug_mode CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: g_module_prefix CONSTANT VARCHAR2(35) := 'pon.plsql.bidDefaultingPkg.';
7: g_bid_rate PON_BID_HEADERS.RATE%TYPE;
8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;
9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;
11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;

Line 52: p_bid_number IN pon_bid_headers.bid_number%TYPE,

48: -- ======================================================================
49: PROCEDURE populate_display_pf_flag
50: (
51: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
52: p_bid_number IN pon_bid_headers.bid_number%TYPE,
53: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
54: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
55: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
56: x_skip_pf_for_batch OUT NOCOPY VARCHAR2

Line 160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

156: -- COMMENT: Insert missing auction side lines into a draft bid
157: -- ======================================================================
158: PROCEDURE insert_auction_lines
159: (
160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

Line 161: p_bid_number IN pon_bid_headers.bid_number%TYPE,

157: -- ======================================================================
158: PROCEDURE insert_auction_lines
159: (
160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 162: p_userid IN pon_bid_headers.created_by%TYPE,

158: PROCEDURE insert_auction_lines
159: (
160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
166: p_has_pe_flag IN VARCHAR2,

Line 164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
166: p_has_pe_flag IN VARCHAR2,
167: p_blanket IN VARCHAR2,
168: p_full_qty IN VARCHAR2,

Line 165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
166: p_has_pe_flag IN VARCHAR2,
167: p_blanket IN VARCHAR2,
168: p_full_qty IN VARCHAR2,
169: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,

Line 170: p_rate IN pon_bid_headers.rate%TYPE,

166: p_has_pe_flag IN VARCHAR2,
167: p_blanket IN VARCHAR2,
168: p_full_qty IN VARCHAR2,
169: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
170: p_rate IN pon_bid_headers.rate%TYPE,
171: p_price_prec IN pon_bid_headers.number_price_decimals%TYPE,
172: p_curr_prec IN fnd_currencies.precision%TYPE,
173: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
174: p_batch_end IN pon_bid_item_prices.line_number%TYPE

Line 171: p_price_prec IN pon_bid_headers.number_price_decimals%TYPE,

167: p_blanket IN VARCHAR2,
168: p_full_qty IN VARCHAR2,
169: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
170: p_rate IN pon_bid_headers.rate%TYPE,
171: p_price_prec IN pon_bid_headers.number_price_decimals%TYPE,
172: p_curr_prec IN fnd_currencies.precision%TYPE,
173: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
174: p_batch_end IN pon_bid_item_prices.line_number%TYPE
175: ) IS

Line 685: p_bid_number IN pon_bid_headers.bid_number%TYPE,

681: -- COMMENT: Populate old value columns for a bid
682: -- ======================================================================
683: PROCEDURE populate_old_value_columns
684: (
685: p_bid_number IN pon_bid_headers.bid_number%TYPE,
686: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
687: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
688: p_batch_end IN pon_bid_item_prices.line_number%TYPE
689: ) IS

Line 686: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

682: -- ======================================================================
683: PROCEDURE populate_old_value_columns
684: (
685: p_bid_number IN pon_bid_headers.bid_number%TYPE,
686: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
687: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
688: p_batch_end IN pon_bid_item_prices.line_number%TYPE
689: ) IS
690: BEGIN

Line 813: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

809: -- if the bid was a rebid
810: -- ======================================================================
811: PROCEDURE handle_proxy
812: (
813: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
814: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
815: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
816: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
817: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 814: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,

810: -- ======================================================================
811: PROCEDURE handle_proxy
812: (
813: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
814: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
815: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
816: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
817: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
818: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

Line 815: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

811: PROCEDURE handle_proxy
812: (
813: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
814: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
815: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
816: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
817: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
818: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
819: x_rebid_flag OUT NOCOPY VARCHAR2

Line 816: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

812: (
813: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
814: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
815: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
816: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
817: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
818: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
819: x_rebid_flag OUT NOCOPY VARCHAR2
820: ) IS

Line 817: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

813: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
814: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
815: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
816: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
817: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
818: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
819: x_rebid_flag OUT NOCOPY VARCHAR2
820: ) IS
821: l_max_line_number pon_bid_item_prices.line_number%TYPE;

Line 818: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

814: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
815: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
816: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
817: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
818: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
819: x_rebid_flag OUT NOCOPY VARCHAR2
820: ) IS
821: l_max_line_number pon_bid_item_prices.line_number%TYPE;
822: l_batch_start pon_bid_item_prices.line_number%TYPE;

Line 835: FROM pon_bid_headers bh

831: -- is modifying the draft. So we can't use the login in supplier's tpcid,
832: -- we should use the tpcid of the user who creates the draft
833: SELECT bh.bid_number, 'Y'
834: INTO x_prev_bid_number, x_rebid_flag
835: FROM pon_bid_headers bh
836: WHERE bh.auction_header_id = p_auc_header_id
837: AND bh.trading_partner_id = p_tpid
838: AND bh.trading_partner_contact_id =
839: (SELECT trading_partner_contact_id

Line 840: FROM pon_bid_headers bh2

836: WHERE bh.auction_header_id = p_auc_header_id
837: AND bh.trading_partner_id = p_tpid
838: AND bh.trading_partner_contact_id =
839: (SELECT trading_partner_contact_id
840: FROM pon_bid_headers bh2
841: WHERE bh2.bid_number = p_draft_bid_num)
842: AND bh.vendor_site_id = p_vensid
843: AND bh.bid_status = 'ACTIVE'
844: AND rownum = 1

Line 848: UPDATE pon_bid_headers bh

844: AND rownum = 1
845: ORDER BY bh.publish_date DESC;
846:
847: -- Update old_bid_number to new source bid
848: UPDATE pon_bid_headers bh
849: SET bh.old_bid_number = x_prev_bid_number
850: WHERE bh.bid_number = p_draft_bid_num;
851:
852: -- START BATCHING

Line 918: FROM pon_bid_headers bh

914: -- No ACTIVE bids on the current amendment
915: WHEN NO_DATA_FOUND THEN
916: SELECT bh.old_bid_number
917: INTO x_prev_bid_number
918: FROM pon_bid_headers bh
919: WHERE bh.bid_number = p_draft_bid_num;
920: x_rebid_flag := 'N';
921:
922: END handle_proxy;

Line 948: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

944: -- ======================================================================
945: PROCEDURE insert_into_bid_header
946: (
947: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
948: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
949: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

Line 949: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

945: PROCEDURE insert_into_bid_header
946: (
947: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
948: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
949: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
953: p_userid IN pon_bid_headers.created_by%TYPE,

Line 950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

946: (
947: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
948: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
949: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
953: p_userid IN pon_bid_headers.created_by%TYPE,
954: p_venid IN pon_bid_headers.vendor_id%TYPE,

Line 951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

947: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
948: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
949: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
953: p_userid IN pon_bid_headers.created_by%TYPE,
954: p_venid IN pon_bid_headers.vendor_id%TYPE,
955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

948: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
949: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
953: p_userid IN pon_bid_headers.created_by%TYPE,
954: p_venid IN pon_bid_headers.vendor_id%TYPE,
955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
956: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

Line 953: p_userid IN pon_bid_headers.created_by%TYPE,

949: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
953: p_userid IN pon_bid_headers.created_by%TYPE,
954: p_venid IN pon_bid_headers.vendor_id%TYPE,
955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
956: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
957: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

Line 954: p_venid IN pon_bid_headers.vendor_id%TYPE,

950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
953: p_userid IN pon_bid_headers.created_by%TYPE,
954: p_venid IN pon_bid_headers.vendor_id%TYPE,
955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
956: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
957: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
958: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

Line 955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
953: p_userid IN pon_bid_headers.created_by%TYPE,
954: p_venid IN pon_bid_headers.vendor_id%TYPE,
955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
956: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
957: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
958: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
959: p_buyer_user IN VARCHAR2,

Line 956: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

952: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
953: p_userid IN pon_bid_headers.created_by%TYPE,
954: p_venid IN pon_bid_headers.vendor_id%TYPE,
955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
956: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
957: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
958: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
959: p_buyer_user IN VARCHAR2,
960: p_rebid_flag IN VARCHAR2,

Line 957: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

953: p_userid IN pon_bid_headers.created_by%TYPE,
954: p_venid IN pon_bid_headers.vendor_id%TYPE,
955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
956: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
957: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
958: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
959: p_buyer_user IN VARCHAR2,
960: p_rebid_flag IN VARCHAR2,
961: p_prev_bid_disq IN VARCHAR2,

Line 958: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

954: p_venid IN pon_bid_headers.vendor_id%TYPE,
955: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
956: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
957: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
958: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
959: p_buyer_user IN VARCHAR2,
960: p_rebid_flag IN VARCHAR2,
961: p_prev_bid_disq IN VARCHAR2,
962: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE

Line 962: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE

958: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
959: p_buyer_user IN VARCHAR2,
960: p_rebid_flag IN VARCHAR2,
961: p_prev_bid_disq IN VARCHAR2,
962: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
963: ) IS
964: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
965: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
966: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486

Line 989: PON_BID_HEADERS pbh

985: , l_two_part_flag
986: , l_technical_evaluation_status
987: -------------------------------------------------------
988: FROM PON_AUCTION_HEADERS_ALL pah,
989: PON_BID_HEADERS pbh
990: WHERE pah.auction_header_id = pbh.auction_header_id
991: AND pbh.bid_number = p_source_bid_num;
992: END IF;
993:

Line 995: SELECT pon_bid_headers_s.nextval INTO x_bid_number

991: AND pbh.bid_number = p_source_bid_num;
992: END IF;
993:
994: -- Generate next bid number
995: SELECT pon_bid_headers_s.nextval INTO x_bid_number
996: FROM dual;
997:
998: INSERT INTO pon_bid_headers
999: (

Line 998: INSERT INTO pon_bid_headers

994: -- Generate next bid number
995: SELECT pon_bid_headers_s.nextval INTO x_bid_number
996: FROM dual;
997:
998: INSERT INTO pon_bid_headers
999: (
1000: BID_NUMBER,
1001: AUCTION_HEADER_ID,
1002: BIDDERS_BID_NUMBER,

Line 1125: FROM pon_auction_headers_all ah, pon_bid_headers bh

1121: decode(l_two_part_flag, 'Y',
1122: decode(p_buyer_user, 'Y',
1123: decode(l_technical_evaluation_status, 'COMPLETED', 'TECHNICAL', null), null), null), null)
1124: -----------------------------------------------------------------------------
1125: FROM pon_auction_headers_all ah, pon_bid_headers bh
1126: WHERE ah.auction_header_id = p_auc_header_id
1127: AND bh.bid_number (+) = p_source_bid_num
1128: AND ah.auction_header_id >= bh.auction_header_id (+));
1129:

Line 1149: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1145: -- ======================================================================
1146: PROCEDURE insert_into_bid_items
1147: (
1148: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1149: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1150: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1151: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1152: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1153: p_userid IN pon_bid_headers.created_by%TYPE,

Line 1150: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

1146: PROCEDURE insert_into_bid_items
1147: (
1148: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1149: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1150: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1151: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1152: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1153: p_userid IN pon_bid_headers.created_by%TYPE,
1154: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 1151: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

1147: (
1148: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1149: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1150: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1151: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1152: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1153: p_userid IN pon_bid_headers.created_by%TYPE,
1154: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1155: p_rebid_flag IN VARCHAR2,

Line 1152: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

1148: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1149: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1150: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1151: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1152: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1153: p_userid IN pon_bid_headers.created_by%TYPE,
1154: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1155: p_rebid_flag IN VARCHAR2,
1156: p_restricted_flag IN VARCHAR2,

Line 1153: p_userid IN pon_bid_headers.created_by%TYPE,

1149: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1150: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1151: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1152: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1153: p_userid IN pon_bid_headers.created_by%TYPE,
1154: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1155: p_rebid_flag IN VARCHAR2,
1156: p_restricted_flag IN VARCHAR2,
1157: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 1154: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

1150: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1151: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1152: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1153: p_userid IN pon_bid_headers.created_by%TYPE,
1154: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1155: p_rebid_flag IN VARCHAR2,
1156: p_restricted_flag IN VARCHAR2,
1157: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1158: p_batch_end IN pon_bid_item_prices.line_number%TYPE,

Line 1159: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE

1155: p_rebid_flag IN VARCHAR2,
1156: p_restricted_flag IN VARCHAR2,
1157: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1158: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1159: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1160: ) IS
1161: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
1162: l_blanket VARCHAR2(1);
1163: l_full_qty VARCHAR2(1);

Line 1421: FROM pon_bid_headers bh

1417: IF (l_enforce_prevrnd_price_flag = 'Y') THEN
1418: BEGIN
1419: SELECT MAX(bid_number)
1420: INTO l_prev_rnd_active_bid_number
1421: FROM pon_bid_headers bh
1422: WHERE bh.auction_header_id = l_auction_header_id_prev_round
1423: AND bh.trading_partner_id = p_tpid
1424: AND bh.trading_partner_contact_id = p_tpcid
1425: AND bh.bid_status ='ACTIVE'

Line 1511: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1507: -- ======================================================================
1508: PROCEDURE insert_into_header_attributes
1509: (
1510: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1511: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1512: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1513: p_userid IN pon_bid_headers.created_by%TYPE,
1514: p_rebid_flag IN VARCHAR2
1515: ) IS

Line 1512: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

1508: PROCEDURE insert_into_header_attributes
1509: (
1510: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1511: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1512: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1513: p_userid IN pon_bid_headers.created_by%TYPE,
1514: p_rebid_flag IN VARCHAR2
1515: ) IS
1516:

Line 1513: p_userid IN pon_bid_headers.created_by%TYPE,

1509: (
1510: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1511: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1512: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1513: p_userid IN pon_bid_headers.created_by%TYPE,
1514: p_rebid_flag IN VARCHAR2
1515: ) IS
1516:
1517: l_has_scoring_teams_flag pon_auction_headers_all.has_scoring_teams_flag%TYPE;

Line 1609: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1605: -- ======================================================================
1606: PROCEDURE insert_into_line_attributes
1607: (
1608: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1609: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1610: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1611: p_userid IN pon_bid_headers.created_by%TYPE,
1612: p_rebid_flag IN VARCHAR2,
1613: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 1610: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

1606: PROCEDURE insert_into_line_attributes
1607: (
1608: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1609: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1610: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1611: p_userid IN pon_bid_headers.created_by%TYPE,
1612: p_rebid_flag IN VARCHAR2,
1613: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1614: p_batch_end IN pon_bid_item_prices.line_number%TYPE

Line 1611: p_userid IN pon_bid_headers.created_by%TYPE,

1607: (
1608: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1609: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1610: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1611: p_userid IN pon_bid_headers.created_by%TYPE,
1612: p_rebid_flag IN VARCHAR2,
1613: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1614: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1615: ) IS

Line 1690: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1686: -- ======================================================================
1687: PROCEDURE insert_into_price_factors
1688: (
1689: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1690: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1691: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1692: p_userid IN pon_bid_headers.created_by%TYPE,
1693: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1694: p_rebid_flag IN VARCHAR2,

Line 1691: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

1687: PROCEDURE insert_into_price_factors
1688: (
1689: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1690: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1691: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1692: p_userid IN pon_bid_headers.created_by%TYPE,
1693: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1694: p_rebid_flag IN VARCHAR2,
1695: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 1692: p_userid IN pon_bid_headers.created_by%TYPE,

1688: (
1689: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1690: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1691: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1692: p_userid IN pon_bid_headers.created_by%TYPE,
1693: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1694: p_rebid_flag IN VARCHAR2,
1695: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1696: p_batch_end IN pon_bid_item_prices.line_number%TYPE

Line 1698: l_price_prec pon_bid_headers.number_price_decimals%TYPE;

1694: p_rebid_flag IN VARCHAR2,
1695: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1696: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1697: ) IS
1698: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1699: l_curr_prec fnd_currencies.precision%TYPE;
1700: l_rate pon_bid_headers.rate%TYPE;
1701: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1702: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;

Line 1700: l_rate pon_bid_headers.rate%TYPE;

1696: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1697: ) IS
1698: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1699: l_curr_prec fnd_currencies.precision%TYPE;
1700: l_rate pon_bid_headers.rate%TYPE;
1701: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1702: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1703: BEGIN
1704:

Line 1712: FROM pon_bid_headers bh,

1708: bh.rate
1709: INTO l_price_prec,
1710: l_curr_prec,
1711: l_rate
1712: FROM pon_bid_headers bh,
1713: fnd_currencies cu
1714: WHERE bh.bid_number = p_bid_number
1715: AND cu.currency_code = bh.bid_currency_code;
1716:

Line 1848: p_bid_number IN pon_bid_headers.bid_number%TYPE,

1844: -- ======================================================================
1845: PROCEDURE insert_into_price_tiers
1846: (
1847: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1848: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1849: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1850: p_userid IN pon_bid_headers.created_by%TYPE,
1851: p_rebid_flag IN VARCHAR2,
1852: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 1849: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

1845: PROCEDURE insert_into_price_tiers
1846: (
1847: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1848: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1849: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1850: p_userid IN pon_bid_headers.created_by%TYPE,
1851: p_rebid_flag IN VARCHAR2,
1852: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1853: p_batch_end IN pon_bid_item_prices.line_number%TYPE

Line 1850: p_userid IN pon_bid_headers.created_by%TYPE,

1846: (
1847: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1848: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1849: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1850: p_userid IN pon_bid_headers.created_by%TYPE,
1851: p_rebid_flag IN VARCHAR2,
1852: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1853: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1854: ) IS

Line 2023: p_bid_number IN pon_bid_headers.bid_number%TYPE,

2019: -- ======================================================================
2020: PROCEDURE insert_into_price_diff
2021: (
2022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2023: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2024: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2025: p_userid IN pon_bid_headers.created_by%TYPE,
2026: p_rebid_flag IN VARCHAR2,
2027: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 2024: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

2020: PROCEDURE insert_into_price_diff
2021: (
2022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2023: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2024: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2025: p_userid IN pon_bid_headers.created_by%TYPE,
2026: p_rebid_flag IN VARCHAR2,
2027: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2028: p_batch_end IN pon_bid_item_prices.line_number%TYPE

Line 2025: p_userid IN pon_bid_headers.created_by%TYPE,

2021: (
2022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2023: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2024: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2025: p_userid IN pon_bid_headers.created_by%TYPE,
2026: p_rebid_flag IN VARCHAR2,
2027: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2028: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2029: ) IS

Line 2134: p_bid_number IN pon_bid_headers.bid_number%TYPE,

2130: -- Create and default payments
2131: PROCEDURE insert_into_payments
2132: (
2133: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2134: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2135: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2136: p_copy_only_from_auc IN VARCHAR2,
2137: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2138: p_userid IN pon_bid_headers.created_by%TYPE,

Line 2135: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

2131: PROCEDURE insert_into_payments
2132: (
2133: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2134: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2135: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2136: p_copy_only_from_auc IN VARCHAR2,
2137: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2138: p_userid IN pon_bid_headers.created_by%TYPE,
2139: p_rebid_flag IN VARCHAR2,

Line 2138: p_userid IN pon_bid_headers.created_by%TYPE,

2134: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2135: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2136: p_copy_only_from_auc IN VARCHAR2,
2137: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2138: p_userid IN pon_bid_headers.created_by%TYPE,
2139: p_rebid_flag IN VARCHAR2,
2140: p_new_round_or_amended IN VARCHAR2,
2141: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2142: p_batch_end IN pon_bid_item_prices.line_number%TYPE

Line 2431: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

2427: -- COMMENT: copies over line attachments from source bid
2428: -- ======================================================================
2429: PROCEDURE copy_line_attachments
2430: (
2431: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2432: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2433: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2434: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2435: p_userid IN pon_bid_headers.created_by%TYPE,

Line 2432: p_bid_number IN pon_bid_headers.bid_number%TYPE,

2428: -- ======================================================================
2429: PROCEDURE copy_line_attachments
2430: (
2431: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2432: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2433: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2434: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2435: p_userid IN pon_bid_headers.created_by%TYPE,
2436: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 2433: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,

2429: PROCEDURE copy_line_attachments
2430: (
2431: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2432: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2433: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2434: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2435: p_userid IN pon_bid_headers.created_by%TYPE,
2436: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2437: p_batch_end IN pon_bid_item_prices.line_number%TYPE,

Line 2434: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

2430: (
2431: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2432: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2433: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2434: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2435: p_userid IN pon_bid_headers.created_by%TYPE,
2436: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2437: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2438: p_to_category_id IN NUMBER,

Line 2435: p_userid IN pon_bid_headers.created_by%TYPE,

2431: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2432: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2433: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2434: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2435: p_userid IN pon_bid_headers.created_by%TYPE,
2436: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2437: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2438: p_to_category_id IN NUMBER,
2439: p_change_categ_id IN VARCHAR2

Line 2501: p_bid_number IN pon_bid_headers.bid_number%TYPE

2497: -- ======================================================================
2498: PROCEDURE populate_has_bid_flag
2499: (
2500: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2501: p_bid_number IN pon_bid_headers.bid_number%TYPE
2502: ) IS
2503: l_full_qty_reqd VARCHAR2(1);
2504: BEGIN
2505:

Line 2613: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

2609: -- ======================================================================
2610: PROCEDURE create_new_draft_bid
2611: (
2612: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2613: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2614: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

Line 2614: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

2610: PROCEDURE create_new_draft_bid
2611: (
2612: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2613: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2614: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2618: p_userid IN pon_bid_headers.created_by%TYPE,

Line 2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

2611: (
2612: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2613: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2614: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2618: p_userid IN pon_bid_headers.created_by%TYPE,
2619: p_venid IN pon_bid_headers.vendor_id%TYPE,

Line 2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

2612: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2613: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2614: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2618: p_userid IN pon_bid_headers.created_by%TYPE,
2619: p_venid IN pon_bid_headers.vendor_id%TYPE,
2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

2613: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2614: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2618: p_userid IN pon_bid_headers.created_by%TYPE,
2619: p_venid IN pon_bid_headers.vendor_id%TYPE,
2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2621: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

Line 2618: p_userid IN pon_bid_headers.created_by%TYPE,

2614: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2618: p_userid IN pon_bid_headers.created_by%TYPE,
2619: p_venid IN pon_bid_headers.vendor_id%TYPE,
2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2621: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2622: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

Line 2619: p_venid IN pon_bid_headers.vendor_id%TYPE,

2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2618: p_userid IN pon_bid_headers.created_by%TYPE,
2619: p_venid IN pon_bid_headers.vendor_id%TYPE,
2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2621: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2622: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2623: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

Line 2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2618: p_userid IN pon_bid_headers.created_by%TYPE,
2619: p_venid IN pon_bid_headers.vendor_id%TYPE,
2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2621: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2622: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2623: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2624: p_buyer_user IN VARCHAR2,

Line 2621: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

2617: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2618: p_userid IN pon_bid_headers.created_by%TYPE,
2619: p_venid IN pon_bid_headers.vendor_id%TYPE,
2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2621: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2622: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2623: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2624: p_buyer_user IN VARCHAR2,
2625: p_new_round_or_amended IN VARCHAR2,

Line 2622: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

2618: p_userid IN pon_bid_headers.created_by%TYPE,
2619: p_venid IN pon_bid_headers.vendor_id%TYPE,
2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2621: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2622: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2623: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2624: p_buyer_user IN VARCHAR2,
2625: p_new_round_or_amended IN VARCHAR2,
2626: p_rebid_flag IN VARCHAR2,

Line 2623: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

2619: p_venid IN pon_bid_headers.vendor_id%TYPE,
2620: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2621: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2622: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2623: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2624: p_buyer_user IN VARCHAR2,
2625: p_new_round_or_amended IN VARCHAR2,
2626: p_rebid_flag IN VARCHAR2,
2627: p_prev_bid_disq IN VARCHAR2,

Line 2628: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

2624: p_buyer_user IN VARCHAR2,
2625: p_new_round_or_amended IN VARCHAR2,
2626: p_rebid_flag IN VARCHAR2,
2627: p_prev_bid_disq IN VARCHAR2,
2628: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
2629: x_return_status OUT NOCOPY NUMBER,
2630: x_return_code OUT NOCOPY VARCHAR2
2631: ) IS
2632: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;

Line 2635: l_source_bid_status pon_bid_headers.bid_status%TYPE;

2631: ) IS
2632: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
2633: l_restricted_flag VARCHAR2(1);
2634: l_rel12_draft VARCHAR2(1);
2635: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2636: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2637:
2638: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2639: l_batch_start pon_bid_item_prices.line_number%TYPE;

Line 2646: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;

2642: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2643: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2644: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2645: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2646: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2647: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2648: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2649:
2650:

Line 2647: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

2643: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2644: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2645: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2646: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2647: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2648: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2649:
2650:
2651: -- Two-part RFQ related variables

Line 2707: FROM pon_bid_headers bh

2703: IF (p_source_bid_num IS NOT null) THEN
2704:
2705: SELECT bh.auction_header_id
2706: INTO l_source_header_id
2707: FROM pon_bid_headers bh
2708: WHERE bh.bid_number = p_source_bid_num;
2709:
2710: -- get value of two-part flags for current and prev rounds
2711: select decode(pah.auction_header_id_prev_round, null, 'N', 'Y'),

Line 2747: (x_from_entity_name => 'PON_BID_HEADERS',

2743: log_message(l_module, 'Two-Part related variables: l_to_category_id: ' || l_to_category_id || '; l_categ_id_supp_tech: '||l_categ_id_supp_tech||'; l_categ_id_supp: ' || l_categ_id_supp);
2744:
2745: -- Copy header attachments to new target category
2746: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2747: (x_from_entity_name => 'PON_BID_HEADERS',
2748: x_from_pk1_value => l_source_header_id,
2749: x_from_pk2_value => p_source_bid_num,
2750: x_to_entity_name => 'PON_BID_HEADERS',
2751: x_to_pk1_value => p_auc_header_id,

Line 2750: x_to_entity_name => 'PON_BID_HEADERS',

2746: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2747: (x_from_entity_name => 'PON_BID_HEADERS',
2748: x_from_pk1_value => l_source_header_id,
2749: x_from_pk2_value => p_source_bid_num,
2750: x_to_entity_name => 'PON_BID_HEADERS',
2751: x_to_pk1_value => p_auc_header_id,
2752: x_to_pk2_value => x_bid_number,
2753: x_created_by => p_userid,
2754: x_last_update_login => fnd_global.login_id,

Line 2760: (x_from_entity_name => 'PON_BID_HEADERS',

2756:
2757: ELSE
2758: -- Copy header level attachments without changing categories
2759: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2760: (x_from_entity_name => 'PON_BID_HEADERS',
2761: x_from_pk1_value => l_source_header_id,
2762: x_from_pk2_value => p_source_bid_num,
2763: x_to_entity_name => 'PON_BID_HEADERS',
2764: x_to_pk1_value => p_auc_header_id,

Line 2763: x_to_entity_name => 'PON_BID_HEADERS',

2759: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2760: (x_from_entity_name => 'PON_BID_HEADERS',
2761: x_from_pk1_value => l_source_header_id,
2762: x_from_pk2_value => p_source_bid_num,
2763: x_to_entity_name => 'PON_BID_HEADERS',
2764: x_to_pk1_value => p_auc_header_id,
2765: x_to_pk2_value => x_bid_number,
2766: x_created_by => p_userid,
2767: x_last_update_login => fnd_global.login_id);

Line 2801: FROM pon_bid_headers bh,

2797: bh.surrog_bid_flag
2798: INTO g_curr_prec,
2799: g_bid_rate,
2800: l_surrog_bid_flag
2801: FROM pon_bid_headers bh,
2802: fnd_currencies cu
2803: WHERE bh.bid_number = x_bid_number
2804: AND cu.currency_code = bh.bid_currency_code;
2805:

Line 2988: from pon_bid_headers

2984: -- created. Maybe from a different session
2985: BEGIN
2986: select bid_number
2987: into l_other_draft_bid_number
2988: from pon_bid_headers
2989: where auction_header_id = p_auc_header_id
2990: and bid_number <> x_bid_number
2991: and bid_status = 'DRAFT'
2992: and trading_partner_id = p_tpid

Line 3024: UPDATE pon_bid_headers bh

3020: -- END BATCHING
3021:
3022: -- Populate header level display_price_factors_flag
3023: -- It is 'Y' if any line has the line level flag set
3024: UPDATE pon_bid_headers bh
3025: SET bh.display_price_factors_flag =
3026: nvl((SELECT 'Y'
3027: FROM pon_bid_item_prices bl
3028: WHERE bl.bid_number = bh.bid_number

Line 3048: p_bid_number IN pon_bid_headers.bid_number%TYPE,

3044: -- As such, they need to be expanded to include them
3045: -- ======================================================================
3046: PROCEDURE expand_draft
3047: (
3048: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3049: x_rebid_flag OUT NOCOPY VARCHAR2
3050: ) IS
3051: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3052:

Line 3051: l_source_bid_num pon_bid_headers.bid_number%TYPE;

3047: (
3048: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3049: x_rebid_flag OUT NOCOPY VARCHAR2
3050: ) IS
3051: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3052:
3053: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3054: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;

Line 3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;

3051: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3052:
3053: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3054: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3056: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3057: l_userid pon_bid_headers.created_by%TYPE;
3058: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3059: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

Line 3056: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

3052:
3053: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3054: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3056: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3057: l_userid pon_bid_headers.created_by%TYPE;
3058: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3059: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
3060: l_has_pe_flag VARCHAR2(1);

Line 3057: l_userid pon_bid_headers.created_by%TYPE;

3053: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3054: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3056: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3057: l_userid pon_bid_headers.created_by%TYPE;
3058: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3059: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
3060: l_has_pe_flag VARCHAR2(1);
3061: l_blanket VARCHAR2(1);

Line 3058: l_vensid pon_bid_headers.vendor_site_id%TYPE;

3054: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3056: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3057: l_userid pon_bid_headers.created_by%TYPE;
3058: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3059: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
3060: l_has_pe_flag VARCHAR2(1);
3061: l_blanket VARCHAR2(1);
3062: l_full_qty VARCHAR2(1);

Line 3063: l_rate pon_bid_headers.rate%TYPE;

3059: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
3060: l_has_pe_flag VARCHAR2(1);
3061: l_blanket VARCHAR2(1);
3062: l_full_qty VARCHAR2(1);
3063: l_rate pon_bid_headers.rate%TYPE;
3064: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3065: l_curr_prec fnd_currencies.precision%TYPE;
3066:
3067: l_max_line_number pon_bid_item_prices.line_number%TYPE;

Line 3064: l_price_prec pon_bid_headers.number_price_decimals%TYPE;

3060: l_has_pe_flag VARCHAR2(1);
3061: l_blanket VARCHAR2(1);
3062: l_full_qty VARCHAR2(1);
3063: l_rate pon_bid_headers.rate%TYPE;
3064: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3065: l_curr_prec fnd_currencies.precision%TYPE;
3066:
3067: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3068: l_batch_start pon_bid_item_prices.line_number%TYPE;

Line 3098: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu

3094: l_userid,
3095: l_rate,
3096: l_price_prec,
3097: l_curr_prec
3098: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu
3099: WHERE bh.bid_number = p_bid_number
3100: AND ah.auction_header_id = bh.auction_header_id
3101: AND cu.currency_code = bh.bid_currency_code;
3102:

Line 3129: FROM pon_bid_headers bh

3125: -- Since there can only exist a single ACTIVE bid on an amendment for
3126: -- a particular user on a site, we use the rownum = 1 optimisation
3127: SELECT bh.bid_number, 'Y'
3128: INTO l_source_bid_num, x_rebid_flag
3129: FROM pon_bid_headers bh
3130: WHERE bh.auction_header_id = l_auc_header_id
3131: AND bh.trading_partner_id = l_tpid
3132: AND bh.trading_partner_contact_id = l_tpcid
3133: AND bh.vendor_site_id = l_vensid

Line 3205: UPDATE pon_bid_headers bh

3201: -- END BATCHING
3202:
3203: -- Populate header level display_price_factors_flag
3204: -- It is 'Y' if any line has the line level flag set
3205: UPDATE pon_bid_headers bh
3206: SET bh.display_price_factors_flag =
3207: nvl((SELECT 'Y'
3208: FROM pon_bid_item_prices bl
3209: WHERE bl.bid_number = bh.bid_number

Line 3220: update pon_bid_headers

3216: (l_auc_header_id,
3217: p_bid_number);
3218:
3219: /* once we have finished upgrading the draft, reset the flag to Y */
3220: update pon_bid_headers
3221: set rel12_draft_flag = 'Y'
3222: where bid_number = p_bid_number;
3223:
3224: -- handle_proxy will be called in check_and_load_bid

Line 3241: p_bid_number IN pon_bid_headers.bid_number%TYPE,

3237: -- COMMENT: If the bid is not locked by another user, it is locked.
3238: -- ======================================================================
3239: PROCEDURE lock_draft
3240: (
3241: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3242: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3243: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3244: x_return_status OUT NOCOPY NUMBER,
3245: x_return_code OUT NOCOPY VARCHAR2

Line 3242: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

3238: -- ======================================================================
3239: PROCEDURE lock_draft
3240: (
3241: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3242: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3243: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3244: x_return_status OUT NOCOPY NUMBER,
3245: x_return_code OUT NOCOPY VARCHAR2
3246: ) IS

Line 3243: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

3239: PROCEDURE lock_draft
3240: (
3241: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3242: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3243: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3244: x_return_status OUT NOCOPY NUMBER,
3245: x_return_code OUT NOCOPY VARCHAR2
3246: ) IS
3247: l_draft_locked pon_bid_headers.draft_locked%TYPE;

Line 3247: l_draft_locked pon_bid_headers.draft_locked%TYPE;

3243: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3244: x_return_status OUT NOCOPY NUMBER,
3245: x_return_code OUT NOCOPY VARCHAR2
3246: ) IS
3247: l_draft_locked pon_bid_headers.draft_locked%TYPE;
3248: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3249: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3250: BEGIN
3251:

Line 3248: l_tpid pon_bid_headers.trading_partner_id%TYPE;

3244: x_return_status OUT NOCOPY NUMBER,
3245: x_return_code OUT NOCOPY VARCHAR2
3246: ) IS
3247: l_draft_locked pon_bid_headers.draft_locked%TYPE;
3248: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3249: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3250: BEGIN
3251:
3252: -- pull up draft lock info

Line 3249: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

3245: x_return_code OUT NOCOPY VARCHAR2
3246: ) IS
3247: l_draft_locked pon_bid_headers.draft_locked%TYPE;
3248: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3249: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3250: BEGIN
3251:
3252: -- pull up draft lock info
3253: SELECT draft_locked, draft_locked_by, draft_locked_by_contact_id

Line 3255: FROM pon_bid_headers

3251:
3252: -- pull up draft lock info
3253: SELECT draft_locked, draft_locked_by, draft_locked_by_contact_id
3254: INTO l_draft_locked, l_tpid, l_tpcid
3255: FROM pon_bid_headers
3256: WHERE bid_number = p_bid_number;
3257:
3258: -- If the draft is locked by another user, return an error
3259: IF (l_draft_locked = 'Y' AND (p_tpid <> l_tpid OR p_tpcid <> l_tpcid)) THEN

Line 3268: UPDATE pon_bid_headers

3264:
3265: -- If the draft is not locked, lock it
3266: ELSIF (l_draft_locked = 'N') THEN
3267:
3268: UPDATE pon_bid_headers
3269: SET draft_locked = 'Y',
3270: draft_locked_by = p_tpid,
3271: draft_locked_by_contact_id = p_tpcid,
3272: draft_locked_date = sysdate

Line 3418: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

3414: -- ======================================================================
3415: PROCEDURE is_bidding_allowed
3416: (
3417: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3418: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3419: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3420: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3421: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3422: p_buyer_user IN VARCHAR2,

Line 3419: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

3415: PROCEDURE is_bidding_allowed
3416: (
3417: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3418: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3419: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3420: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3421: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3422: p_buyer_user IN VARCHAR2,
3423: p_action_code IN VARCHAR2,

Line 3420: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

3416: (
3417: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3418: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3419: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3420: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3421: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3422: p_buyer_user IN VARCHAR2,
3423: p_action_code IN VARCHAR2,
3424: x_return_status OUT NOCOPY NUMBER,

Line 3421: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

3417: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3418: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3419: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3420: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3421: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3422: p_buyer_user IN VARCHAR2,
3423: p_action_code IN VARCHAR2,
3424: x_return_status OUT NOCOPY NUMBER,
3425: x_return_code OUT NOCOPY VARCHAR2

Line 3532: FROM pon_bid_headers bh

3528: -- to publish
3529: BEGIN
3530: SELECT bid_number
3531: INTO l_bid_number
3532: FROM pon_bid_headers bh
3533: WHERE bh.auction_header_id = p_auc_header_id
3534: AND bh.trading_partner_id = p_tpid
3535: AND bh.trading_partner_contact_id = p_tpcid
3536: AND bh.vendor_site_id = p_vensid

Line 3550: FROM pon_bid_headers bh, po_vendors pov

3546: -- Supplier should not be invalid
3547: BEGIN
3548: SELECT nvl(pov.end_date_active, sysdate)
3549: INTO l_supp_end_date
3550: FROM pon_bid_headers bh, po_vendors pov
3551: WHERE bh.auction_header_id = p_auc_header_id
3552: AND bh.trading_partner_id = p_tpid
3553: AND bh.trading_partner_contact_id = p_tpcid
3554: AND bh.vendor_site_id = p_vensid

Line 3610: FROM pon_bid_headers

3606:
3607: -- Do an existence check
3608: SELECT decode(count(auction_header_id), 0, 'N', 'Y')
3609: INTO l_has_bid_flag
3610: FROM pon_bid_headers
3611: WHERE auction_header_id = p_auc_header_id
3612: AND trading_partner_id = p_tpid
3613: AND vendor_site_id = p_vensid
3614: AND bid_status = 'ACTIVE';

Line 3632: FROM pon_bid_headers

3628: -- time. We will have this check during submit bid anyways
3629:
3630: SELECT decode(count(auction_header_id), 0, 'N', 'Y')
3631: INTO l_has_draft_flag
3632: FROM pon_bid_headers
3633: WHERE auction_header_id = p_auc_header_id
3634: AND trading_partner_id = p_tpid
3635: AND trading_partner_contact_id <> p_tpcid
3636: AND vendor_site_id = p_vensid

Line 3651: FROM pon_bid_headers bh, pon_auction_headers_all ah

3647: -- Check if a buyer/supplier has already placed a bid on the round
3648: -- I.e. check for surrog bid if supplier, or a supplier bid if buyer
3649: SELECT decode(count(bh.auction_header_id), 0, 'N', 'Y')
3650: INTO l_has_surrog_flag
3651: FROM pon_bid_headers bh, pon_auction_headers_all ah
3652: WHERE ah.auction_header_id_orig_amend = l_orig_amend_id
3653: AND bh.auction_header_id = ah.auction_header_id
3654: AND bh.trading_partner_id = p_tpid
3655: AND bh.trading_partner_contact_id = p_tpcid

Line 3698: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

3694: -- ======================================================================
3695: PROCEDURE get_source_bid
3696: (
3697: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3698: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3699: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3701: p_action_code IN VARCHAR2,
3702:

Line 3699: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

3695: PROCEDURE get_source_bid
3696: (
3697: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3698: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3699: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3701: p_action_code IN VARCHAR2,
3702:
3703: x_rebid_flag OUT NOCOPY VARCHAR2,

Line 3700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

3696: (
3697: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3698: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3699: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3701: p_action_code IN VARCHAR2,
3702:
3703: x_rebid_flag OUT NOCOPY VARCHAR2,
3704: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

Line 3704: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

3700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3701: p_action_code IN VARCHAR2,
3702:
3703: x_rebid_flag OUT NOCOPY VARCHAR2,
3704: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
3705: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
3706: x_amend_bid_def OUT NOCOPY VARCHAR2,
3707: x_round_bid_def OUT NOCOPY VARCHAR2,
3708: x_prev_bid_disq OUT NOCOPY VARCHAR2,

Line 3705: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

3701: p_action_code IN VARCHAR2,
3702:
3703: x_rebid_flag OUT NOCOPY VARCHAR2,
3704: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
3705: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
3706: x_amend_bid_def OUT NOCOPY VARCHAR2,
3707: x_round_bid_def OUT NOCOPY VARCHAR2,
3708: x_prev_bid_disq OUT NOCOPY VARCHAR2,
3709: x_return_status OUT NOCOPY NUMBER,

Line 3714: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;

3710: x_return_code OUT NOCOPY VARCHAR2
3711: ) IS
3712: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
3713: l_status_order NUMBER;
3714: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
3715:
3716: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
3717: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
3718:

Line 3721: l_ignored_return pon_bid_headers.bid_number%TYPE;

3717: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
3718:
3719: l_terms_cond_apply VARCHAR2(1);
3720:
3721: l_ignored_return pon_bid_headers.bid_number%TYPE;
3722:
3723: -- select bids on all amendments/previous round by the current user for the current site
3724: CURSOR current_users_bids IS
3725: SELECT bh.bid_number,

Line 3737: FROM pon_bid_headers bh, pon_auction_headers_all ah

3733: decode(ah.auction_header_id_orig_amend, l_orig_amend_id, 'Y', 'N')) prev_amend_def,
3734:
3735: decode(bh.bid_status, 'DISQUALIFIED', 'Y', 'N') prev_bid_disq,
3736: nvl(bh.rel12_draft_flag, 'N') rel12_draft_flag
3737: FROM pon_bid_headers bh, pon_auction_headers_all ah
3738: WHERE
3739: -- look at all amendments on the current round
3740: (ah.auction_header_id_orig_amend = l_orig_amend_id
3741: -- look at all amendments on the previous round

Line 3764: FROM pon_bid_headers bh, pon_auction_headers_all ah

3760: 'ACTIVE', 'SINGLE_BEST_BID'),
3761: decode(bh.bid_status, 'DRAFT', 'OTHER_USERS_DRAFT',
3762: 'ACTIVE', 'OTHER_USERS_ACTIVE')),
3763: 'OTHER_USERS_PREV_ROUND') return_code
3764: FROM pon_bid_headers bh, pon_auction_headers_all ah
3765: WHERE
3766: -- look at the current amendment
3767: (ah.auction_header_id = p_auc_header_id
3768: AND bh.bid_status IN ('DRAFT', 'ACTIVE')

Line 3822: UPDATE pon_bid_headers

3818:
3819: -- draft is on a previous amendment/round
3820: ELSE
3821: -- Need to archive the previous amend/round DRAFT bid
3822: UPDATE pon_bid_headers
3823: SET bid_status = 'ARCHIVED_DRAFT',
3824: last_update_date = sysdate
3825: WHERE bid_number = x_prev_bid_number;
3826:

Line 3895: p_source_bid IN pon_bid_headers.bid_number%TYPE,

3891: -- ======================================================================
3892: PROCEDURE create_defaulted_draft
3893: (
3894: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3895: p_source_bid IN pon_bid_headers.bid_number%TYPE,
3896: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
3897: ) IS
3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

Line 3896: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE

3892: PROCEDURE create_defaulted_draft
3893: (
3894: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3895: p_source_bid IN pon_bid_headers.bid_number%TYPE,
3896: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
3897: ) IS
3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;

Line 3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;

3894: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3895: p_source_bid IN pon_bid_headers.bid_number%TYPE,
3896: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
3897: ) IS
3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;
3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
3902: l_userid pon_bid_headers.created_by%TYPE;

Line 3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

3895: p_source_bid IN pon_bid_headers.bid_number%TYPE,
3896: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
3897: ) IS
3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;
3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
3902: l_userid pon_bid_headers.created_by%TYPE;
3903: l_venid pon_bid_headers.vendor_id%TYPE;

Line 3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;

3896: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
3897: ) IS
3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;
3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
3902: l_userid pon_bid_headers.created_by%TYPE;
3903: l_venid pon_bid_headers.vendor_id%TYPE;
3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;

Line 3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;

3897: ) IS
3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;
3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
3902: l_userid pon_bid_headers.created_by%TYPE;
3903: l_venid pon_bid_headers.vendor_id%TYPE;
3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3905: l_venscode pon_bid_headers.vendor_site_code%TYPE;

Line 3902: l_userid pon_bid_headers.created_by%TYPE;

3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;
3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
3902: l_userid pon_bid_headers.created_by%TYPE;
3903: l_venid pon_bid_headers.vendor_id%TYPE;
3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3905: l_venscode pon_bid_headers.vendor_site_code%TYPE;
3906: l_buyer_user VARCHAR2(1);

Line 3903: l_venid pon_bid_headers.vendor_id%TYPE;

3899: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;
3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
3902: l_userid pon_bid_headers.created_by%TYPE;
3903: l_venid pon_bid_headers.vendor_id%TYPE;
3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3905: l_venscode pon_bid_headers.vendor_site_code%TYPE;
3906: l_buyer_user VARCHAR2(1);
3907: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;

Line 3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;

3900: l_tpname pon_bid_headers.trading_partner_name%TYPE;
3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
3902: l_userid pon_bid_headers.created_by%TYPE;
3903: l_venid pon_bid_headers.vendor_id%TYPE;
3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3905: l_venscode pon_bid_headers.vendor_site_code%TYPE;
3906: l_buyer_user VARCHAR2(1);
3907: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
3908: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;

Line 3905: l_venscode pon_bid_headers.vendor_site_code%TYPE;

3901: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
3902: l_userid pon_bid_headers.created_by%TYPE;
3903: l_venid pon_bid_headers.vendor_id%TYPE;
3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3905: l_venscode pon_bid_headers.vendor_site_code%TYPE;
3906: l_buyer_user VARCHAR2(1);
3907: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
3908: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
3909:

Line 3907: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;

3903: l_venid pon_bid_headers.vendor_id%TYPE;
3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3905: l_venscode pon_bid_headers.vendor_site_code%TYPE;
3906: l_buyer_user VARCHAR2(1);
3907: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
3908: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
3909:
3910: l_rebid_flag VARCHAR2(1);
3911: l_prev_bid_disq VARCHAR2(1);

Line 3908: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;

3904: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3905: l_venscode pon_bid_headers.vendor_site_code%TYPE;
3906: l_buyer_user VARCHAR2(1);
3907: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
3908: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
3909:
3910: l_rebid_flag VARCHAR2(1);
3911: l_prev_bid_disq VARCHAR2(1);
3912: l_new_round_or_amended VARCHAR2(1);

Line 3953: FROM pon_bid_headers bh

3949: l_venscode,
3950: l_auctpid,
3951: l_auctpcid,
3952: l_buyer_user
3953: FROM pon_bid_headers bh
3954: WHERE bh.bid_number = p_source_bid;
3955:
3956: -- Create the new bid
3957: create_new_draft_bid

Line 3981: UPDATE pon_bid_headers bh

3977:
3978: -- Update the status of the previous bid
3979: -- NOTE: if this procedure is used for cases other than spreadsheet upload
3980: -- on a DRAFT after an amendment, the status will need to be set correctly
3981: UPDATE pon_bid_headers bh
3982: SET bh.bid_status = decode('DRAFT', 'ARCHIVED_DRAFT', bh.bid_status)
3983: WHERE bh.bid_number = p_source_bid;
3984:
3985: END create_defaulted_draft;

Line 4023: p_draft_number IN pon_bid_headers.bid_number%TYPE,

4019: -- ======================================================================
4020: PROCEDURE check_and_load_bid
4021: (
4022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4023: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4024: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

Line 4024: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

4020: PROCEDURE check_and_load_bid
4021: (
4022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4023: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4024: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4028: p_userid IN pon_bid_headers.created_by%TYPE,

Line 4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

4021: (
4022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4023: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4024: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4028: p_userid IN pon_bid_headers.created_by%TYPE,
4029: p_venid IN pon_bid_headers.vendor_id%TYPE,

Line 4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

4022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4023: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4024: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4028: p_userid IN pon_bid_headers.created_by%TYPE,
4029: p_venid IN pon_bid_headers.vendor_id%TYPE,
4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

4023: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4024: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4028: p_userid IN pon_bid_headers.created_by%TYPE,
4029: p_venid IN pon_bid_headers.vendor_id%TYPE,
4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4031: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

Line 4028: p_userid IN pon_bid_headers.created_by%TYPE,

4024: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4028: p_userid IN pon_bid_headers.created_by%TYPE,
4029: p_venid IN pon_bid_headers.vendor_id%TYPE,
4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4031: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4032: p_buyer_user IN VARCHAR2,

Line 4029: p_venid IN pon_bid_headers.vendor_id%TYPE,

4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4028: p_userid IN pon_bid_headers.created_by%TYPE,
4029: p_venid IN pon_bid_headers.vendor_id%TYPE,
4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4031: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4032: p_buyer_user IN VARCHAR2,
4033: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

Line 4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4028: p_userid IN pon_bid_headers.created_by%TYPE,
4029: p_venid IN pon_bid_headers.vendor_id%TYPE,
4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4031: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4032: p_buyer_user IN VARCHAR2,
4033: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4034: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

Line 4031: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

4027: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4028: p_userid IN pon_bid_headers.created_by%TYPE,
4029: p_venid IN pon_bid_headers.vendor_id%TYPE,
4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4031: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4032: p_buyer_user IN VARCHAR2,
4033: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4034: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4035:

Line 4033: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

4029: p_venid IN pon_bid_headers.vendor_id%TYPE,
4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4031: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4032: p_buyer_user IN VARCHAR2,
4033: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4034: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4035:
4036: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4037: x_rebid_flag OUT NOCOPY VARCHAR2,

Line 4034: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

4030: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4031: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4032: p_buyer_user IN VARCHAR2,
4033: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4034: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4035:
4036: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4037: x_rebid_flag OUT NOCOPY VARCHAR2,
4038: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

Line 4036: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

4032: p_buyer_user IN VARCHAR2,
4033: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4034: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4035:
4036: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4037: x_rebid_flag OUT NOCOPY VARCHAR2,
4038: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4039: x_amend_bid_def OUT NOCOPY VARCHAR2,
4040: x_round_bid_def OUT NOCOPY VARCHAR2,

Line 4038: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

4034: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4035:
4036: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4037: x_rebid_flag OUT NOCOPY VARCHAR2,
4038: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4039: x_amend_bid_def OUT NOCOPY VARCHAR2,
4040: x_round_bid_def OUT NOCOPY VARCHAR2,
4041: x_prev_bid_disq OUT NOCOPY VARCHAR2,
4042: x_edit_draft OUT NOCOPY VARCHAR2,

Line 4048: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;

4044: p_action_code IN VARCHAR2,
4045: x_return_status OUT NOCOPY NUMBER,
4046: x_return_code OUT NOCOPY VARCHAR2
4047: ) IS
4048: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
4049: l_new_round_or_amended VARCHAR2(1);
4050:
4051: l_temp_num NUMBER;
4052: BEGIN

Line 4120: FROM pon_bid_headers bh

4116:
4117: -- If it is a pre-release 12 draft, we need to expand it
4118: SELECT nvl(bh.rel12_draft_flag, 'N') rel12_draft_flag
4119: INTO l_rel12_draft
4120: FROM pon_bid_headers bh
4121: WHERE bh.bid_number = p_draft_number;
4122:
4123: -- If the draft is pre-release 12 we need to fill in the missing lines
4124: IF (l_rel12_draft <> 'Y') THEN

Line 4321: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

4317: FUNCTION get_source_bid_for_spreadsheet
4318: (
4319: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4320: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
4321: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4322: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4323: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
4324: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
4325: p_vensid IN pon_bid_headers.vendor_site_id%TYPE

Line 4322: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

4318: (
4319: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4320: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
4321: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4322: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4323: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
4324: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
4325: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
4326:

Line 4325: p_vensid IN pon_bid_headers.vendor_site_id%TYPE

4321: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4322: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4323: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
4324: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
4325: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
4326:
4327: ) RETURN NUMBER IS
4328:
4329: CURSOR current_amendment_bids IS

Line 4331: from pon_bid_headers

4327: ) RETURN NUMBER IS
4328:
4329: CURSOR current_amendment_bids IS
4330: select bid_number
4331: from pon_bid_headers
4332: where auction_header_id = p_auc_header_id
4333: and trading_partner_id = p_tpid
4334: and trading_partner_contact_id = p_tpcid
4335: and nvl(vendor_site_id, -1) = nvl(p_vensid, -1)

Line 4344: pon_bid_headers bh,

4340:
4341: CURSOR previous_amendments_bids IS
4342: select bh.bid_number
4343: from
4344: pon_bid_headers bh,
4345: pon_auction_headers_all ah
4346: where
4347: bh.auction_header_id = ah.auction_header_id
4348: and ah.auction_header_id_orig_amend = p_auc_header_id_orig_amend

Line 4384: from pon_bid_headers bh,

4380: -- try to find an active bid from previous round
4381:
4382: select max(bid_number) prev_round_bid
4383: into x_prev_bid_number
4384: from pon_bid_headers bh,
4385: pon_auction_headers_all ah,
4386: pon_auction_headers_all ah2
4387: where bh.auction_header_id = ah.auction_header_id
4388: and ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend

Line 4563: pon_bid_headers pbh

4559: )
4560: INTO l_auc_pf_unit_price
4561: FROM pon_pf_supplier_formula ppsf,
4562: pon_auction_item_prices_all aip,
4563: pon_bid_headers pbh
4564: WHERE ppsf.auction_header_id = p_auction_header_id
4565: AND ppsf.line_number = p_line_number
4566: AND ppsf.trading_partner_id = pbh.trading_partner_id
4567: AND ppsf.vendor_site_id = pbh.vendor_site_id