eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PJI_FM_PLAN_MAINT_T_PVT

Source


1 PACKAGE PJI_FM_PLAN_MAINT_T_PVT 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;