1 PACKAGE OE_Price_List_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVLSTS.pls 115.1 99/07/16 08:17:05 porting shi $ */
3
4 -- Start of Comments
5 -- API name : Fetch_List_Price
6 -- Type : PRIVATE
7 -- Function : Return the list price of an item based on a specified
8 -- price list, item, and unit code.
9 -- Pre-reqs : None
10 -- Parameters :
11 -- IN : p_api_version_number IN NUMBER required
12 -- p_init_msg_list IN VARCHAR2 optional
13 -- default = FND_API.G_FALSE
14 -- p_validation_level IN NUMBER optional
15 -- default = FND_API.G_VALID_LEVEL_FULL
16 -- p_price_list_id IN NUMBER required
17 -- p_inventory_item_id IN NUMBER required
18 -- p_unit_code IN VARCHAR2 required
19 -- p_service_duration IN NUMBER optional
20 -- p_item_type_code IN VARCHAR2 optional
21 -- p_prc_method_code IN VARCHAR2 optional
22 -- p_pricing_attribute1 IN VARCHAR2 optional
23 -- p_pricing_attribute2 IN VARCHAR2 optional
24 -- p_pricing_attribute3 IN VARCHAR2 optional
25 -- p_pricing_attribute4 IN VARCHAR2 optional
26 -- p_pricing_attribute5 IN VARCHAR2 optional
27 -- p_pricing_attribute6 IN VARCHAR2 optional
28 -- p_pricing_attribute7 IN VARCHAR2 optional
29 -- p_pricing_attribute8 IN VARCHAR2 optional
30 -- p_pricing_attribute9 IN VARCHAR2 optional
31 -- p_pricing_attribute10 IN VARCHAR2 optional
32 -- p_pricing_attribute11 IN VARCHAR2 optional
33 -- p_pricing_attribute12 IN VARCHAR2 optional
34 -- p_pricing_attribute13 IN VARCHAR2 optional
35 -- p_pricing_attribute14 IN VARCHAR2 optional
36 -- p_pricing_attribute15 IN VARCHAR2 optional
37 -- p_base_price IN NUMBER optional
38 -- p_fetch_attempts IN NUMBER optional
39 -- default = G_PRC_LST_DEF_ATTEMPTS
40 -- OUT : p_return_status OUT VARCHAR2(1)
41 -- p_msg_count OUT NUMBER
42 -- p_msg_data OUT VARCHAR2(2000)
43 -- p_price_list_id_out OUT NUMBER
44 -- p_prc_method_code_out OUT VARCHAR2(4)
45 -- p_list_price OUT NUMBER
46 -- p_list_percent OUT NUMBER
47 -- p_rounding_factor OUT NUMBER
48 -- Version : Current Version 1.0
49 -- Initial Version 1.0
50 -- Notes :
51 -- End Of Comments
52
53
54
55 -- Global constants holding the maximum number of fetch attempts allowed.
56
57 G_PRC_LST_MAX_ATTEMPTS CONSTANT NUMBER := 2 ;
58 G_PRC_LST_DEF_ATTEMPTS CONSTANT NUMBER := 2 ;
59
60 -- Global constants representing pricing method codes
61
62 G_PRC_METHOD_AMOUNT CONSTANT VARCHAR2(10) := 'AMNT';
63 G_PRC_METHOD_PERCENT CONSTANT VARCHAR2(10) := 'PERC';
64
65 -- Global constant Item type codes
66
67 G_PRC_ITEM_SERVICE CONSTANT VARCHAR2(10) := 'SERVICE';
68
69
70
71 PROCEDURE Fetch_List_Price
72 ( p_api_version_number IN NUMBER ,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
74 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
75 p_return_status OUT VARCHAR2 ,
76 p_msg_count OUT NUMBER ,
77 p_msg_data OUT VARCHAR2 ,
78 p_price_list_id IN NUMBER := NULL ,
79 p_inventory_item_id IN NUMBER := NULL ,
80 p_unit_code IN VARCHAR2 := NULL ,
81 p_service_duration IN NUMBER := NULL ,
82 p_item_type_code IN VARCHAR2 := NULL ,
83 p_prc_method_code IN VARCHAR2 := NULL ,
84 p_pricing_attribute1 IN VARCHAR2 := NULL ,
85 p_pricing_attribute2 IN VARCHAR2 := NULL ,
86 p_pricing_attribute3 IN VARCHAR2 := NULL ,
87 p_pricing_attribute4 IN VARCHAR2 := NULL ,
88 p_pricing_attribute5 IN VARCHAR2 := NULL ,
89 p_pricing_attribute6 IN VARCHAR2 := NULL ,
90 p_pricing_attribute7 IN VARCHAR2 := NULL ,
91 p_pricing_attribute8 IN VARCHAR2 := NULL ,
92 p_pricing_attribute9 IN VARCHAR2 := NULL ,
93 p_pricing_attribute10 IN VARCHAR2 := NULL ,
94 p_pricing_attribute11 IN VARCHAR2 := NULL ,
95 p_pricing_attribute12 IN VARCHAR2 := NULL ,
96 p_pricing_attribute13 IN VARCHAR2 := NULL ,
97 p_pricing_attribute14 IN VARCHAR2 := NULL ,
98 p_pricing_attribute15 IN VARCHAR2 := NULL ,
99 p_base_price IN NUMBER := NULL ,
100 p_fetch_attempts IN NUMBER := G_PRC_LST_DEF_ATTEMPTS ,
101 p_price_list_id_out OUT NUMBER ,
102 p_prc_method_code_out OUT VARCHAR2 ,
103 p_list_price OUT NUMBER ,
104 p_list_percent OUT NUMBER ,
105 p_rounding_factor OUT NUMBER
106 );
107
108 END; -- OE_Price_List_PVT
109