DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_RT_QUOTA_ASGNS_PKG

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