1 PACKAGE CN_SCENARIOS_PVT AS
2 /*$Header: cnvscns.pls 120.0 2007/07/26 01:11:11 appldev noship $*/
3
4
5 /*
6 1. Pass p_role_plan_id when you are dis associating a role from the plan or plan to a role
7 2. Pass p_comp_plan_id when you are about to delete a compensation plan
8 */
9
10 PROCEDURE delete_scenario_plans
11 (p_api_version IN NUMBER ,
12 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
13 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
14 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15 p_role_plan_id IN CN_SCENARIO_PLANS_ALL.ROLE_PLAN_ID%TYPE := NULL,
16 p_comp_plan_id IN CN_SCENARIO_PLANS_ALL.COMP_PLAN_ID%TYPE := NULL,
17 p_role_id IN CN_SCENARIO_PLANS_ALL.ROLE_ID%TYPE := NULL,
18 x_return_status OUT NOCOPY VARCHAR2 ,
19 x_msg_count OUT NOCOPY NUMBER ,
20 x_msg_data OUT NOCOPY VARCHAR2 );
21
22 END CN_SCENARIOS_PVT;