1 PACKAGE CN_REVENUE_CLASS_PVT AS
2 --$Header: cnvrclss.pls 120.2 2005/08/07 23:04:53 vensrini noship $
3
4 TYPE revenue_class_rec_type IS RECORD
5 (revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
6 name cn_revenue_classes.name%TYPE,
7 description cn_revenue_classes.description%TYPE,
8 liability_account_id cn_revenue_classes.liability_account_id%TYPE,
9 expense_account_id cn_revenue_classes.expense_account_id%TYPE,
10 object_version_number NUMBER
11 );
12
13 -- Start of comments
14 -- API name : Create_revenue_class
15 -- Type : Private
16 -- Function : This Private API can be used to create a
17 -- Revenue Class
18 --
19 -- Pre-reqs : None.
20 -- Parameters :
21 -- IN : p_api_version IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional
23 -- Default = FND_API.G_FALSE
24 -- p_commit IN VARCHAR2 Optional
25 -- Default = FND_API.G_FALSE
26 -- p_validation_level IN NUMBER Optional
27 -- Default = FND_API.G_VALID_LEVEL_FULL
28
29 --
30 -- OUT : x_return_status OUT VARCHAR2(1)
31 -- x_msg_count OUT NUMBER
32 -- x_msg_data OUT VARCHAR2(2000)
33 --
34 -- Version : Current version 1.0
35 -- previous version y.y
36 -- Changed....
37 -- Initial version 1.0
38 --
39 -- Notes : Note text
40 --
41 -- End of comments
42
43 PROCEDURE create_revenue_class
44 ( p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46 p_commit IN VARCHAR2 := FND_API.G_FALSE,
47 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 x_loading_status OUT NOCOPY VARCHAR2,
52 x_revenue_class_id OUT NOCOPY NUMBER,
53 p_revenue_class_rec IN CN_REVENUE_CLASS_PVT.revenue_class_rec_type,
54 p_org_id IN NUMBER
55 );
56
57 -- Start of comments
58 -- API name : Update_revenue_class
59 -- Type : Public
60 -- Function : This Private API can be used to update a Revenue Class
61 -- Pre-reqs : None.
62 -- Parameters :
63 -- IN : p_api_version IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Optional
65 -- Default = FND_API.G_FALSE
66 -- p_commit IN VARCHAR2 Optional
67 -- Default = FND_API.G_FALSE
68 -- p_validation_level IN NUMBER Optional
69 -- Default = FND_API.G_VALID_LEVEL_FULL
70 -- p_calc_ext_table_rec_type IN
71 -- CN_REVENUE_CLASS_PVT.calc_ext_table_rec_type
72 --
73 -- OUT : x_return_status OUT VARCHAR2(1)
74 -- x_msg_count OUT NUMBER
75 -- x_msg_data OUT VARCHAR2(2000)
76 --
77 -- Version : Current version 1.0
78 -- previous version y.y
79 -- Changed....
80 -- Initial version 1.0
81 -- Notes : Note text
82 --
83 -- End of comments
84
85
86 PROCEDURE Update_revenue_class
87 ( p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 x_loading_status OUT NOCOPY VARCHAR2,
95 pold_revenue_class_rec IN OUT NOCOPY CN_REVENUE_CLASS_PVT.revenue_class_rec_type,
96 p_revenue_class_rec IN OUT NOCOPY CN_REVENUE_CLASS_PVT.revenue_class_rec_type
97 );
98
99 -- Start of comments
100 -- API name : Delete_revenue_class
101 -- Type : Public
102 -- Function : This Private API can be used to delete a Revenue Class
103 -- Pre-reqs : None.
104 -- Parameters :
105 -- IN : p_api_version IN NUMBER Required
106 -- p_init_msg_list IN VARCHAR2 Optional
107 -- Default = FND_API.G_FALSE
108 -- p_commit IN VARCHAR2 Optional
109 -- Default = FND_API.G_FALSE
110 -- p_validation_level IN NUMBER Optional
111 -- Default = FND_API.G_VALID_LEVEL_FULL
112 --
113 -- OUT : x_return_status OUT VARCHAR2(1)
114 -- x_msg_count OUT NUMBER
115 -- x_msg_data OUT VARCHAR2(2000)
116 --
117 -- Version : Current version 1.0
118 -- previous version y.y
119 -- Changed....
120 -- Initial version 1.0
121 --
122 -- Notes : Note text
123 --
124 -- End of comments
125
126 PROCEDURE Delete_revenue_class
127 ( p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
129 p_commit IN VARCHAR2 := FND_API.G_FALSE,
130 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 x_loading_status OUT NOCOPY VARCHAR2,
135 p_revenue_class_id IN NUMBER
136 );
137
138 END CN_REVENUE_CLASS_PVT;