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_DIMENSIONS

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 170: from cn_rate_dim_tiers_all rdt, cn_rate_dimensions_all rd, cn_calc_sql_exps e1, cn_calc_sql_exps e2

166: 'AMOUNT', rdt.minimum_amount || ' - ' || rdt.maximum_amount,
167: 'PERCENT', rdt.minimum_amount * 100 || '% - ' || rdt.maximum_amount * 100 || '%',
168: 'STRING', rdt.string_value,
169: 'EXPRESSION', e1.name || ' - ' || e2.name) tier
170: from cn_rate_dim_tiers_all rdt, cn_rate_dimensions_all rd, cn_calc_sql_exps e1, cn_calc_sql_exps e2
171: where rdt.rate_dimension_id = p_rate_dimension_id
172: and rdt.tier_sequence = p_sequence
173: and rd.rate_dimension_id = rdt.rate_dimension_id
174: and rdt.min_exp_id = e1.calc_sql_exp_id(+)

Line 1050: from cn_rate_dimensions

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
1051: where rate_dimension_id = l_dimension_id;
1052:
1053: select name into l_rate_sch_name_old
1054: from cn_rate_schedules

Line 1192: l_number_tier_old CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;

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;
1196: l_count NUMBER;

Line 1193: l_number_tier_new CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;

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;
1196: l_count NUMBER;
1197:

Line 1212: FROM cn_rate_dimensions

1208: WHERE rate_sch_dim_id = p_rate_sch_dim_id;
1209:
1210: CURSOR old_dim_info IS
1211: SELECT number_tier
1212: FROM cn_rate_dimensions
1213: WHERE rate_dimension_id = l_rate_dimension_id_old;
1214:
1215: CURSOR new_dim_info IS
1216: SELECT number_tier

Line 1217: FROM cn_rate_dimensions

1213: WHERE rate_dimension_id = l_rate_dimension_id_old;
1214:
1215: CURSOR new_dim_info IS
1216: SELECT number_tier
1217: FROM cn_rate_dimensions
1218: WHERE rate_dimension_id = p_rate_dimension_id;
1219: BEGIN
1220: -- Standard Start of API savepoint
1221: SAVEPOINT Update_Dimension_Assign;

Line 1303: from cn_rate_dimensions

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
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

Line 1325: from cn_rate_dimensions

1321: -- *********************************************************************
1322: IF (p_rate_dimension_id <> l_rate_dimension_id) THEN
1323:
1324: select name into l_dimension_name_new
1325: from cn_rate_dimensions
1326: where rate_dimension_id = p_rate_dimension_id;
1327:
1328: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_UPDATE');
1329: fnd_message.set_token('OLD_DIM', l_dimension_name_old);

Line 1528: from cn_rate_dimensions

1524: -- *********************************************************************
1525: -- ************ Start - R12 Notes History ******************************
1526: -- *********************************************************************
1527: select name into l_dimension_name
1528: from cn_rate_dimensions
1529: where rate_dimension_id = p_rate_dimension_id;
1530:
1531: select name into l_rate_sch_name
1532: from cn_rate_schedules

Line 1627: -- instead of cn_rate_dimensions.number_tier

1623: END Create_Dimension_Assign;
1624:
1625: -- 1. if two or more tiers are inserted at the same time, create_rate_tiers will
1626: -- face problems. The solution is to use the actual number of tiers in the dimension
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,

Line 2211: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;

2207: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
2208:
2209: l_base NUMBER := 1;
2210: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
2211: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2212: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
2213: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
2214: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
2215:

Line 2213: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;

2209: l_base NUMBER := 1;
2210: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
2211: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2212: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
2213: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
2214: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
2215:
2216: dim_size_table num_tbl_type;
2217: current_tier_table num_tbl_type;

Line 2222: cn_rate_dimensions rd

2218:
2219: CURSOR dim_info(p_rate_dimension_id NUMBER) IS
2220: SELECT rsd.rate_dim_sequence, rd.number_tier
2221: FROM cn_rate_sch_dims rsd,
2222: cn_rate_dimensions rd
2223: WHERE rsd.rate_schedule_id = p_rate_schedule_id
2224: AND rsd.rate_dimension_id = p_rate_dimension_id
2225: AND rd.rate_dimension_id = p_rate_dimension_id;
2226:

Line 2408: cursor rate_dim_info(l_dim_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)

2404: select * from cn_rate_sch_dims_all
2405: where rate_schedule_id = p_rate_schedule_id
2406: and org_id = p_org_id;
2407:
2408: cursor rate_dim_info(l_dim_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)
2409: is
2410: select * from cn_rate_dimensions_all
2411: where rate_dimension_id = l_dim_id
2412: and org_id = p_org_id;

Line 2410: select * from cn_rate_dimensions_all

2406: and org_id = p_org_id;
2407:
2408: cursor rate_dim_info(l_dim_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)
2409: is
2410: select * from cn_rate_dimensions_all
2411: where rate_dimension_id = l_dim_id
2412: and org_id = p_org_id;
2413:
2414: