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_DIM_TIERS

Line 180: l_temp_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

176: IS
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);

Line 272: cn_rate_dim_tiers_pkg.insert_row

268: -- call table handler to create dimension tiers
269: IF (p_tiers_tbl.COUNT > 0) THEN
270: FOR i IN p_tiers_tbl.first..p_tiers_tbl.last LOOP
271: l_temp_id := NULL;
272: cn_rate_dim_tiers_pkg.insert_row
273: (x_rate_dim_tier_id => l_temp_id,
274: x_rate_dimension_id => x_rate_dimension_id,
275: x_minimum_amount => p_tiers_tbl(i).minimum_amount,
276: x_maximum_amount => p_tiers_tbl(i).maximum_amount,

Line 368: l_temp_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

364: IS
365: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension';
366: l_api_version CONSTANT NUMBER := 1.0;
367:
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;

Line 369: l_dim_unit_code CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE;

365: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension';
366: l_api_version CONSTANT NUMBER := 1.0;
367:
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:

Line 397: FROM cn_rate_dim_tiers

393: WHERE rate_schedule_id = rsd.rate_schedule_id));
394:
395: CURSOR db_tiers IS
396: SELECT rate_dim_tier_id
397: FROM cn_rate_dim_tiers
398: WHERE rate_dimension_id = p_rate_dimension_id;
399: BEGIN
400: -- Standard Start of API savepoint
401: SAVEPOINT Update_Dimension;

Line 492: cn_rate_dim_tiers_pkg.lock_row

