[Home] [Help]
PACKAGE: APPS.PA_FIN_PLAN_TYPES_UTILS
Source
1 PACKAGE pa_fin_plan_types_utils AUTHID CURRENT_USER 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
10
11 /****************************************************************************************
12 * Dusan changes. Moved this api to pa_fin_plan_utils
13 procedure end_date_active_val
14 (p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
15 p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
16 x_return_status OUT VARCHAR2,
17 x_msg_count OUT NUMBER,
18 x_msg_data OUT VARCHAR2);
19 *****************************************************************************************/
20
21 /***********************************************************************
22 Commented since generated_flag and used_in_billing_flag
23 are obsolete after change in functionality
24
25 procedure generated_flag_val
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
35 procedure used_in_billing_flag_val
36 (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
37 p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
38 x_return_status OUT VARCHAR2,
39 x_msg_count OUT NUMBER,
40 x_msg_data OUT VARCHAR2);
41
42 **************************************************************************/
43 procedure delete_val
44 (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
45 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
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,
56 p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,
57 p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
58 p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
59 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
61 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
62
63 function isfptypeused
64 (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type)
65 return VARCHAR2;
66
67 /* FP M - dbora Additional FUNCTIONS and PROCEDURE
68 */
69 FUNCTION PARTIALLY_IMPL_COS_EXIST
70 (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
71 p_ci_type_id IN pa_control_items.ci_type_id%TYPE )
72 RETURN VARCHAR2;
73
74 FUNCTION GET_CONCAT_STATUSES
75 (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
76 p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
77 p_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE)
78 RETURN VARCHAR2;
79
80 PROCEDURE GET_WORKPLAN_PT_DETAILS
81 (x_workplan_pt_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
82 x_w_pt_attached_to_proj OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
83 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
84 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
85 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
86
87 FUNCTION Is_Rev_Impl_Partially
88 (p_ci_id IN pa_budget_versions.ci_id%TYPE,
89 p_project_id IN pa_budget_versions.project_id%TYPE)
90 RETURN VARCHAR2;
91
92 END pa_fin_plan_types_utils;