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_DIMENSIONS

Line 1: PACKAGE BODY CN_RATE_DIMENSIONS_PVT AS

1: PACKAGE BODY CN_RATE_DIMENSIONS_PVT AS
2: /*$Header: cnvrdimb.pls 120.9 2007/08/08 19:21:44 jxsingh ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='CN_RATE_DIMENSIONS_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) :='CN_RATE_DIMENSIONS_PVT';

1: PACKAGE BODY CN_RATE_DIMENSIONS_PVT AS
2: /*$Header: cnvrdimb.pls 120.9 2007/08/08 19:21:44 jxsingh ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='CN_RATE_DIMENSIONS_PVT';
5:
6: -- validate dimension name and dim_unit_code
7: PROCEDURE validate_dimension
8: (p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE := NULL,

Line 8: (p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE := NULL,

4: G_PKG_NAME CONSTANT VARCHAR2(30) :='CN_RATE_DIMENSIONS_PVT';
5:
6: -- validate dimension name and dim_unit_code
7: PROCEDURE validate_dimension
8: (p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE := NULL,
9: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
10: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
11: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
12: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,

Line 9: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

5:
6: -- validate dimension name and dim_unit_code
7: PROCEDURE validate_dimension
8: (p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE := NULL,
9: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
10: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
11: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
12: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
13: --R12 MOAC Changes--Start

Line 10: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

6: -- validate dimension name and dim_unit_code
7: PROCEDURE validate_dimension
8: (p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE := NULL,
9: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
10: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
11: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
12: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
13: --R12 MOAC Changes--Start
14: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE)

Line 11: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,

7: PROCEDURE validate_dimension
8: (p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE := NULL,
9: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
10: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
11: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
12: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
13: --R12 MOAC Changes--Start
14: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE)
15: --R12 MOAC Changes--End

Line 14: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE)

10: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
11: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
12: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
13: --R12 MOAC Changes--Start
14: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE)
15: --R12 MOAC Changes--End
16: IS
17: l_prompt CN_LOOKUPS.MEANING%TYPE;
18: l_dummy NUMBER;

Line 37: FROM cn_rate_dimensions

33: AND (exp_type_code IS NULL OR exp_type_code NOT LIKE '%DDT%');
34:
35: CURSOR name_exists IS
36: SELECT 1
37: FROM cn_rate_dimensions
38: WHERE name = p_name
39: AND (p_rate_dimension_id IS NULL OR p_rate_dimension_id <> rate_dimension_id)
40: --R12 MOAC Changes--Start
41: AND org_id = p_org_id;

Line 164: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

160: (p_api_version IN NUMBER ,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
165: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
166: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
167: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
168: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,

Line 165: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,

161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
165: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
166: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
167: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
168: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
169: --R12 MOAC Changes--Start

Line 166: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

162: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
165: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
166: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
167: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
168: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
169: --R12 MOAC Changes--Start
170: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new

Line 167: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used

163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
165: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
166: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
167: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
168: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
169: --R12 MOAC Changes--Start
170: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
171: x_rate_dimension_id IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE, --changed

Line 170: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new

166: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
167: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
168: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
169: --R12 MOAC Changes--Start
170: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
171: x_rate_dimension_id IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE, --changed
172: --R12 MOAC Changes--End
173: x_return_status OUT NOCOPY VARCHAR2 ,
174: x_msg_count OUT NOCOPY NUMBER ,

Line 171: x_rate_dimension_id IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE, --changed

167: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
168: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
169: --R12 MOAC Changes--Start
170: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
171: x_rate_dimension_id IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE, --changed
172: --R12 MOAC Changes--End
173: x_return_status OUT NOCOPY VARCHAR2 ,
174: x_msg_count OUT NOCOPY NUMBER ,
175: x_msg_data OUT NOCOPY VARCHAR2 )

Line 181: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;

177: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dimension';
178: l_api_version CONSTANT NUMBER := 1.0;
179:
180: l_temp_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
181: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
182:
183: --R12 Notes Hoistory
184: l_dimension_name VARCHAR2(30);
185: l_note_msg VARCHAR2(240);

Line 222: -- call table handler to create dimension record in cn_rate_dimensions

218: --R12 MOAC Changes--Start
219: p_org_id);
220: --R12 MOAC Changes--End
221:
222: -- call table handler to create dimension record in cn_rate_dimensions
223: cn_rate_dimensions_pkg.insert_row
224: (x_rate_dimension_id => x_rate_dimension_id,
225: x_name => p_name,
226: x_description => p_description,

Line 223: cn_rate_dimensions_pkg.insert_row

219: p_org_id);
220: --R12 MOAC Changes--End
221:
222: -- call table handler to create dimension record in cn_rate_dimensions
223: cn_rate_dimensions_pkg.insert_row
224: (x_rate_dimension_id => x_rate_dimension_id,
225: x_name => p_name,
226: x_description => p_description,
227: x_dim_unit_code => p_dim_unit_code,

Line 238: from cn_rate_dimensions

234: -- *********************************************************************
235: -- ************ Start - R12 Notes History ************** ***************
236: -- *********************************************************************
237: select name into l_dimension_name
238: from cn_rate_dimensions
239: where rate_dimension_id = x_rate_dimension_id;
240:
241: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_CREATE');
242: fnd_message.set_token('RT_DIM', l_dimension_name);

Line 251: p_source_object_code => 'CN_RATE_DIMENSIONS',

247: x_return_status => x_return_status,
248: x_msg_count => x_msg_count,
249: x_msg_data => x_msg_data,
250: p_source_object_id => x_rate_dimension_id,
251: p_source_object_code => 'CN_RATE_DIMENSIONS',
252: p_notes => l_note_msg,
253: p_notes_detail => l_note_msg,
254: p_note_type => 'CN_SYSGEN', -- for system generated
255: x_jtf_note_id => l_note_id -- returned

Line 351: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,

347: (p_api_version IN NUMBER ,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
352: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
353: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
354: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
355: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used

Line 352: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
352: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
353: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
354: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
355: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
356: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,

Line 353: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,

349: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
352: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
353: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
354: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
355: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
356: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
357: --R12 MOAC Changes--Start

Line 354: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
352: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
353: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
354: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
355: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
356: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
357: --R12 MOAC Changes--Start
358: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new

Line 355: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used

351: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
352: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
353: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
354: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
355: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
356: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
357: --R12 MOAC Changes--Start
358: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
359: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --Changed

Line 358: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new

354: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
355: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
356: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
357: --R12 MOAC Changes--Start
358: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
359: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --Changed
360: --R12 MOAC Changes--End
361: x_return_status OUT NOCOPY VARCHAR2 ,
362: x_msg_count OUT NOCOPY NUMBER ,

Line 359: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --Changed

355: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE, -- not used
356: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
357: --R12 MOAC Changes--Start
358: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
359: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --Changed
360: --R12 MOAC Changes--End
361: x_return_status OUT NOCOPY VARCHAR2 ,
362: x_msg_count OUT NOCOPY NUMBER ,
363: x_msg_data OUT NOCOPY VARCHAR2 )

Line 372: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;

368: l_temp_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
369: l_dim_unit_code CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE;
370: l_delete_flag VARCHAR2(1);
371: l_dummy NUMBER;
372: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
373:
374: --R12 Notes Hoistory
375: l_dimension_name_old VARCHAR2(30);
376: l_type_old VARCHAR2(30);

Line 382: FROM cn_rate_dimensions

378: l_note_id NUMBER;
379: l_consolidated_note VARCHAR2(2000);
380: CURSOR dim_unit_code IS
381: SELECT dim_unit_code
382: FROM cn_rate_dimensions
383: WHERE rate_dimension_id = p_rate_dimension_id;
384:
385: CURSOR formula_info IS
386: SELECT 1

Line 542: from cn_rate_dimensions

538: -- *********************************************************************
539:
540: -- Start - R12 Notes History Query for old Dimension Name
541: select name into l_dimension_name_old
542: from cn_rate_dimensions
543: where rate_dimension_id = p_rate_dimension_id;
544:
545: select dim_unit_code into l_type_old
546: from cn_rate_dimensions

Line 546: from cn_rate_dimensions

542: from cn_rate_dimensions
543: where rate_dimension_id = p_rate_dimension_id;
544:
545: select dim_unit_code into l_type_old
546: from cn_rate_dimensions
547: where rate_dimension_id = p_rate_dimension_id;
548: -- End - R12 Notes History Query for old Dimension Name
549:
550: -- call table handler to update dimension record in cn_rate_dimensions

Line 550: -- call table handler to update dimension record in cn_rate_dimensions

546: from cn_rate_dimensions
547: where rate_dimension_id = p_rate_dimension_id;
548: -- End - R12 Notes History Query for old Dimension Name
549:
550: -- call table handler to update dimension record in cn_rate_dimensions
551: -- get the appropriate number of tiers
552: select count(*) into l_number_tier from cn_rate_dim_tiers
553: where rate_dimension_id = p_rate_dimension_id;
554:

Line 555: cn_rate_dimensions_pkg.lock_row

551: -- get the appropriate number of tiers
552: select count(*) into l_number_tier from cn_rate_dim_tiers
553: where rate_dimension_id = p_rate_dimension_id;
554:
555: cn_rate_dimensions_pkg.lock_row
556: (x_rate_dimension_id => p_rate_dimension_id,
557: x_object_version_number => p_object_version_number);
558:
559: cn_rate_dimensions_pkg.update_row

Line 559: cn_rate_dimensions_pkg.update_row

555: cn_rate_dimensions_pkg.lock_row
556: (x_rate_dimension_id => p_rate_dimension_id,
557: x_object_version_number => p_object_version_number);
558:
559: cn_rate_dimensions_pkg.update_row
560: (x_rate_dimension_id => p_rate_dimension_id,
561: x_name => p_name,
562: x_description => p_description,
563: x_dim_unit_code => p_dim_unit_code,

Line 583: p_source_object_code => 'CN_RATE_DIMENSIONS',

579: x_return_status => x_return_status,
580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data,
582: p_source_object_id => p_rate_dimension_id,
583: p_source_object_code => 'CN_RATE_DIMENSIONS',
584: p_notes => l_note_msg,
585: p_notes_detail => l_note_msg,
586: p_note_type => 'CN_SYSGEN', -- for system generated
587: x_jtf_note_id => l_note_id -- returned

Line 603: p_source_object_code => 'CN_RATE_DIMENSIONS',

599: x_return_status => x_return_status,
600: x_msg_count => x_msg_count,
601: x_msg_data => x_msg_data,
602: p_source_object_id => p_rate_dimension_id,
603: p_source_object_code => 'CN_RATE_DIMENSIONS',
604: p_notes => l_note_msg,
605: p_notes_detail => l_note_msg,
606: p_note_type => 'CN_SYSGEN', -- for system generated
607: x_jtf_note_id => l_note_id -- returned

Line 618: p_source_object_code => 'CN_RATE_DIMENSIONS',

614: x_return_status => x_return_status,
615: x_msg_count => x_msg_count,
616: x_msg_data => x_msg_data,
617: p_source_object_id => p_rate_dimension_id,
618: p_source_object_code => 'CN_RATE_DIMENSIONS',
619: p_notes => l_consolidated_note,
620: p_notes_detail => l_consolidated_note,
621: p_note_type => 'CN_SYSGEN', -- for system generated
622: x_jtf_note_id => l_note_id -- returned

Line 679: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,

675: (p_api_version IN NUMBER ,
676: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
677: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
680: --R12 MOAC Changes--Start
681: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --new
682: --R12 MOAC Changes--End
683: x_return_status OUT NOCOPY VARCHAR2 ,

Line 681: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --new

677: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
680: --R12 MOAC Changes--Start
681: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --new
682: --R12 MOAC Changes--End
683: x_return_status OUT NOCOPY VARCHAR2 ,
684: x_msg_count OUT NOCOPY NUMBER ,
685: x_msg_data OUT NOCOPY VARCHAR2 )

Line 738: FROM cn_rate_dimensions

734: END IF;
735:
736: /* Start - R12 Notes History */
737: SELECT org_id INTO l_org_id
738: FROM cn_rate_dimensions
739: WHERE rate_dimension_id = p_rate_dimension_id;
740:
741: SELECT name INTO l_dimension_name
742: FROM cn_rate_dimensions

