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_DIM_TIERS

Line 84: FUNCTION get_rate_dim_tier_id(p_rate_dimension_id in CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

80: RAISE fnd_api.g_exc_error;
81: END get_exp_id;
82:
83: -- to get a rate_dim_tier_id from the rate_dimension_id and its sequence
84: FUNCTION get_rate_dim_tier_id(p_rate_dimension_id in CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
85: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
86: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
87:
88: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

Line 85: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)

81: END get_exp_id;
82:
83: -- to get a rate_dim_tier_id from the rate_dimension_id and its sequence
84: FUNCTION get_rate_dim_tier_id(p_rate_dimension_id in CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
85: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
86: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
87:
88: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
89: BEGIN

Line 86: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS

82:
83: -- to get a rate_dim_tier_id from the rate_dimension_id and its sequence
84: FUNCTION get_rate_dim_tier_id(p_rate_dimension_id in CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
85: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
86: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
87:
88: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
89: BEGIN
90: select rate_dim_tier_id into l_rate_dim_tier_id

Line 88: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

84: FUNCTION get_rate_dim_tier_id(p_rate_dimension_id in CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
85: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
86: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
87:
88: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
89: BEGIN
90: select rate_dim_tier_id into l_rate_dim_tier_id
91: from cn_rate_dim_tiers
92: where rate_dimension_id = p_rate_dimension_id

Line 91: from cn_rate_dim_tiers

87:
88: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
89: BEGIN
90: select rate_dim_tier_id into l_rate_dim_tier_id
91: from cn_rate_dim_tiers
92: where rate_dimension_id = p_rate_dimension_id
93: and tier_sequence = p_tier_sequence;
94:
95: RETURN l_rate_dim_tier_id;

Line 106: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)

102:
103: -- to get a rate_dim_tier_id from the rate_schedule and sequence numbers
104: FUNCTION get_rate_dim_tier_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
105: p_rate_dim_sequence in CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
106: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
107: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
108:
109: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
110: BEGIN

Line 107: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS

103: -- to get a rate_dim_tier_id from the rate_schedule and sequence numbers
104: FUNCTION get_rate_dim_tier_id(p_rate_schedule_id in CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
105: p_rate_dim_sequence in CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
106: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
107: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
108:
109: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
110: BEGIN
111: select rdt.rate_dim_tier_id into l_rate_dim_tier_id

Line 109: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

105: p_rate_dim_sequence in CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
106: p_tier_sequence in CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE)
107: RETURN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE IS
108:
109: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
110: BEGIN
111: select rdt.rate_dim_tier_id into l_rate_dim_tier_id
112: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt
113: where rsd.rate_schedule_id = p_rate_schedule_id

Line 112: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt

108:
109: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
110: BEGIN
111: select rdt.rate_dim_tier_id into l_rate_dim_tier_id
112: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt
113: where rsd.rate_schedule_id = p_rate_schedule_id
114: and rsd.rate_dim_sequence = p_rate_dim_sequence
115: and rdt.rate_dimension_id = rsd.rate_dimension_id
116: and rdt.tier_sequence = p_tier_sequence;

Line 129: p_minimum_amount OUT NOCOPY CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE,

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,
131: p_min_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
132: p_max_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
133: p_string_value OUT NOCOPY CN_RATE_DIM_TIERS.STRING_VALUE%TYPE) IS

Line 130: p_maximum_amount OUT NOCOPY CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE,

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,
131: p_min_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
132: p_max_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
133: p_string_value OUT NOCOPY CN_RATE_DIM_TIERS.STRING_VALUE%TYPE) IS
134: BEGIN

Line 131: p_min_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MIN_EXP_ID%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,
131: p_min_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
132: p_max_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
133: p_string_value OUT NOCOPY CN_RATE_DIM_TIERS.STRING_VALUE%TYPE) IS
134: BEGIN
135: if p_dim_unit_code = 'AMOUNT' OR p_dim_unit_code = 'PERCENT' then

Line 132: p_max_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,

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,
131: p_min_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
132: p_max_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
133: p_string_value OUT NOCOPY CN_RATE_DIM_TIERS.STRING_VALUE%TYPE) IS
134: BEGIN
135: if p_dim_unit_code = 'AMOUNT' OR p_dim_unit_code = 'PERCENT' then
136: p_minimum_amount := p_value1;

Line 133: p_string_value OUT NOCOPY CN_RATE_DIM_TIERS.STRING_VALUE%TYPE) IS

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,
131: p_min_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE,
132: p_max_exp_id OUT NOCOPY CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE,
133: p_string_value OUT NOCOPY CN_RATE_DIM_TIERS.STRING_VALUE%TYPE) IS
134: BEGIN
135: if p_dim_unit_code = 'AMOUNT' OR p_dim_unit_code = 'PERCENT' then
136: p_minimum_amount := p_value1;
137: p_maximum_amount := p_value2;

