[Home] [Help]
PACKAGE: APPS.PJI_PJP_PRG_PERF_ALL
Source
1 PACKAGE PJI_PJP_PRG_PERF_ALL AUTHID CURRENT_USER AS
2 /* $Header: PJIPRG1S.pls 120.0.12020000.2 2012/07/18 10:55:26 admarath ship $ */
3
4 PROCEDURE CREATE_FP_ENT_ROLLUP;
5 PROCEDURE CREATE_FP_PA_PRI_ROLLUP;
6 PROCEDURE CREATE_FP_GL_PRI_ROLLUP;
7 PROCEDURE CREATE_FP_ALL_T_PRI_ROLLUP (p_calendar_type IN VARCHAR2 := 'G');
8 PROCEDURE PRORATE_TO_ENT_PG_PJP1_D;
9 PROCEDURE PRORATE_TO_ENT_N_PJP1_D;
10 PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_D(p_calendar_type IN VARCHAR2 := NULL);
11 PROCEDURE PRORATE_TO_PAGL_N_PJP1_D(p_calendar_type IN VARCHAR2 := NULL);
12 PROCEDURE INSERT_INTO_FP_FACT;
13 PROCEDURE GET_GLOBAL_EXCHANGE_RATES;
14 PROCEDURE PRORATE_TO_ENT;
15 PROCEDURE POPULATE_RBS_HDR;
16 PROCEDURE UPDATE_WBS_HDR;
17 PROCEDURE EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
18 PROCEDURE EXTRACT_DANGL_REVERSAL;
19 PROCEDURE UPDATE_WBS_HDR_1;
20 PROCEDURE MERGE_INTO_FP_FACTS;
21 PROCEDURE UPDATE_BATCH_CONC_STATUS;
22 PROCEDURE REMAP_RBS_TXN_ACCUM_HDRS (
23 x_return_status OUT NOCOPY VARCHAR2
24 ,x_msg_data OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER );
26 procedure AGGREGATE_FP_CUST_SLICES (p_worker_id in number);
27 procedure ROLLUP_FPR_WBS (p_worker_id in number default null);
28 procedure PURGE_PLAN_DATA (p_worker_id in number);
29 function NEED_TO_RUN_STEP(p_process in varchar2,p_step in varchar2) return boolean;
30 procedure REGISTER_STEP_COMPLETION(p_process in varchar2,p_step in varchar2);
31 procedure WRAPUP_PROCESS (p_process in varchar2);
32 procedure EXECUTE_ROLLUP_FPR_WBS (p_worker_id in number default null,
33 p_level in number default null,
34 p_partial_mode in varchar2,
35 p_fpm_upgrade in varchar2);
36 procedure EXECUTE_AGGREGATE_PLAN_DATA (p_worker_id in number default null);
37 PROCEDURE GATHER_TEMP_STATS (p_ownname IN VARCHAR2
38 ,p_tabname IN VARCHAR2
39 ,p_partname IN VARCHAR2 DEFAULT NULL
40 ,p_percent IN NUMBER DEFAULT 10);
41
42 END PJI_PJP_PRG_PERF_ALL;