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_TIERS

Line 5: p_rate_sequence CN_RATE_TIERS.RATE_SEQUENCE%TYPE,

1: PACKAGE CN_MULTI_RATE_SCHEDULES_PVT AS
2: /*$Header: cnvrschs.pls 120.10 2007/03/27 15:12:10 kkanyara ship $*/
3:
4: TYPE comm_rec_type IS RECORD (
5: p_rate_sequence CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
6: p_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
7: p_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
8: p_org_id CN_RATE_TIERS.ORG_ID%TYPE
9: );

Line 6: p_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,

2: /*$Header: cnvrschs.pls 120.10 2007/03/27 15:12:10 kkanyara ship $*/
3:
4: TYPE comm_rec_type IS RECORD (
5: p_rate_sequence CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
6: p_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
7: p_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
8: p_org_id CN_RATE_TIERS.ORG_ID%TYPE
9: );
10:

Line 7: p_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,

3:
4: TYPE comm_rec_type IS RECORD (
5: p_rate_sequence CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
6: p_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
7: p_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
8: p_org_id CN_RATE_TIERS.ORG_ID%TYPE
9: );
10:
11:

Line 8: p_org_id CN_RATE_TIERS.ORG_ID%TYPE

4: TYPE comm_rec_type IS RECORD (
5: p_rate_sequence CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
6: p_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
7: p_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
8: p_org_id CN_RATE_TIERS.ORG_ID%TYPE
9: );
10:
11:
12: -- record type of the rate table dimensions

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 148: -- and cn_rate_tiers

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 ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 168: -- 2) if the rate table is not used, update and cn_rate_tiers;

164: x_msg_data OUT NOCOPY VARCHAR2 );
165:
166: -- Notes : Create dimension assignment
167: -- 1) If the rate table is used, new assignment can not be created
168: -- 2) if the rate table is not used, update and cn_rate_tiers;
169: -- and adjust cn_rate_tiers.rate_sequence
170: -- 3) update cn_rate_schedules.number_dim
171: -- 4) rate_dim_sequence is not adjusted here, users should do it by
172: -- calling update_dimension_assign

Line 169: -- and adjust cn_rate_tiers.rate_sequence

165:
166: -- Notes : Create dimension assignment
167: -- 1) If the rate table is used, new assignment can not be created
168: -- 2) if the rate table is not used, update and cn_rate_tiers;
169: -- and adjust cn_rate_tiers.rate_sequence
170: -- 3) update cn_rate_schedules.number_dim
171: -- 4) rate_dim_sequence is not adjusted here, users should do it by
172: -- calling update_dimension_assign
173: PROCEDURE create_dimension_assign

Line 191: (p_rate_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,

187: x_msg_data OUT NOCOPY VARCHAR2 );
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

Line 196: p_org_id IN CN_RATE_TIERS.ORG_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);
197: --R12 MOAC Changes--End
198:
199: -- procedure to delete rate tiers upon delete of rate dimension assignment or dimension tiers.
200: PROCEDURE delete_rate_tiers

Line 201: (p_rate_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,

197: --R12 MOAC Changes--End
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:

Line 208: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,

204: p_num_tiers NUMBER := 1);
205:
206: -- procedure to update a rate
207: PROCEDURE update_rate
208: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
209: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
210: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
211: --R12 MOAC Changes--Start
212: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed

Line 209: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,

205:
206: -- procedure to update a rate
207: PROCEDURE update_rate
208: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
209: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
210: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
211: --R12 MOAC Changes--Start
212: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
213: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE --new

Line 210: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,

206: -- procedure to update a rate
207: PROCEDURE update_rate
208: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
209: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
210: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
211: --R12 MOAC Changes--Start
212: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
213: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE --new
214: --R12 MOAC Changes--End

Line 212: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed

208: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
209: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
210: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
211: --R12 MOAC Changes--Start
212: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
213: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE --new
214: --R12 MOAC Changes--End
215: );
216:

Line 213: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE --new

209: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
210: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
211: --R12 MOAC Changes--Start
212: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
213: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE --new
214: --R12 MOAC Changes--End
215: );
216:
217: PROCEDURE update_srp_rate

Line 220: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,

