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_SCHEDULES

Line 8: (p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := NULL,

4: G_PKG_NAME CONSTANT VARCHAR2(30) :='CN_MULTI_RATE_SCHEDULES_PVT';
5:
6: -- validate schedule name and commission_unit_code
7: PROCEDURE validate_schedule
8: (p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := NULL,
9: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
10: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
11: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
12: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,

Line 9: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,

5:
6: -- validate schedule name and commission_unit_code
7: PROCEDURE validate_schedule
8: (p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := NULL,
9: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
10: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
11: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
12: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
13: --R12 MOAC Changes--Start

Line 10: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

6: -- validate schedule name and commission_unit_code
7: PROCEDURE validate_schedule
8: (p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := NULL,
9: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
10: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
11: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
12: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
13: --R12 MOAC Changes--Start
14: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE --new

Line 11: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

7: PROCEDURE validate_schedule
8: (p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := NULL,
9: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
10: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
11: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
12: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
13: --R12 MOAC Changes--Start
14: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE --new
15: --R12 MOAC Changes--End

Line 14: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE --new

10: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
11: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
12: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
13: --R12 MOAC Changes--Start
14: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE --new
15: --R12 MOAC Changes--End
16: )
17: IS
18: l_prompt cn_lookups.meaning%TYPE;

Line 23: FROM cn_rate_schedules

19: l_dummy NUMBER;
20:
21: CURSOR name_exists IS
22: SELECT 1
23: FROM cn_rate_schedules
24: WHERE name = p_name
25: AND (p_rate_schedule_id IS NULL OR p_rate_schedule_id <> rate_schedule_id)
26: --R12 MOAC Changes--Start
27: AND org_id = p_org_id;

Line 96: PROCEDURE usage_check(p_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

92: END IF;
93:
94: END validate_schedule;
95:
96: PROCEDURE usage_check(p_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
97: x_usage_code OUT NOCOPY VARCHAR2)
98: IS
99: CURSOR usage_check IS
100: SELECT 'USED'

Line 147: from cn_rate_schedules s, cn_rt_quota_asgns rqa

143: l_list wf_parameter_list_t;
144:
145: cursor get_rate_info is
146: select s.name, rqa.start_date, rqa.end_date, s.commission_unit_code, s.rate_schedule_id
147: from cn_rate_schedules s, cn_rt_quota_asgns rqa
148: where s.rate_schedule_id = rqa.rate_schedule_id
149: and rqa.rt_quota_asgn_id = p_rt_quota_asgn_id;
150: l_info_rec get_rate_info%rowtype;
151:

Line 154: from cn_rate_schedules s

150: l_info_rec get_rate_info%rowtype;
151:
152: cursor get_rate_info_for_mul_rate is
153: select s.name,null,null,s.commission_unit_code, s.rate_schedule_id
154: from cn_rate_schedules s
155: where s.rate_schedule_id =p_rate_schedule_id;
156:
157: cursor get_rate_dims(p_rate_schedule_id NUMBER) is
158: select d.name, d.rate_dimension_id, d.number_tier

Line 246: p_source_object_code => 'CN_RATE_SCHEDULES',--CN_SRP_QUOTA_ASSIGNS

242: x_return_status => x_return_status,
243: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data,
245: p_source_object_id => p_rate_schedule_id ,--p_srp_quota_assign_id
246: p_source_object_code => 'CN_RATE_SCHEDULES',--CN_SRP_QUOTA_ASSIGNS
247: p_notes => l_note_msg,
248: p_notes_detail => l_note_msg,
249: p_note_type => 'CN_SYSGEN', -- for system generated
250: x_jtf_note_id => x_note_id -- returned

Line 312: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,

308: (p_api_version IN NUMBER ,
309: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
310: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
311: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
312: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
313: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
314: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
315: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
316: --R12 MOAC Changes--Start

Line 313: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

309: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
310: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
311: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
312: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
313: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
314: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
315: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
316: --R12 MOAC Changes--Start
317: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

Line 314: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used

310: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
311: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
312: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
313: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
314: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
315: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
316: --R12 MOAC Changes--Start
317: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
318: x_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed

Line 317: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

313: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
314: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
315: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
316: --R12 MOAC Changes--Start
317: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
318: x_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
319: --R12 MOAC Changes--End
320: x_return_status OUT NOCOPY VARCHAR2 ,
321: x_msg_count OUT NOCOPY NUMBER ,

Line 318: x_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed

314: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
315: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
316: --R12 MOAC Changes--Start
317: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
318: x_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
319: --R12 MOAC Changes--End
320: x_return_status OUT NOCOPY VARCHAR2 ,
321: x_msg_count OUT NOCOPY NUMBER ,
322: x_msg_data OUT NOCOPY VARCHAR2 )

Line 326: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;

322: x_msg_data OUT NOCOPY VARCHAR2 )
323: IS
324: l_api_name CONSTANT VARCHAR2(30) := 'Create_Schedule';
325: l_api_version CONSTANT NUMBER := 1.0;
326: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;
327: l_temp_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
328:
329: --R12 Notes Hoistory
330: l_rate_sch_name VARCHAR2(80);

Line 368: -- call table handler to create rate schedule record in cn_rate_schedules

364: p_org_id => p_org_id
365: --R12 MOAC Changes--End
366: );
367:
368: -- call table handler to create rate schedule record in cn_rate_schedules
369: cn_multi_rate_schedules_pkg.insert_row(x_rate_schedule_id => x_rate_schedule_id,
370: x_name => p_name,
371: x_commission_unit_code => p_commission_unit_code,
372: x_number_dim => l_number_dim,

Line 381: from cn_rate_schedules

377: -- *********************************************************************
378: -- ************ Start - R12 Notes History ************** ***************
379: -- *********************************************************************
380: select name into l_rate_sch_name
381: from cn_rate_schedules
382: where rate_schedule_id = x_rate_schedule_id;
383:
384: fnd_message.set_name('CN', 'CNR12_NOTE_RT_CREATE');
385: fnd_message.set_token('RT_NAME', l_rate_sch_name);

Line 394: p_source_object_code => 'CN_RATE_SCHEDULES',

390: x_return_status => x_return_status,
391: x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data,
393: p_source_object_id => x_rate_schedule_id,
394: p_source_object_code => 'CN_RATE_SCHEDULES',
395: p_notes => l_note_msg,
396: p_notes_detail => l_note_msg,
397: p_note_type => 'CN_SYSGEN', -- for system generated
398: x_jtf_note_id => l_note_id -- returned

Line 510: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

506: (p_api_version IN NUMBER ,
507: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
508: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
511: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
512: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
513: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
514: --R12 MOAC Changes--Start

Line 511: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,

507: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
508: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
511: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
512: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
513: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
514: --R12 MOAC Changes--Start
515: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

Line 512: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

508: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
511: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
512: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
513: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
514: --R12 MOAC Changes--Start
515: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
516: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed

Line 513: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used

509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
511: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
512: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
513: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
514: --R12 MOAC Changes--Start
515: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
516: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed
517: --R12 MOAC Changes--End

Line 515: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

511: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
512: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
513: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
514: --R12 MOAC Changes--Start
515: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
516: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed
517: --R12 MOAC Changes--End
518: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
519: x_return_status OUT NOCOPY VARCHAR2 ,

Line 516: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed

512: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
513: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE, -- not used
514: --R12 MOAC Changes--Start
515: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
516: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- Changed
517: --R12 MOAC Changes--End
518: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,
519: x_return_status OUT NOCOPY VARCHAR2 ,
520: x_msg_count OUT NOCOPY NUMBER ,

Line 527: l_commission_unit_code_old CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;

523: l_api_name CONSTANT VARCHAR2(30) := 'Update_Schedule';
524: l_api_version CONSTANT NUMBER := 1.0;
525:
526: l_temp_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
527: l_commission_unit_code_old CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
528: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;
529: l_number_dim_old CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;
530: l_delete_flag VARCHAR2(1);
531: l_usage_code VARCHAR2(30);

Line 528: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;

524: l_api_version CONSTANT NUMBER := 1.0;
525:
526: l_temp_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
527: l_commission_unit_code_old CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
528: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;
529: l_number_dim_old CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;
530: l_delete_flag VARCHAR2(1);
531: l_usage_code VARCHAR2(30);
532: i pls_integer;

Line 529: l_number_dim_old CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;

525:
526: l_temp_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
527: l_commission_unit_code_old CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE;
528: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;
529: l_number_dim_old CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := 0;
530: l_delete_flag VARCHAR2(1);
531: l_usage_code VARCHAR2(30);
532: i pls_integer;
533:

Line 544: FROM cn_rate_schedules

540:
541:
542: CURSOR schedule_info IS
543: SELECT commission_unit_code, number_dim
544: FROM cn_rate_schedules
545: WHERE rate_schedule_id = p_rate_schedule_id;
546:
547: CURSOR db_dim_assignments IS
548: SELECT rate_sch_dim_id

Line 605: from cn_rate_schedules

601: END IF;
602:
603: -- Start - R12 Notes History Query for old Rate Table Name
604: select name into l_rate_sch_old
605: from cn_rate_schedules
606: where rate_schedule_id = p_rate_schedule_id;
607:
608: select commission_unit_code into l_type_old
609: from cn_rate_schedules

Line 609: from cn_rate_schedules

605: from cn_rate_schedules
606: where rate_schedule_id = p_rate_schedule_id;
607:
608: select commission_unit_code into l_type_old
609: from cn_rate_schedules
610: where rate_schedule_id = p_rate_schedule_id;
611: -- End - R12 Notes History Query for old Rate Table Name
612:
613: -- lock rate schedule for update or delete

Line 681: p_source_object_code => 'CN_RATE_SCHEDULES',

677: x_return_status => x_return_status,
678: x_msg_count => x_msg_count,
679: x_msg_data => x_msg_data,
680: p_source_object_id => p_rate_schedule_id,
681: p_source_object_code => 'CN_RATE_SCHEDULES',
682: p_notes => l_note_msg,
683: p_notes_detail => l_note_msg,
684: p_note_type => 'CN_SYSGEN', -- for system generated
685: x_jtf_note_id => l_note_id -- returned

Line 704: p_source_object_code => 'CN_RATE_SCHEDULES',

700: x_return_status => x_return_status,
701: x_msg_count => x_msg_count,
702: x_msg_data => x_msg_data,
703: p_source_object_id => p_rate_schedule_id,
704: p_source_object_code => 'CN_RATE_SCHEDULES',
705: p_notes => l_note_msg,
706: p_notes_detail => l_note_msg,
707: p_note_type => 'CN_SYSGEN', -- for system generated
708: x_jtf_note_id => l_note_id -- returned

Line 720: p_source_object_code => 'CN_RATE_SCHEDULES',

716: x_return_status => x_return_status,
717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data,
719: p_source_object_id => p_rate_schedule_id,
720: p_source_object_code => 'CN_RATE_SCHEDULES',
721: p_notes => l_consolidated_note,
722: p_notes_detail => l_consolidated_note,
723: p_note_type => 'CN_SYSGEN', -- for system generated
724: x_jtf_note_id => l_note_id -- returned

Line 807: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

803: (p_api_version IN NUMBER ,
804: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
805: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
808: --R12 MOAC Changes--Start
809: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
810: --R12 MOAC Changes--End
811: x_return_status OUT NOCOPY VARCHAR2 ,

Line 809: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new

805: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
808: --R12 MOAC Changes--Start
809: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
810: --R12 MOAC Changes--End
811: x_return_status OUT NOCOPY VARCHAR2 ,
812: x_msg_count OUT NOCOPY NUMBER ,
813: x_msg_data OUT NOCOPY VARCHAR2 )

Line 858: FROM cn_rate_schedules

854: END IF;
855:
856: /* Start - R12 Notes History */
857: SELECT org_id INTO l_org_id
858: FROM cn_rate_schedules
859: WHERE rate_schedule_id = p_rate_schedule_id;
860:
861: SELECT name INTO l_rate_sch_name
862: FROM cn_rate_schedules

Line 862: FROM cn_rate_schedules

858: FROM cn_rate_schedules
859: WHERE rate_schedule_id = p_rate_schedule_id;
860:
861: SELECT name INTO l_rate_sch_name
862: FROM cn_rate_schedules
863: WHERE rate_schedule_id = p_rate_schedule_id;
864: /* End - R12 Notes History */
865:
866: -- deleting a rate schedule causes cascading delete

Line 961: -- 3) update cn_rate_schedules.number_dim if not called from form

957: --
958: -- Notes : Delete schedule dimension
959: -- 1) If the rate schedule is used, its dimensions can not be deleted
960: -- 2) delete the corresponding records in cn_rate_sch_dims and cn_rate_tiers
961: -- 3) update cn_rate_schedules.number_dim if not called from form
962: -- 4) rate_dim_sequence is not adjusted here, users should take care
963: -- of the adjustment by calling
964: -- update_dimension_assign
965: --

