[Home] [Help]
PACKAGE: APPS.PA_PRJ_PERIOD_PROFILE_UTILS
Source
1 PACKAGE Pa_Prj_Period_Profile_Utils AS
2 /* $Header: PAPJPDPS.pls 120.1 2005/08/19 16:41:13 mwasowic noship $ */
3
4 Procedure Maintain_Prj_Period_Profile(
5 p_project_id IN NUMBER,
6 p_period_profile_type IN VARCHAR2,
7 p_plan_period_type IN VARCHAR2,
8 p_period_set_name IN VARCHAR2,
9 p_gl_period_type IN VARCHAR2,
10 p_pa_period_type IN VARCHAR2,
11 p_start_date IN DATE,
12 px_end_date IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
13 px_period_profile_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
14 p_commit_flag IN VARCHAR2 DEFAULT 'N',
15 px_number_of_periods IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
16 p_debug_mode IN VARCHAR2 DEFAULT 'N',
17 p_add_msg_in_stack IN VARCHAR2 DEFAULT 'N',
18 x_plan_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
19 x_plan_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
20 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
23
24
25 Procedure Get_Prj_Period_Profile_Dtls(
26 p_period_profile_id IN NUMBER,
27 p_debug_mode IN VARCHAR2 DEFAULT 'N',
28 p_add_msg_in_stack IN VARCHAR2 DEFAULT 'N',
29 x_period_profile_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
30 x_plan_period_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
31 x_period_set_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32 x_gl_period_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
33 x_plan_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
34 x_plan_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
35 x_number_of_periods OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
36 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
37 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
38 procedure Get_Date_details(
39 p_project_id IN NUMBER,
40 p_period_name IN VARCHAR2,
41 p_plan_period_type IN VARCHAR2,
42 x_start_date OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43 x_end_date OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
44
45 Procedure Maintain_Prj_Profile_wrp(
46 p_project_id IN NUMBER,
47 p_period_profile_type IN VARCHAR2,
48 p_pa_start_date IN DATE DEFAULT NULL,
49 px_pa_end_date IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
50 px_pa_period_profile_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
51 p_commit_flag IN VARCHAR2 DEFAULT 'N',
52 px_pa_number_of_periods IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53 p_debug_mode IN VARCHAR2 DEFAULT 'N',
54 p_add_msg_in_stack IN VARCHAR2 DEFAULT 'N',
55 x_pa_plan_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
56 x_pa_plan_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
57 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60 p_pa_start_period IN VARCHAR2 DEFAULT NULL,
61 p_pa_end_period IN VARCHAR2 DEFAULT NULL,
62 p_gl_start_period IN VARCHAR2 DEFAULT NULL,
63 p_gl_end_period IN VARCHAR2 DEFAULT NULL,
64 p_gl_start_date IN DATE DEFAULT NULL,
65 px_gl_end_date IN OUT NOCOPY DATE , --File.Sql.39 bug 4440895
66 px_gl_period_profile_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
67 px_gl_number_of_periods IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
68 p_old_pa_profile_id IN NUMBER ,
69 p_old_gl_profile_id IN NUMBER,
70 p_refresh_option_code IN VARCHAR2 DEFAULT 'NONE',
71 x_conc_req_id OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
72
73
74 Procedure Get_Prj_Defaults( p_project_id IN NUMBER,
75 p_info_flag IN VARCHAR2,
76 p_create_defaults IN VARCHAR2, --Y or N
77 x_gl_start_period OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
78 x_gl_end_period OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79 x_gl_start_Date OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
80 x_pa_start_period OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
81 x_pa_end_period OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
82 x_pa_start_date OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
83 x_plan_version_exists_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
84 x_prj_start_date OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
85 x_prj_end_date OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
86 );
87
88 Procedure Get_Curr_Period_Profile_Info(
89 p_project_id IN VARCHAR2
90 ,p_period_type IN VARCHAR2
91 ,p_period_profile_type IN VARCHAR2
92 ,x_period_profile_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
93 ,x_start_period OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
94 ,x_end_period OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
97 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
98
99 PROCEDURE Refresh_Period_Profile
100 (
101 p_budget_version_id IN NUMBER,
102 p_period_profile_id IN NUMBER,
103 p_project_id IN NUMBER,
104 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
105 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
106 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
107 );
108
109 PROCEDURE Wrapper_Refresh_Pd_Profile
110 (
111 errbuff OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
112 retcode OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
113 p_budget_version_id1 IN NUMBER DEFAULT NULL,
114 p_budget_version_id2 IN NUMBER DEFAULT NULL,
115 p_project_id IN NUMBER DEFAULT NULL,
116 p_refresh_option_code IN VARCHAR2 DEFAULT NULL,
117 p_gl_period_profile_id IN NUMBER DEFAULT NULL,
118 p_pa_period_profile_id IN NUMBER DEFAULT NULL,
119 p_debug_mode IN VARCHAR2 DEFAULT 'N'
120 ) ;
121
122 procedure get_current_period_info
123 (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
124 x_cur_period_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
125 x_cur_period_name OUT NOCOPY pa_proj_period_profiles.period_name1%TYPE, --File.Sql.39 bug 4440895
126 x_cur_period_start_date OUT NOCOPY pa_proj_period_profiles.period1_start_date%TYPE, --File.Sql.39 bug 4440895
127 x_cur_period_end_date OUT NOCOPY pa_proj_period_profiles.period1_end_date%TYPE, --File.Sql.39 bug 4440895
128 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
129 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
130 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
131
132 function has_preceding_periods
133 (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) RETURN VARCHAR2;
134
135 function has_succeeding_periods
136 (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) RETURN VARCHAR2;
137
138 PROCEDURE UPDATE_BUDGET_VERSION(p_budget_version_id IN NUMBER,
139 p_return_status IN VARCHAR2,
140 p_project_id IN NUMBER,
141 p_request_id IN NUMBER );
142 end Pa_Prj_Period_Profile_Utils;