DBA Data[Home] [Help]

APPS.CN_MULTI_RATE_SCHEDULES_CUHK dependencies on CN_RATE_DIM_TIERS

Line 235: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2);
239: PROCEDURE Create_Tier_Post

Line 243: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2);
247:

Line 254: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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,
258: x_return_status OUT NOCOPY VARCHAR2,

Line 257: p_object_version_number IN CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

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,
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

Line 263: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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,
267: x_return_status OUT NOCOPY VARCHAR2,

Line 266: p_object_version_number IN CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

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,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2);
270:

Line 275: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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);
279: PROCEDURE Delete_Tier_Post

Line 281: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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);
285: