APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on CN_RATE_DIM_TIERS

Line 44: (tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

40: -- If type is EXPRESSION, select expressions for minimum and maximum values by their
41: -- name for value1 and value2
42: -- If type is STRING, select the string value for value1 (leave value2 blank).
43: TYPE rate_tier_rec_type IS RECORD
44: (tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
45: value1 VARCHAR2(80),
46: value2 VARCHAR2(80),
47: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE);
48:

Line 47: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE);

43: TYPE rate_tier_rec_type IS RECORD
44: (tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
45: value1 VARCHAR2(80),
46: value2 VARCHAR2(80),
47: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE);
48:
49: TYPE rate_tier_tbl_type IS TABLE OF rate_tier_rec_type INDEX BY BINARY_INTEGER;
50:
51: TYPE tier_coordinates_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 471: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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
473: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE := NULL,
474: -- End - MOAC Change
475: x_return_status OUT NOCOPY VARCHAR2,

Line 508: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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,
512: -- Start - MOAC Change

Line 511: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

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,
512: -- Start - MOAC Change
513: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE,
514: -- End - MOAC Change
515: x_return_status OUT NOCOPY VARCHAR2,

Line 543: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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