[Home] [Help]
PACKAGE: APPS.CZ_OM_LIST_PRICE
Source
1 PACKAGE CZ_OM_LIST_PRICE AUTHID CURRENT_USER AS
2 /* $Header: czomlprs.pls 115.9 2002/12/03 15:23:23 askhacha ship $ */
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_price_list_id IN NUMBER required
12 -- p_inventory_item_id IN NUMBER required
13 -- p_unit_code IN VARCHAR2 required
14 -- p_pricing_attribute1 IN VARCHAR2 optional
15 -- p_pricing_attribute2 IN VARCHAR2 optional
16 -- p_pricing_attribute3 IN VARCHAR2 optional
17 -- p_pricing_attribute4 IN VARCHAR2 optional
18 -- p_pricing_attribute5 IN VARCHAR2 optional
19 -- p_pricing_attribute6 IN VARCHAR2 optional
20 -- p_pricing_attribute7 IN VARCHAR2 optional
21 -- p_pricing_attribute8 IN VARCHAR2 optional
22 -- p_pricing_attribute9 IN VARCHAR2 optional
23 -- p_pricing_attribute10 IN VARCHAR2 optional
24 -- p_pricing_attribute11 IN VARCHAR2 optional
25 -- p_pricing_attribute12 IN VARCHAR2 optional
26 -- p_pricing_attribute13 IN VARCHAR2 optional
27 -- p_pricing_attribute14 IN VARCHAR2 optional
28 -- p_pricing_attribute15 IN VARCHAR2 optional
29 -- p_fetch_attempts IN NUMBER optional
30 -- default = G_PRC_LST_DEF_ATTEMPTS
31 -- OUT NOCOPY : p_return_status OUT VARCHAR2(1)
32 -- p_msg_data OUT VARCHAR2(2000)
33 -- p_list_price OUT NUMBER
34 -- p_rounding_factor OUT NUMBER
35 -- Version : Current Version 1.0
36 -- Initial Version 1.0
37 -- Notes :
38 -- End Of Comments
39
40
41 -- Global constants holding the maximum number of fetch attempts allowed.
42
43 G_PRC_LST_MAX_ATTEMPTS CONSTANT NUMBER := 2 ;
44 G_PRC_LST_DEF_ATTEMPTS CONSTANT NUMBER := 2 ;
45
46 -- Global constants representing pricing method codes
47
48 G_PRC_METHOD_AMOUNT CONSTANT VARCHAR2(10) := 'AMNT';
49 G_PRC_METHOD_PERCENT CONSTANT VARCHAR2(10) := 'PERC';
50
51 -- Global constants holding return status values.
52
53 G_RET_STS_SUCCESS CONSTANT CHAR := 'S';
54 G_RET_STS_ERROR CONSTANT CHAR := 'E';
55 G_RET_STS_UNEXP_ERROR CONSTANT CHAR := 'U';
56
57 -- Global constant Item type codes
58
59 G_PRC_ITEM_SERVICE CONSTANT VARCHAR2(10) := 'SERVICE';
60
61
62
63 PROCEDURE Fetch_List_Price
64 ( p_return_status OUT NOCOPY VARCHAR2 ,
65 p_msg_data OUT NOCOPY VARCHAR2 ,
66 p_list_price OUT NOCOPY NUMBER ,
67 p_list_percent OUT NOCOPY NUMBER ,
68 p_rounding_factor OUT NOCOPY NUMBER ,
69 p_price_list_id IN NUMBER := NULL ,
70 p_inventory_item_id IN NUMBER := NULL ,
71 p_unit_code IN VARCHAR2 := NULL ,
72 p_service_duration IN NUMBER := NULL ,
73 p_item_type_code IN VARCHAR2 := NULL ,
74 p_prc_method_code IN VARCHAR2 := NULL ,
75 p_pricing_attribute1 IN VARCHAR2 := NULL ,
76 p_pricing_attribute2 IN VARCHAR2 := NULL ,
77 p_pricing_attribute3 IN VARCHAR2 := NULL ,
78 p_pricing_attribute4 IN VARCHAR2 := NULL ,
79 p_pricing_attribute5 IN VARCHAR2 := NULL ,
80 p_pricing_attribute6 IN VARCHAR2 := NULL ,
81 p_pricing_attribute7 IN VARCHAR2 := NULL ,
82 p_pricing_attribute8 IN VARCHAR2 := NULL ,
83 p_pricing_attribute9 IN VARCHAR2 := NULL ,
84 p_pricing_attribute10 IN VARCHAR2 := NULL ,
85 p_pricing_attribute11 IN VARCHAR2 := NULL ,
86 p_pricing_attribute12 IN VARCHAR2 := NULL ,
87 p_pricing_attribute13 IN VARCHAR2 := NULL ,
88 p_pricing_attribute14 IN VARCHAR2 := NULL ,
89 p_pricing_attribute15 IN VARCHAR2 := NULL ,
90 p_base_price IN NUMBER := NULL ,
91 p_pricing_date IN DATE := NULL ,
92 p_prc_method_code_out OUT NOCOPY VARCHAR2 ,
93 p_fetch_attempts IN NUMBER := G_PRC_LST_DEF_ATTEMPTS
94 );
95
96 END CZ_OM_LIST_PRICE;