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_PVT dependencies on CN_RATE_SCH_DIMS

Line 14: (rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE := NULL,

10:
11:
12: -- record type of the rate table dimensions
13: TYPE dim_rec_type IS RECORD
14: (rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE := NULL,
15: rate_dimension_id CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
16: rate_schedule_id CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
17: rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
18: rate_dim_name CN_RATE_DIMENSIONS.NAME%TYPE,

Line 15: rate_dimension_id CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,

11:
12: -- record type of the rate table dimensions
13: TYPE dim_rec_type IS RECORD
14: (rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE := NULL,
15: rate_dimension_id CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
16: rate_schedule_id CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
17: rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
18: rate_dim_name CN_RATE_DIMENSIONS.NAME%TYPE,
19: number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,

Line 16: rate_schedule_id CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

12: -- record type of the rate table dimensions
13: TYPE dim_rec_type IS RECORD
14: (rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE := NULL,
15: rate_dimension_id CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
16: rate_schedule_id CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
17: rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
18: rate_dim_name CN_RATE_DIMENSIONS.NAME%TYPE,
19: number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
20: dim_unit_code CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

Line 17: rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

13: TYPE dim_rec_type IS RECORD
14: (rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE := NULL,
15: rate_dimension_id CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
16: rate_schedule_id CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
17: rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
18: rate_dim_name CN_RATE_DIMENSIONS.NAME%TYPE,
19: number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
20: dim_unit_code CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
21: object_version_number CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE);

Line 111: -- cn_rate_sch_dims and cn_rate_tiers

107:
108: -- Notes : Delete rate schedule
109: -- 1) If it is used, it can not be deleted
110: -- 2) If it can be deleted, delete corresponding records in
111: -- cn_rate_sch_dims and cn_rate_tiers
112: PROCEDURE Delete_Schedule
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 ,

Line 127: -- 2) delete the corresponding records in cn_rate_sch_dims and cn_rate_tiers

123: x_msg_data OUT NOCOPY VARCHAR2 );
124:
125: -- Notes : Delete schedule dimension
126: -- 1) If the rate schedule is used, its dimensions can not be deleted
127: -- 2) delete the corresponding records in cn_rate_sch_dims and cn_rate_tiers
128: -- 3) update cn_rate_schedules.number_dim if not called from form
129: -- 4) rate_dim_sequence is not adjusted here, users should take
130: -- care of the adjustment by calling update_dimension_assign
131: PROCEDURE delete_dimension_assign

Line 136: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,

132: (p_api_version IN NUMBER ,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
137: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
138: --R12 MOAC Changes--Start
139: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
140: --R12 MOAC Changes--End

Line 137: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
137: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
138: --R12 MOAC Changes--Start
139: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
140: --R12 MOAC Changes--End
141: x_return_status OUT NOCOPY VARCHAR2 ,

Line 147: -- 2) If it can be updated, update records in cn_rate_sch_dims

143: x_msg_data OUT NOCOPY VARCHAR2 );
144:
145: -- Notes : Update dimension assignment
146: -- 1) If the rate table is used, then update is not allowed
147: -- 2) If it can be updated, update records in cn_rate_sch_dims
148: -- and cn_rate_tiers
149: PROCEDURE update_dimension_assign
150: (p_api_version IN NUMBER ,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

Line 154: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,

150: (p_api_version IN NUMBER ,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
157: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
158: --R12 MOAC Changes--Start

Line 155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
157: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
158: --R12 MOAC Changes--Start
159: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

Line 156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,

152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
157: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
158: --R12 MOAC Changes--Start
159: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
160: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, --changed

Line 157: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,

153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
157: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
158: --R12 MOAC Changes--Start
159: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
160: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, --changed
161: --R12 MOAC Changes--End

Line 178: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

174: (p_api_version IN NUMBER ,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
180: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
181: --R12 MOAC Changes--Start
182: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

Line 179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,

175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
180: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
181: --R12 MOAC Changes--Start
182: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
183: x_rate_sch_dim_id IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE, --changed

Line 180: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
180: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
181: --R12 MOAC Changes--Start
182: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
183: x_rate_sch_dim_id IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE, --changed
184: --R12 MOAC Changes--End

Line 183: x_rate_sch_dim_id IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE, --changed

179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
180: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
181: --R12 MOAC Changes--Start
182: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
183: x_rate_sch_dim_id IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE, --changed
184: --R12 MOAC Changes--End
185: x_return_status OUT NOCOPY VARCHAR2 ,
186: x_msg_count OUT NOCOPY NUMBER ,
187: x_msg_data OUT NOCOPY VARCHAR2 );

Line 192: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := NULL,

188:
189: -- procedure to create rate tiers upon insert of rate dimension assignment or dimension tiers.
190: PROCEDURE create_rate_tiers
191: (p_rate_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
192: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := NULL,
193: p_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := NULL,
194: p_num_tiers NUMBER := 1,
195: --R12 MOAC Changes--Start
196: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE);

Line 202: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

198:
199: -- procedure to delete rate tiers upon delete of rate dimension assignment or dimension tiers.
200: PROCEDURE delete_rate_tiers
201: (p_rate_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
202: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
203: p_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := NULL,
204: p_num_tiers NUMBER := 1);
205:
206: -- procedure to update a rate