Line 742: FROM cn_rate_dimensions

738: FROM cn_rate_dimensions
739: WHERE rate_dimension_id = p_rate_dimension_id;
740:
741: SELECT name INTO l_dimension_name
742: FROM cn_rate_dimensions
743: WHERE rate_dimension_id = p_rate_dimension_id;
744: /* End - R12 Notes History */
745:
746:

Line 748: cn_rate_dimensions_pkg.delete_row(p_rate_dimension_id);

744: /* End - R12 Notes History */
745:
746:
747: -- table handler does cascading delete of dimension tiers
748: cn_rate_dimensions_pkg.delete_row(p_rate_dimension_id);
749:
750: -- *********************************************************************
751: -- ************ Start - R12 Notes History ******************************
752: -- *********************************************************************

Line 823: -- 3) update cn_rate_dimensions.number_tier

819: -- tier should be left in the rate dimension
820: -- 2) If it is used in a rate table, delete the corresponding
821: -- records in cn_sch_dim_tiers,
822: -- cn_srp_rate_assigns, cn_rate_tiers, and cn_rate_dim_tiers
823: -- 3) update cn_rate_dimensions.number_tier
824: -- 4) tier_sequence is not adjusted here, users should take
825: -- care of the adjustment by calling update_tier
826: -- 5) the other validations should be done by users also
827: -- (like minimum_amount < maximum_amount, etc.)

