1 PACKAGE PJI_FM_XBS_ACCUM_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PJIPUT1S.pls 120.4.12020000.2 2012/07/18 10:55:37 admarath ship $ */
3
4 /*Changed for workplan progress.
5 p_end_date IN DATE,
6 p_calendar_type IN VARCHAR2,
7 and added
8 p_extraction_type IN VARCHAR2(1) := NULL,
9 p_calling_context IN VARCHAR2 := NULL */
10 PROCEDURE DELETE_FIN8(
11 p_project_id IN NUMBER,
12 p_calendar_type IN VARCHAR2 DEFAULT NULL,
13 p_end_date IN DATE DEFAULT NULL,
14 p_err_flag IN NUMBER DEFAULT 0,
15 p_err_msg IN VARCHAR2 DEFAULT NULL
16 );
17
18 PROCEDURE get_summarized_data (
19 p_project_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
20 p_resource_list_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
21 p_struct_ver_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
22 p_start_date IN DATE := NULL,
23 p_end_date IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
24 p_start_period_name IN VARCHAR2 := NULL,
25 p_end_period_name IN VARCHAR2 := NULL,
26 p_calendar_type IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
27 p_extraction_type IN VARCHAR2 := NULL,
28 p_calling_context IN VARCHAR2 := NULL,
29 p_record_type IN VARCHAR2,
30 p_currency_type IN NUMBER,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_code OUT NOCOPY VARCHAR2);
33
34 /*
35 PROCEDURE populate_workplan_data (
36 p_project_id IN NUMBER,
37 p_struct_ver_id IN NUMBER DEFAULT NULL,
38 p_base_struct_ver_id IN NUMBER DEFAULT NULL,
39 p_plan_version_id IN NUMBER DEFAULT NULL,
40 p_progress_actuals_flag IN VARCHAR2 DEFAULT 'N',
41 p_as_of_date IN DATE DEFAULT NULL,
42 p_delete_flag IN VARCHAR2 := 'Y',
43 p_workplan_flag IN VARCHAR2 := 'Y',
44 p_project_element_id IN NUMBER DEFAULT NULL,
45 p_calling_context IN VARCHAR2 := NULL,
46 p_program_rollup_flag IN VARCHAR2 DEFAULT 'N',
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_code OUT NOCOPY VARCHAR2 ); */
49
50
51
52 PROCEDURE populate_updatewbs_data (
53 p_project_id IN NUMBER,
54 p_struct_ver_id IN NUMBER DEFAULT NULL,
55 p_base_struct_ver_id IN NUMBER DEFAULT NULL,
56 p_plan_version_id IN NUMBER DEFAULT NULL,
57 p_as_of_date IN DATE DEFAULT NULL,
58 p_delete_flag IN VARCHAR2 := 'Y',
59 p_project_element_id IN NUMBER DEFAULT NULL,
60 p_level IN NUMBER DEFAULT 1,
61 p_structure_flag IN VARCHAR2 DEFAULT 'N',
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_code OUT NOCOPY VARCHAR2 );
64
65
66 PROCEDURE FPM_UPGRADE_INITIALIZE;
67
68 PROCEDURE FPM_UPGRADE_END;
69
70 PROCEDURE REMAP_RBS_TXN_ACCUM_HDRS (
71 x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER );
74
75 PROCEDURE get_msp_actuals_data(
76 p_project_id IN NUMBER,
77 p_calendar_type IN VARCHAR2,
78 p_resource_list_id IN NUMBER DEFAULT NULL,
79 p_task_res_flag IN VARCHAR2,
80 p_end_date IN DATE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_code OUT NOCOPY VARCHAR2);
83
84
85
86 TYPE populate_in_rec_type IS RECORD
87 ( project_id NUMBER(25) ,
88 struct_ver_id NUMBER(25),
89 base_struct_ver_id NUMBER(25) ,
90 plan_version_id NUMBER (25) ,
91 as_of_date DATE ,
92 project_element_id NUMBER (25)
93 );
94
95 TYPE populate_in_tbl_type IS TABLE OF populate_in_rec_type
96 INDEX BY BINARY_INTEGER;
97 populate_in_default_tbl populate_in_tbl_type;
98
99
100 PROCEDURE populate_workplan_data (
101 p_populate_in_tbl IN populate_in_tbl_type := populate_in_default_tbl,
102 p_project_id IN NUMBER DEFAULT NULL,
103 p_struct_ver_id IN NUMBER DEFAULT NULL,
104 p_base_struct_ver_id IN NUMBER DEFAULT NULL,
105 p_plan_version_id IN NUMBER DEFAULT NULL,
106 p_progress_actuals_flag IN VARCHAR2 DEFAULT 'N',
107 p_as_of_date IN DATE DEFAULT NULL,
108 p_delete_flag IN VARCHAR2 := 'Y',
109 p_workplan_flag IN VARCHAR2 := 'Y',
110 p_project_element_id IN NUMBER DEFAULT NULL,
111 p_calling_context IN VARCHAR2 := NULL,
112 p_program_rollup_flag IN VARCHAR2 DEFAULT 'N',
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_code OUT NOCOPY VARCHAR2 );
115
116
117 END PJI_FM_XBS_ACCUM_UTILS;