1 PACKAGE PON_TRANSFORM_BIDDING_PKG AS
2 -- $Header: PONTFBDS.pls 120.1 2005/06/17 16:03:08 dgallant noship $
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 FUNCTION calculate_price
33 (p_auction_header_id IN NUMBER,
34 p_line_number IN NUMBER,
35 p_price IN NUMBER,
36 p_quantity IN NUMBER,
37 p_tpid IN NUMBER,
38 p_tpcid IN NUMBER,
39 p_site IN NUMBER,
40 p_requested_supplier_id IN NUMBER)
41 RETURN NUMBER;
42
43 FUNCTION calculate_price
44 (p_auction_header_id IN NUMBER,
45 p_line_number IN NUMBER,
46 p_price IN NUMBER,
47 p_quantity IN NUMBER,
48 p_tpid IN NUMBER,
49 p_tpcid IN NUMBER,
50 p_site IN NUMBER)
51 RETURN NUMBER;
52
53 FUNCTION calculate_price
54 (p_auction_header_id IN NUMBER,
55 p_line_number IN NUMBER,
56 p_price IN NUMBER,
57 p_quantity IN NUMBER,
58 p_tpid IN NUMBER,
59 p_site IN NUMBER)
60 RETURN NUMBER;
61
62 FUNCTION untransform_one_price
63 (p_auction_header_id IN NUMBER,
64 p_line_number IN NUMBER,
65 p_price IN NUMBER,
66 p_quantity IN NUMBER,
67 p_tpid IN NUMBER,
68 p_site_id IN NUMBER)
69 RETURN NUMBER;
70
71 FUNCTION untransform_one_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_id IN NUMBER,
78 p_requested_supplier_id IN NUMBER)
79 RETURN NUMBER;
80
81 FUNCTION calculate_quote_amount
82 (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
83 p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
84 p_bid_number IN pon_bid_headers.bid_number%TYPE,
85 p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
86 p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
87 p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88 p_site IN pon_bid_headers.vendor_site_id%TYPE)
89 RETURN NUMBER;
90
91 FUNCTION has_pf_values_defined
92 (p_auction_header_id IN NUMBER,
93 p_line_number IN NUMBER,
94 p_pf_seq_number IN NUMBER,
95 p_trading_partner_id IN NUMBER,
96 p_vendor_site_id IN NUMBER) RETURN VARCHAR2;
97
98 FUNCTION has_pf_values_defined
99 (p_auction_header_id IN NUMBER,
100 p_line_number IN NUMBER,
101 p_pf_seq_number IN NUMBER,
102 p_trading_partner_id IN NUMBER,
103 p_vendor_site_id IN NUMBER,
104 p_requested_supplier_id IN NUMBER) RETURN VARCHAR2;
105
106 PROCEDURE GET_DISPLAY_CURRENCY_INFO (p_auction_header_id IN NUMBER,
107 p_trading_partner_id IN NUMBER,
108 p_vendor_site_id IN NUMBER,
109 p_trading_partner_contact_id IN NUMBER,
110 p_is_buyer IN VARCHAR2,
111 x_currency OUT NOCOPY VARCHAR2,
112 x_rate OUT NOCOPY NUMBER,
113 x_precision OUT NOCOPY NUMBER,
114 x_currency_precision OUT NOCOPY NUMBER,
115 x_site_id OUT NOCOPY NUMBER,
116 x_bid_number OUT NOCOPY NUMBER,
117 x_bid_status OUT NOCOPY VARCHAR2);
118
119
120 END PON_TRANSFORM_BIDDING_PKG;