Line 844: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

840:
841: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
842: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
843: l_dummy pls_integer;
844: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
845:
846: --R12 Notes Hoistory
847: l_from VARCHAR2(100);
848: l_to VARCHAR2(100);

Line 981: p_source_object_code => 'CN_RATE_DIMENSIONS',

977: x_return_status => x_return_status,
978: x_msg_count => x_msg_count,
979: x_msg_data => x_msg_data,
980: p_source_object_id => l_rate_dimension_id,
981: p_source_object_code => 'CN_RATE_DIMENSIONS',
982: p_notes => l_note_msg,
983: p_notes_detail => l_note_msg,
984: p_note_type => 'CN_SYSGEN', -- for system generated
985: x_jtf_note_id => l_note_id -- returned

Line 1001: UPDATE cn_rate_dimensions

997: and tier_sequence >= l_tier_sequence;
998:
999: -- update rate dimension (number_tier is treated as a "virtual column" - just a
1000: -- count(*) of tiers assigned to the rate_dimension... it is not ovn controlled here
1001: UPDATE cn_rate_dimensions
1002: SET number_tier = (select count(*) from cn_rate_dim_tiers
1003: where rate_dimension_id = l_rate_dimension_id)
1004: WHERE rate_dimension_id = l_rate_dimension_id;
1005:

Line 1207: p_source_object_code => 'CN_RATE_DIMENSIONS',

1203: x_return_status => x_return_status,
1204: x_msg_count => x_msg_count,
1205: x_msg_data => x_msg_data,
1206: p_source_object_id => p_rate_dimension_id,
1207: p_source_object_code => 'CN_RATE_DIMENSIONS',
1208: p_notes => l_note_msg,
1209: p_notes_detail => l_note_msg,
1210: p_note_type => 'CN_SYSGEN', -- for system generated
1211: x_jtf_note_id => l_note_id -- returned

Line 1265: -- 2) update cn_rate_dimensions.number_tier

