1 PACKAGE Pji_Setup_Pkg AS
2 /* $Header: PJIUT04S.pls 120.2 2005/12/06 18:03:03 appldev noship $ */
3
4
5 PROCEDURE pji_sys_settings_update_row (p_organization_structure IN VARCHAR2,
6 p_org_structure_version IN VARCHAR2,
7 p_dflt_prjpip_period_type IN VARCHAR2,
8 p_dflt_prjpip_as_of_date IN VARCHAR2,
9 p_dflt_prjpip_cycle IN VARCHAR2,
10 p_dflt_prjbab_period_type IN VARCHAR2,
11 p_dflt_prjbab_as_of_date IN VARCHAR2,
12 p_dflt_prjbab_cycle IN VARCHAR2,
13 p_dflt_resutl_period_type IN VARCHAR2,
14 p_dflt_resutl_as_of_date IN VARCHAR2,
15 p_dflt_resutl_cycle IN VARCHAR2,
16 p_dflt_resavl_period_type IN VARCHAR2,
17 p_dflt_resavl_as_of_date IN VARCHAR2,
18 p_dflt_resavl_cycle IN VARCHAR2,
19 p_dflt_respln_period_type IN VARCHAR2,
20 p_dflt_respln_as_of_date IN VARCHAR2,
21 p_dflt_respln_cycle IN VARCHAR2,
22 p_dflt_prjhlt_period_type IN VARCHAR2,
23 p_dflt_prjhlt_as_of_date IN VARCHAR2,
24 p_dflt_prjhlt_cycle IN VARCHAR2,
25 p_dflt_prjact_period_type IN VARCHAR2,
26 p_dflt_prjact_as_of_date IN VARCHAR2,
27 p_dflt_prjact_cycle IN VARCHAR2,
28 p_dflt_prjprf_period_type IN VARCHAR2,
29 p_dflt_prjprf_as_of_date IN VARCHAR2,
30 p_dflt_prjprf_cycle IN VARCHAR2,
31 p_dflt_prjcst_period_type IN VARCHAR2,
32 p_dflt_prjcst_as_of_date IN VARCHAR2,
33 p_dflt_prjcst_cycle IN VARCHAR2,
34 p_pa_period_flag IN VARCHAR2,
35 p_gl_period_flag IN VARCHAR2,
36 p_conversion_ratio_days IN NUMBER,
37 p_book_to_bill_days IN NUMBER,
38 p_dso_days IN NUMBER,
39 p_dormant_backlog_days IN NUMBER,
40 p_cost_budget_type IN VARCHAR2,
41 p_cost_budget_conv_rule IN VARCHAR2,
42 p_revenue_budget_type IN VARCHAR2,
43 p_revenue_budget_conv_rule IN VARCHAR2,
44 p_cost_forecast_type IN VARCHAR2,
45 p_cost_forecast_conv_rule IN VARCHAR2,
46 p_revenue_forecast_type IN VARCHAR2,
47 p_revenue_forecast_conv_rule IN VARCHAR2,
48 p_report_cost_type IN VARCHAR2,
49 p_report_labor_units IN VARCHAR2,
50 p_rolling_weeks IN NUMBER,
51 p_config_proj_perf_flag IN VARCHAR2,
52 p_config_cost_flag IN VARCHAR2,
53 p_config_profit_flag IN VARCHAR2,
54 p_config_util_flag IN VARCHAR2,
55 p_cost_fp_type_id IN NUMBER,
56 p_revenue_fp_type_id IN NUMBER,
57 p_cost_forecast_fp_type_id IN NUMBER,
58 p_revenue_forecast_fp_type_id IN NUMBER,
59 p_global_curr2_flag IN VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_error_message_code OUT NOCOPY VARCHAR2
62 ) ;
63
64
65 /*
66 procedure pji_mt_bsr_insert_row (p_name in VARCHAR2,
67 p_seq in NUMBER,
68 p_bucket_set_code in VARCHAR2,
69 p_default_flag in VARCHAR2,
70 p_from_value in NUMBER,
71 p_to_value in NUMBER,
72 x_return_status OUT NOCOPY varchar2,
73 x_error_message_code OUT NOCOPY varchar2
74 ) ;
75 */
76
77 PROCEDURE pji_mt_pip_update_row (p_name IN VARCHAR2,
78 p_seq IN NUMBER,
79 p_bucket_set_code IN VARCHAR2,
80 p_default_flag IN VARCHAR2,
81 p_from_value IN NUMBER,
82 p_to_value IN NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_error_message_code OUT NOCOPY VARCHAR2
85 ) ;
86
87 PROCEDURE pji_mt_dls_update_row (p_name IN VARCHAR2,
88 p_seq IN NUMBER,
89 p_bucket_set_code IN VARCHAR2,
90 p_default_flag IN VARCHAR2,
91 p_from_value IN NUMBER,
92 p_to_value IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_error_message_code OUT NOCOPY VARCHAR2
95 ) ;
96
97 PROCEDURE pji_mt_res_avl_dur_update_row(p_name IN VARCHAR2,
98 p_seq IN NUMBER,
99 p_bucket_set_code IN VARCHAR2,
100 p_default_flag IN VARCHAR2,
101 p_from_value IN NUMBER,
102 p_to_value IN NUMBER,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_error_message_code OUT NOCOPY VARCHAR2
105 ) ;
106
107 PROCEDURE pji_mt_avl_update_row (p_name IN VARCHAR2,
108 p_seq IN NUMBER,
109 p_bucket_set_code IN VARCHAR2,
110 p_default_flag IN VARCHAR2,
111 p_from_value IN NUMBER,
112 p_to_value IN NUMBER,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_error_message_code OUT NOCOPY VARCHAR2
115 ) ;
116
117 --
118 -- Procedure to validate Bucket range
119 --
120 PROCEDURE pji_validate_bucket_ranges (x_return_status OUT NOCOPY VARCHAR2,
121 x_error_message_code OUT NOCOPY VARCHAR2
122 ) ;
123
124
125 --
126 -- Procedure to create the audit records.
127 --
128 PROCEDURE pji_insert_events_log (
129 p_organization_structure_id IN NUMBER,
130 p_org_structure_version_id IN NUMBER,
131 p_dflt_prjpip_period_type IN VARCHAR2,
132 p_dflt_prjpip_as_of_date IN VARCHAR2,
133 p_dflt_prjbab_period_type IN VARCHAR2,
134 p_dflt_prjbab_as_of_date IN VARCHAR2,
135 p_dflt_resutl_period_type IN VARCHAR2,
136 p_dflt_resutl_as_of_date IN VARCHAR2,
137 p_dflt_resavl_period_type IN VARCHAR2,
138 p_dflt_resavl_as_of_date IN VARCHAR2,
139 p_dflt_respln_period_type IN VARCHAR2,
140 p_dflt_respln_as_of_date IN VARCHAR2,
141 p_dflt_prjhlt_period_type IN VARCHAR2,
142 p_dflt_prjhlt_as_of_date IN VARCHAR2,
143 p_dflt_prjact_period_type IN VARCHAR2,
144 p_dflt_prjact_as_of_date IN VARCHAR2,
145 p_dflt_prjprf_period_type IN VARCHAR2,
146 p_dflt_prjprf_as_of_date IN VARCHAR2,
147 p_dflt_prjcst_period_type IN VARCHAR2,
148 p_dflt_prjcst_as_of_date IN VARCHAR2,
149 p_pa_period_flag IN VARCHAR2,
150 p_gl_period_flag IN VARCHAR2,
151 p_conversion_ratio_days IN VARCHAR2,
152 p_book_to_bill_days IN NUMBER,
153 p_dso_days IN NUMBER,
154 p_dormant_backlog_days IN NUMBER,
155 p_cost_budget_type_code IN VARCHAR2,
156 p_cost_budget_conv_rule IN VARCHAR2,
157 p_revenue_budget_type_code IN VARCHAR2,
158 p_revenue_budget_conv_rule IN VARCHAR2,
159 p_cost_forecast_type_code IN VARCHAR2,
160 p_cost_forecast_conv_rule IN VARCHAR2,
161 p_revenue_forecast_type_code IN VARCHAR2,
162 p_revenue_forecast_conv_rule IN VARCHAR2,
163 p_report_cost_type IN VARCHAR2,
164 p_report_labor_units IN VARCHAR2,
165 p_rolling_weeks IN NUMBER,
166 p_config_proj_perf_flag IN VARCHAR2,
167 p_config_cost_flag IN VARCHAR2,
168 p_config_profit_flag IN VARCHAR2,
169 p_config_util_flag IN VARCHAR2,
170 p_cost_fp_type_id IN NUMBER,
171 p_revenue_fp_type_id IN NUMBER,
172 p_cost_forecast_fp_type_id IN NUMBER,
173 p_revenue_forecast_fp_type_id IN NUMBER,
174 p_global_curr2_flag IN VARCHAR2,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_error_message_code OUT NOCOPY VARCHAR2);
177
178 --
179 -- Procedure to validate Organization Structure
180 --
181 PROCEDURE Check_Org_structure
182 ( p_Org_structure IN VARCHAR2
183 ,x_Org_structure_id OUT NOCOPY VARCHAR2
184 ,x_return_status OUT NOCOPY VARCHAR2
185 ,x_error_message_code OUT NOCOPY VARCHAR2) ;
186
187 --
188 -- Procedure to validate Organization Structure Version
189 --
190 PROCEDURE Check_Org_structure_Version
191 ( p_Org_structure_version IN VARCHAR2
192 ,p_Org_structure_id IN NUMBER
193 ,x_Org_structure_version_id OUT NOCOPY VARCHAR2
194 ,x_return_status OUT NOCOPY VARCHAR2
195 ,x_error_message_code OUT NOCOPY VARCHAR2) ;
196
197 --
198 -- Procedure to validate Cost Budget Type
199 --
200 PROCEDURE Check_Budget_Type
201 ( p_budget_type IN VARCHAR2
202 ,p_amount_type_code IN VARCHAR2
203 ,x_budget_type_code OUT NOCOPY VARCHAR2
204 ,x_return_status OUT NOCOPY VARCHAR2
205 ,x_error_message_code OUT NOCOPY VARCHAR2) ;
206
207 PROCEDURE Derive_Summarization_Flags
208 ( x_base_summary_flag OUT NOCOPY VARCHAR2
209 ,x_intelligence_flag OUT NOCOPY VARCHAR2
210 ,x_performance_flag OUT NOCOPY VARCHAR2) ;
211
212 END Pji_Setup_Pkg;