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_PUB dependencies on CN_RATE_DIMENSIONS

Line 27: FUNCTION get_rate_dimension_id(p_name in CN_RATE_DIMENSIONS.NAME%TYPE)

23: RAISE fnd_api.g_exc_error;
24: END get_rate_schedule_id;
25:
26: -- to get a rate dimension ID from its name
27: FUNCTION get_rate_dimension_id(p_name in CN_RATE_DIMENSIONS.NAME%TYPE)
28: RETURN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE IS
29:
30: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
31:

Line 28: RETURN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE IS

24: END get_rate_schedule_id;
25:
26: -- to get a rate dimension ID from its name
27: FUNCTION get_rate_dimension_id(p_name in CN_RATE_DIMENSIONS.NAME%TYPE)
28: RETURN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE IS
29:
30: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
31:
32: BEGIN

Line 30: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

26: -- to get a rate dimension ID from its name
27: FUNCTION get_rate_dimension_id(p_name in CN_RATE_DIMENSIONS.NAME%TYPE)
28: RETURN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE IS
29:
30: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
31:
32: BEGIN
33: select RATE_DIMENSION_ID into l_rate_dimension_id
34: from CN_RATE_DIMENSIONS

Line 34: from CN_RATE_DIMENSIONS

30: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
31:
32: BEGIN
33: select RATE_DIMENSION_ID into l_rate_dimension_id
34: from CN_RATE_DIMENSIONS
35: where name = p_name;
36:
37: RETURN l_rate_dimension_id;
38: EXCEPTION

Line 47: p_rate_dimension_id in CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)

43: END get_rate_dimension_id;
44:
45: -- to get a rate_sch_dim_id from a given rate dimension ID and rate schedule ID
46: FUNCTION get_rate_sch_dim_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
47: p_rate_dimension_id in CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)
48: RETURN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE IS
49:
50: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
51: BEGIN