Line 975: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new

971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
972: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
973: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
974: --R12 MOAC Changes--Start
975: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
976: --R12 MOAC Changes--End
977: x_return_status OUT NOCOPY VARCHAR2 ,
978: x_msg_count OUT NOCOPY NUMBER ,
979: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1054: from cn_rate_schedules

1050: from cn_rate_dimensions
1051: where rate_dimension_id = l_dimension_id;
1052:
1053: select name into l_rate_sch_name_old
1054: from cn_rate_schedules
1055: where rate_schedule_id = p_rate_schedule_id;
1056:
1057: /* End - R12 Notes History */
1058:

Line 1077: p_source_object_code => 'CN_RATE_SCHEDULES',

1073: x_return_status => x_return_status,
1074: x_msg_count => x_msg_count,
1075: x_msg_data => x_msg_data,
1076: p_source_object_id => p_rate_schedule_id,
1077: p_source_object_code => 'CN_RATE_SCHEDULES',
1078: p_notes => l_note_msg,
1079: p_notes_detail => l_note_msg,
1080: p_note_type => 'CN_SYSGEN', -- for system generated
1081: x_jtf_note_id => l_note_id -- returned

Line 1091: UPDATE cn_rate_schedules

1087: -- *********************************************************************
1088:
1089: -- update rate schedule (number_dim is treated as a "virtual column" - just a
1090: -- count(*) of dimensions assigned to the rate_schedule... it is not ovn controlled here
1091: UPDATE cn_rate_schedules
1092: SET number_dim = (select count(*) from cn_rate_sch_dims
1093: where rate_schedule_id = p_rate_schedule_id)
1094: WHERE rate_schedule_id = p_rate_schedule_id;
1095:

Line 1181: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

1177: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
1178: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
1179: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num, -- not used
1180: --R12 MOAC Changes--Start
1181: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
1182: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, --changed
1183: --R12 MOAC Changes--End
1184: x_return_status OUT NOCOPY VARCHAR2 ,
1185: x_msg_count OUT NOCOPY NUMBER ,

Line 1182: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, --changed

1178: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
1179: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num, -- not used
1180: --R12 MOAC Changes--Start
1181: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
1182: p_object_version_number IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, --changed
1183: --R12 MOAC Changes--End
1184: x_return_status OUT NOCOPY VARCHAR2 ,
1185: x_msg_count OUT NOCOPY NUMBER ,
1186: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1339: p_source_object_code => 'CN_RATE_SCHEDULES',

1335: x_return_status => x_return_status,
1336: x_msg_count => x_msg_count,
1337: x_msg_data => x_msg_data,
1338: p_source_object_id => p_rate_schedule_id,
1339: p_source_object_code => 'CN_RATE_SCHEDULES',
1340: p_notes => l_note_msg,
1341: p_notes_detail => l_note_msg,
1342: p_note_type => 'CN_SYSGEN', -- for system generated
1343: x_jtf_note_id => l_note_id -- returned

Line 1418: -- 3) update cn_rate_schedules.number_dim