488:
489: -- update the existing tiers
490: FOR i IN p_tiers_tbl.first..p_tiers_tbl.last LOOP
491: IF (p_tiers_tbl(i).rate_dim_tier_id IS NOT NULL) THEN
492: cn_rate_dim_tiers_pkg.lock_row
493: (x_rate_dim_tier_id => p_tiers_tbl(i).rate_dim_tier_id,
494: x_object_version_number => p_tiers_tbl(i).object_version_number);
495: cn_rate_dim_tiers_pkg.update_row
496: (x_rate_dim_tier_id => p_tiers_tbl(i).rate_dim_tier_id,

Line 495: cn_rate_dim_tiers_pkg.update_row

491: IF (p_tiers_tbl(i).rate_dim_tier_id IS NOT NULL) THEN
492: cn_rate_dim_tiers_pkg.lock_row
493: (x_rate_dim_tier_id => p_tiers_tbl(i).rate_dim_tier_id,
494: x_object_version_number => p_tiers_tbl(i).object_version_number);
495: cn_rate_dim_tiers_pkg.update_row
496: (x_rate_dim_tier_id => p_tiers_tbl(i).rate_dim_tier_id,
497: x_rate_dimension_id => p_rate_dimension_id,
498: x_minimum_amount => p_tiers_tbl(i).minimum_amount,
499: x_maximum_amount => p_tiers_tbl(i).maximum_amount,

Line 552: select count(*) into l_number_tier from cn_rate_dim_tiers

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:
555: cn_rate_dimensions_pkg.lock_row
556: (x_rate_dimension_id => p_rate_dimension_id,

Line 822: -- cn_srp_rate_assigns, cn_rate_tiers, and cn_rate_dim_tiers

818: -- 1) If the dimension is used in a rate table, at least one
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

Line 833: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,

829: (p_api_version IN NUMBER ,
830: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
831: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
833: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
834: x_return_status OUT NOCOPY VARCHAR2 ,
835: x_msg_count OUT NOCOPY NUMBER ,
836: x_msg_data OUT NOCOPY VARCHAR2 )
837: IS

Line 842: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;

838: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Tier';
839: l_api_version CONSTANT NUMBER := 1.0;
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

Line 862: FROM cn_rate_dim_tiers

858: CURSOR last_tier IS
859: SELECT 1
860: FROM dual
861: WHERE NOT exists (SELECT 1
862: FROM cn_rate_dim_tiers
863: WHERE rate_dimension_id = l_rate_dimension_id
864: AND rate_dim_tier_id <> p_rate_dim_tier_id);
865:
866: --R12 History Cursor

Line 870: from cn_rate_dim_tiers

866: --R12 History Cursor
867: CURSOR get_old_rec IS
868: Select minimum_amount, maximum_amount, min_exp_id, max_exp_id,
869: string_value, org_id
870: from cn_rate_dim_tiers
871: where rate_dim_tier_id = p_rate_dim_tier_id;
872:
873: l_old_rec get_old_rec%ROWTYPE;
874:

Line 900: FROM cn_rate_dim_tiers

896: -- get dimension ID
897: begin
898: SELECT rate_dimension_id, tier_sequence
899: INTO l_rate_dimension_id, l_tier_sequence
900: FROM cn_rate_dim_tiers
901: WHERE rate_dim_tier_id = p_rate_dim_tier_id;
902: exception
903: when no_data_found then
904: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line 942: -- delete this tier in cn_rate_dim_tiers

938: close get_old_rec;
939:
940: /* End - R12 Notes History */
941:
942: -- delete this tier in cn_rate_dim_tiers
943: cn_rate_dim_tiers_pkg.delete_row(p_rate_dim_tier_id);
944:
945: -- *********************************************************************
946: -- ************ Start - R12 Notes History ******************************

Line 943: cn_rate_dim_tiers_pkg.delete_row(p_rate_dim_tier_id);

939:
940: /* End - R12 Notes History */
941:
942: -- delete this tier in cn_rate_dim_tiers
943: cn_rate_dim_tiers_pkg.delete_row(p_rate_dim_tier_id);
944:
945: -- *********************************************************************
946: -- ************ Start - R12 Notes History ******************************
947: -- *********************************************************************

Line 995: update cn_rate_dim_tiers set tier_sequence = tier_sequence - 1

991: -- *********************************************************************
992:
993:
994: -- push tier sequence numbers down by one
995: update cn_rate_dim_tiers set tier_sequence = tier_sequence - 1
996: where rate_dimension_id = l_rate_dimension_id
997: and tier_sequence >= l_tier_sequence;
998:
999: -- update rate dimension (number_tier is treated as a "virtual column" - just a

Line 1002: SET number_tier = (select count(*) from cn_rate_dim_tiers

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:
1006: -- End of API body.

Line 1054: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,

1050: (p_api_version IN NUMBER ,
1051: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1052: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

Line 1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

1051: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1052: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,

Line 1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,

1052: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,

Line 1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,

Line 1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

1054: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,

Line 1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,

1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start

Line 1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,

1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start
1064: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed

Line 1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,

1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start
1064: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
1065: -- R12 MOAC Changes --End

Line 1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,

1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start
1064: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
1065: -- R12 MOAC Changes --End
1066: x_return_status OUT NOCOPY VARCHAR2 ,

Line 1064: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed

1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start
1064: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
1065: -- R12 MOAC Changes --End
1066: x_return_status OUT NOCOPY VARCHAR2 ,
1067: x_msg_count OUT NOCOPY NUMBER ,
1068: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1084: from cn_rate_dim_tiers

1080:
1081: --R12 History Cursor
1082: CURSOR get_old_rec IS
1083: Select minimum_amount, maximum_amount, min_exp_id, max_exp_id, string_value
1084: from cn_rate_dim_tiers
1085: where rate_dim_tier_id = p_rate_dim_tier_id;
1086:
1087: l_old_rec get_old_rec%ROWTYPE;
1088:

Line 1139: -- update this tier in cn_rate_dim_tiers

1135: Fetch get_old_rec into l_old_rec;
1136: close get_old_rec;
1137: /* End - R12 Notes History */
1138:
1139: -- update this tier in cn_rate_dim_tiers
1140: cn_rate_dim_tiers_pkg.lock_row
1141: (x_rate_dim_tier_id => p_rate_dim_tier_id,
1142: x_object_version_number => p_object_version_number);
1143:

Line 1140: cn_rate_dim_tiers_pkg.lock_row

1136: close get_old_rec;
1137: /* End - R12 Notes History */
1138:
1139: -- update this tier in cn_rate_dim_tiers
1140: cn_rate_dim_tiers_pkg.lock_row
1141: (x_rate_dim_tier_id => p_rate_dim_tier_id,
1142: x_object_version_number => p_object_version_number);
1143:
1144: cn_rate_dim_tiers_pkg.update_row

Line 1144: cn_rate_dim_tiers_pkg.update_row

1140: cn_rate_dim_tiers_pkg.lock_row
1141: (x_rate_dim_tier_id => p_rate_dim_tier_id,
1142: x_object_version_number => p_object_version_number);
1143:
1144: cn_rate_dim_tiers_pkg.update_row
1145: (x_rate_dim_tier_id => p_rate_dim_tier_id,
1146: x_rate_dimension_id => p_rate_dimension_id,
1147: x_minimum_amount => p_minimum_amount,
1148: x_maximum_amount => p_maximum_amount,

Line 1276: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

1272: (p_api_version IN NUMBER ,
1273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1274: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1276: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1277: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1278: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,

Line 1277: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,

1273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1274: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1276: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1277: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1278: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,

Line 1278: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,

1274: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1276: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1277: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1278: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,

Line 1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,

1275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1276: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1277: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1278: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
1283: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,

Line 1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,

1276: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1277: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1278: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
1283: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
1284: -- R12 MOAC Changes --Start

Line 1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,

1277: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1278: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
1283: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
1284: -- R12 MOAC Changes --Start
1285: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new

Line 1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,

1278: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
1283: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
1284: -- R12 MOAC Changes --Start
1285: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
1286: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed

Line 1283: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,

1279: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,
1280: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := null,
1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
1283: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
1284: -- R12 MOAC Changes --Start
1285: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
1286: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed
1287: -- R12 MOAC Changes --End

Line 1285: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new

1281: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := null,
1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
1283: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
1284: -- R12 MOAC Changes --Start
1285: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
1286: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed
1287: -- R12 MOAC Changes --End
1288: x_return_status OUT NOCOPY VARCHAR2 ,
1289: x_msg_count OUT NOCOPY NUMBER ,

Line 1286: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed

1282: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := null,
1283: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := null,
1284: -- R12 MOAC Changes --Start
1285: p_org_id IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
1286: x_rate_dim_tier_id IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE, --changed
1287: -- R12 MOAC Changes --End
1288: x_return_status OUT NOCOPY VARCHAR2 ,
1289: x_msg_count OUT NOCOPY NUMBER ,
1290: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1369: update cn_rate_dim_tiers set tier_sequence = tier_sequence + 1

1365: -- R12 MOAC Changes --End
1366: END LOOP;
1367:
1368: -- push tiers with higher sequence numbers than p_tier_sequence up by one
1369: update cn_rate_dim_tiers set tier_sequence = tier_sequence + 1
1370: where rate_dimension_id = p_rate_dimension_id
1371: and tier_sequence >= p_tier_sequence;
1372:
1373: -- create this tier in cn_rate_dim_tiers

Line 1373: -- create this tier in cn_rate_dim_tiers

1369: update cn_rate_dim_tiers set tier_sequence = tier_sequence + 1
1370: where rate_dimension_id = p_rate_dimension_id
1371: and tier_sequence >= p_tier_sequence;
1372:
1373: -- create this tier in cn_rate_dim_tiers
1374: cn_rate_dim_tiers_pkg.insert_row
1375: (x_rate_dim_tier_id => x_rate_dim_tier_id,
1376: x_rate_dimension_id => p_rate_dimension_id,
1377: x_minimum_amount => p_minimum_amount,

Line 1374: cn_rate_dim_tiers_pkg.insert_row

1370: where rate_dimension_id = p_rate_dimension_id
1371: and tier_sequence >= p_tier_sequence;
1372:
1373: -- create this tier in cn_rate_dim_tiers
1374: cn_rate_dim_tiers_pkg.insert_row
1375: (x_rate_dim_tier_id => x_rate_dim_tier_id,
1376: x_rate_dimension_id => p_rate_dimension_id,
1377: x_minimum_amount => p_minimum_amount,
1378: x_maximum_amount => p_maximum_amount,

Line 1436: SET number_tier = (select count(*) from cn_rate_dim_tiers

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:
1440: -- End of API body.