1 PACKAGE cn_trx_factor_pvt AS
2 /*$Header: cnvtxfts.pls 120.1 2005/07/11 20:35:03 appldev ship $*/
3
4 -- trx factor
5 TYPE trx_factor_rec_type IS RECORD (
6 trx_factor_id NUMBER := NULL,
7 revenue_class_id NUMBER := NULL,
8 quota_id NUMBER := NULL,
9 quota_rule_id NUMBER := NULL,
10 event_factor cn_trx_factors.event_factor%TYPE := NULL,
11 trx_type cn_trx_factors.trx_type%TYPE := NULL,
12 object_version_number cn_trx_factors.object_version_number%TYPE := NULL,
13 org_id cn_trx_factors.org_id%TYPE := NULL
14 );
15
16 TYPE trx_factor_tbl_type IS TABLE OF trx_factor_rec_type
17 INDEX BY BINARY_INTEGER;
18
19 -- Global variable that represent missing values.
20 g_miss_trx_factor_rec trx_factor_rec_type;
21 g_miss_trx_factor_rec_tb trx_factor_tbl_type;
22
23 -- Start of comments
24 -- API name : Validate_Trx_Factor
25 -- Type : Private.
26 -- Function :
27 -- Pre-reqs : None.
28 -- Parameters :
29 -- IN : p_api_version IN NUMBER Required
30 -- p_init_msg_list IN VARCHAR2 Optional
31 -- Default = FND_API.G_FALSE
32 -- p_commit IN VARCHAR2 Optional
33 -- Default = FND_API.G_FALSE
34 -- p_validation_level IN NUMBER Optional
35 -- Default = FND_API.G_VALID_LEVEL_FULL
36 -- p_trx_factor IN trx_factor_rec_type
37 -- OUT : x_return_status OUT VARCHAR2(1)
38 -- x_msg_count OUT NUMBER
39 -- x_msg_data OUT VARCHAR2(2000)
40 -- x_trx_factor_id OUT NUMBER
41 -- Version : Current version 1.0
42 -- Notes : Note text
43 --
44 -- End of comments
45 PROCEDURE validate_trx_factor (
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48 p_commit IN VARCHAR2 := fnd_api.g_false,
49 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
50 p_action IN VARCHAR2,
51 p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
52 p_old_trx_factor IN trx_factor_rec_type := g_miss_trx_factor_rec,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58 -- Start of comments
59 -- API name : Create_Trx_Factor
60 -- Type : Private.
61 -- Function :
62 -- Pre-reqs : None.
63 -- Parameters :
64 -- IN : p_api_version IN NUMBER Required
65 -- p_init_msg_list IN VARCHAR2 Optional
66 -- Default = FND_API.G_FALSE
67 -- p_commit IN VARCHAR2 Optional
68 -- Default = FND_API.G_FALSE
69 -- p_validation_level IN NUMBER Optional
70 -- Default = FND_API.G_VALID_LEVEL_FULL
71 -- p_trx_factor IN trx_factor_rec_type
72 -- OUT : x_return_status OUT VARCHAR2(1)
73 -- x_msg_count OUT NUMBER
74 -- x_msg_data OUT VARCHAR2(2000)
75 -- x_trx_factor_id OUT NUMBER
76 -- Version : Current version 1.0
77 -- Notes : Note text
78 --
79 -- End of comments
80 PROCEDURE create_trx_factor (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
83 p_commit IN VARCHAR2 := fnd_api.g_false,
84 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
85 p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 -- Start of comments
92 -- API name : Update_Trx_Factor
93 -- Type : Private.
94 -- Function :
95 -- Pre-reqs : None.
96 -- Parameters :
97 -- IN : p_api_version IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Optional
99 -- Default = FND_API.G_FALSE
100 -- p_commit IN VARCHAR2 Optional
101 -- Default = FND_API.G_FALSE
102 -- p_validation_level IN NUMBER Optional
103 -- Default = FND_API.G_VALID_LEVEL_FULL
104 -- p_trx_factor IN trx_factor_rec_type
105 -- OUT : x_return_status OUT VARCHAR2(1)
106 -- x_msg_count OUT NUMBER
107 -- x_msg_data OUT VARCHAR2(2000)
108 -- Version : Current version 1.0
109 -- Notes : Note text
110 --
111 -- End of comments
112 PROCEDURE update_trx_factor (
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
115 p_commit IN VARCHAR2 := fnd_api.g_false,
116 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
117 p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 -- Start of comments
124 -- API name : Delete_Trx_Factor
125 -- Type : Private.
126 -- Function :
127 -- Pre-reqs : None.
128 -- Parameters :
129 -- IN : p_api_version IN NUMBER Required
130 -- p_init_msg_list IN VARCHAR2 Optional
131 -- Default = FND_API.G_FALSE
132 -- p_commit IN VARCHAR2 Optional
133 -- Default = FND_API.G_FALSE
134 -- p_validation_level IN NUMBER Optional
135 -- Default = FND_API.G_VALID_LEVEL_FULL
136 -- p_trx_factor IN trx_factor_rec_type
137 -- OUT : x_return_status OUT VARCHAR2(1)
138 -- x_msg_count OUT NUMBER
139 -- x_msg_data OUT VARCHAR2(2000)
140 -- Version : Current version 1.0
141 -- Notes : Note text
142 --
143 -- End of comments
144 PROCEDURE delete_trx_factor (
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
147 p_commit IN VARCHAR2 := fnd_api.g_false,
148 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
149 p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2
153 );
154
155 -- Start of comments
156 -- API name : Get_Trx_Factor
157 -- Type : Private.
158 -- Function :
159 -- Pre-reqs : None.
160 -- Parameters :
161 -- IN : p_api_version IN NUMBER Required
162 -- p_init_msg_list IN VARCHAR2 Optional
163 -- Default = FND_API.G_FALSE
164 -- p_commit IN VARCHAR2 Optional
165 -- Default = FND_API.G_FALSE
166 -- p_validation_level IN NUMBER Optional
167 -- Default = FND_API.G_VALID_LEVEL_FULL
168 -- p_quota_rule_id IN NUMBER
169 -- OUT : x_return_status OUT VARCHAR2(1)
170 -- x_msg_count OUT NUMBER
171 -- x_msg_data OUT VARCHAR2(2000)
172 -- x_trx_factor OUT trx_factor_rec_type
173 -- Version : Current version 1.0
174 -- Notes : Note text
175 --
176 -- End of comments
177 PROCEDURE get_trx_factor (
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
180 p_commit IN VARCHAR2 := fnd_api.g_false,
181 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182 p_quota_rule_id IN NUMBER,
183 x_trx_factor OUT NOCOPY trx_factor_tbl_type,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2
187 );
188
189 -- Start of comments
190 -- API name : update_trx_factors
191 -- Type : Private.
192 -- Function :
193 -- Pre-reqs : None.
194 -- Parameters :
195 -- IN : p_api_version IN NUMBER Required
196 -- p_init_msg_list IN VARCHAR2 Optional
197 -- Default = FND_API.G_FALSE
198 -- p_commit IN VARCHAR2 Optional
199 -- Default = FND_API.G_FALSE
200 -- p_validation_level IN NUMBER Optional
201 -- Default = FND_API.G_VALID_LEVEL_FULL
202 -- p_trx_factor IN trx_factor_rec_type
203 -- OUT : x_return_status OUT VARCHAR2(1)
204 -- x_msg_count OUT NUMBER
205 -- x_msg_data OUT VARCHAR2(2000)
206 -- x_trx_factor_id OUT NUMBER
207 -- Version : Current version 1.0
208 -- Notes : Note text
209 --
210 -- End of comments
211 PROCEDURE update_trx_factors (
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
214 p_commit IN VARCHAR2 := fnd_api.g_false,
215 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
216 p_org_id IN NUMBER,
217 p_quota_name IN VARCHAR2,
218 p_revenue_class_name IN VARCHAR2 := NULL,
219 p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 x_loading_status OUT NOCOPY VARCHAR2
224 );
225 END cn_trx_factor_pvt;