1261: -- Notes : Create dimension tiers
1262: -- 1) If it is used in a rate table, update cn_sch_dim_tiers,
1263: -- cn_srp_rate_assigns, and cn_rate_tiers,
1264: -- and adjust cn_rate_tiers.rate_sequence
1265: -- 2) update cn_rate_dimensions.number_tier
1266: -- 3) tier_sequence is not adjusted here, users should do it by calling
1267: -- update_tier
1268: -- 4) minimum_amount < maximum_amount
1269: -- 5) validation of minimum_amount = previous maximum_amount should be

Line 1422: p_source_object_code => 'CN_RATE_DIMENSIONS',

1418: x_return_status => x_return_status,
1419: x_msg_count => x_msg_count,
1420: x_msg_data => x_msg_data,
1421: p_source_object_id => p_rate_dimension_id,
1422: p_source_object_code => 'CN_RATE_DIMENSIONS',
1423: p_notes => l_note_msg,
1424: p_notes_detail => l_note_msg,
1425: p_note_type => 'CN_SYSGEN', -- for system generated
1426: x_jtf_note_id => l_note_id -- returned

Line 1435: UPDATE cn_rate_dimensions

1431: -- *********************************************************************
1432:
1433: -- update rate dimension (number_tier is treated as a "virtual column" - just a
1434: -- count(*) of tiers assigned to the rate_dimension... it is not ovn controlled here
1435: UPDATE cn_rate_dimensions
1436: SET number_tier = (select count(*) from cn_rate_dim_tiers
1437: where rate_dimension_id = p_rate_dimension_id)
1438: WHERE rate_dimension_id = p_rate_dimension_id;
1439:

Line 1482: END CN_RATE_DIMENSIONS_PVT;

1478: p_data => x_msg_data ,
1479: p_encoded => FND_API.G_FALSE );
1480: END Create_tier;
1481:
1482: END CN_RATE_DIMENSIONS_PVT;