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 CN_RATE_DIMENSIONS_PVT AUTHID CURRENT_USER AS

1: PACKAGE CN_RATE_DIMENSIONS_PVT AUTHID CURRENT_USER 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,

Line 32: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

28: (p_api_version IN NUMBER ,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
33: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
34: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
35: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
36: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,

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

29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
33: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
34: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
35: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
36: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
37: --R12 MOAC Changes--Start

Line 34: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

30: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
33: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
34: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
35: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
36: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
37: --R12 MOAC Changes--Start
38: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new

Line 35: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,

31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
33: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
34: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
35: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
36: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
37: --R12 MOAC Changes--Start
38: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
39: x_rate_dimension_id IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE, --changed

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

34: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
35: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
36: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
37: --R12 MOAC Changes--Start
38: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
39: x_rate_dimension_id IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE, --changed
40: --R12 MOAC Changes--End
41: x_return_status OUT NOCOPY VARCHAR2 ,
42: x_msg_count OUT NOCOPY NUMBER ,

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

35: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
36: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
37: --R12 MOAC Changes--Start
38: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
39: x_rate_dimension_id IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE, --changed
40: --R12 MOAC Changes--End
41: x_return_status OUT NOCOPY VARCHAR2 ,
42: x_msg_count OUT NOCOPY NUMBER ,
43: x_msg_data OUT NOCOPY VARCHAR2 );

Line 61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,

57: (p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
63: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
64: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
65: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,

Line 62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
63: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
64: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
65: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
66: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,

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

59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
63: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
64: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
65: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
66: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
67: --R12 MOAC Changes--Start

Line 64: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
63: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
64: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
65: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
66: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
67: --R12 MOAC Changes--Start
68: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new

Line 65: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,

61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
63: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
64: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
65: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
66: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
67: --R12 MOAC Changes--Start
68: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
69: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --Changed

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

64: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
65: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
66: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
67: --R12 MOAC Changes--Start
68: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
69: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --Changed
70: --R12 MOAC Changes--End
71: x_return_status OUT NOCOPY VARCHAR2 ,
72: x_msg_count OUT NOCOPY NUMBER ,

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

65: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
66: p_tiers_tbl IN tiers_tbl_type := g_miss_tiers_tbl,
67: --R12 MOAC Changes--Start
68: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
69: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --Changed
70: --R12 MOAC Changes--End
71: x_return_status OUT NOCOPY VARCHAR2 ,
72: x_msg_count OUT NOCOPY NUMBER ,
73: x_msg_data OUT NOCOPY VARCHAR2 );

Line 82: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,

78: (p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
83: -- R12 MOAC Changes --Start
84: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --new
85: -- R12 MOAC Changes --End
86: x_return_status OUT NOCOPY VARCHAR2 ,

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

80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
83: -- R12 MOAC Changes --Start
84: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --new
85: -- R12 MOAC Changes --End
86: x_return_status OUT NOCOPY VARCHAR2 ,
87: x_msg_count OUT NOCOPY NUMBER ,
88: x_msg_data OUT NOCOPY VARCHAR2 );

Line 96: -- 3) update cn_rate_dimensions.number_tier

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
100: -- (like minimum_amount < maximum_amount, etc.)

Line 137: -- 2) update cn_rate_dimensions.number_tier

133: -- Notes : Create dimension tiers
134: -- 1) If it is used in a rate table, update cn_sch_dim_tiers,
135: -- cn_srp_rate_assigns, and cn_rate_tiers,
136: -- and adjust cn_rate_tiers.rate_sequence
137: -- 2) update cn_rate_dimensions.number_tier
138: -- 3) tier_sequence is not adjusted here, users should do it by calling
139: -- update_tier
140: -- 4) minimum_amount < maximum_amount
141: -- 5) validation of minimum_amount = previous maximum_amount should be

Line 165: END CN_RATE_DIMENSIONS_PVT;

161: x_msg_count OUT NOCOPY NUMBER ,
162: x_msg_data OUT NOCOPY VARCHAR2 );
163:
164:
165: END CN_RATE_DIMENSIONS_PVT;