PACKAGE: APPS.PON_BID_VALIDATIONS_PKG

Source

1 PACKAGE PON_BID_VALIDATIONS_PKG 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;