Line 126: PROCEDURE translate_values(p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

122: fnd_msg_pub.ADD;
123: RAISE fnd_api.g_exc_error;
124: END get_rate_dim_tier_id;
125:
126: PROCEDURE translate_values(p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
127: p_value1 IN VARCHAR2,
128: p_value2 IN VARCHAR2,
129: p_minimum_amount OUT NOCOPY CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,
130: p_maximum_amount OUT NOCOPY CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,

Line 707: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

703: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
704: p_commit IN VARCHAR2 := FND_API.G_FALSE,
705: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
706: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
707: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
708: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
709: -- Start - MOAC Change
710: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
711: -- End - MOAC Change

Line 710: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,

706: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
707: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
708: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
709: -- Start - MOAC Change
710: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
711: -- End - MOAC Change
712: x_return_status OUT NOCOPY VARCHAR2,
713: x_msg_count OUT NOCOPY NUMBER,
714: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 719: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

715:
716: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dimension_Assign';
717: l_api_version CONSTANT NUMBER := 1.0;
718: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
719: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
720: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
721: -- Start - MOAC Change
722: l_org_id NUMBER;
723: l_status VARCHAR2(1);

Line 881: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

877: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
878: p_commit IN VARCHAR2 := FND_API.G_FALSE,
879: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
881: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
884: cn_api.g_miss_num,
885: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,

Line 882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,

878: p_commit IN VARCHAR2 := FND_API.G_FALSE,
879: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
881: p_orig_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
882: p_new_rate_dim_name IN CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
884: cn_api.g_miss_num,
885: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
886: -- Start - MOAC Change

Line 887: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,

883: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
884: cn_api.g_miss_num,
885: p_object_version_number IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
886: -- Start - MOAC Change
887: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,
888: -- End - MOAC Change
889: x_return_status OUT NOCOPY VARCHAR2,
890: x_msg_count OUT NOCOPY NUMBER,
891: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 896: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

892:
893: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension_Assign';
894: l_api_version CONSTANT NUMBER := 1.0;
895: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
896: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
897: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
898: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
899: -- Start - MOAC Change
900: l_org_id NUMBER;

Line 1092: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

1088: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1089: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1090: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1091: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
1092: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1093: -- Start - R12 MOAC Changes
1094: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
1095: -- End - R12 MOAC Changes
1096: x_return_status OUT NOCOPY VARCHAR2,

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

1090: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1091: p_rate_schedule_name IN CN_RATE_SCHEDULES.NAME%TYPE,
1092: p_rate_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1093: -- Start - R12 MOAC Changes
1094: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
1095: -- End - R12 MOAC Changes
1096: x_return_status OUT NOCOPY VARCHAR2,
1097: x_msg_count OUT NOCOPY NUMBER,
1098: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1103: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

1099:
1100: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dimension_Assign';
1101: l_api_version CONSTANT NUMBER := 1.0;
1102: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
1103: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1104: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
1105: BEGIN
1106: -- Standard Start of API savepoint
1107: SAVEPOINT Delete_Dimension_Assign;

Line 1437: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

1433: (p_api_version IN NUMBER,
1434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1437: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1438: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
1439: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
1440: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
1441: -- Start - MOAC Change

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

1434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1437: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1438: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
1439: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
1440: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
1441: -- Start - MOAC Change
1442: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,

Line 1439: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

1435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1437: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1438: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
1439: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
1440: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
1441: -- Start - MOAC Change
1442: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
1443: -- End - MOAC Change

Line 1442: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,

1438: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
1439: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
1440: p_tiers_tbl IN rate_tier_tbl_type := g_miss_rate_tier_tbl,
1441: -- Start - MOAC Change
1442: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE := NULL,
1443: -- End - MOAC Change
1444: x_return_status OUT NOCOPY VARCHAR2,
1445: x_msg_count OUT NOCOPY NUMBER,
1446: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1450: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

1446: x_msg_data OUT NOCOPY VARCHAR2) IS
1447:
1448: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dimension';
1449: l_api_version CONSTANT NUMBER := 1.0;
1450: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1451: l_tiers_tbl CN_RATE_DIMENSIONS_PVT.TIERS_TBL_TYPE;
1452: -- Start - MOAC Change
1453: l_org_id NUMBER;
1454: l_status VARCHAR2(1);

Line 1451: l_tiers_tbl CN_RATE_DIMENSIONS_PVT.TIERS_TBL_TYPE;

1447:
1448: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dimension';
1449: l_api_version CONSTANT NUMBER := 1.0;
1450: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1451: l_tiers_tbl CN_RATE_DIMENSIONS_PVT.TIERS_TBL_TYPE;
1452: -- Start - MOAC Change
1453: l_org_id NUMBER;
1454: l_status VARCHAR2(1);
1455: -- End - MOAC Change

Line 1529: CN_RATE_DIMENSIONS_PVT.Create_Dimension

1525:
1526: check_ret_sts(x_return_status);
1527: end if;
1528:
1529: CN_RATE_DIMENSIONS_PVT.Create_Dimension
1530: (p_api_version => p_api_version,
1531: p_init_msg_list => p_init_msg_list,
1532: p_commit => p_commit,
1533: p_validation_level => p_validation_level,

Line 1624: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

1620: (p_api_version IN NUMBER,
1621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1622: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1623: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1624: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1625: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
1626: cn_api.g_miss_char,
1627: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
1628: cn_api.g_miss_char,

Line 1625: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=

1621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1622: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1623: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1624: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1625: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
1626: cn_api.g_miss_char,
1627: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
1628: cn_api.g_miss_char,
1629: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=

Line 1627: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=

1623: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1624: p_original_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1625: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
1626: cn_api.g_miss_char,
1627: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
1628: cn_api.g_miss_char,
1629: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
1630: cn_api.g_miss_char,
1631: p_tiers_tbl IN rate_tier_tbl_type :=

Line 1629: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=

1625: p_new_name IN CN_RATE_DIMENSIONS.NAME%TYPE :=
1626: cn_api.g_miss_char,
1627: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
1628: cn_api.g_miss_char,
1629: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
1630: cn_api.g_miss_char,
1631: p_tiers_tbl IN rate_tier_tbl_type :=
1632: g_miss_rate_tier_tbl,
1633: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 1633: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

1629: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
1630: cn_api.g_miss_char,
1631: p_tiers_tbl IN rate_tier_tbl_type :=
1632: g_miss_rate_tier_tbl,
1633: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
1634: -- Start - MOAC Change
1635: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,
1636: -- End - MOAC Change
1637: x_return_status OUT NOCOPY VARCHAR2,

Line 1635: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,

1631: p_tiers_tbl IN rate_tier_tbl_type :=
1632: g_miss_rate_tier_tbl,
1633: p_object_version_number IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
1634: -- Start - MOAC Change
1635: p_org_id IN CN_RATE_DIMENSIONS.ORG_ID%TYPE,
1636: -- End - MOAC Change
1637: x_return_status OUT NOCOPY VARCHAR2,
1638: x_msg_count OUT NOCOPY NUMBER,
1639: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1643: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

1639: x_msg_data OUT NOCOPY VARCHAR2) IS
1640:
1641: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension';
1642: l_api_version CONSTANT NUMBER := 1.0;
1643: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1644: l_description CN_RATE_DIMENSIONS.DESCRIPTION%TYPE;
1645: l_name CN_RATE_DIMENSIONS.NAME%TYPE;
1646: l_tiers_tbl CN_RATE_DIMENSIONS_PVT.TIERS_TBL_TYPE;
1647: -- Start - MOAC Change

Line 1644: l_description CN_RATE_DIMENSIONS.DESCRIPTION%TYPE;

1640:
1641: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension';
1642: l_api_version CONSTANT NUMBER := 1.0;
1643: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1644: l_description CN_RATE_DIMENSIONS.DESCRIPTION%TYPE;
1645: l_name CN_RATE_DIMENSIONS.NAME%TYPE;
1646: l_tiers_tbl CN_RATE_DIMENSIONS_PVT.TIERS_TBL_TYPE;
1647: -- Start - MOAC Change
1648: l_org_id NUMBER;

Line 1645: l_name CN_RATE_DIMENSIONS.NAME%TYPE;

1641: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dimension';
1642: l_api_version CONSTANT NUMBER := 1.0;
1643: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1644: l_description CN_RATE_DIMENSIONS.DESCRIPTION%TYPE;
1645: l_name CN_RATE_DIMENSIONS.NAME%TYPE;
1646: l_tiers_tbl CN_RATE_DIMENSIONS_PVT.TIERS_TBL_TYPE;
1647: -- Start - MOAC Change
1648: l_org_id NUMBER;
1649: -- End - MOAC Change

Line 1646: l_tiers_tbl CN_RATE_DIMENSIONS_PVT.TIERS_TBL_TYPE;

1642: l_api_version CONSTANT NUMBER := 1.0;
1643: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1644: l_description CN_RATE_DIMENSIONS.DESCRIPTION%TYPE;
1645: l_name CN_RATE_DIMENSIONS.NAME%TYPE;
1646: l_tiers_tbl CN_RATE_DIMENSIONS_PVT.TIERS_TBL_TYPE;
1647: -- Start - MOAC Change
1648: l_org_id NUMBER;
1649: -- End - MOAC Change
1650:

Line 1682: FROM cn_rate_dimensions

1678: l_rate_dimension_id := get_rate_dimension_id(p_original_name);
1679:
1680: -- Start - MOAC Change
1681: SELECT org_id INTO l_org_id
1682: FROM cn_rate_dimensions
1683: WHERE rate_dimension_id = l_rate_dimension_id;
1684:
1685: IF (l_org_id <> p_org_id)
1686: THEN

Line 1704: select description into l_description from cn_rate_dimensions

1700: RAISE FND_API.G_EXC_ERROR ;
1701: END IF;
1702: -- End - MOAC Change
1703:
1704: select description into l_description from cn_rate_dimensions
1705: where rate_dimension_id = l_rate_dimension_id;
1706:
1707: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
1708: decode(p_description, cn_api.g_miss_char, l_description, p_description)

Line 1759: CN_RATE_DIMENSIONS_PVT.Update_Dimension

1755:
1756: check_ret_sts(x_return_status);
1757: end if;
1758:
1759: CN_RATE_DIMENSIONS_PVT.Update_Dimension
1760: (p_api_version => p_api_version,
1761: p_init_msg_list => p_init_msg_list,
1762: p_commit => p_commit,
1763: p_validation_level => p_validation_level,

Line 1859: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

1855: (p_api_version IN NUMBER,
1856: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1857: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1858: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1859: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1860: -- Start - R12 MOAC Changes
1861: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
1862: -- End - R12 MOAC Changes
1863: x_return_status OUT NOCOPY VARCHAR2,

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

1857: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1858: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1859: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
1860: -- Start - R12 MOAC Changes
1861: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
1862: -- End - R12 MOAC Changes
1863: x_return_status OUT NOCOPY VARCHAR2,
1864: x_msg_count OUT NOCOPY NUMBER,
1865: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1869: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

1865: x_msg_data OUT NOCOPY VARCHAR2) IS
1866:
1867: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dimension';
1868: l_api_version CONSTANT NUMBER := 1.0;
1869: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1870:
1871: BEGIN
1872: -- Standard Start of API savepoint
1873: SAVEPOINT Delete_Dimension;

Line 1916: CN_RATE_DIMENSIONS_PVT.Delete_Dimension

1912:
1913: check_ret_sts(x_return_status);
1914: end if;
1915:
1916: CN_RATE_DIMENSIONS_PVT.Delete_Dimension
1917: (p_api_version => p_api_version,
1918: p_init_msg_list => p_init_msg_list,
1919: p_commit => p_commit,
1920: p_validation_level => p_validation_level,

Line 2000: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

1996: (p_api_version IN NUMBER,
1997: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1998: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1999: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2000: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
2001: p_value1 IN VARCHAR2,
2002: p_value2 IN VARCHAR2,
2003: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
2004: -- Start - MOAC Change

Line 2013: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

2009: x_msg_data OUT NOCOPY VARCHAR2) IS
2010:
2011: l_api_name CONSTANT VARCHAR2(30) := 'Create_Tier';
2012: l_api_version CONSTANT NUMBER := 1.0;
2013: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2014: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
2015: l_dim_unit_code CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE;
2016: l_minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE;
2017: l_maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE;

Line 2015: l_dim_unit_code CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE;

2011: l_api_name CONSTANT VARCHAR2(30) := 'Create_Tier';
2012: l_api_version CONSTANT NUMBER := 1.0;
2013: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2014: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
2015: l_dim_unit_code CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE;
2016: l_minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE;
2017: l_maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE;
2018: l_min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE;
2019: l_max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE;

Line 2061: select dim_unit_code into l_dim_unit_code from cn_rate_dimensions

2057:
2058: l_rate_dimension_id := get_rate_dimension_id(p_dimension_name);
2059:
2060: -- get dim_unit_code from the dimension
2061: select dim_unit_code into l_dim_unit_code from cn_rate_dimensions
2062: where rate_dimension_id = l_rate_dimension_id;
2063:
2064: translate_values(l_dim_unit_code, p_value1, p_value2, l_minimum_amount, l_maximum_amount,
2065: l_min_exp_id, l_max_exp_id, l_string_value);

Line 2095: CN_RATE_DIMENSIONS_PVT.create_tier

2091:
2092: check_ret_sts(x_return_status);
2093: end if;
2094:
2095: CN_RATE_DIMENSIONS_PVT.create_tier
2096: (p_api_version => p_api_version,
2097: p_init_msg_list => p_init_msg_list,
2098: p_commit => p_commit,
2099: p_validation_level => p_validation_level,

Line 2193: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

2189: (p_api_version IN NUMBER,
2190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2193: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
2194: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
2195: p_value1 IN VARCHAR2,
2196: p_value2 IN VARCHAR2,
2197: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

Line 2207: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

2203: x_msg_data OUT NOCOPY VARCHAR2) IS
2204:
2205: l_api_name CONSTANT VARCHAR2(30) := 'Update_Tier';
2206: l_api_version CONSTANT NUMBER := 1.0;
2207: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2208: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
2209: l_dim_unit_code CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE;
2210: l_minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE;
2211: l_maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE;

Line 2209: l_dim_unit_code CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE;

2205: l_api_name CONSTANT VARCHAR2(30) := 'Update_Tier';
2206: l_api_version CONSTANT NUMBER := 1.0;
2207: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2208: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
2209: l_dim_unit_code CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE;
2210: l_minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE;
2211: l_maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE;
2212: l_min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE;
2213: l_max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE;

Line 2267: select dim_unit_code into l_dim_unit_code from cn_rate_dimensions

2263: END IF;
2264: -- End - MOAC Change
2265:
2266: -- get dim_unit_code from the dimension
2267: select dim_unit_code into l_dim_unit_code from cn_rate_dimensions
2268: where rate_dimension_id = l_rate_dimension_id;
2269:
2270: translate_values(l_dim_unit_code, p_value1, p_value2, l_minimum_amount, l_maximum_amount,
2271: l_min_exp_id, l_max_exp_id, l_string_value);

Line 2303: CN_RATE_DIMENSIONS_PVT.update_tier

2299:
2300: check_ret_sts(x_return_status);
2301: end if;
2302:
2303: CN_RATE_DIMENSIONS_PVT.update_tier
2304: (p_api_version => p_api_version,
2305: p_init_msg_list => p_init_msg_list,
2306: p_commit => p_commit,
2307: p_validation_level => p_validation_level,

Line 2401: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

2397: (p_api_version IN NUMBER,
2398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2401: p_dimension_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
2402: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
2403: -- Start - R12 MOAC Changes
2404: p_object_version_number IN CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- new
2405: -- End - R12 MOAC Changes

Line 2412: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

2408: x_msg_data OUT NOCOPY VARCHAR2) IS
2409:
2410: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Tier';
2411: l_api_version CONSTANT NUMBER := 1.0;
2412: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2413: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
2414: BEGIN
2415: -- Standard Start of API savepoint
2416: SAVEPOINT Delete_Tier;

Line 2462: CN_RATE_DIMENSIONS_PVT.delete_tier

2458:
2459: check_ret_sts(x_return_status);
2460: end if;
2461:
2462: CN_RATE_DIMENSIONS_PVT.delete_tier
2463: (p_api_version => p_api_version,
2464: p_init_msg_list => p_init_msg_list,
2465: p_commit => p_commit,
2466: p_validation_level => p_validation_level,