216:
217: PROCEDURE update_srp_rate
218: (p_srp_quota_assign_id IN CN_SRP_QUOTA_ASSIGNS.SRP_QUOTA_ASSIGN_ID%TYPE,
219: p_rt_quota_asgn_id IN CN_SRP_RATE_ASSIGNS.RT_QUOTA_ASGN_ID%TYPE,
220: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
221: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
222: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- changed
223: --R12 MOAC Changes--Start
224: p_org_id CN_RATE_TIERS.ORG_ID%TYPE, --new

Line 221: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,

217: PROCEDURE update_srp_rate
218: (p_srp_quota_assign_id IN CN_SRP_QUOTA_ASSIGNS.SRP_QUOTA_ASSIGN_ID%TYPE,
219: p_rt_quota_asgn_id IN CN_SRP_RATE_ASSIGNS.RT_QUOTA_ASGN_ID%TYPE,
220: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
221: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
222: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- changed
223: --R12 MOAC Changes--Start
224: p_org_id CN_RATE_TIERS.ORG_ID%TYPE, --new
225: --R12 MOAC Changes--End

Line 222: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- changed

218: (p_srp_quota_assign_id IN CN_SRP_QUOTA_ASSIGNS.SRP_QUOTA_ASSIGN_ID%TYPE,
219: p_rt_quota_asgn_id IN CN_SRP_RATE_ASSIGNS.RT_QUOTA_ASGN_ID%TYPE,
220: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
221: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
222: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- changed
223: --R12 MOAC Changes--Start
224: p_org_id CN_RATE_TIERS.ORG_ID%TYPE, --new
225: --R12 MOAC Changes--End
226: x_return_status OUT NOCOPY VARCHAR2,

Line 224: p_org_id CN_RATE_TIERS.ORG_ID%TYPE, --new

220: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
221: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
222: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- changed
223: --R12 MOAC Changes--Start
224: p_org_id CN_RATE_TIERS.ORG_ID%TYPE, --new
225: --R12 MOAC Changes--End
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_loading_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,

Line 235: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,

231: );
232:
233: -- utility function to get the rate_tier_id and commission amount when given the tier combination
234: PROCEDURE get_rate_tier_info
235: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
236: p_rate_dim_tier_id_tbl IN num_tbl_type ,
237: x_rate_tier_id OUT NOCOPY CN_RATE_TIERS.RATE_TIER_ID%TYPE ,
238: x_rate_sequence OUT NOCOPY CN_RATE_TIERS.RATE_SEQUENCE%TYPE ,
239: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,

Line 237: x_rate_tier_id OUT NOCOPY CN_RATE_TIERS.RATE_TIER_ID%TYPE ,

233: -- utility function to get the rate_tier_id and commission amount when given the tier combination
234: PROCEDURE get_rate_tier_info
235: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
236: p_rate_dim_tier_id_tbl IN num_tbl_type ,
237: x_rate_tier_id OUT NOCOPY CN_RATE_TIERS.RATE_TIER_ID%TYPE ,
238: x_rate_sequence OUT NOCOPY CN_RATE_TIERS.RATE_SEQUENCE%TYPE ,
239: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
240: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE);
241:

Line 238: x_rate_sequence OUT NOCOPY CN_RATE_TIERS.RATE_SEQUENCE%TYPE ,

234: PROCEDURE get_rate_tier_info
235: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
236: p_rate_dim_tier_id_tbl IN num_tbl_type ,
237: x_rate_tier_id OUT NOCOPY CN_RATE_TIERS.RATE_TIER_ID%TYPE ,
238: x_rate_sequence OUT NOCOPY CN_RATE_TIERS.RATE_SEQUENCE%TYPE ,
239: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
240: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE);
241:
242: PROCEDURE update_comm_rate

Line 239: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,

235: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
236: p_rate_dim_tier_id_tbl IN num_tbl_type ,
237: x_rate_tier_id OUT NOCOPY CN_RATE_TIERS.RATE_TIER_ID%TYPE ,
238: x_rate_sequence OUT NOCOPY CN_RATE_TIERS.RATE_SEQUENCE%TYPE ,
239: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
240: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE);
241:
242: PROCEDURE update_comm_rate
243: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,

Line 240: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE);

236: p_rate_dim_tier_id_tbl IN num_tbl_type ,
237: x_rate_tier_id OUT NOCOPY CN_RATE_TIERS.RATE_TIER_ID%TYPE ,
238: x_rate_sequence OUT NOCOPY CN_RATE_TIERS.RATE_SEQUENCE%TYPE ,
239: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
240: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE);
241:
242: PROCEDURE update_comm_rate
243: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
244: x_result_tbl IN comm_tbl_type,

Line 243: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,

239: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
240: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE);
241:
242: PROCEDURE update_comm_rate
243: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
244: x_result_tbl IN comm_tbl_type,
245: --R12 MOAC Changes--Start
246: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE --new
247: --R12 MOAC Changes--End

Line 246: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE --new

242: PROCEDURE update_comm_rate
243: (p_rate_schedule_id IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
244: x_result_tbl IN comm_tbl_type,
245: --R12 MOAC Changes--Start
246: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE --new
247: --R12 MOAC Changes--End
248: );
249:
250: PROCEDURE duplicate_rate_Schedule

Line 268: FUNCTION get_sequence(x_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,sbuf varchar2)

264:
265: );
266:
267:
268: FUNCTION get_sequence(x_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,sbuf varchar2)
269: RETURN Number;
270: END CN_MULTI_RATE_SCHEDULES_PVT;