1414: -- Notes : Create dimension assignment
1415: -- 1) If the rate table is used, new assignment can not be created
1416: -- 2) if the rate table is not used, update cn_rate_tiers;
1417: -- and adjust cn_rate_tiers.rate_sequence
1418: -- 3) update cn_rate_schedules.number_dim
1419: -- 4) rate_dim_sequence is not adjusted here, users should do it by
1420: -- calling update_dimension_assign
1421: --
1422: -- End of comments

Line 1432: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

1428: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
1429: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
1430: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
1431: --R12 MOAC Changes--Start
1432: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
1433: x_rate_sch_dim_id IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE, --changed
1434: --R12 MOAC Changes--End
1435: x_return_status OUT NOCOPY VARCHAR2 ,
1436: x_msg_count OUT NOCOPY NUMBER ,

Line 1532: from cn_rate_schedules

1528: from cn_rate_dimensions
1529: where rate_dimension_id = p_rate_dimension_id;
1530:
1531: select name into l_rate_sch_name
1532: from cn_rate_schedules
1533: where rate_schedule_id = p_rate_schedule_id;
1534:
1535: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_CREATE');
1536: fnd_message.set_token('RT_DIM', l_dimension_name);

Line 1546: p_source_object_code => 'CN_RATE_SCHEDULES',

