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_PUB dependencies on CN_RATE_DIMENSIONS

Line 31: rate_dim_name CN_RATE_DIMENSIONS.NAME%TYPE,

27: -- a rate schedule name and rate dimension name (they have to be unique),
28: -- a sequence number, and the object version number (for locking)
29: TYPE dim_assign_rec_type IS RECORD
30: (rate_schedule_name CN_RATE_SCHEDULES.NAME%TYPE,
31: rate_dim_name CN_RATE_DIMENSIONS.NAME%TYPE,
32: rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
33: object_version_number CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE);
34:
35: TYPE dim_assign_tbl_type IS TABLE OF dim_assign_rec_type INDEX BY BINARY_INTEGER;

Line 33: object_version_number CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE);

29: TYPE dim_assign_rec_type IS RECORD
30: (rate_schedule_name CN_RATE_SCHEDULES.NAME%TYPE,
31: rate_dim_name CN_RATE_DIMENSIONS.NAME%TYPE,
32: rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
33: object_version_number CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE);
34:
35: TYPE dim_assign_tbl_type IS TABLE OF dim_assign_rec_type INDEX BY BINARY_INTEGER;
36:
37: -- Each rate tier has type=AMOUNT, PERCENT, EXPRESSION, or STRING.

Line 205: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
205: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
206: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
207: -- Start - MOAC Change
208: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
209: -- End - MOAC Change

Line 208: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,

204: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
205: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
206: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
207: -- Start - MOAC Change
208: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
209: -- End - MOAC Change
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2);

Line 245: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
245: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
246: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
247: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
248: cn_api.g_miss_num,
249: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,

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

242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
245: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
246: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
247: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
248: cn_api.g_miss_num,
249: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
250: -- Start - MOAC Change

Line 251: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,

247: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
248: cn_api.g_miss_num,
249: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
250: -- Start - MOAC Change
251: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,
252: -- End - MOAC Change
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2);

Line 281: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
281: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
282: -- Start - R12 MOAC Changes
283: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
284: -- End - R12 MOAC Changes
285: x_return_status OUT NOCOPY VARCHAR2,

Line 283: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new

279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
281: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
282: -- Start - R12 MOAC Changes
283: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
284: -- End - R12 MOAC Changes
285: x_return_status OUT NOCOPY VARCHAR2,
286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2);

Line 355: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

351: (p_api_version IN NUMBER,
352: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
356: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
357: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
358: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
359: -- Start - MOAC Change

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

352: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
356: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
357: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
358: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
359: -- Start - MOAC Change
360: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,

Line 357: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
356: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
357: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
358: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
359: -- Start - MOAC Change
360: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
361: -- End - MOAC Change

Line 360: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,

356: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
357: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
358: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
359: -- Start - MOAC Change
360: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
361: -- End - MOAC Change
362: x_return_status OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY NUMBER,
364: x_msg_data OUT NOCOPY VARCHAR2);

Line 394: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

390: (p_api_version IN NUMBER,
391: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
392: p_commit IN VARCHAR2 := FND_API.G_FALSE,
393: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
394: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
395: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
396: cn_api.g_miss_char,
397: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
398: cn_api.g_miss_char,

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

391: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
392: p_commit IN VARCHAR2 := FND_API.G_FALSE,
393: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
394: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
395: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
396: cn_api.g_miss_char,
397: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
398: cn_api.g_miss_char,
399: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=

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

393: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
394: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
395: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
396: cn_api.g_miss_char,
397: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
398: cn_api.g_miss_char,
399: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
400: cn_api.g_miss_char,
401: p_tiers_tbl IN rate_tier_tbl_type :=

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

395: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
396: cn_api.g_miss_char,
397: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
398: cn_api.g_miss_char,
399: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
400: cn_api.g_miss_char,
401: p_tiers_tbl IN rate_tier_tbl_type :=
402: g_miss_rate_tier_tbl,
403: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 403: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

399: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
400: cn_api.g_miss_char,
401: p_tiers_tbl IN rate_tier_tbl_type :=
402: g_miss_rate_tier_tbl,
403: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
404: -- Start - MOAC Change
405: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,
406: -- End - MOAC Change
407: x_return_status OUT NOCOPY VARCHAR2,

Line 405: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,

401: p_tiers_tbl IN rate_tier_tbl_type :=
402: g_miss_rate_tier_tbl,
403: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
404: -- Start - MOAC Change
405: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,
406: -- End - MOAC Change
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,
409: x_msg_data OUT NOCOPY VARCHAR2);

Line 433: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

429: (p_api_version IN NUMBER,
430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
434: -- Start - R12 MOAC Changes
435: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
436: -- End - R12 MOAC Changes
437: x_return_status OUT NOCOPY VARCHAR2,

Line 435: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new

431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
434: -- Start - R12 MOAC Changes
435: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
436: -- End - R12 MOAC Changes
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2);

Line 468: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

464: (p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466: p_commit IN VARCHAR2 := FND_API.G_FALSE,
467: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
469: p_value1 IN VARCHAR2,
470: p_value2 IN VARCHAR2,
471: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
472: -- Start - MOAC Change

Line 507: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

503: (p_api_version IN NUMBER,
504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
505: p_commit IN VARCHAR2 := FND_API.G_FALSE,
506: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
507: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
508: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
509: p_value1 IN VARCHAR2,
510: p_value2 IN VARCHAR2,
511: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

Line 542: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

538: (p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540: p_commit IN VARCHAR2 := FND_API.G_FALSE,
541: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
543: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
544: -- Start - R12 MOAC Changes
545: p_object_version_number IN CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- new
546: -- End - R12 MOAC Changes