APPS.CN_SRP_PMT_PLANS_PUB dependencies on CN_SRP_PMT_PLANS_PVT

Line 289: l_create_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;

285: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
286: l_start_date cn_srp_pmt_plans.start_date%TYPE;
287: l_end_date cn_srp_pmt_plans.end_date%TYPE;
288: l_action VARCHAR2(30) := 'CREATE';
289: l_create_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
290: l_org_id NUMBER;
291: l_status VARCHAR2(1);
292:
293: -- Declaration for user hooks

Line 446: cn_srp_pmt_plans_pvt.create_srp_pmt_plan

442: l_create_rec.srp_role_id := p_srp_pmt_plans_rec.srp_role_id;
443: l_create_rec.role_pmt_plan_id := p_srp_pmt_plans_rec.role_pmt_plan_id;
444: l_create_rec.lock_flag := p_srp_pmt_plans_rec.lock_flag;
445:
446: cn_srp_pmt_plans_pvt.create_srp_pmt_plan
447: ( p_api_version => p_api_version,
448: p_init_msg_list => fnd_api.g_false,
449: p_commit => fnd_api.g_false,
450: p_validation_level => p_validation_level,

Line 658: l_update_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;

654: l_pp_start_date cn_pmt_plans.start_date%TYPE;
655: l_pp_end_date cn_pmt_plans.end_date%TYPE;
656: l_action VARCHAR2(30) := 'UPDATE';
657: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
658: l_update_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
659:
660: -- Declaration for user hooks
661: l_OAI_array JTF_USR_HKS.oai_data_array_type;
662: l_bind_data_id NUMBER ;

Line 879: cn_srp_pmt_plans_pvt.update_srp_pmt_plan

875: l_update_rec.srp_role_id := p_srp_pmt_plans_rec.srp_role_id;
876: l_update_rec.role_pmt_plan_id := p_srp_pmt_plans_rec.role_pmt_plan_id;
877: l_update_rec.lock_flag := p_srp_pmt_plans_rec.lock_flag;
878:
879: cn_srp_pmt_plans_pvt.update_srp_pmt_plan
880: ( p_api_version => p_api_version,
881: p_init_msg_list => fnd_api.g_false,
882: p_commit => fnd_api.g_false,
883: p_validation_level => p_validation_level,

Line 1224: cn_srp_pmt_plans_pvt.delete_srp_pmt_plan

1220: END IF;
1221:
1222: -- API body
1223:
1224: cn_srp_pmt_plans_pvt.delete_srp_pmt_plan
1225: (
1226: p_api_version => p_api_version,
1227: p_init_msg_list => fnd_api.g_false,
1228: p_commit => fnd_api.g_false,

Line 1414: cn_srp_pmt_plans_pvt.create_mass_asgn_srp_pmt_plan

1410: x_srp_pmt_plan_id OUT NOCOPY NUMBER,
1411: x_loading_status OUT NOCOPY VARCHAR2
1412: ) IS
1413: BEGIN
1414: cn_srp_pmt_plans_pvt.create_mass_asgn_srp_pmt_plan
1415: (p_api_version => p_api_version,
1416: p_init_msg_list => p_init_msg_list,
1417: p_commit => p_commit,
1418: p_validation_level => p_validation_level,

Line 1446: cn_srp_pmt_plans_pvt.update_mass_asgn_srp_pmt_plan

1442: p_role_pmt_plan_id IN NUMBER,
1443: x_loading_status OUT NOCOPY VARCHAR2
1444: ) IS
1445: BEGIN
1446: cn_srp_pmt_plans_pvt.update_mass_asgn_srp_pmt_plan
1447: (p_api_version => p_api_version,
1448: p_init_msg_list => p_init_msg_list,
1449: p_commit => p_commit,
1450: p_validation_level => p_validation_level,

Line 1477: cn_srp_pmt_plans_pvt.delete_mass_asgn_srp_pmt_plan

1473: p_role_pmt_plan_id IN NUMBER,
1474: x_loading_status OUT NOCOPY VARCHAR2
1475: ) IS
1476: BEGIN
1477: cn_srp_pmt_plans_pvt.delete_mass_asgn_srp_pmt_plan
1478: (p_api_version => p_api_version,
1479: p_init_msg_list => p_init_msg_list,
1480: p_commit => p_commit,
1481: p_validation_level => p_validation_level,