1542: x_return_status => x_return_status,
1543: x_msg_count => x_msg_count,
1544: x_msg_data => x_msg_data,
1545: p_source_object_id => p_rate_schedule_id,
1546: p_source_object_code => 'CN_RATE_SCHEDULES',
1547: p_notes => l_note_msg,
1548: p_notes_detail => l_note_msg,
1549: p_note_type => 'CN_SYSGEN', -- for system generated
1550: x_jtf_note_id => l_note_id -- returned

Line 1559: UPDATE cn_rate_schedules

1555: -- *********************************************************************
1556:
1557: -- update rate schedule (number_dim is treated as a "virtual column" - just a
1558: -- count(*) of dimensions assigned to the rate_schedule... it is not ovn controlled here
1559: UPDATE cn_rate_schedules
1560: SET number_dim = l_num_dims + 1
1561: WHERE rate_schedule_id = p_rate_schedule_id;
1562:
1563: -- insert records into cn_rate_tiers

Line 1639: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;

1635: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE
1636: --R12 MOAC Changes--End
1637: ) IS
1638:
1639: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
1640: l_coords NUM_TBL_TYPE;
1641: l_seq NUMBER;
1642: l_new_seq NUMBER;
1643: l_dim_count NUMBER := 0; -- number of dimensions in cn_rate_sch_dims for this rate table

