APPS.PA_FIN_PLAN_PVT dependencies on PA_FIN_PLAN_TYPES_TL

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

3724: returned
3725: */
3726:
3727: FUNCTION Fetch_Plan_Type_Id
3728: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE) RETURN NUMBER IS
3729:
3730: CURSOR l_get_plan_type_id_csr
3731: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE )
3732: IS

Line 3731: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE )

3727: FUNCTION Fetch_Plan_Type_Id
3728: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE) RETURN NUMBER IS
3729:
3730: CURSOR l_get_plan_type_id_csr
3731: (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE )
3732: IS
3733: SELECT fin_plan_type_id
3734: FROM pa_fin_plan_types_vl
3735: WHERE name=p_fin_plan_type_name;

Line 3766: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

3762: */
3763:
3764: PROCEDURE convert_plan_type_name_to_id
3765: ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3766: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3767: ,x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
3768: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3769: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3770: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895