APPS.PA_FIN_PLAN_PVT dependencies on PA_FIN_PLAN_TYPES_TL

Line 3767: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE) RETURN NUMBER IS

3763: returned
3764: */
3765:
3766: FUNCTION Fetch_Plan_Type_Id
3767: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE) RETURN NUMBER IS
3768:
3769: CURSOR l_get_plan_type_id_csr
3770: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE )
3771: IS

Line 3770: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE )

3766: FUNCTION Fetch_Plan_Type_Id
3767: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE) RETURN NUMBER IS
3768:
3769: CURSOR l_get_plan_type_id_csr
3770: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE )
3771: IS
3772: SELECT fin_plan_type_id
3773: FROM pa_fin_plan_types_vl
3774: WHERE name=p_fin_plan_type_name;

Line 3805: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

3801: */
3802:
3803: PROCEDURE convert_plan_type_name_to_id
3804: ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3805: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3806: ,x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
3807: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3808: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3809: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895