Line 1664: FROM cn_rate_schedules

1660:
1661: BEGIN
1662: SELECT number_dim
1663: INTO l_number_dim
1664: FROM cn_rate_schedules
1665: WHERE rate_schedule_id = p_rate_schedule_id;
1666:
1667: -- build dimension size table
1668: FOR dim IN dims_info LOOP

Line 1742: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;

1738: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
1739: p_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := NULL,
1740: p_num_tiers NUMBER := 1) IS
1741:
1742: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
1743: l_coords NUM_TBL_TYPE;
1744: l_seq NUMBER;
1745: l_new_seq NUMBER;
1746: l_dim_count NUMBER := 0; -- number of dimensions in cn_rate_sch_dims for this rate table

Line 1768: FROM cn_rate_schedules

1764:
1765: BEGIN
1766: SELECT number_dim
1767: INTO l_number_dim
1768: FROM cn_rate_schedules
1769: WHERE rate_schedule_id = p_rate_schedule_id;
1770:
1771: -- build dimension size table
1772: FOR dim IN dims_info LOOP

Line 2214: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;

2210: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
2211: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2212: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
2213: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
2214: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
2215:
2216: dim_size_table num_tbl_type;
2217: current_tier_table num_tbl_type;
2218:

Line 2326: select number_dim into l_number_dim from cn_rate_schedules

