APPS.CN_CALC_FORMULAS_PVT dependencies on CN_RT_FORMULA_ASGNS

Line 184: from cn_rt_formula_asgns a, cn_rate_schedules s,

180: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
181: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE) IS
182: cursor rt_asgns is
183: select s.number_dim, d.dim_unit_code
184: from cn_rt_formula_asgns a, cn_rate_schedules s,
185: cn_rate_sch_dims r, cn_rate_dimensions d
186: where a.rate_schedule_id = s.rate_schedule_id
187: and s.rate_schedule_id = r.rate_schedule_id
188: and r.rate_dimension_id = d.rate_dimension_id

Line 471: -- in cn_rt_formula_asgns

467: END LOOP;
468: END IF;
469:
470: -- call table handler to create the rate table assignment records
471: -- in cn_rt_formula_asgns
472: IF (p_rt_assign_tbl.COUNT > 0) THEN
473: FOR i IN p_rt_assign_tbl.first..p_rt_assign_tbl.last LOOP
474: -- make sure no date ranges overlap and start_date <= end_date
475: for j in p_rt_assign_tbl.first..i-1 loop

Line 492: cn_rt_formula_asgns_pkg.insert_row

488: RAISE FND_API.G_EXC_ERROR;
489: end if;
490:
491: l_temp_id := NULL;
492: cn_rt_formula_asgns_pkg.insert_row
493: (x_rt_formula_asgn_id => l_temp_id,
494: x_calc_formula_id => x_calc_formula_id,
495: x_rate_schedule_id => p_rt_assign_tbl(i).rate_schedule_id,
496: x_start_date => p_rt_assign_tbl(i).start_date,

Line 1305: -- records in cn_rt_formula_asgns

1301: -- ************ Start - This code is not required in R12 ***************
1302: -- *********************************************************************
1303: /*
1304: -- call table handler to insert/update/delete the rate table assignment
1305: -- records in cn_rt_formula_asgns
1306: IF (p_rt_assign_tbl.COUNT > 0) THEN
1307: FOR i IN p_rt_assign_tbl.first..p_rt_assign_tbl.last LOOP
1308: -- make sure no date ranges overlap and start_date <= end_date
1309: for j in p_rt_assign_tbl.first..i-1 loop

Line 1327: cn_rt_formula_asgns_pkg.insert_row

1323: end if;
1324:
1325: IF (p_rt_assign_tbl(i).rt_formula_asgn_id IS NULL) then
1326: l_temp_id := NULL;
1327: cn_rt_formula_asgns_pkg.insert_row
1328: (x_rt_formula_asgn_id => l_temp_id,
1329: x_calc_formula_id => p_calc_formula_id,
1330: x_rate_schedule_id => p_rt_assign_tbl(i).rate_schedule_id,
1331: x_start_date => p_rt_assign_tbl(i).start_date,

Line 1338: cn_rt_formula_asgns_pkg.delete_row

1334: x_org_id => p_org_id
1335: --R12 MOAC Changes--End
1336: );
1337: ELSIF (p_rt_assign_tbl(i).rate_schedule_id IS NULL) THEN
1338: cn_rt_formula_asgns_pkg.delete_row
1339: (p_rt_assign_tbl(i).rt_formula_asgn_id);
1340: ELSE
1341: cn_rt_formula_asgns_pkg.lock_row
1342: (x_rt_formula_asgn_id => p_rt_assign_tbl(i).rt_formula_asgn_id,

Line 1341: cn_rt_formula_asgns_pkg.lock_row

1337: ELSIF (p_rt_assign_tbl(i).rate_schedule_id IS NULL) THEN
1338: cn_rt_formula_asgns_pkg.delete_row
1339: (p_rt_assign_tbl(i).rt_formula_asgn_id);
1340: ELSE
1341: cn_rt_formula_asgns_pkg.lock_row
1342: (x_rt_formula_asgn_id => p_rt_assign_tbl(i).rt_formula_asgn_id,
1343: x_object_version_number => p_rt_assign_tbl(i).object_version_number);
1344:
1345: cn_rt_formula_asgns_pkg.update_row

Line 1345: cn_rt_formula_asgns_pkg.update_row

1341: cn_rt_formula_asgns_pkg.lock_row
1342: (x_rt_formula_asgn_id => p_rt_assign_tbl(i).rt_formula_asgn_id,
1343: x_object_version_number => p_rt_assign_tbl(i).object_version_number);
1344:
1345: cn_rt_formula_asgns_pkg.update_row
1346: (x_rt_formula_asgn_id => p_rt_assign_tbl(i).rt_formula_asgn_id,
1347: x_calc_formula_id => p_calc_formula_id,
1348: x_rate_schedule_id => p_rt_assign_tbl(i).rate_schedule_id,
1349: x_start_date => p_rt_assign_tbl(i).start_date,

Line 1568: DELETE FROM cn_rt_formula_asgns WHERE calc_formula_id = p_calc_formula_id AND org_id = p_org_id;

1564: /* End - R12 Notes History */
1565:
1566: -- delete formula inputs and rate table assignments
1567: DELETE FROM cn_formula_inputs WHERE calc_formula_id = p_calc_formula_id AND org_id = p_org_id;
1568: DELETE FROM cn_rt_formula_asgns WHERE calc_formula_id = p_calc_formula_id AND org_id = p_org_id;
1569:
1570: -- delete formula packages and the records in cn_objects if they exist.
1571:
1572: -- End of API body.

Line 1711: FROM cn_rt_formula_asgns

1707: SELECT 1
1708: FROM cn_rate_schedules
1709: WHERE number_dim <> l_number_dim
1710: AND rate_schedule_id IN (SELECT rate_schedule_id
1711: FROM cn_rt_formula_asgns
1712: WHERE calc_formula_id = p_calc_formula_id);
1713: BEGIN
1714: -- Standard Start of API savepoint
1715: SAVEPOINT Generate_Formula;