[Home] [Help]
PACKAGE: APPS.PJI_FM_PLAN_MAINT_T_PVT
Source
1 PACKAGE PJI_FM_PLAN_MAINT_T_PVT AUTHID CURRENT_USER AS
2 /* $Header: PJIPP03S.pls 120.0 2005/05/29 12:20:10 appldev noship $ */
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 ----------------------------------------------
22 --- Copy apis
23 ----------------------------------------------
24
25 PROCEDURE COPY_PRIMARY(
26 p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
27 , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
28 , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
29 , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
30 , p_commit IN VARCHAR2 := 'F'
31 );
32
33
34 PROCEDURE COPY_PLANS(
35 p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
36 , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
37 , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
38 , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
39 , p_commit IN VARCHAR2 := 'F'
40 );
41
42
43 PROCEDURE COPY_PRIMARY_SINGLE
44 (
45 p_source_plan_ver_id IN NUMBER := NULL
46 , p_target_plan_ver_id IN NUMBER := NULL
47 , p_commit IN VARCHAR2 := 'F');
48
49
50 ----------------------------------------------
51 --- Extract apis
52 ----------------------------------------------
53
54 PROCEDURE EXTRACT_FIN_PLAN_VERS_BULK(
55 p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC'
56 );
57
58 PROCEDURE EXTRACT_FIN_PLAN_VERSIONS(
59 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
60 , p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC'
61 );
62
63 PROCEDURE EXTRACT_CB_CO_PLAN_VERSIONS;
64
65 PROCEDURE EXTRACT_PLAN_AMOUNTS_PRIRBS;
66
67 PROCEDURE EXTRACT_PLAN_AMOUNTS_SECRBS;
68
69 PROCEDURE EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
70
71 PROCEDURE EXTRACT_PLAN_AMTS_SECRBS_GLC12;
72
73 PROCEDURE REVERSE_PLAN_AMTS;
74
75
76 ----------------------------------------------
77 --- FP Time, WBS, RBS, Program, etc Rollup apis
78 ----------------------------------------------
79
80 PROCEDURE CREATE_WBSRLP; -- WBS, Program rollups.
81
82 PROCEDURE ROLLUP_FPR_RBS; -- Renamed.. ROLLUP_XBS_AFTER_WBSRLP; -- RBS, Program rollups.
83
84 PROCEDURE ROLLUP_FPR_RBS_T_SLICE;
85
86 ----------------------------------------------
87 --- Handling non-time phased amounts
88 ----------------------------------------------
89
90 PROCEDURE DELETE_PRI_NONTIMEPH_ENTDAMTS;
91
92 -- PROCEDURE RETRIEVE_BL_SECSLC_NONTIMEPH;
93
94 -- PROCEDURE RETRIEVE_RL_SECSLC_TIMEPH;
95
96
97 ----------------------------------------------
98 --- FP Insert/Merge apis
99 ----------------------------------------------
100
101 PROCEDURE INSERT_INTO_FP_FACT (p_slice_type IN VARCHAR2 := NULL);
102
103 PROCEDURE MERGE_INTO_FP_FACT;
104
105 PROCEDURE GET_FP_ROW_IDS;
106
107 PROCEDURE UPDATE_FP_ROWS;
108
109 PROCEDURE INSERT_FP_ROWS;
110
111
112 ----------------------------------------------
113 --- AC Insert/Merge apis
114 ----------------------------------------------
115
116 PROCEDURE INSERT_INTO_AC_FACT;
117
118 PROCEDURE MERGE_INTO_AC_FACT;
119
120 PROCEDURE GET_AC_ROW_IDS;
121
122 PROCEDURE UPDATE_AC_ROWS;
123
124 PROCEDURE INSERT_AC_ROWS;
125
126
127 ----------------------------------------------
128 --- Handling deltas in budget line entries
129 ----------------------------------------------
130
131 PROCEDURE RETRIEVE_DELTA_SLICE;
132
133 PROCEDURE POPULATE_PLN_VER_TABLE;
134
135
136 ----------------------------------------------
137 --- Misc extraction/secondary creation helper apis
138 ----------------------------------------------
139
140 PROCEDURE GET_PRI_SLICE_DATA(
141 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
142 , p_commit IN VARCHAR2 := 'F');
143
144 PROCEDURE GET_GLOBAL_EXCHANGE_RATES;
145
146 PROCEDURE DELETE_GLOBAL_EXCHANGE_RATES;
147
148 -- PROCEDURE CONV_TO_GLOBAL_CURRENCIES;
149 -- PROCEDURE UPDATE_CURR_RCD_TYPES_GL1_GL2;
150
151 PROCEDURE DO_CURRENCY_DANGLING_CHECK;
152
153 -- PROCEDURE CREATE_GL1_GL2_CURR_RCDS;
154 -- PROCEDURE AGGREGATE ;
155
156
157 ----------------------------------------------
158 --- Prorate apis
159 ----------------------------------------------
160
161 PROCEDURE GET_PRORATE_FORMAT;
162
163 PROCEDURE GET_SPREAD_DATE_RANGE_AMOUNTS;
164
165 PROCEDURE SPREAD_NON_TIME_PHASE_AMOUNTS;
166
167 PROCEDURE PRORATE_NON_TIME_PHASED_AMTS(
168 p_calENDar_type IN VARCHAR2 := NULL -- Values can be GL, PA, ENT, ENTW.
169 );
170
171 PROCEDURE PRORATE_TO_OTHER_CALENDAR(
172 p_calENDar_type IN VARCHAR2 := NULL -- Values can be GL, PA, ENT, ENTW.
173 );
174
175 PROCEDURE PRORATE_TO_ALL_CALENDARS;
176
177 -- PROCEDURE PRORATE_TO_PA;
178 -- PROCEDURE PRORATE_TO_GL;
179
180 PROCEDURE PRORATE_TO_ENT;
181
182 PROCEDURE PRORATE(
183 p_calENDar_type IN VARCHAR2 := NULL -- Values can be GL, PA, ENT, ENTW.
184 );
185
186
187 ----------------------------------------------
188 --- Dangling check/pull apis
189 ----------------------------------------------
190
191 PROCEDURE MARK_EXTRACTED_PLANS(p_slice_type IN VARCHAR2);
192
193 PROCEDURE MARK_TIME_DANGLING_VERSIONS;
194
195 PROCEDURE MARK_DANGLING_PLAN_VERSIONS;
196
197 PROCEDURE DELETE_DNGLRATE_PLNVER_DATA;
198
199 PROCEDURE PULL_DANGLING_PLANS;
200
201
202 ----------------------------------------------
203 --- RBS update apis
204 ----------------------------------------------
205
206 PROCEDURE RETRIEVE_ENTERED_SLICE (
207 p_pln_ver_id IN NUMBER := NULL ) ;
208
209
210 ----------------------------------------------
211 --- XBS update apis
212 ----------------------------------------------
213
214 PROCEDURE COMPUTE_XBS_UPDATED_ROLLUPS;
215
216
217
218 ----------------------------------------------
219 ----- Populate WBS, RBS header tables... -----
220 ----------------------------------------------
221
222 PROCEDURE POPULATE_RBS_HDR;
223
224 PROCEDURE POPULATE_WBS_HDR;
225
226 PROCEDURE UPDATE_WBS_HDR;
227
228
229 ------------------------------------------------------------------------
230 --- Misc apis needed to do clean up of interim tables, etc.
231 ------------------------------------------------------------------------
232
233 PROCEDURE CLEANUP_INTERIM_TABLES;
234
235 PROCEDURE GET_ACTUALS (
236 p_new_pub_version_id IN NUMBER
237 , p_prev_pub_version_id IN NUMBER := NULL ) ;
238
239 PROCEDURE REVERSE_ETC (
240 p_new_pub_version_id IN NUMBER
241 , p_prev_pub_version_id IN NUMBER := NULL ) ;
242
243 PROCEDURE UPDATE_ACTUALS_TO_NULL;
244
245 PROCEDURE MAP_ORG_CAL_INFO ( p_fpm_upgrade IN VARCHAR2 := 'Y');
246
247
248 END PJI_FM_PLAN_MAINT_T_PVT;