1 PACKAGE Pa_Rp_Util AS
2 /* $Header: PARPUTILS.pls 120.1 2006/12/06 01:13:33 ninzhang noship $ */
3 G_RET_STS_WARNING VARCHAR2(1):='W';
4 G_RET_STS_ERROR VARCHAR2(1):='E';
5
6 PROCEDURE Add_Message (p_app_short_name VARCHAR2
7 , p_msg_name VARCHAR2
8 , p_msg_type VARCHAR2
9 , p_token1 VARCHAR2 DEFAULT NULL
10 , p_token1_value VARCHAR2 DEFAULT NULL
11 , p_token2 VARCHAR2 DEFAULT NULL
12 , p_token2_value VARCHAR2 DEFAULT NULL
13 , p_token3 VARCHAR2 DEFAULT NULL
14 , p_token3_value VARCHAR2 DEFAULT NULL
15 , p_token4 VARCHAR2 DEFAULT NULL
16 , p_token4_value VARCHAR2 DEFAULT NULL
17 , p_token5 VARCHAR2 DEFAULT NULL
18 , p_token5_value VARCHAR2 DEFAULT NULL
19 );
20
21
22 PROCEDURE Assign_Job(p_main_request_id NUMBER
23 , p_worker_request_id NUMBER
24 , p_previous_succeed VARCHAR
25 , x_job_assigned OUT NOCOPY VARCHAR2
26 , x_bursting_values OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
27 , x_return_status IN OUT NOCOPY VARCHAR2
28 , x_msg_count IN OUT NOCOPY NUMBER
29 , x_msg_data IN OUT NOCOPY VARCHAR2);
30
31
32 PROCEDURE Is_DT_Trimmed (p_rp_id NUMBER
33 , p_app_short_name VARCHAR2
34 , x_is_dt_trimmed OUT NOCOPY VARCHAR2
35 , x_return_status IN OUT NOCOPY VARCHAR2
36 , x_msg_count IN OUT NOCOPY NUMBER
37 , x_msg_data IN OUT NOCOPY VARCHAR2);
38
39 PROCEDURE Save_Trimmed_DT (p_rp_id NUMBER
40 , x_trimmed_dt OUT NOCOPY BLOB
41 , x_return_status IN OUT NOCOPY VARCHAR2
42 , x_msg_count IN OUT NOCOPY NUMBER
43 , x_msg_data IN OUT NOCOPY VARCHAR2);
44
45 PROCEDURE Start_Workers (p_request_id NUMBER
46 , p_rp_id NUMBER
47 , x_worker_request_ids OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
48 , x_return_status IN OUT NOCOPY VARCHAR
49 , x_msg_count IN OUT NOCOPY NUMBER
50 , x_msg_data IN OUT NOCOPY VARCHAR2);
51
52 PROCEDURE Check_Workers (p_main_request_id NUMBER
53 , p_worker_request_ids SYSTEM.PA_NUM_TBL_TYPE
54 , x_conc_prog_status OUT NOCOPY NUMBER -- 0 normal 1 warning 2 error
55 , x_return_status IN OUT NOCOPY VARCHAR
56 , x_msg_count IN OUT NOCOPY NUMBER
57 , x_msg_data IN OUT NOCOPY VARCHAR2);
58
59 PROCEDURE Save_Params (p_main_request_id NUMBER
60 , p_rp_id NUMBER
61 , p_param_names SYSTEM.PA_VARCHAR2_240_TBL_TYPE
62 , p_param_values SYSTEM.PA_VARCHAR2_240_TBL_TYPE
63 , x_return_status IN OUT NOCOPY VARCHAR
64 , x_msg_count IN OUT NOCOPY NUMBER
65 , x_msg_data IN OUT NOCOPY VARCHAR2);
66
67
68 PROCEDURE get_email_addresses (p_rp_id NUMBER
69 , p_project_id NUMBER
70 , x_email_addresses OUT NOCOPY VARCHAR2
71 , x_return_status IN OUT NOCOPY VARCHAR2
72 , x_msg_count IN OUT NOCOPY NUMBER
73 , x_msg_data IN OUT NOCOPY VARCHAR2);
74
75 PROCEDURE Derive_Currency_Info(
76 p_project_id NUMBER
77 , p_currency_type VARCHAR2
78 , x_currency_record_type OUT NOCOPY NUMBER
79 , x_currency_code OUT NOCOPY VARCHAR2
80 , x_return_status IN OUT NOCOPY VARCHAR2
81 , x_msg_count IN OUT NOCOPY NUMBER
82 , x_msg_data IN OUT NOCOPY VARCHAR2);
83
84 PROCEDURE Derive_Proj_Params (p_project_id NUMBER
85 , p_calendar_type VARCHAR2
86 , p_currency_type VARCHAR2
87 , p_cstbudget2_plan_type_id NUMBER
88 , p_revbudget2_plan_type_id NUMBER
89 , p_report_period VARCHAR2
90 , p_spec_period_name VARCHAR2
91 , x_wbs_version_id OUT NOCOPY NUMBER
92 , x_wbs_element_id OUT NOCOPY NUMBER
93 , x_rbs_version_id OUT NOCOPY NUMBER
94 , x_rbs_element_id OUT NOCOPY NUMBER
95 , x_calendar_id OUT NOCOPY NUMBER
96 , x_report_date OUT NOCOPY NUMBER
97 , x_period_name OUT NOCOPY VARCHAR2
98 , x_period_id OUT NOCOPY NUMBER
99 , x_actual_version_id OUT NOCOPY NUMBER
100 , x_cstforecast_version_id OUT NOCOPY NUMBER
101 , x_cstbudget_version_id OUT NOCOPY NUMBER
102 , x_cstbudget2_version_id OUT NOCOPY NUMBER
103 , x_revforecast_version_id OUT NOCOPY NUMBER
104 , x_revbudget_version_id OUT NOCOPY NUMBER
105 , x_revbudget2_version_id OUT NOCOPY NUMBER
106 , x_orig_cstbudget_version_id OUT NOCOPY NUMBER
107 , x_orig_cstbudget2_version_id OUT NOCOPY NUMBER
108 , x_orig_revbudget_version_id OUT NOCOPY NUMBER
109 , x_orig_revbudget2_version_id OUT NOCOPY NUMBER
110 , x_prior_cstforecast_version_id OUT NOCOPY NUMBER
111 , x_prior_revforecast_version_id OUT NOCOPY NUMBER
112 , x_cstforecast_plan_type_id OUT NOCOPY NUMBER
113 , x_cstbudget_plan_type_id OUT NOCOPY NUMBER
114 , x_revforecast_plan_type_id OUT NOCOPY NUMBER
115 , x_revbudget_plan_type_id OUT NOCOPY NUMBER
116 , x_currency_record_type_id OUT NOCOPY NUMBER
117 , x_Currency_Code OUT NOCOPY VARCHAR2
118 , x_period_start_date OUT NOCOPY NUMBER
119 , x_period_end_date OUT NOCOPY NUMBER
120 , x_project_type OUT NOCOPY VARCHAR2
121 , x_return_status IN OUT NOCOPY VARCHAR2
122 , x_msg_count IN OUT NOCOPY NUMBER
123 , x_msg_data IN OUT NOCOPY VARCHAR2);
124
125
126 PROCEDURE Derive_Calendar_Info(p_project_id NUMBER
127 , p_report_period VARCHAR2
128 , p_calendar_type VARCHAR2
129 , p_spec_period_name VARCHAR2
130 , x_calendar_id OUT NOCOPY NUMBER
131 , x_report_date OUT NOCOPY NUMBER
132 , x_period_name OUT NOCOPY VARCHAR2
133 , x_period_id OUT NOCOPY NUMBER
134 , x_start_date OUT NOCOPY NUMBER
135 , x_end_date OUT NOCOPY NUMBER
136 , x_return_status IN OUT NOCOPY VARCHAR2
137 , x_msg_count IN OUT NOCOPY NUMBER
138 , x_msg_data IN OUT NOCOPY VARCHAR2
139 );
140
141 FUNCTION Get_Percent_Complete
142 ( p_project_id NUMBER
143 , p_wbs_version_id NUMBER
144 , p_wbs_element_id NUMBER
145 , p_report_date_julian NUMBER
146 , p_calendar_type VARCHAR2 DEFAULT 'E'
147 , p_calendar_id NUMBER DEFAULT -1
148 ) RETURN NUMBER;
149
150
151 FUNCTION Get_Task_Proj_Number
152 ( p_project_id NUMBER
153 , p_proj_elem_id NUMBER
154 ) RETURN VARCHAR;
155
156 END Pa_Rp_Util;
[Home] [Help]