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_RATE_DIMENSIONS_PVT dependencies on CN_RATE_DIM_TIERS

Line 5: (rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE := NULL,

1: PACKAGE CN_RATE_DIMENSIONS_PVT AS
2: /*$Header: cnvrdims.pls 120.2 2006/01/18 15:28:23 jxsingh ship $*/
3:
4: TYPE tier_rec_type IS RECORD
5: (rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE := NULL,
6: minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,
7: maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,
8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,

Line 6: minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,

2: /*$Header: cnvrdims.pls 120.2 2006/01/18 15:28:23 jxsingh ship $*/
3:
4: TYPE tier_rec_type IS RECORD
5: (rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE := NULL,
6: minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,
7: maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,
8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
10: string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE,

Line 7: maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,

3:
4: TYPE tier_rec_type IS RECORD
5: (rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE := NULL,
6: minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,
7: maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,
8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
10: string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE,
11: tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

Line 8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,

4: TYPE tier_rec_type IS RECORD
5: (rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE := NULL,
6: minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,
7: maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,
8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
10: string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE,
11: tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
12: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

Line 9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,

5: (rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE := NULL,
6: minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,
7: maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,
8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
10: string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE,
11: tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
12: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
13: tier_description VARCHAR2(1000)); -- tier_description is calculated

Line 10: string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE,

6: minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,
7: maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,
8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
10: string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE,
11: tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
12: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
13: tier_description VARCHAR2(1000)); -- tier_description is calculated
14:

Line 11: tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

7: maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,
8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
10: string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE,
11: tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
12: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
13: tier_description VARCHAR2(1000)); -- tier_description is calculated
14:
15: TYPE tiers_tbl_type IS TABLE OF tier_rec_type INDEX BY BINARY_INTEGER;

Line 12: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

8: min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
9: max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
10: string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE,
11: tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
12: object_version_number CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
13: tier_description VARCHAR2(1000)); -- tier_description is calculated
14:
15: TYPE tiers_tbl_type IS TABLE OF tier_rec_type INDEX BY BINARY_INTEGER;
16: TYPE parent_rate_tables_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 95: -- cn_srp_rate_assigns, cn_rate_tiers, and cn_rate_dim_tiers

91: -- 1) If the dimension is used in a rate table, at least one
92: -- tier should be left in the rate dimension
93: -- 2) If it is used in a rate table, delete the corresponding
94: -- records in cn_sch_dim_tiers,
95: -- cn_srp_rate_assigns, cn_rate_tiers, and cn_rate_dim_tiers
96: -- 3) update cn_rate_dimensions.number_tier
97: -- 4) tier_sequence is not adjusted here, users should take
98: -- care of the adjustment by calling update_tier
99: -- 5) the other validations should be done by users also

Line 106: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,

102: (p_api_version IN NUMBER ,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
107: x_return_status OUT NOCOPY VARCHAR2 ,
108: x_msg_count OUT NOCOPY NUMBER ,
109: x_msg_data OUT NOCOPY VARCHAR2 );
110:

Line 117: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,

113: (p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

Line 118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,

Line 119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,

115: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,

Line 120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
124: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,

Line 121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

117: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
124: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
125: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,

Line 122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,

118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
124: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
125: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
126: -- R12 MOAC Changes --Start

Line 123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,

119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
124: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
125: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
126: -- R12 MOAC Changes --Start
127: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

Line 124: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,

120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
124: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
125: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
126: -- R12 MOAC Changes --Start
127: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
128: -- R12 MOAC Changes --End

Line 125: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,

121: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
122: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
124: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
125: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
126: -- R12 MOAC Changes --Start
127: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
128: -- R12 MOAC Changes --End
129: x_return_status OUT NOCOPY VARCHAR2 ,

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

123: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
124: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
125: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
126: -- R12 MOAC Changes --Start
127: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
128: -- R12 MOAC Changes --End
129: x_return_status OUT NOCOPY VARCHAR2 ,
130: x_msg_count OUT NOCOPY NUMBER ,
131: x_msg_data OUT NOCOPY VARCHAR2 );

Line 148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

144: (p_api_version IN NUMBER ,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,

Line 149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,

145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,

Line 150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,

146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,

Line 151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,

147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
155: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,

Line 152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,

148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
155: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
156: -- R12 MOAC Changes --Start

Line 153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,

149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
155: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
156: -- R12 MOAC Changes --Start
157: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new

Line 154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,

150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
155: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
156: -- R12 MOAC Changes --Start
157: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
158: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed

Line 155: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,

151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
152: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
155: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
156: -- R12 MOAC Changes --Start
157: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
158: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed
159: -- R12 MOAC Changes --End

Line 157: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new

153: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
155: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
156: -- R12 MOAC Changes --Start
157: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
158: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed
159: -- R12 MOAC Changes --End
160: x_return_status OUT NOCOPY VARCHAR2 ,
161: x_msg_count OUT NOCOPY NUMBER ,

Line 158: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed

154: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
155: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
156: -- R12 MOAC Changes --Start
157: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
158: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed
159: -- R12 MOAC Changes --End
160: x_return_status OUT NOCOPY VARCHAR2 ,
161: x_msg_count OUT NOCOPY NUMBER ,
162: x_msg_data OUT NOCOPY VARCHAR2 );