[Home] [Help]
PACKAGE: APPS.PJI_PJP_SUM_ROLLUP
Source
1 package PJI_PJP_SUM_ROLLUP as
2 /* $Header: PJISP02S.pls 120.2.12000000.2 2007/05/04 16:46:29 sacgupta ship $ */
3
4 G_PROGRESS_COMMIT_SIZE NUMBER := 10;
5
6 procedure CREATE_EVENTS_SNAPSHOT (p_worker_id in number);
7
8 procedure PROCESS_RBS_CHANGES (p_worker_id in number);
9
10 procedure CREATE_MAPPING_RULES (p_worker_id in number);
11
12 procedure MAP_RBS_HEADERS (p_worker_id in number);
13
14 procedure UPDATE_XBS_DENORM_FULL (p_worker_id in number);
15
16 procedure LOCK_HEADERS (p_worker_id in number);
17
18 procedure UPDATE_PROGRAM_WBS (p_worker_id in number);
19
20 procedure PURGE_EVENT_DATA (p_worker_id in number);
21
22 procedure UPDATE_PROGRAM_RBS (p_worker_id in number);
23
24 procedure SET_ONLINE_CONTEXT (p_event_id in number,
25 p_project_id in number,
26 p_plan_type_id in number,
27 p_old_baselined_version in number,
28 p_new_baselined_version in number,
29 p_old_original_version in number,
30 p_new_original_version in number,
31 p_old_struct_version in number,
32 p_new_struct_version in number,
33 p_rbs_version in number default null);
34
35 procedure POPULATE_XBS_DENORM_DELTA (p_worker_id in number default null);
36
37 procedure POPULATE_RBS_DENORM_DELTA (p_worker_id in number);
38
39 procedure AGGREGATE_FP_SLICES (p_worker_id in number);
40
41 procedure AGGREGATE_AC_SLICES (p_worker_id in number);
42
43 procedure MARK_EXTRACTED_PROJECTS (p_worker_id in number);
44
45 procedure AGGREGATE_FP_CUST_SLICES (p_worker_id in number);
46
47 procedure AGGREGATE_AC_CUST_SLICES (p_worker_id in number);
48
49 procedure PULL_DANGLING_PLANS (p_worker_id in number);
50
51 procedure PULL_PLANS_FOR_PR (p_worker_id in number);
52
53 procedure PULL_PLANS_FOR_RBS (p_worker_id in number);
54
55 procedure ROLLUP_FPR_RBS_TOP (p_worker_id in number);
56
57 procedure ROLLUP_FPR_WBS (p_worker_id in number default null);
58
59 procedure ROLLUP_FPR_RBS_SMART_SLICES (p_worker_id in number default null);
60
61 procedure ROLLUP_ACR_WBS (p_worker_id in number default null);
62
63 procedure ROLLUP_FPR_PRG (p_worker_id in number);
64
65 procedure ROLLUP_ACR_PRG (p_worker_id in number);
66
67 procedure POPULATE_TIME_DIMENSION (p_worker_id in number);
68
69 procedure ROLLUP_FPR_CAL_NONTP (p_worker_id in number);
70
71 procedure ROLLUP_FPR_CAL_PA (p_worker_id in number);
72
73 procedure ROLLUP_FPR_CAL_GL (p_worker_id in number);
74
75 procedure ROLLUP_FPR_CAL_EN (p_worker_id in number);
76
77 procedure ROLLUP_FPR_CAL_ALL (p_worker_id in number);
78
79 procedure ROLLUP_ACR_CAL_PA (p_worker_id in number);
80
81 procedure ROLLUP_ACR_CAL_GL (p_worker_id in number);
82
83 procedure ROLLUP_ACR_CAL_EN (p_worker_id in number);
84
85 procedure ROLLUP_ACR_CAL_ALL (p_worker_id in number);
86
87 procedure AGGREGATE_PLAN_DATA (p_worker_id in number);
88
89 procedure PURGE_PLAN_DATA (p_worker_id in number);
90
91 procedure GET_FPR_ROWIDS (p_worker_id in number);
92
93 procedure UPDATE_FPR_ROWS (p_worker_id in number);
94
95 procedure INSERT_FPR_ROWS (p_worker_id in number);
96
97 procedure CLEANUP_FPR_ROWID_TABLE (p_worker_id in number);
98
99 procedure GET_ACR_ROWIDS (p_worker_id in number);
100
101 procedure UPDATE_ACR_ROWS (p_worker_id in number);
102
103 procedure INSERT_ACR_ROWS (p_worker_id in number);
104
105 procedure CLEANUP_ACR_ROWID_TABLE (p_worker_id in number);
106
107 procedure UPDATE_XBS_DENORM (p_worker_id in number default null);
108
109 procedure UPDATE_RBS_DENORM (p_worker_id in number default null);
110
111 procedure PROCESS_PENDING_EVENTS (p_worker_id in number);
112
113 procedure PROCESS_PENDING_PLAN_UPDATES (p_worker_id in number);
114
115 procedure GET_PLANRES_ACTUALS (p_worker_id in number);
116
117 procedure GET_TASK_ROLLUP_ACTUALS (p_worker_id in number);
118
119 procedure UNLOCK_ALL_HEADERS (p_worker_id in number);
120
121 procedure EXTRACT_FIN_PLAN_VERS_BULK (p_worker_id in number);
122
123 procedure POPULATE_WBS_HDR (p_worker_id in number);
124
125 procedure UPDATE_WBS_HDR (p_worker_id in number);
126
127 procedure POPULATE_RBS_HDR (p_worker_id in number);
128
129 procedure EXTRACT_PLAN_AMOUNTS_PRIRBS (p_worker_id in number);
130
131 procedure ROLLUP_FPR_RBS_T_SLICE (p_worker_id in number);
132
133 procedure CREATE_FP_PA_PRI_ROLLUP (p_worker_id in number);
134
135 procedure CREATE_FP_GL_PRI_ROLLUP (p_worker_id in number);
136
137 procedure CREATE_FP_ALL_PRI_ROLLUP (p_worker_id in number);
138
139 procedure INSERT_INTO_FP_FACT (p_worker_id in number);
140
141 procedure MARK_EXTRACTED_PLANS (p_worker_id in number);
142
143 procedure REMAP_RBS_TXN_ACCUM_HDRS (p_worker_id in number);
144
145 procedure RETRIEVE_OVERRIDDEN_WP_ETC (p_worker_id in number);
146
147 procedure EXTRACT_PLAN_ETC_PRIRBS (p_worker_id in number);
148
149 procedure CLEANUP (p_worker_id in number default null);
150
151 -- Bug 5957219
152 procedure MERGE_INTO_FP_FACTS (p_worker_id in number);
153
154 end PJI_PJP_SUM_ROLLUP;