[Home] [Help]
PACKAGE: APPS.PJI_FM_XBS_ACCUM_MAINT
Source
1 PACKAGE PJI_FM_XBS_ACCUM_MAINT AUTHID CURRENT_USER AS
2 /* $Header: PJIPMNTS.pls 120.7 2006/10/16 15:13:03 degupta noship $ */
3
4
5 PROCEDURE PLAN_DELETE (
6 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
7 x_return_status OUT NOCOPY VARCHAR2,
8 x_msg_code OUT NOCOPY VARCHAR2 );
9
10 PROCEDURE PLAN_DELETE_PVT (
11 p_event_id IN NUMBER
12 , x_return_status OUT NOCOPY VARCHAR2
13 , x_processing_code OUT NOCOPY VARCHAR2 );
14
15 PROCEDURE PLAN_CREATE (
16 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_code OUT NOCOPY VARCHAR2,
19 p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type(),
20 p_copy_mode in varchar2 :=NULL);
21
22 PROCEDURE PLAN_UPDATE (
23 p_plan_version_id IN NUMBER := NULL,
24 x_msg_code OUT NOCOPY VARCHAR2,
25 x_return_status OUT NOCOPY VARCHAR2 );
26
27 PROCEDURE PLAN_UPDATE_PVT (
28 p_plan_version_id IN NUMBER := NULL
29 , x_return_status OUT NOCOPY VARCHAR2
30 , x_processing_code OUT NOCOPY VARCHAR2 );
31
32 PROCEDURE PLAN_UPDATE_ACT_ETC (
33 p_plan_wbs_ver_id IN NUMBER
34 , p_prev_pub_wbs_ver_id IN NUMBER := NULL
35 , x_msg_code OUT NOCOPY VARCHAR2
36 , x_return_status OUT NOCOPY VARCHAR2 );
37
38 PROCEDURE DELETE_SMART_SLICE (
39 p_online_flag IN VARCHAR2 := 'Y'
40 , x_return_status OUT NOCOPY VARCHAR2 );
41
42 PROCEDURE PLAN_UPDATE_PVT_ACT_ETC (
43 p_plan_version_id IN NUMBER
44 , p_prev_pub_version_id IN NUMBER := NULL
45 , x_return_status OUT NOCOPY VARCHAR2
46 , x_processing_code OUT NOCOPY VARCHAR2);
47
48 PROCEDURE FINPLAN_COPY (
49 p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
50 p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
51 p_source_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
52 p_dest_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_code OUT NOCOPY VARCHAR2 );
55
56 PROCEDURE PLAN_COPY_PVT (
57 p_event_id IN NUMBER
58 , x_return_status OUT NOCOPY VARCHAR2
59 , x_processing_code OUT NOCOPY VARCHAR2);
60
61 PROCEDURE PLAN_BASELINE (
62 p_baseline_version_id IN NUMBER,
63 p_new_version_id IN NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_code OUT NOCOPY VARCHAR2 );
66
67 PROCEDURE PLAN_BASELINE_PVT (
68 p_event_id IN NUMBER
69 , x_return_status OUT NOCOPY VARCHAR2
70 , x_processing_code OUT NOCOPY VARCHAR2);
71
72 PROCEDURE PLAN_ORIGINAL (
73 p_original_version_id IN NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_code OUT NOCOPY VARCHAR2 );
76
77 PROCEDURE PLAN_ORIGINAL_PVT (
78 p_event_id IN NUMBER
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_processing_code OUT NOCOPY VARCHAR2);
81
82 PROCEDURE WBS_MAINT (
83 p_new_struct_ver_id IN NUMBER,
84 p_old_struct_ver_id IN NUMBER,
85 p_project_id IN NUMBER,
86 p_publish_flag IN VARCHAR2 DEFAULT 'N',
87 p_online_flag IN VARCHAR2,
88 p_calling_context IN VARCHAR2 DEFAULT NULL,
89 p_rerun_flag IN VARCHAR2 :=NULL,
90 x_request_id OUT NOCOPY NUMBER,
91 x_processing_code OUT NOCOPY VARCHAR2,
92 x_msg_code OUT NOCOPY VARCHAR2,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_online_flag OUT NOCOPY VARCHAR2 );
95
96 PROCEDURE PRG_CHANGE (
97 p_prg_grp_id IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_code OUT NOCOPY VARCHAR2 );
100
101
102 PROCEDURE RBS_PUSH (
103 p_old_rbs_version_id IN NUMBER DEFAULT NULL
104 , p_new_rbs_version_id IN NUMBER
105 , p_project_id IN NUMBER DEFAULT NULL
106 , p_program_flag IN VARCHAR2 DEFAULT 'N'
107 , x_return_status OUT NOCOPY VARCHAR2
108 , x_msg_code OUT NOCOPY VARCHAR2 );
109
110
111 PROCEDURE RBS_DELETE (
112 p_rbs_version_id IN NUMBER
113 , p_project_id IN NUMBER
114 , x_return_status OUT NOCOPY VARCHAR2
115 , x_msg_code OUT NOCOPY VARCHAR2 );
116
117
118 PROCEDURE maintain_smart_slice (
119 p_rbs_version_id IN NUMBER :=NULL,
120 p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
121 p_wbs_element_id IN NUMBER,
122 p_rbs_element_id IN NUMBER,
123 p_prg_rollup_flag IN VARCHAR2,
124 p_curr_record_type_id IN NUMBER,
125 p_calendar_type IN VARCHAR2,
126 p_wbs_version_id IN NUMBER,
127 p_commit IN VARCHAR2 := 'Y',
128 p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 x_return_status OUT NOCOPY VARCHAR2);
132
133 PROCEDURE PROCESS_PROJ_SUM_CHANGES (
134 errbuf OUT NOCOPY VARCHAR2,
135 retcode OUT NOCOPY VARCHAR2,
136 p_event_id IN NUMBER,
137 p_calling_context IN VARCHAR2,
138 p_rerun_flag IN VARCHAR2 := NULL);
139
140 PROCEDURE process_pending_events (
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_data OUT NOCOPY VARCHAR2 );
143
144 PROCEDURE process_pending_plan_updates (
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_data OUT NOCOPY VARCHAR2 );
147
148 PROCEDURE WBS_LOCK_PVT (
149 p_event_id IN NUMBER DEFAULT NULL,
150 p_online_flag IN VARCHAR2,
151 p_request_id IN NUMBER DEFAULT NULL,
152 x_lock_mode OUT NOCOPY VARCHAR2,
153 x_return_status OUT NOCOPY VARCHAR2 );
154
155 PROCEDURE process_plan_events (
156 p_project_id IN NUMBER,
157 p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
158 x_processing_code OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 x_return_status OUT NOCOPY VARCHAR2 );
162
163 PROCEDURE PRINT_PLAN_VERSION_ID_LIST
164 ( p_fp_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() );
165
166 PROCEDURE PRINT_PLAN_VERSION_TYPE_LIST
167 ( p_fp_version_types IN SYSTEM.pa_varchar2_30_tbl_type );
168
169 PROCEDURE debug_plan_lines; -- So it can be called from summarization also, when needed.
170
171 PROCEDURE CREATE_EVENT(p_event_rec IN OUT NOCOPY pa_pji_proj_events_log%ROWTYPE);
172
173 END PJI_FM_XBS_ACCUM_MAINT;