DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_TYPES_UTILS dependencies on PA_FIN_PLAN_TYPES_TL

Line 5: (p_name IN pa_fin_plan_types_tl.name%TYPE,

1: PACKAGE pa_fin_plan_types_utils as
2: /* $Header: PAFTYPUS.pls 120.1 2005/08/19 16:32:33 mwasowic noship $ */
3:
4: procedure name_val
5: (p_name IN pa_fin_plan_types_tl.name%TYPE,
6: p_fin_plan_type_id IN pa_fin_plan_types_tl.fin_plan_type_id%TYPE,
7: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 6: p_fin_plan_type_id IN pa_fin_plan_types_tl.fin_plan_type_id%TYPE,

2: /* $Header: PAFTYPUS.pls 120.1 2005/08/19 16:32:33 mwasowic noship $ */
3:
4: procedure name_val
5: (p_name IN pa_fin_plan_types_tl.name%TYPE,
6: p_fin_plan_type_id IN pa_fin_plan_types_tl.fin_plan_type_id%TYPE,
7: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
10:

Line 30: p_name IN pa_fin_plan_types_tl.name%type,

26: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
27: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
28: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
29: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
30: p_name IN pa_fin_plan_types_tl.name%type,
31: x_return_status OUT VARCHAR2,
32: x_msg_count OUT NUMBER,
33: x_msg_data OUT VARCHAR2);
34:

Line 51: p_name IN pa_fin_plan_types_tl.name%type,

47: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
48:
49: procedure validate
50: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
51: p_name IN pa_fin_plan_types_tl.name%type,
52: p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,