Line 1256: l_rate_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;

1252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rate';
1253: l_api_version CONSTANT NUMBER := 1.0;
1254: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
1255: l_rate_tier_id CN_RATE_TIERS.RATE_TIER_ID%TYPE;
1256: l_rate_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
1257: l_commission_amount CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE;
1258: l_object_version_number CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE;
1259: l_rate_dim_tier_id_tbl CN_MULTI_RATE_SCHEDULES_PVT.num_tbl_type;
1260: -- Start - MOAC Change

Line 1651: CURSOR get_rdt_id(p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

1647: -- Start - MOAC Change
1648: l_org_id NUMBER;
1649: -- End - MOAC Change
1650:
1651: CURSOR get_rdt_id(p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1652: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE) IS
1653: select rate_dim_tier_id from cn_rate_dim_tiers
1654: where rate_dimension_id = p_rate_dimension_id
1655: and tier_sequence = p_tier_sequence;

Line 1652: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE) IS

1648: l_org_id NUMBER;
1649: -- End - MOAC Change
1650:
1651: CURSOR get_rdt_id(p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1652: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE) IS
1653: select rate_dim_tier_id from cn_rate_dim_tiers
1654: where rate_dimension_id = p_rate_dimension_id
1655: and tier_sequence = p_tier_sequence;
1656:

Line 1653: select rate_dim_tier_id from cn_rate_dim_tiers

1649: -- End - MOAC Change
1650:
1651: CURSOR get_rdt_id(p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1652: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE) IS
1653: select rate_dim_tier_id from cn_rate_dim_tiers
1654: where rate_dimension_id = p_rate_dimension_id
1655: and tier_sequence = p_tier_sequence;
1656:
1657: BEGIN

Line 2003: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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
2005: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE := NULL,
2006: -- End - MOAC Change
2007: x_return_status OUT NOCOPY VARCHAR2,

Line 2014: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

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;
2018: l_min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE;

Line 2016: l_minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE;

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;
2020: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;

Line 2017: l_maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE;

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;
2020: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;
2021: -- Start - MOAC Change

Line 2018: l_min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_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;
2020: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;
2021: -- Start - MOAC Change
2022: l_org_id NUMBER;

Line 2019: l_max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_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;
2020: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;
2021: -- Start - MOAC Change
2022: l_org_id NUMBER;
2023: l_status VARCHAR2(1);

Line 2020: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%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;
2020: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;
2021: -- Start - MOAC Change
2022: l_org_id NUMBER;
2023: l_status VARCHAR2(1);
2024: -- End - MOAC Change

Line 2194: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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,
2198: -- Start - MOAC Change

Line 2197: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,

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,
2198: -- Start - MOAC Change
2199: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE,
2200: -- End - MOAC Change
2201: x_return_status OUT NOCOPY VARCHAR2,

Line 2208: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

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;
2212: l_min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE;

Line 2210: l_minimum_amount CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE;

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;
2214: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;

Line 2211: l_maximum_amount CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE;

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;
2214: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;
2215: -- Start - MOAC Change

Line 2212: l_min_exp_id CN_RATE_DIM_TIERS.MIN_EXP_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;
2214: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;
2215: -- Start - MOAC Change
2216: l_org_id NUMBER;

Line 2213: l_max_exp_id CN_RATE_DIM_TIERS.MAX_EXP_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;
2214: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;
2215: -- Start - MOAC Change
2216: l_org_id NUMBER;
2217: -- End - MOAC Change

Line 2214: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%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;
2214: l_string_value CN_RATE_DIM_TIERS.STRING_VALUE%TYPE;
2215: -- Start - MOAC Change
2216: l_org_id NUMBER;
2217: -- End - MOAC Change
2218: BEGIN

Line 2244: FROM cn_rate_dim_tiers

2240: l_rate_dim_tier_id := get_rate_dim_tier_id(l_rate_dimension_id, p_tier_sequence);
2241:
2242: -- Start - MOAC Change
2243: SELECT org_id INTO l_org_id
2244: FROM cn_rate_dim_tiers
2245: WHERE rate_dim_tier_id = l_rate_dim_tier_id;
2246:
2247: IF (l_org_id <> p_org_id)
2248: THEN

Line 2402: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

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
2406: x_return_status OUT NOCOPY VARCHAR2,

Line 2413: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;

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;
2417: -- Standard call to check for call compatibility.