1 PACKAGE PON_TRANSFORM_BIDDING_PKG AUTHID CURRENT_USER AS
2 -- $Header: PONTFBDS.pls 120.2.12020000.2 2013/02/09 10:49:24 hvutukur ship $
3 --===================
4 -- PROCEDURES
5 --===================
6
7 FUNCTION find_user_site
8 (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
9 p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
10 p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)
11 RETURN NUMBER;
12
13
14 FUNCTION check_est_qty_on_all_bid_lines
15 (p_auction_header_id IN NUMBER,
16 p_bid_number IN NUMBER) RETURN VARCHAR2;
17
18 FUNCTION calculate_supplier_bid_total
19 (p_auction_header_id IN NUMBER,
20 p_bid_number IN NUMBER,
21 p_outcome IN pon_auction_headers_all.contract_type%TYPE,
22 p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
23 p_tpid IN NUMBER,
24 p_site IN NUMBER) RETURN NUMBER;
25
26 FUNCTION calculate_bid_total
27 (p_auction_header_id IN NUMBER,
28 p_bid_number IN NUMBER,
29 p_tpid IN NUMBER,
30 p_site IN NUMBER) RETURN NUMBER;
31
32 /* Offer Enhancements Start */
33 FUNCTION calc_btotal_with_out_ol
34 (p_auction_header_id IN NUMBER,
35 p_bid_number IN NUMBER,
36 p_tpid IN NUMBER,
37 p_site IN NUMBER) RETURN NUMBER;
38
39 FUNCTION calc_sup_btotal_with_out_ol
40 (p_auction_header_id IN NUMBER,
41 p_bid_number IN NUMBER,
42 p_outcome IN pon_auction_headers_all.contract_type%TYPE,
43 p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
44 p_tpid IN NUMBER,
45 p_site IN NUMBER) RETURN NUMBER;
46
47 /* Offer Enhancements End */
48
49
50 FUNCTION calculate_price
51 (p_auction_header_id IN NUMBER,
52 p_line_number IN NUMBER,
53 p_price IN NUMBER,
54 p_quantity IN NUMBER,
55 p_tpid IN NUMBER,
56 p_tpcid IN NUMBER,
57 p_site IN NUMBER,
58 p_requested_supplier_id IN NUMBER)
59 RETURN NUMBER;
60
61 FUNCTION calculate_price
62 (p_auction_header_id IN NUMBER,
63 p_line_number IN NUMBER,
64 p_price IN NUMBER,
65 p_quantity IN NUMBER,
66 p_tpid IN NUMBER,
67 p_tpcid IN NUMBER,
68 p_site IN NUMBER)
69 RETURN NUMBER;
70
71 FUNCTION calculate_price
72 (p_auction_header_id IN NUMBER,
73 p_line_number IN NUMBER,
74 p_price IN NUMBER,
75 p_quantity IN NUMBER,
76 p_tpid IN NUMBER,
77 p_site IN NUMBER)
78 RETURN NUMBER;
79
80 FUNCTION untransform_one_price
81 (p_auction_header_id IN NUMBER,
82 p_line_number IN NUMBER,
83 p_price IN NUMBER,
84 p_quantity IN NUMBER,
85 p_tpid IN NUMBER,
86 p_site_id IN NUMBER)
87 RETURN NUMBER;
88
89 FUNCTION untransform_one_price
90 (p_auction_header_id IN NUMBER,
91 p_line_number IN NUMBER,
92 p_price IN NUMBER,
93 p_quantity IN NUMBER,
94 p_tpid IN NUMBER,
95 p_site_id IN NUMBER,
96 p_requested_supplier_id IN NUMBER)
97 RETURN NUMBER;
98
99 FUNCTION calculate_quote_amount
100 (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
101 p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
102 p_bid_number IN pon_bid_headers.bid_number%TYPE,
103 p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
104 p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
105 p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
106 p_site IN pon_bid_headers.vendor_site_id%TYPE)
107 RETURN NUMBER;
108
109 FUNCTION has_pf_values_defined
110 (p_auction_header_id IN NUMBER,
111 p_line_number IN NUMBER,
112 p_pf_seq_number IN NUMBER,
113 p_trading_partner_id IN NUMBER,
114 p_vendor_site_id IN NUMBER) RETURN VARCHAR2;
115
116 FUNCTION has_pf_values_defined
117 (p_auction_header_id IN NUMBER,
118 p_line_number IN NUMBER,
119 p_pf_seq_number IN NUMBER,
120 p_trading_partner_id IN NUMBER,
121 p_vendor_site_id IN NUMBER,
122 p_requested_supplier_id IN NUMBER) RETURN VARCHAR2;
123
124 PROCEDURE GET_DISPLAY_CURRENCY_INFO (p_auction_header_id IN NUMBER,
125 p_trading_partner_id IN NUMBER,
126 p_vendor_site_id IN NUMBER,
127 p_trading_partner_contact_id IN NUMBER,
128 p_is_buyer IN VARCHAR2,
129 x_currency OUT NOCOPY VARCHAR2,
130 x_rate OUT NOCOPY NUMBER,
131 x_precision OUT NOCOPY NUMBER,
132 x_currency_precision OUT NOCOPY NUMBER,
133 x_site_id OUT NOCOPY NUMBER,
134 x_bid_number OUT NOCOPY NUMBER,
135 x_bid_status OUT NOCOPY VARCHAR2);
136
137 --Staggered Awards Project
138 FUNCTION get_unawarded_bid_total(p_auction_header_id NUMBER,
139 p_bid_number NUMBER) RETURN NUMBER;
140
141 END PON_TRANSFORM_BIDDING_PKG;