2322: l_tbl APPS.CN_MULTI_RATE_SCHEDULES_PVT.NUM_TBL_TYPE;
2323:
2324: begin
2325: -- if rate schedule is 1-dimensional, then don't need to do lot of fancy parsing
2326: select number_dim into l_number_dim from cn_rate_schedules
2327: where rate_schedule_id = x_schedule_id;
2328:
2329: if l_number_dim = 1 then
2330: -- strip off extra commas

Line 2390: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,

2386: (p_api_version IN NUMBER ,
2387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2390: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
2391: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
2392: --R12 MOAC Changes--End
2393: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
2394: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

Line 2391: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

2387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2390: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
2391: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
2392: --R12 MOAC Changes--End
2393: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
2394: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
2395: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

Line 2393: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed

2389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2390: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
2391: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
2392: --R12 MOAC Changes--End
2393: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
2394: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
2395: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
2396: x_return_status OUT NOCOPY VARCHAR2,
2397: x_msg_count OUT NOCOPY NUMBER,

Line 2394: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

2390: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
2391: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
2392: --R12 MOAC Changes--End
2393: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
2394: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
2395: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
2396: x_return_status OUT NOCOPY VARCHAR2,
2397: x_msg_count OUT NOCOPY NUMBER,
2398: x_msg_data OUT NOCOPY VARCHAR2

Line 2395: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

2391: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
2392: --R12 MOAC Changes--End
2393: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed
2394: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
2395: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
2396: x_return_status OUT NOCOPY VARCHAR2,
2397: x_msg_count OUT NOCOPY NUMBER,
2398: x_msg_data OUT NOCOPY VARCHAR2
2399:

Line 2415: CURSOR rate_sch_tiers_info(l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE) IS

2411: where rate_dimension_id = l_dim_id
2412: and org_id = p_org_id;
2413:
2414:
2415: CURSOR rate_sch_tiers_info(l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE) IS
2416: select * from cn_rate_tiers_all
2417: where rate_schedule_id = l_rate_schedule_id
2418: and org_id = p_org_id;
2419:

Line 2422: l_new_name CN_RATE_SCHEDULES.NAME%TYPE;

2418: and org_id = p_org_id;
2419:
2420:
2421:
2422: l_new_name CN_RATE_SCHEDULES.NAME%TYPE;
2423: l_tbl_type dims_tbl_type;
2424: --l_rate_sch_rec rate_sch_dim%ROWTYPE;
2425: l_rate_dim_info_rec rate_dim_info%ROWTYPE;
2426: l_rate_tier_rec rate_sch_tiers_info%ROWTYPE ;

Line 2427: old_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;

2423: l_tbl_type dims_tbl_type;
2424: --l_rate_sch_rec rate_sch_dim%ROWTYPE;
2425: l_rate_dim_info_rec rate_dim_info%ROWTYPE;
2426: l_rate_tier_rec rate_sch_tiers_info%ROWTYPE ;
2427: old_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
2428:
2429:
2430:
2431: next_row NUMBER ;

Line 2444: select name into p_name from cn_rate_schedules_all where rate_schedule_id = p_rate_schedule_id

2440: old_rate_schedule_id:=p_rate_schedule_id;
2441: next_row:=1;
2442:
2443:
2444: select name into p_name from cn_rate_schedules_all where rate_schedule_id = p_rate_schedule_id
2445: and org_id = p_org_id;
2446:
2447:
2448: l_new_name:=p_name;