APPS.CN_SCENARIOS_PVT dependencies on CN_SCENARIO_PLANS_ALL

Line 11: p_role_plan_id IN CN_SCENARIO_PLANS_ALL.ROLE_PLAN_ID%TYPE := NULL,

7: (p_api_version IN NUMBER ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_role_plan_id IN CN_SCENARIO_PLANS_ALL.ROLE_PLAN_ID%TYPE := NULL,
12: p_comp_plan_id IN CN_SCENARIO_PLANS_ALL.COMP_PLAN_ID%TYPE := NULL,
13: p_role_id IN CN_SCENARIO_PLANS_ALL.ROLE_ID%TYPE := NULL,
14: x_return_status OUT NOCOPY VARCHAR2 ,
15: x_msg_count OUT NOCOPY NUMBER ,

Line 12: p_comp_plan_id IN CN_SCENARIO_PLANS_ALL.COMP_PLAN_ID%TYPE := NULL,

8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_role_plan_id IN CN_SCENARIO_PLANS_ALL.ROLE_PLAN_ID%TYPE := NULL,
12: p_comp_plan_id IN CN_SCENARIO_PLANS_ALL.COMP_PLAN_ID%TYPE := NULL,
13: p_role_id IN CN_SCENARIO_PLANS_ALL.ROLE_ID%TYPE := NULL,
14: x_return_status OUT NOCOPY VARCHAR2 ,
15: x_msg_count OUT NOCOPY NUMBER ,
16: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 13: p_role_id IN CN_SCENARIO_PLANS_ALL.ROLE_ID%TYPE := NULL,

9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_role_plan_id IN CN_SCENARIO_PLANS_ALL.ROLE_PLAN_ID%TYPE := NULL,
12: p_comp_plan_id IN CN_SCENARIO_PLANS_ALL.COMP_PLAN_ID%TYPE := NULL,
13: p_role_id IN CN_SCENARIO_PLANS_ALL.ROLE_ID%TYPE := NULL,
14: x_return_status OUT NOCOPY VARCHAR2 ,
15: x_msg_count OUT NOCOPY NUMBER ,
16: x_msg_data OUT NOCOPY VARCHAR2 ) IS
17:

Line 41: delete from cn_scenario_plans_all where role_plan_id = p_role_plan_id;

37: -- Initialize API return status to success
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: IF p_role_plan_id is not null then
41: delete from cn_scenario_plans_all where role_plan_id = p_role_plan_id;
42: end if;
43:
44:
45: IF p_role_id is not null then

Line 46: delete from cn_scenario_plans_all where role_id = p_role_id;

42: end if;
43:
44:
45: IF p_role_id is not null then
46: delete from cn_scenario_plans_all where role_id = p_role_id;
47: end if;
48:
49:
50: IF p_comp_plan_id is not null then

Line 51: delete from cn_scenario_plans_all where comp_plan_id = p_comp_plan_id;

47: end if;
48:
49:
50: IF p_comp_plan_id is not null then
51: delete from cn_scenario_plans_all where comp_plan_id = p_comp_plan_id;
52: end if;
53:
54: -- End of API body.
55: