eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_MULTI_RATE_SCHEDULES_CUHK dependencies on CN_RATE_DIMENSIONS

Line 82: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

78: -- dimension assignments with equal or higher sequence number are pushed up by one sequence
79: -- number.
80: PROCEDURE Create_Dimension_Assign_Pre
81: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
82: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
83: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2);

Line 89: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2);
87: PROCEDURE Create_Dimension_Assign_Post
88: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
89: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
90: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2);

Line 102: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

98: -- rate dimension sequence number and object_version_number. If you do not pass in the
99: -- rate dimension sequence, the new dimension takes the same sequence number.
100: PROCEDURE Update_Dimension_Assign_Pre
101: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
102: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
103: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
104: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
105: cn_api.g_miss_num,
106: p_object_version_number IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,

Line 103: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,

99: -- rate dimension sequence, the new dimension takes the same sequence number.
100: PROCEDURE Update_Dimension_Assign_Pre
101: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
102: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
103: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
104: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
105: cn_api.g_miss_num,
106: p_object_version_number IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
107: x_return_status OUT NOCOPY VARCHAR2,

Line 112: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2);
110: PROCEDURE Update_Dimension_Assign_Post
111: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
112: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
113: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
114: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
115: cn_api.g_miss_num,
116: p_object_version_number IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,

Line 113: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,

109: x_msg_data OUT NOCOPY VARCHAR2);
110: PROCEDURE Update_Dimension_Assign_Post
111: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
112: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
113: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
114: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
115: cn_api.g_miss_num,
116: p_object_version_number IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
117: x_return_status OUT NOCOPY VARCHAR2,

Line 125: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

121: -- Delete a rate dimension assignment by identifying the rate schedule and rate dimension
122: -- name.
123: PROCEDURE Delete_Dimension_Assign_Pre
124: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
125: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2);
129: PROCEDURE Delete_Dimension_Assign_Post

Line 131: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2);
129: PROCEDURE Delete_Dimension_Assign_Post
130: (p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
131: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2);
135:

Line 162: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

158: -- Choose a name, description, a unit code (AMOUNT, PERCENT, EXPRESSION or STRING), and a set
159: -- of tiers. For each tier, populate value1 and value2 (except for STRING which only uses
160: -- value1).
161: PROCEDURE Create_Dimension_Pre
162: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
163: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
164: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
165: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
166: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,

Line 163: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,

159: -- of tiers. For each tier, populate value1 and value2 (except for STRING which only uses
160: -- value1).
161: PROCEDURE Create_Dimension_Pre
162: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
163: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
164: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
165: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
166: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
167: x_return_status OUT NOCOPY VARCHAR2,

Line 164: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

160: -- value1).
161: PROCEDURE Create_Dimension_Pre
162: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
163: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
164: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
165: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
166: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,

Line 171: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2);
170: PROCEDURE Create_Dimension_Post
171: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
172: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
173: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
174: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
175: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,

Line 172: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,

168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2);
170: PROCEDURE Create_Dimension_Post
171: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
172: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
173: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
174: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
175: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
176: x_return_status OUT NOCOPY VARCHAR2,

Line 173: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

169: x_msg_data OUT NOCOPY VARCHAR2);
170: PROCEDURE Create_Dimension_Post
171: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
172: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
173: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
174: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
175: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,

Line 185: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

181: -- Identify the dimension to be updated by its original name. Select the new name,
182: -- description, unit code and tiers table. If unit code and tiers table are not passed in,
183: -- only the name and description are updated.
184: PROCEDURE Update_Dimension_Pre
185: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
186: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
187: cn_api.g_miss_char,
188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
189: cn_api.g_miss_char,

Line 186: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=

182: -- description, unit code and tiers table. If unit code and tiers table are not passed in,
183: -- only the name and description are updated.
184: PROCEDURE Update_Dimension_Pre
185: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
186: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
187: cn_api.g_miss_char,
188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
189: cn_api.g_miss_char,
190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=

Line 188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=

184: PROCEDURE Update_Dimension_Pre
185: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
186: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
187: cn_api.g_miss_char,
188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
189: cn_api.g_miss_char,
190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
191: cn_api.g_miss_char,
192: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=

Line 190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=

186: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
187: cn_api.g_miss_char,
188: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
189: cn_api.g_miss_char,
190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
191: cn_api.g_miss_char,
192: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
193: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
194: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 194: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

190: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
191: cn_api.g_miss_char,
192: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
193: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
194: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2);
198: PROCEDURE Update_Dimension_Post

Line 199: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2);
198: PROCEDURE Update_Dimension_Post
199: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
200: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
201: cn_api.g_miss_char,
202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
203: cn_api.g_miss_char,

Line 200: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=

196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2);
198: PROCEDURE Update_Dimension_Post
199: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
200: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
201: cn_api.g_miss_char,
202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
203: cn_api.g_miss_char,
204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=

Line 202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=

198: PROCEDURE Update_Dimension_Post
199: (p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
200: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
201: cn_api.g_miss_char,
202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
203: cn_api.g_miss_char,
204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
205: cn_api.g_miss_char,
206: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=

Line 204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=

200: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
201: cn_api.g_miss_char,
202: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
203: cn_api.g_miss_char,
204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
205: cn_api.g_miss_char,
206: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
207: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
208: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 208: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

204: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
205: cn_api.g_miss_char,
206: p_tiers_tbl IN CN_MULTI_RATE_SCHEDULES_PUB.rate_tier_tbl_type :=
207: CN_MULTI_RATE_SCHEDULES_PUB.g_miss_rate_tier_tbl,
208: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2);
212:

Line 216: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

212:
213: -- Delete a dimension
214: -- Pass in the name of dimension to be deleted.
215: PROCEDURE Delete_Dimension_Pre
216: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2);
220: PROCEDURE Delete_Dimension_Post

Line 221: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2);
220: PROCEDURE Delete_Dimension_Post
221: (p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2);
225:

Line 232: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

228: -- specified dimension is STRING, value2 is not used... just pass in null).
229: -- Also pass in the tier sequence number. All existing tiers with equal or higher
230: -- sequence numbers get pushed up by one.
231: PROCEDURE Create_Tier_Pre
232: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
233: p_value1 IN VARCHAR2,
234: p_value2 IN VARCHAR2,
235: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
236: x_return_status OUT NOCOPY VARCHAR2,

Line 240: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2);
239: PROCEDURE Create_Tier_Post
240: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
241: p_value1 IN VARCHAR2,
242: p_value2 IN VARCHAR2,
243: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
244: x_return_status OUT NOCOPY VARCHAR2,

Line 253: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

249: -- Pass in the dimension name and sequence number to uniquely identify the tier.
250: -- Indicate the new minimum and maximum values as p_value1 and p_value2 (STRING
251: -- value tiers don't use p_value2).
252: PROCEDURE Update_Tier_Pre
253: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
254: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
255: p_value1 IN VARCHAR2,
256: p_value2 IN VARCHAR2,
257: p_object_version_number IN CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

Line 262: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2);
261: PROCEDURE Update_Tier_Post
262: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
263: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
264: p_value1 IN VARCHAR2,
265: p_value2 IN VARCHAR2,
266: p_object_version_number IN CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

Line 274: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

270:
271: -- Delete a tier for a dimension
272: -- Pass in the dimension name and sequence number to uniquely identify the tier.
273: PROCEDURE Delete_Tier_Pre
274: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
275: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2);

Line 280: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2);
279: PROCEDURE Delete_Tier_Post
280: (p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
281: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2);