APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_RT_QUOTA_ASGNS

Line 899: cn_rt_quota_asgns_pkg.DELETE_RECORD (x_quota_id => p_pe_rec_old.quota_id, x_calc_formula_id => NULL, x_rt_quota_asgn_id => NULL);

895: -- and end Date then insert through a batch by calling the Table Handler
896: IF NVL (p_pe_rec_old.calc_formula_id, 0) <> NVL (p_pe_rec.calc_formula_id, 0)
897: THEN
898: -- Call the Table Handler to Delete the Old Period quotas
899: cn_rt_quota_asgns_pkg.DELETE_RECORD (x_quota_id => p_pe_rec_old.quota_id, x_calc_formula_id => NULL, x_rt_quota_asgn_id => NULL);
900: END IF;
901:
902: IF p_rt_quota_asgns_rec_tbl.COUNT = 0 AND p_pe_rec.quota_type_code <> 'NONE'
903: THEN

Line 943: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_pe_rec.quota_id, x_calc_formula_id => p_pe_rec.calc_formula_id);

939: END IF;*/
940:
941: -- call the Table handler for batch insert. we betten
942: -- DO IN TABLE handler itself
943: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_pe_rec.quota_id, x_calc_formula_id => p_pe_rec.calc_formula_id);
944: END IF;
945: -- if the rt_table_count is > 0 and the quota type is FORMULA
946: ELSIF p_pe_rec.quota_type_code <> 'NONE' AND p_rt_quota_asgns_rec_tbl.COUNT > 0
947: THEN

Line 950: cn_rt_quota_asgns_pvt.update_rt_quota_asgns (p_api_version => p_api_version,

946: ELSIF p_pe_rec.quota_type_code <> 'NONE' AND p_rt_quota_asgns_rec_tbl.COUNT > 0
947: THEN
948: -- call create_rt_quota_asgns_pvt package to validate and create
949: -- the rate Quota Assigns
950: cn_rt_quota_asgns_pvt.update_rt_quota_asgns (p_api_version => p_api_version,
951: p_init_msg_list => 'T',
952: p_commit => p_commit,
953: p_validation_level => p_validation_level,
954: x_return_status => x_return_status,

Line 1066: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_pe_rec.quota_id, x_calc_formula_id => p_pe_rec.calc_formula_id);

1062: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1063: RAISE FND_API.G_EXC_ERROR ;
1064: END IF;*/
1065: -- call the Table handler for batch insert.
1066: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_pe_rec.quota_id, x_calc_formula_id => p_pe_rec.calc_formula_id);
1067: END IF;
1068: -- if the rt_table_count is > 0 and the quota type is FORMULA
1069: ELSIF p_pe_rec.quota_type_code <> 'NONE' AND p_rt_quota_asgns_rec_tbl.COUNT > 0
1070: THEN

Line 1073: cn_rt_quota_asgns_pvt.create_rt_quota_asgns (p_api_version => p_api_version,

1069: ELSIF p_pe_rec.quota_type_code <> 'NONE' AND p_rt_quota_asgns_rec_tbl.COUNT > 0
1070: THEN
1071: -- call create_rt_quota_asgns_pvt package to validate and create
1072: -- the rate Quota Assigns
1073: cn_rt_quota_asgns_pvt.create_rt_quota_asgns (p_api_version => p_api_version,
1074: p_init_msg_list => 'T',
1075: p_commit => p_commit,
1076: p_validation_level => p_validation_level,
1077: x_return_status => x_return_status,

Line 3374: cn_rt_quota_asgns_pvt.update_rt_quota_asgns (p_api_version => p_api_version,

3370: -- Procedure to Update the rate Quota assigns
3371: IF l_p_rt_quota_asgns_rec_tbl.COUNT > 0
3372: THEN
3373: -- Call Update the Rate Quota Assisns procedure
3374: cn_rt_quota_asgns_pvt.update_rt_quota_asgns (p_api_version => p_api_version,
3375: p_init_msg_list => 'T',
3376: p_commit => p_commit,
3377: p_validation_level => p_validation_level,
3378: x_return_status => x_return_status,

Line 3579: -- CN_QUOTAS, CN_QUOTA_RULES, CN_RT_QUOTA_ASGNS

3575: -- Type : Public
3576: -- Pre-reqs : None.
3577: -- Purpose : The following API performs the following
3578: -- 1. Deletes the Plan Element and it's associated records in
3579: -- CN_QUOTAS, CN_QUOTA_RULES, CN_RT_QUOTA_ASGNS
3580: -- 2.
3581: -- 3.
3582: -- Parameters :
3583: -- IN : p_api_version IN NUMBER API version

Line 3923: cn_rt_quota_asgns_pvt.delete_rt_quota_asgns (p_api_version => p_api_version,

3919: IF l_p_rt_quota_asgns_rec_tbl.COUNT > 0
3920: THEN
3921: -- Call the rate_quota_assigns delete package procedure to delete the
3922: -- rate quota Assigns
3923: cn_rt_quota_asgns_pvt.delete_rt_quota_asgns (p_api_version => p_api_version,
3924: p_init_msg_list => 'T',
3925: p_commit => p_commit,
3926: p_validation_level => p_validation_level,
3927: x_return_status => x_return_status,

Line 4337: FROM cn_rt_quota_asgns

4333: NULL rate_schedule_name_old,
4334: NULL start_date1,
4335: NULL start_date2,
4336: org_id
4337: FROM cn_rt_quota_asgns
4338: WHERE quota_id = pe_id
4339: ORDER BY start_date;
4340: BEGIN
4341: -- Standard Start of API savepoint