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_SCH_DIMS

Line 159: from cn_rate_sch_dims rsd, cn_rate_dimensions d

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
159: from cn_rate_sch_dims rsd, cn_rate_dimensions d
160: where rate_schedule_id = p_rate_schedule_id
161: and rsd.rate_dimension_id = d.rate_dimension_id
162: order by rsd.rate_dim_sequence desc;
163:

Line 327: l_temp_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;

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);
331: l_note_msg VARCHAR2(240);

Line 409: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => l_temp_id,

405: -- call table handler to create dimension assignments and populate cn_rate_tiers
406: IF (p_dims_tbl.COUNT > 0) THEN
407: FOR i IN p_dims_tbl.first..p_dims_tbl.last LOOP
408: l_temp_id := NULL;
409: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => l_temp_id,
410: x_rate_dimension_id => p_dims_tbl(i).rate_dimension_id,
411: x_rate_schedule_id => x_rate_schedule_id,
412: x_rate_dim_sequence => p_dims_tbl(i).rate_dim_sequence,
413: --R12 MOAC Changes--Start

Line 526: l_temp_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;

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

Line 549: FROM cn_rate_sch_dims

545: WHERE rate_schedule_id = p_rate_schedule_id;
546:
547: CURSOR db_dim_assignments IS
548: SELECT rate_sch_dim_id
549: FROM cn_rate_sch_dims
550: WHERE rate_schedule_id = p_rate_schedule_id;
551: BEGIN
552: -- Standard Start of API savepoint
553: SAVEPOINT Update_Schedule;

Line 623: delete from cn_rate_sch_dims where rate_schedule_id = p_rate_schedule_id;

619: -- we passed in a dimensions table... delete and re-create the table as the
620: -- dimensions have been changed
621:
622: -- delete all rate tiers and rate_sch_dims
623: delete from cn_rate_sch_dims where rate_schedule_id = p_rate_schedule_id;
624: delete from cn_rate_tiers where rate_schedule_id = p_rate_schedule_id;
625:
626: -- reassign rate schedule dimensions
627: FOR i IN p_dims_tbl.first..p_dims_tbl.last LOOP

Line 629: cn_rate_sch_dims_pkg.insert_row

625:
626: -- reassign rate schedule dimensions
627: FOR i IN p_dims_tbl.first..p_dims_tbl.last LOOP
628: l_temp_id := NULL;
629: cn_rate_sch_dims_pkg.insert_row
630: (x_rate_sch_dim_id => l_temp_id,
631: x_rate_dimension_id => p_dims_tbl(i).rate_dimension_id,
632: x_rate_schedule_id => p_rate_schedule_id,
633: x_rate_dim_sequence => p_dims_tbl(i).rate_dim_sequence,

Line 799: -- cn_rate_sch_dims and cn_rate_tiers

795: --
796: -- Notes : Delete rate schedule
797: -- 1) If it is used, it can not be deleted
798: -- 2) If it can be deleted, delete corresponding records in
799: -- cn_rate_sch_dims and cn_rate_tiers
800: --
801: -- End of comments
802: PROCEDURE Delete_Schedule
803: (p_api_version IN NUMBER ,

Line 960: -- 2) delete the corresponding records in cn_rate_sch_dims and cn_rate_tiers

956: -- Initial version 1.0
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

Line 972: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,

968: (p_api_version IN NUMBER ,
969: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
970: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
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

Line 973: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

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

Line 1030: FROM cn_rate_sch_dims

1026: -- delete the records corresponding to this dimension in cn_rate_tiers
1027: BEGIN
1028: SELECT rate_dim_sequence
1029: INTO l_rate_dim_sequence
1030: FROM cn_rate_sch_dims
1031: WHERE rate_schedule_id = p_rate_schedule_id
1032: AND rate_sch_dim_id = p_rate_sch_dim_id;
1033: EXCEPTION
1034: when no_data_found then

Line 1046: FROM cn_rate_sch_dims

1042:
1043: /* Start - R12 Notes History */
1044:
1045: SELECT org_id,rate_dimension_id INTO l_org_id,l_dimension_id
1046: FROM cn_rate_sch_dims
1047: WHERE rate_sch_dim_id = p_rate_sch_dim_id;
1048:
1049: select name into l_dimension_name_old
1050: from cn_rate_dimensions

Line 1059: -- delete records in cn_rate_sch_dims

1055: where rate_schedule_id = p_rate_schedule_id;
1056:
1057: /* End - R12 Notes History */
1058:
1059: -- delete records in cn_rate_sch_dims
1060: cn_rate_sch_dims_pkg.delete_row(x_rate_sch_dim_id => p_rate_sch_dim_id);
1061:
1062: -- *********************************************************************
1063: -- ************ Start - R12 Notes History ******************************

Line 1060: cn_rate_sch_dims_pkg.delete_row(x_rate_sch_dim_id => p_rate_sch_dim_id);

1056:
1057: /* End - R12 Notes History */
1058:
1059: -- delete records in cn_rate_sch_dims
1060: cn_rate_sch_dims_pkg.delete_row(x_rate_sch_dim_id => p_rate_sch_dim_id);
1061:
1062: -- *********************************************************************
1063: -- ************ Start - R12 Notes History ******************************
1064: -- *********************************************************************

Line 1092: SET number_dim = (select count(*) from cn_rate_sch_dims

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:
1096: -- push dimension sequence numbers down by one

Line 1097: --update cn_rate_sch_dims set rate_dim_sequence = rate_dim_sequence - 1

1093: where rate_schedule_id = p_rate_schedule_id)
1094: WHERE rate_schedule_id = p_rate_schedule_id;
1095:
1096: -- push dimension sequence numbers down by one
1097: --update cn_rate_sch_dims set rate_dim_sequence = rate_dim_sequence - 1
1098: -- where rate_schedule_id = p_rate_schedule_id
1099: -- and rate_dim_sequence >= l_rate_dim_sequence;
1100:
1101: -- End of API body.

Line 1168: -- 2) If it can be updated, update records in cn_rate_sch_dims and cn_rate_tiers

1164: -- Initial version 1.0
1165: --
1166: -- Notes : Update dimension assignment
1167: -- 1) If the rate table is used, then update is not allowed
1168: -- 2) If it can be updated, update records in cn_rate_sch_dims and cn_rate_tiers
1169: --
1170: -- End of comments
1171: PROCEDURE update_dimension_assign
1172: (p_api_version IN NUMBER ,

Line 1176: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,

1172: (p_api_version IN NUMBER ,
1173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1176: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
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

Line 1177: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

1173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1176: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
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

Line 1178: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,

1174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1176: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
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

Line 1179: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num, -- not used

1175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1176: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
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

Line 1191: l_rate_dimension_id_old CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE;

1187: IS
1188: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension_Assign';
1189: l_api_version CONSTANT NUMBER := 1.0;
1190:
1191: l_rate_dimension_id_old CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE;
1192: l_number_tier_old CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
1193: l_number_tier_new CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
1194: l_usage_code VARCHAR2(30);
1195: l_rate_dim_sequence NUMBER;

Line 1207: FROM cn_rate_sch_dims

1203: l_note_id NUMBER;
1204:
1205: CURSOR old_sch_dim IS
1206: SELECT rate_dimension_id, rate_dim_sequence
1207: FROM cn_rate_sch_dims
1208: WHERE rate_sch_dim_id = p_rate_sch_dim_id;
1209:
1210: CURSOR old_dim_info IS
1211: SELECT number_tier

Line 1266: select count(*) into l_count from cn_rate_sch_dims

1262: -- if rate dimension is replaced, then adjust cn_rate_tiers also
1263: -- remove the dimension and re-create it
1264: IF (l_rate_dimension_id_old <> p_rate_dimension_id) THEN
1265: -- make sure the dimension hasn't already been assigned
1266: select count(*) into l_count from cn_rate_sch_dims
1267: where rate_schedule_id = p_rate_schedule_id
1268: and rate_dimension_id = p_rate_dimension_id;
1269: if l_count > 0 then
1270: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 1299: from cn_rate_sch_dims

1295: END IF;
1296:
1297: -- Start - R12 Notes History Query for old dimension id assigned to rate table
1298: select rate_dimension_id into l_rate_dimension_id
1299: from cn_rate_sch_dims
1300: where rate_sch_dim_id = p_rate_sch_dim_id;
1301:
1302: select name into l_dimension_name_old
1303: from cn_rate_dimensions

Line 1308: cn_rate_sch_dims_pkg.lock_row

1304: where rate_dimension_id = l_rate_dimension_id;
1305: -- End - R12 Notes History Query for old dimension id assigned to rate table
1306:
1307: -- lock and update the row
1308: cn_rate_sch_dims_pkg.lock_row
1309: (x_rate_sch_dim_id => p_rate_sch_dim_id,
1310: x_object_version_number => p_object_version_number);
1311:
1312: cn_rate_sch_dims_pkg.update_row

Line 1312: cn_rate_sch_dims_pkg.update_row

1308: cn_rate_sch_dims_pkg.lock_row
1309: (x_rate_sch_dim_id => p_rate_sch_dim_id,
1310: x_object_version_number => p_object_version_number);
1311:
1312: cn_rate_sch_dims_pkg.update_row
1313: (x_rate_sch_dim_id => p_rate_sch_dim_id,
1314: x_rate_schedule_id => p_rate_schedule_id,
1315: x_rate_dimension_id => p_rate_dimension_id,
1316: x_rate_dim_sequence => p_rate_dim_sequence,

Line 1428: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

1424: (p_api_version IN NUMBER ,
1425: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1426: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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

Line 1429: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,

1425: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1426: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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

Line 1430: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

1426: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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

Line 1433: x_rate_sch_dim_id IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE, --changed

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 ,
1437: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1489: select count(*) into l_count from cn_rate_sch_dims

1485: RAISE fnd_api.g_exc_error;
1486: END IF;
1487:
1488: -- make sure the dimension hasn't already been assigned
1489: select count(*) into l_count from cn_rate_sch_dims
1490: where rate_schedule_id = p_rate_schedule_id
1491: and rate_dimension_id = p_rate_dimension_id;
1492: if l_count > 0 then
1493: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 1502: from cn_rate_sch_dims

1498: END IF;
1499:
1500: -- if assigned rate sequence is too high, bring it down to a valid value
1501: select count(*) into l_num_dims
1502: from cn_rate_sch_dims
1503: where rate_schedule_id = p_rate_schedule_id;
1504:
1505: --push dimensions with higher sequence numbers than l_rate_dim_sequence up by one
1506: -- l_rate_dim_sequence := l_num_dims + 1;

Line 1510: --update cn_rate_sch_dims set rate_dim_sequence = rate_dim_sequence + 1

1506: -- l_rate_dim_sequence := l_num_dims + 1;
1507: --end if;
1508:
1509: -- push dimensions with higher sequence numbers than l_rate_dim_sequence up by one
1510: --update cn_rate_sch_dims set rate_dim_sequence = rate_dim_sequence + 1
1511: -- where rate_schedule_id = p_rate_schedule_id
1512: -- and rate_dim_sequence >= l_rate_dim_sequence;
1513:
1514: -- create this dimension assignment in cn_rate_sch_dims

Line 1514: -- create this dimension assignment in cn_rate_sch_dims

1510: --update cn_rate_sch_dims set rate_dim_sequence = rate_dim_sequence + 1
1511: -- where rate_schedule_id = p_rate_schedule_id
1512: -- and rate_dim_sequence >= l_rate_dim_sequence;
1513:
1514: -- create this dimension assignment in cn_rate_sch_dims
1515: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => x_rate_sch_dim_id,
1516: x_rate_schedule_id => p_rate_schedule_id,
1517: x_rate_dimension_id => p_rate_dimension_id,
1518: x_rate_dim_sequence => l_rate_dim_sequence,

Line 1515: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => x_rate_sch_dim_id,

1511: -- where rate_schedule_id = p_rate_schedule_id
1512: -- and rate_dim_sequence >= l_rate_dim_sequence;
1513:
1514: -- create this dimension assignment in cn_rate_sch_dims
1515: cn_rate_sch_dims_pkg.insert_row(x_rate_sch_dim_id => x_rate_sch_dim_id,
1516: x_rate_schedule_id => p_rate_schedule_id,
1517: x_rate_dimension_id => p_rate_dimension_id,
1518: x_rate_dim_sequence => l_rate_dim_sequence,
1519: --R12 MOAC Changes--Start

Line 1631: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := NULL,

1627: -- instead of cn_rate_dimensions.number_tier
1628: -- 2. form processing changes in the following order: delete --> update --> insert
1629: PROCEDURE create_rate_tiers
1630: (p_rate_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
1631: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := NULL,
1632: p_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := NULL,
1633: p_num_tiers NUMBER := 1,
1634: --R12 MOAC Changes--Start
1635: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE

Line 1643: l_dim_count NUMBER := 0; -- number of dimensions in cn_rate_sch_dims for this rate table

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
1644: dim_size_table num_tbl_type;
1645: l_num_tiers number := nvl(p_num_tiers,1);
1646:
1647: CURSOR dims_info IS

Line 1650: cn_rate_sch_dims rsd

1646:
1647: CURSOR dims_info IS
1648: SELECT COUNT(*) number_tier
1649: FROM cn_rate_dim_tiers rdt,
1650: cn_rate_sch_dims rsd
1651: WHERE rdt.rate_dimension_id = rsd.rate_dimension_id
1652: AND rsd.rate_schedule_id = p_rate_schedule_id
1653: GROUP BY rsd.rate_dim_sequence
1654: ORDER BY rsd.rate_dim_sequence;

Line 1738: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

1734: END create_rate_tiers;
1735:
1736: PROCEDURE delete_rate_tiers
1737: (p_rate_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%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;

Line 1746: l_dim_count NUMBER := 0; -- number of dimensions in cn_rate_sch_dims for this rate table

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
1747: dim_size_table num_tbl_type;
1748: l_num_tiers number := nvl(p_num_tiers,1);
1749: delete_flag boolean;
1750:

Line 1754: cn_rate_sch_dims rsd

1750:
1751: CURSOR dims_info IS
1752: SELECT COUNT(*) number_tier
1753: FROM cn_rate_dim_tiers rdt,
1754: cn_rate_sch_dims rsd
1755: WHERE rdt.rate_dimension_id = rsd.rate_dimension_id
1756: AND rsd.rate_schedule_id = p_rate_schedule_id
1757: GROUP BY rsd.rate_dim_sequence
1758: ORDER BY rsd.rate_dim_sequence;

Line 2203: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;

2199:
2200: l_base NUMBER := 1;
2201: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
2202: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2203: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
2204: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
2205: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
2206:
2207: dim_size_table num_tbl_type;

Line 2212: FROM cn_rate_sch_dims rsd,

2208: current_tier_table num_tbl_type;
2209:
2210: CURSOR dim_info(p_rate_dimension_id NUMBER) IS
2211: SELECT rsd.rate_dim_sequence, rd.number_tier
2212: FROM cn_rate_sch_dims rsd,
2213: cn_rate_dimensions rd
2214: WHERE rsd.rate_schedule_id = p_rate_schedule_id
2215: AND rsd.rate_dimension_id = p_rate_dimension_id
2216: AND rd.rate_dimension_id = p_rate_dimension_id;

Line 2324: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt

2320: if l_number_dim = 1 then
2321: -- strip off extra commas
2322: sres := replace(sbuf, ',');
2323: select rdt.tier_sequence into x_rate_sequence
2324: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt
2325: where rsd.rate_schedule_id = x_schedule_id
2326: and rsd.rate_dimension_id = rdt.rate_dimension_id
2327: and rdt.rate_dim_tier_id = sres;
2328: return x_rate_sequence;

Line 2395: select * from cn_rate_sch_dims_all

2391: )
2392: IS
2393:
2394: CURSOR rate_sch_dim IS
2395: select * from cn_rate_sch_dims_all
2396: where rate_schedule_id = p_rate_schedule_id
2397: and org_id = p_org_id;
2398:
2399: cursor rate_dim_info(l_dim_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)