[Home] [Help]
PACKAGE: APPS.PON_BID_VALIDATIONS_PKG
Source
1 PACKAGE PON_BID_VALIDATIONS_PKG AUTHID CURRENT_USER AS
2 --$Header: PONBDVLS.pls 120.3 2007/02/01 00:41:25 mxfang ship $
3
4 g_online_mode CONSTANT VARCHAR2(3) := 'ONL';
5 g_xml_upload_mode CONSTANT VARCHAR2(3) := 'XML';
6 g_txt_upload_mode CONSTANT VARCHAR2(3) := 'TXT';
7
8 FUNCTION GET_MASK
9 ( p_precision in NUMBER
10 ) RETURN VARCHAR2;
11
12 FUNCTION FORMAT_PRICE
13 ( p_price in NUMBER,
14 p_format_mask in VARCHAR2,
15 p_precision IN NUMBER
16 ) RETURN VARCHAR2;
17
18 FUNCTION validate_price_precision
19 (
20 p_number IN NUMBER,
21 p_precision IN NUMBER
22 ) RETURN VARCHAR2;
23
24 FUNCTION validate_currency_precision
25 (
26 p_number IN NUMBER,
27 p_precision IN NUMBER
28 ) RETURN VARCHAR2;
29
30 PROCEDURE validate_bid
31 (
32 p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
33 p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
34 p_interface_type IN pon_interface_errors.interface_type%TYPE,
35 p_userid IN pon_interface_errors.created_by%TYPE,
36 p_batch_id IN pon_interface_errors.batch_id%TYPE,
37 p_request_id IN pon_interface_errors.request_id%TYPE,
38 x_return_status OUT NOCOPY NUMBER,
39 x_return_code OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE validate_spreadsheet_upload
43 (
44 p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
45 p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
46 p_interface_type IN pon_interface_errors.interface_type%TYPE,
47 p_spreadsheet_type IN VARCHAR2,
48 p_userid IN pon_interface_errors.created_by%TYPE,
49 p_batch_id IN pon_interface_errors.batch_id%TYPE,
50 p_request_id IN pon_interface_errors.request_id%TYPE,
51 x_return_status OUT NOCOPY NUMBER,
52 x_return_code OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE populate_has_bid_changed_line
56 (
57 p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
58 p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
59 p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
60 p_batch_start IN NUMBER,
61 p_batch_end IN NUMBER,
62 p_rebid_flag IN VARCHAR2,
63 p_blanket IN VARCHAR2,
64 p_use_batch_id IN VARCHAR2
65 );
66
67 FUNCTION GET_VENDOR_SITE_CODE(p_vendor_site_id IN NUMBER) RETURN VARCHAR2;
68
69 END PON_BID_VALIDATIONS_PKG;