[Home] [Help]
PACKAGE: APPS.CN_RT_QUOTA_ASGN_PVT
Source
1 PACKAGE cn_rt_quota_asgn_pvt AUTHID CURRENT_USER AS
2 /*$Header: cnvrtqas.pls 120.1 2005/07/11 20:01:43 appldev ship $*/
3 TYPE calc_formulas_rec_type IS RECORD (
4 NAME cn_calc_formulas.NAME%TYPE := NULL,
5 calc_formula_id NUMBER := NULL
6 );
7
8 TYPE calc_formulas_tbl_type IS TABLE OF calc_formulas_rec_type
9 INDEX BY BINARY_INTEGER;
10
11 -- rt quota asgn
12 TYPE rt_quota_asgn_rec_type IS RECORD (
13 NAME cn_rate_schedules.NAME%TYPE := NULL,
14 org_id NUMBER := NULL,
15 rt_quota_asgn_id NUMBER := NULL,
16 quota_id NUMBER := NULL,
17 start_date DATE := NULL,
18 end_date DATE := NULL,
19 rate_schedule_id NUMBER := NULL,
20 calc_formula_id NUMBER := NULL,
21 calc_formula_name cn_calc_formulas.NAME%TYPE := NULL,
22 attribute_category cn_rt_quota_asgns.attribute_category%TYPE := NULL,
23 attribute1 cn_rt_quota_asgns.attribute1%TYPE := NULL,
24 attribute2 cn_rt_quota_asgns.attribute2%TYPE := NULL,
25 attribute3 cn_rt_quota_asgns.attribute3%TYPE := NULL,
26 attribute4 cn_rt_quota_asgns.attribute4%TYPE := NULL,
27 attribute5 cn_rt_quota_asgns.attribute5%TYPE := NULL,
28 attribute6 cn_rt_quota_asgns.attribute6%TYPE := NULL,
29 attribute7 cn_rt_quota_asgns.attribute7%TYPE := NULL,
30 attribute8 cn_rt_quota_asgns.attribute8%TYPE := NULL,
31 attribute9 cn_rt_quota_asgns.attribute9%TYPE := NULL,
32 attribute10 cn_rt_quota_asgns.attribute10%TYPE := NULL,
33 attribute11 cn_rt_quota_asgns.attribute11%TYPE := NULL,
34 attribute12 cn_rt_quota_asgns.attribute12%TYPE := NULL,
35 attribute13 cn_rt_quota_asgns.attribute13%TYPE := NULL,
36 attribute14 cn_rt_quota_asgns.attribute14%TYPE := NULL,
37 attribute15 cn_rt_quota_asgns.attribute15%TYPE := NULL,
38 object_version_number cn_rt_quota_asgns.object_version_number%TYPE := NULL,
39 created_by cn_rt_quota_asgns.created_by%TYPE := NULL,
40 creation_date cn_rt_quota_asgns.creation_date%TYPE := NULL,
41 last_update_login cn_rt_quota_asgns.last_update_login%TYPE := NULL,
42 last_update_date cn_rt_quota_asgns.last_update_date%TYPE := NULL,
43 last_updated_by cn_rt_quota_asgns.last_updated_by%TYPE := NULL
44 );
45
46 TYPE rt_quota_asgn_tbl_type IS TABLE OF rt_quota_asgn_rec_type
47 INDEX BY BINARY_INTEGER;
48
49 -- Global variable that represent missing values.
50 g_miss_rt_quota_asgn_rec rt_quota_asgn_rec_type;
51 g_miss_rt_quota_asgn_rec_tb rt_quota_asgn_tbl_type;
52
53 -- Start of comments
54 -- API name : Create_Rt_Quota_Asgn
55 -- Type : Private.
56 -- Function :
57 -- Pre-reqs : None.
58 -- Parameters :
59 -- IN : p_api_version IN NUMBER Required
60 -- p_init_msg_list IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_commit IN VARCHAR2 Optional
63 -- Default = FND_API.G_FALSE
64 -- p_validation_level IN NUMBER Optional
65 -- Default = FND_API.G_VALID_LEVEL_FULL
66 -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
67 -- OUT : x_return_status OUT VARCHAR2(1)
68 -- x_msg_count OUT NUMBER
69 -- x_msg_data OUT VARCHAR2(2000)
70 -- x_rt_quota_asgn_id OUT NUMBER
71 -- Version : Current version 1.0
72 -- Notes : Note text
73 --
74 -- End of comments
75 PROCEDURE create_rate_table_assignment (
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
78 p_commit IN VARCHAR2 := fnd_api.g_false,
79 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
80 p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86 -- Start of comments
87 -- API name : Update_Rt_Quota_Asgn
88 -- Type : Private.
89 -- Function :
90 -- Pre-reqs : None.
91 -- Parameters :
92 -- IN : p_api_version IN NUMBER Required
93 -- p_init_msg_list IN VARCHAR2 Optional
94 -- Default = FND_API.G_FALSE
95 -- p_commit IN VARCHAR2 Optional
96 -- Default = FND_API.G_FALSE
97 -- p_validation_level IN NUMBER Optional
98 -- Default = FND_API.G_VALID_LEVEL_FULL
99 -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
100 -- OUT : x_return_status OUT VARCHAR2(1)
101 -- x_msg_count OUT NUMBER
102 -- x_msg_data OUT VARCHAR2(2000)
103 -- Version : Current version 1.0
104 -- Notes : Note text
105 --
106 -- End of comments
107 PROCEDURE update_rate_table_assignment (
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
110 p_commit IN VARCHAR2 := fnd_api.g_false,
111 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
112 p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2
116 );
117
118 -- Start of comments
119 -- API name : Delete_Rt_Quota_Asgn
120 -- Type : Private.
121 -- Function :
122 -- Pre-reqs : None.
123 -- Parameters :
124 -- IN : p_api_version IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional
126 -- Default = FND_API.G_FALSE
127 -- p_commit IN VARCHAR2 Optional
128 -- Default = FND_API.G_FALSE
129 -- p_validation_level IN NUMBER Optional
130 -- Default = FND_API.G_VALID_LEVEL_FULL
131 -- p_rt_quota_asgn IN quota_asgn_rec_type
132 -- OUT : x_return_status OUT VARCHAR2(1)
133 -- x_msg_count OUT NUMBER
134 -- x_msg_data OUT VARCHAR2(2000)
135 -- Version : Current version 1.0
136 -- Notes : Note text
137 --
138 -- End of comments
139 PROCEDURE delete_rate_table_assignment (
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
142 p_commit IN VARCHAR2 := fnd_api.g_false,
143 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
144 p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150 -- Start of comments
151 -- API name : get_formula_rate_tables
152 -- Type : Private.
153 -- Function :
154 -- Pre-reqs : None.
155 -- Parameters :
156 -- IN : p_api_version IN NUMBER Required
157 -- p_init_msg_list IN VARCHAR2 Optional
158 -- Default = FND_API.G_FALSE
159 -- p_commit IN VARCHAR2 Optional
160 -- Default = FND_API.G_FALSE
161 -- p_validation_level IN NUMBER Optional
162 -- Default = FND_API.G_VALID_LEVEL_FULL
163 -- p_quota_id IN NUMBER
164 -- OUT : x_return_status OUT VARCHAR2(1)
165 -- x_msg_count OUT NUMBER
166 -- x_msg_data OUT VARCHAR2(2000)
167 -- x_rt_quota_asgn OUT rt_quota_asgn_tbl_type
168 -- Version : Current version 1.0
169 -- Notes : Note text
170 --
171 -- End of comments
172 PROCEDURE get_formula_rate_tables (
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175 p_commit IN VARCHAR2 := fnd_api.g_false,
176 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177 p_type IN VARCHAR2 := 'FORMULA',
178 p_quota_id IN NUMBER,
179 p_calc_formula_id IN NUMBER,
180 x_calc_formulas OUT NOCOPY calc_formulas_tbl_type,
181 x_rate_tables OUT NOCOPY rt_quota_asgn_tbl_type,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2
185 );
186
187 -- Start of comments
188 -- API name : get_formula_rate_tables
189 -- Type : Private.
190 -- Function :
191 -- Pre-reqs : None.
192 -- Parameters :
193 -- IN : p_api_version IN NUMBER Required
194 -- p_init_msg_list IN VARCHAR2 Optional
195 -- Default = FND_API.G_FALSE
196 -- p_commit IN VARCHAR2 Optional
197 -- Default = FND_API.G_FALSE
198 -- p_validation_level IN NUMBER Optional
199 -- Default = FND_API.G_VALID_LEVEL_FULL
200 -- p_quota_id IN NUMBER
201 -- OUT : x_return_status OUT VARCHAR2(1)
202 -- x_msg_count OUT NUMBER
203 -- x_msg_data OUT VARCHAR2(2000)
204 -- x_rt_quota_asgn OUT rt_quota_asgn_tbl_type
205 -- Version : Current version 1.0
206 -- Notes : Note text
207 --
208 -- End of comments
209 PROCEDURE validate_rate_table_assignment (
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
212 p_commit IN VARCHAR2 := fnd_api.g_false,
213 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
214 p_action IN VARCHAR2,
215 p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
216 p_old_rt_quota_asgn IN rt_quota_asgn_rec_type := g_miss_rt_quota_asgn_rec,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2
220 );
221 END cn_rt_quota_asgn_pvt;