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_PVT

Source


1 PACKAGE PJI_FM_PLAN_MAINT_PVT AUTHID CURRENT_USER AS
2 /* $Header: PJIPP02S.pls 120.8.12020000.3 2013/04/18 12:35:09 udshanmu 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   -- cbs change
13   g_res_class_flag                      VARCHAR2(1) := 'Y';
14   -- End cbs change
15 
16 
17 ------------------------------------------------------------------
18 ------------------------------------------------------------------
19 --              Helper Apis Declaration                         --
20 ------------------------------------------------------------------
21 ------------------------------------------------------------------
22 
23 ----------------------------------------------
24 --- Extract apis
25 ----------------------------------------------
26 
27 PROCEDURE VALIDATE_SET_PR_PARAMS(
28   p_rbs_version_id  IN NUMBER
29 , p_plan_type_id    IN NUMBER
30 , p_context         IN VARCHAR2      -- Valid values are 'RBS' or 'PLANTYPE'.
31 , x_num_rows        OUT NOCOPY NUMBER
32 , x_return_status   OUT NOCOPY  VARCHAR2
33 , x_msg_code        OUT NOCOPY  VARCHAR2 );
34 
35 PROCEDURE OBTAIN_RELEASE_LOCKS (
36   p_context         IN          VARCHAR2
37 , p_lock_mode       IN          VARCHAR2
38 , x_return_status   OUT NOCOPY  VARCHAR2
39 , x_msg_code        OUT NOCOPY  VARCHAR2 );
40 
41 PROCEDURE EXTRACT_FIN_PLAN_VERS_BULK(
42   p_slice_type        IN   VARCHAR2 := NULL -- 'PRI' or 'SEC'
43 );
44 
45 PROCEDURE EXTRACT_FIN_PLAN_VERSIONS(
46   p_fp_version_ids    IN   SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
47 , p_slice_type        IN   VARCHAR2 := NULL -- 'PRI' or 'SEC'
48 );
49 
50 PROCEDURE EXTRACT_PLAN_AMOUNTS_PRIRBS;
51 
52 PROCEDURE EXTRACT_PLAN_AMTS_PRIRBS_GLC12
53 (p_pull_dangling_flag IN VARCHAR2 := 'Y'); -- Reversals to be computed only if pull_dangling flag is 'Y'
54 
55 PROCEDURE EXTRACT_PLAN_AMTS_SECRBS_GLC12
56 (p_pull_dangling_flag IN VARCHAR2 := 'Y'); -- Reversals to be computed only if pull_dangling flag is 'Y'
57 
58 PROCEDURE EXTRACT_DANGL_REVERSAL;
59 
60 PROCEDURE EXTRACT_ACTUALS(
61   p_extrn_type        IN   VARCHAR2 := NULL -- 'FULL' or 'INCR'
62 );
63 
64 
65 PROCEDURE PROCESS_PENDING_PLAN_UPDATES(
66   p_extrn_type    IN         VARCHAR2,
67   x_return_status OUT NOCOPY VARCHAR2,
68   x_msg_data      OUT NOCOPY VARCHAR2);
69 
70 
71 ----------------------------------------------
72 --- Overridden ETC Pull apis.
73 ----------------------------------------------
74 
75 PROCEDURE RETRIEVE_OVERRIDDEN_WP_ETC;
76 
77 PROCEDURE EXTRACT_PLAN_ETC_PRIRBS(
78   p_slice_type      IN VARCHAR2 := 'PRI' -- 'PRI' or 'SEC'
79 );
80 
81 PROCEDURE DELETE_PLAN_LINES ( x_return_status OUT NOCOPY VARCHAR2 ) ;
82 
83 
84 ----------------------------------------------
85 --- FP Time, WBS, RBS, Program, etc Rollup apis
86 ----------------------------------------------
87 
88 PROCEDURE CREATE_WBSRLP; -- WBS, Program rollups.
89 
90 PROCEDURE ROLLUP_FPR_RBS; -- Renamed.. ROLLUP_XBS_AFTER_WBSRLP; -- RBS, Program rollups.
91 
92 PROCEDURE ROLLUP_FPR_RBS_T_SLICE;
93 
94 
95 ----------------------------------------------
96 --- FP Insert/Merge apis
97 ----------------------------------------------
98 
99 PROCEDURE INSERT_INTO_FP_FACT (p_slice_type IN VARCHAR2 := NULL);
100 
101 PROCEDURE MERGE_INTO_FP_FACT;
102 
103 PROCEDURE CLEANUP_FP_RMAP_FPR;
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 CLEANUP_AC_RMAP_FPR;
121 
122 PROCEDURE GET_AC_ROW_IDS;
123 
124 PROCEDURE UPDATE_AC_ROWS;
125 
126 PROCEDURE INSERT_AC_ROWS;
127 
128 
129 PROCEDURE DELETE_GLOBAL_EXCHANGE_RATES;
130 
131 ----------------------------------------------
132 --- Handling deltas in budget line entries
133 ----------------------------------------------
134 
135 -- PROCEDURE RETRIEVE_DELTA_SLICE;
136 
137 PROCEDURE POPULATE_PLN_VER_TABLE;
138 
139 
140 ----------------------------------------------
141 --- Misc extraction/secondary creation helper apis
142 ----------------------------------------------
143 
144 PROCEDURE GET_PRI_SLICE_DATA(
145   p_fp_version_ids    IN   SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
146 , p_commit            IN   VARCHAR2 := 'F');
147 
148 PROCEDURE GET_GLOBAL_EXCHANGE_RATES;
149 
150 PROCEDURE CONV_TO_GLOBAL_CURRENCIES;
151 
152 
153 
154 ----------------------------------------------
155 --- Prorate apis
156 ----------------------------------------------
157 
158 PROCEDURE GET_PRORATE_FORMAT;
159 
160 PROCEDURE GET_SPREAD_DATE_RANGE_AMOUNTS;
161 
162 PROCEDURE SPREAD_NON_TIME_PHASE_AMOUNTS;
163 
164 
165 PROCEDURE PRORATE_TO_OTHER_CALENDAR(
166   p_calENDar_type    IN   VARCHAR2 := NULL -- Values can be GL, PA, ENT, ENTW.
167 );
168 
169 PROCEDURE PRORATE_TO_ALL_CALENDARS;
170 
171 PROCEDURE PRORATE_TO_PA;
172 
173 PROCEDURE PRORATE_TO_GL;
174 
175 PROCEDURE PRORATE_TO_ENT;
176 
177 PROCEDURE PRORATE(
178   p_calENDar_type    IN   VARCHAR2 := NULL -- Values can be GL, PA, ENT, ENTW.
179 );
180 
181 
182 ----------------------------------------------
183 --- Dangling check/pull apis
184 ----------------------------------------------
185 
186 PROCEDURE MARK_EXTRACTED_PLANS(p_slice_type IN VARCHAR2);
187 
188 
189 PROCEDURE MARK_DANGLING_PLAN_VERSIONS;
190 
191 PROCEDURE DELETE_DNGLRATE_PLNVER_DATA;
192 
193 PROCEDURE PULL_DANGLING_PLANS;
194 
195 
196 ----------------------------------------------
197 --- RBS update apis
198 ----------------------------------------------
199 
200 PROCEDURE RETRIEVE_ENTERED_SLICE (
201   p_pln_ver_id IN NUMBER := NULL ) ;
202 
203 
204 ----------------------------------------------
205 --- XBS update apis
206 ----------------------------------------------
207 
208 PROCEDURE COMPUTE_XBS_UPDATED_ROLLUPS;
209 
210 
211 
212 ----------------------------------------------
213 ----- Populate WBS, RBS header tables... -----
214 ----------------------------------------------
215 
216 PROCEDURE POPULATE_RBS_HDR;
217 
218 PROCEDURE POPULATE_WBS_HDR;
219 
220 PROCEDURE UPDATE_WBS_HDR;
221 
222 
223 
224 ------------------------------------------------------------------------
225 --- Misc apis needed to do clean up of interim tables, etc.
226 ------------------------------------------------------------------------
227 
228 PROCEDURE CLEANUP_INTERIM_TABLES;
229 
230 -- Bug 6520936
231 PROCEDURE UPDATE_WBS_HDR (p_worker_id in number);
232 
233 PROCEDURE MERGE_INTO_FP_FACTS;
234 -- Bug 6520936
235 
236 PROCEDURE INSERT_INTO_FP_FACTS; -- Added for bug 14636607
237 
238 /* Added for bug 13866243 */
239 PROCEDURE MERGE_HELPER(errbuf     OUT NOCOPY VARCHAR2,
240                       retcode     OUT NOCOPY VARCHAR2,
241                       p_batch_id  IN number);
242 
243 -- cbs change
244 PROCEDURE SET_RES_CLASS_FLAG;
245 function GET_RES_CLASS_FLAG
246   (
247     p_budget_version_id   in NUMBER
248   ) return VARCHAR2;
249 
250 -- End cbs change
251 END PJI_FM_PLAN_MAINT_PVT;