[Home] [Help]
PACKAGE: APPS.PJI_FM_PLAN_MAINT_PVT
Source
1 PACKAGE PJI_FM_PLAN_MAINT_PVT AS
2 /* $Header: PJIPP02S.pls 120.5.12000000.2 2007/10/23 12:34:55 csriperu ship $ */
3
4
5 --
6 -- This line is for reference only: pji_empty_num_tbl is a sql type
7 -- of nested table of numbers. Source: $PA_TOP/.../par1tt20.sql
8 --
9 pji_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10 pji_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
11
12
13
14 ------------------------------------------------------------------
15 ------------------------------------------------------------------
16 -- Helper Apis Declaration --
17 ------------------------------------------------------------------
18 ------------------------------------------------------------------
19
20 ----------------------------------------------
21 --- Extract apis
22 ----------------------------------------------
23
24 PROCEDURE VALIDATE_SET_PR_PARAMS(
25 p_rbs_version_id IN NUMBER
26 , p_plan_type_id IN NUMBER
27 , p_context IN VARCHAR2 -- Valid values are 'RBS' or 'PLANTYPE'.
28 , x_num_rows OUT NOCOPY NUMBER
29 , x_return_status OUT NOCOPY VARCHAR2
30 , x_msg_code OUT NOCOPY VARCHAR2 );
31
32 PROCEDURE OBTAIN_RELEASE_LOCKS (
33 p_context IN VARCHAR2
34 , p_lock_mode IN VARCHAR2
35 , x_return_status OUT NOCOPY VARCHAR2
36 , x_msg_code OUT NOCOPY VARCHAR2 );
37
38 PROCEDURE EXTRACT_FIN_PLAN_VERS_BULK(
39 p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC'
40 );
41
42 PROCEDURE EXTRACT_FIN_PLAN_VERSIONS(
43 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
44 , p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC'
45 );
46
47 PROCEDURE EXTRACT_PLAN_AMOUNTS_PRIRBS;
48
49 PROCEDURE EXTRACT_PLAN_AMTS_PRIRBS_GLC12
50 (p_pull_dangling_flag IN VARCHAR2 := 'Y'); -- Reversals to be computed only if pull_dangling flag is 'Y'
51
52 PROCEDURE EXTRACT_PLAN_AMTS_SECRBS_GLC12
53 (p_pull_dangling_flag IN VARCHAR2 := 'Y'); -- Reversals to be computed only if pull_dangling flag is 'Y'
54
55 PROCEDURE EXTRACT_DANGL_REVERSAL;
56
57 PROCEDURE EXTRACT_ACTUALS(
58 p_extrn_type IN VARCHAR2 := NULL -- 'FULL' or 'INCR'
59 );
60
61
62 PROCEDURE PROCESS_PENDING_PLAN_UPDATES(
63 p_extrn_type IN VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67
68 ----------------------------------------------
69 --- Overridden ETC Pull apis.
70 ----------------------------------------------
71
72 PROCEDURE RETRIEVE_OVERRIDDEN_WP_ETC;
73
74 PROCEDURE EXTRACT_PLAN_ETC_PRIRBS(
75 p_slice_type IN VARCHAR2 := 'PRI' -- 'PRI' or 'SEC'
76 );
77
78 PROCEDURE DELETE_PLAN_LINES ( x_return_status OUT NOCOPY VARCHAR2 ) ;
79
80
81 ----------------------------------------------
82 --- FP Time, WBS, RBS, Program, etc Rollup apis
83 ----------------------------------------------
84
85 PROCEDURE CREATE_WBSRLP; -- WBS, Program rollups.
86
87 PROCEDURE ROLLUP_FPR_RBS; -- Renamed.. ROLLUP_XBS_AFTER_WBSRLP; -- RBS, Program rollups.
88
89 PROCEDURE ROLLUP_FPR_RBS_T_SLICE;
90
91
92 ----------------------------------------------
93 --- FP Insert/Merge apis
94 ----------------------------------------------
95
96 PROCEDURE INSERT_INTO_FP_FACT (p_slice_type IN VARCHAR2 := NULL);
97
98 PROCEDURE MERGE_INTO_FP_FACT;
99
100 PROCEDURE CLEANUP_FP_RMAP_FPR;
101
102 PROCEDURE GET_FP_ROW_IDS;
103
104 PROCEDURE UPDATE_FP_ROWS;
105
106 PROCEDURE INSERT_FP_ROWS;
107
108
109 ----------------------------------------------
110 --- AC Insert/Merge apis
111 ----------------------------------------------
112
113 PROCEDURE INSERT_INTO_AC_FACT;
114
115 PROCEDURE MERGE_INTO_AC_FACT;
116
117 PROCEDURE CLEANUP_AC_RMAP_FPR;
118
119 PROCEDURE GET_AC_ROW_IDS;
120
121 PROCEDURE UPDATE_AC_ROWS;
122
123 PROCEDURE INSERT_AC_ROWS;
124
125
126 PROCEDURE DELETE_GLOBAL_EXCHANGE_RATES;
127
128 ----------------------------------------------
129 --- Handling deltas in budget line entries
130 ----------------------------------------------
131
132 -- PROCEDURE RETRIEVE_DELTA_SLICE;
133
134 PROCEDURE POPULATE_PLN_VER_TABLE;
135
136
137 ----------------------------------------------
138 --- Misc extraction/secondary creation helper apis
139 ----------------------------------------------
140
141 PROCEDURE GET_PRI_SLICE_DATA(
142 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
143 , p_commit IN VARCHAR2 := 'F');
144
145 PROCEDURE GET_GLOBAL_EXCHANGE_RATES;
146
147 PROCEDURE CONV_TO_GLOBAL_CURRENCIES;
148
149
150
151 ----------------------------------------------
152 --- Prorate apis
153 ----------------------------------------------
154
155 PROCEDURE GET_PRORATE_FORMAT;
156
157 PROCEDURE GET_SPREAD_DATE_RANGE_AMOUNTS;
158
159 PROCEDURE SPREAD_NON_TIME_PHASE_AMOUNTS;
160
161
162 PROCEDURE PRORATE_TO_OTHER_CALENDAR(
163 p_calENDar_type IN VARCHAR2 := NULL -- Values can be GL, PA, ENT, ENTW.
164 );
165
166 PROCEDURE PRORATE_TO_ALL_CALENDARS;
167
168 PROCEDURE PRORATE_TO_PA;
169
170 PROCEDURE PRORATE_TO_GL;
171
172 PROCEDURE PRORATE_TO_ENT;
173
174 PROCEDURE PRORATE(
175 p_calENDar_type IN VARCHAR2 := NULL -- Values can be GL, PA, ENT, ENTW.
176 );
177
178
179 ----------------------------------------------
180 --- Dangling check/pull apis
181 ----------------------------------------------
182
183 PROCEDURE MARK_EXTRACTED_PLANS(p_slice_type IN VARCHAR2);
184
185
186 PROCEDURE MARK_DANGLING_PLAN_VERSIONS;
187
188 PROCEDURE DELETE_DNGLRATE_PLNVER_DATA;
189
190 PROCEDURE PULL_DANGLING_PLANS;
191
192
193 ----------------------------------------------
194 --- RBS update apis
195 ----------------------------------------------
196
197 PROCEDURE RETRIEVE_ENTERED_SLICE (
198 p_pln_ver_id IN NUMBER := NULL ) ;
199
200
201 ----------------------------------------------
202 --- XBS update apis
203 ----------------------------------------------
204
205 PROCEDURE COMPUTE_XBS_UPDATED_ROLLUPS;
206
207
208
209 ----------------------------------------------
210 ----- Populate WBS, RBS header tables... -----
211 ----------------------------------------------
212
213 PROCEDURE POPULATE_RBS_HDR;
214
215 PROCEDURE POPULATE_WBS_HDR;
216
217 PROCEDURE UPDATE_WBS_HDR;
218
219
220
221 ------------------------------------------------------------------------
222 --- Misc apis needed to do clean up of interim tables, etc.
223 ------------------------------------------------------------------------
224
225 PROCEDURE CLEANUP_INTERIM_TABLES;
226
227 -- Bug 6520936
228 PROCEDURE UPDATE_WBS_HDR (p_worker_id in number);
229
230 PROCEDURE MERGE_INTO_FP_FACTS;
231 -- Bug 6520936
232
233 END PJI_FM_PLAN_MAINT_PVT;