DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on FND_API

Line 250: IF X_Comp_Plan_Id IS NULL OR X_Comp_Plan_Id = CN_API.G_MISS_ID OR X_Comp_Plan_Id = FND_API.G_MISS_NUM THEN

246: -- Get_Uid
247: -------------------------------------------------------------------------++
248: PROCEDURE Get_Uid ( X_Comp_Plan_Id IN OUT NOCOPY NUMBER ) IS
249: BEGIN
250: IF X_Comp_Plan_Id IS NULL OR X_Comp_Plan_Id = CN_API.G_MISS_ID OR X_Comp_Plan_Id = FND_API.G_MISS_NUM THEN
251: SELECT cn_comp_plans_s.nextval
252: INTO x_comp_plan_id
253: FROM sys.dual;
254: END IF;

Line 602: decode(x_start_date , nvl(x_start_date_old,fnd_api.g_miss_date),

598: attribute14 = x_attribute14,
599: attribute15 = x_attribute15,
600: object_version_number = object_version_number + 1,
601: status_code =
602: decode(x_start_date , nvl(x_start_date_old,fnd_api.g_miss_date),
603: decode(x_end_date, nvl(x_end_date_old,fnd_api.g_miss_date),
604: decode(x_allow_rev_class_overlap,
605: nvl(x_allow_rev_class_overlap_old,'X'),
606: status_code, 'INCOMPLETE'

Line 603: decode(x_end_date, nvl(x_end_date_old,fnd_api.g_miss_date),

599: attribute15 = x_attribute15,
600: object_version_number = object_version_number + 1,
601: status_code =
602: decode(x_start_date , nvl(x_start_date_old,fnd_api.g_miss_date),
603: decode(x_end_date, nvl(x_end_date_old,fnd_api.g_miss_date),
604: decode(x_allow_rev_class_overlap,
605: nvl(x_allow_rev_class_overlap_old,'X'),
606: status_code, 'INCOMPLETE'
607: ), 'INCOMPLETE'

Line 698: RAISE FND_API.G_EXC_ERROR ;

694:
695: l_okay := Check_Assigned( X_Comp_Plan_Id);
696:
697: IF not l_okay then
698: RAISE FND_API.G_EXC_ERROR ;
699: end if;
700:
701: select 1 into l_exists FROM cn_comp_plans
702: WHERE comp_plan_id = x_comp_plan_id;

Line 977: p_validation_level => fnd_api.g_valid_level_full,

973: cn_plan_element_pvt.validate_plan_element(
974: p_api_version => 1.0 ,
975: p_init_msg_list =>'F',
976: p_commit => 'F',
977: p_validation_level => fnd_api.g_valid_level_full,
978: p_comp_plan_id => x_comp_plan_id,
979: p_quota_id => quota_rec.quota_id,
980: x_status_code => x_quota_status_code ,
981: x_return_status => l_return_status,