APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_PERIOD_QUOTAS

Line 1168: cn_period_quotas_pkg.DELETE_RECORD (p_pe_rec_old.quota_id);

1164: /*OR
1165: Nvl(p_pe_rec_old.calc_formula_id,0) <> Nvl(p_pe_rec.calc_formula_id,0)*/
1166: THEN
1167: -- Call the Table Handler to Delete the Old Period quotas
1168: cn_period_quotas_pkg.DELETE_RECORD (p_pe_rec_old.quota_id);
1169: -- Check the ITD flag
1170: -- 2462767, we do not check for formula ID anymore,IF p_pe_rec.calc_formula_id IS NOT NULL THEN
1171: -- clku, enhancement 2380234
1172: --IF Nvl(cn_api.get_itd_flag(p_pe_rec.calc_formula_id),'N') = 'Y'

Line 1174: cn_period_quotas_pkg.distribute_target (p_pe_rec.quota_id);

1170: -- 2462767, we do not check for formula ID anymore,IF p_pe_rec.calc_formula_id IS NOT NULL THEN
1171: -- clku, enhancement 2380234
1172: --IF Nvl(cn_api.get_itd_flag(p_pe_rec.calc_formula_id),'N') = 'Y'
1173: -- THEN
1174: cn_period_quotas_pkg.distribute_target (p_pe_rec.quota_id);
1175:
1176: -- if count is zero create the default period quotas.
1177: IF p_period_quotas_rec_tbl.COUNT > 0
1178: THEN

Line 1182: cn_period_quotas_grp.update_period_quotas (p_api_version => p_api_version,

1178: THEN
1179: -- if count is > 0 then create the period quotas with the
1180: -- customised values.
1181: -- Call the Group package to create the Period Quotas
1182: cn_period_quotas_grp.update_period_quotas (p_api_version => p_api_version,
1183: p_init_msg_list => 'T',
1184: p_commit => p_commit,
1185: p_validation_level => p_validation_level,
1186: x_return_status => x_return_status,

Line 1205: cn_period_quotas_grp.update_period_quotas (p_api_version => p_api_version,

1201: ELSE
1202: --fix for the Bug 6193694
1203: IF p_period_quotas_rec_tbl.COUNT > 0
1204: THEN
1205: cn_period_quotas_grp.update_period_quotas (p_api_version => p_api_version,
1206: p_init_msg_list => 'T',
1207: p_commit => p_commit,
1208: p_validation_level =>p_validation_level,
1209: x_return_status => x_return_status,

Line 1282: cn_period_quotas_pkg.distribute_target (p_pe_rec.quota_id);

1278: --IF Nvl(cn_api.get_itd_flag(p_pe_rec.calc_formula_id),'N') = 'Y' THEN
1279: -- if count is zero create the default period quotas.
1280: IF p_period_quotas_rec_tbl.COUNT = 0
1281: THEN
1282: cn_period_quotas_pkg.distribute_target (p_pe_rec.quota_id);
1283: ELSE
1284: -- if count is > 0 then create the period quotas with the
1285: -- customised values.
1286: l_tmp := p_period_quotas_rec_tbl.COUNT;

Line 1288: cn_period_quotas_grp.create_period_quotas (p_api_version => p_api_version,

1284: -- if count is > 0 then create the period quotas with the
1285: -- customised values.
1286: l_tmp := p_period_quotas_rec_tbl.COUNT;
1287: -- Call the Group package to create the Period Quotas
1288: cn_period_quotas_grp.create_period_quotas (p_api_version => p_api_version,
1289: p_init_msg_list => 'T',
1290: p_commit => p_commit,
1291: p_validation_level => p_validation_level,
1292: x_return_status => x_return_status,

Line 2029: l_per_quota_id cn_period_quotas.period_quota_id%TYPE;

2025: l_api_version CONSTANT NUMBER := 1.0;
2026: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;
2027: l_trx_factor_rec_tbl trx_factor_rec_tbl_type;
2028: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;
2029: l_per_quota_id cn_period_quotas.period_quota_id%TYPE;
2030: l_tmp NUMBER;
2031: l_meaning cn_lookups.meaning%TYPE;
2032: l_p_plan_element_rec plan_element_rec_type;
2033: l_p_revenue_class_rec_tbl revenue_class_rec_tbl_type;

Line 3345: cn_period_quotas_grp.update_period_quotas (p_api_version => p_api_version,

3341: -- Group API's
3342: IF l_p_period_quotas_rec_tbl.COUNT > 0
3343: THEN
3344: -- Call Period Quotas rec Procedure
3345: cn_period_quotas_grp.update_period_quotas (p_api_version => p_api_version,
3346: p_init_msg_list => 'T',
3347: p_commit => p_commit,
3348: p_validation_level => p_validation_level,
3349: x_return_status => x_return_status,

Line 4305: FROM cn_period_quotas

4301: attribute14,
4302: attribute15,
4303: NULL period_name_old,
4304: org_id
4305: FROM cn_period_quotas
4306: WHERE quota_id = pe_id;
4307:
4308: -- Rate Quota Assigns Cursor
4309: CURSOR c_rt_quota_asgns_rec_csr (