1 package PJM_PROJECT AUTHID CURRENT_USER as
2 /* $Header: PJMPROJS.pls 120.1 2006/03/15 15:28:13 yliou noship $ */
3
4 FUNCTION Proj_Or_Seiban
5 ( X_project_id IN NUMBER
6 ) return varchar2;
7
8
9 FUNCTION Is_Exp_Proj
10 ( X_project_id IN NUMBER ,
11 X_org_id IN NUMBER
12 ) return varchar2;
13
14 --
15 -- Resolve project number from project ID against all projects
16 --
17 function all_proj_idtonum
18 ( X_project_id in number
19 ) return varchar2;
20
21
22 --
23 -- Resolve project name from project ID against all projects
24 --
25 function all_proj_idtoname
26 ( X_project_id in number
27 ) return varchar2;
28
29
30 --
31 -- Resolve project number from project ID against current valid projects only
32 --
33 -- X_organization_id is optional; if given, the function further narrows the
34 -- list of valid projects to those with project parameter defined in the
35 -- given organization
36 --
37 function val_proj_idtonum
38 ( X_project_id in number
39 , X_organization_id in number default null
40 ) return varchar2;
41
42
43 --
44 -- Resolve project name from project ID against current valid projects only
45 --
46 -- X_organization_id is optional; if given, the function further narrows the
47 -- list of valid projects to those with project parameter defined in the
48 -- given organization
49 --
50 function val_proj_idtoname
51 ( X_project_id in number
52 , X_organization_id in number default null
53 ) return varchar2;
54
55
56 --
57 -- Resolve project ID from project number against current valid projects only
58 --
59 -- X_organization_id is optional; if given, the function further narrows the
60 -- list of valid projects to those with project parameter defined in the
61 -- given organization
62 --
63 function val_proj_numtoid
64 ( X_project_num in varchar2
65 , X_organization_id in number default null
66 ) return number;
67
68
69 --
70 -- Resolve project ID from project name against current valid projects only
71 --
72 -- X_organization_id is optional; if given, the function further narrows the
73 -- list of valid projects to those with project parameter defined in the
74 -- given organization
75 --
76 function val_proj_nametoid
77 ( X_project_name in varchar2
78 , X_organization_id in number default null
79 ) return number;
80
81
82 --
83 -- Resolve task number from task ID against all tasks
84 --
85 function all_task_idtonum
86 ( X_task_id in number
87 ) return varchar2;
88
89
90 --
91 -- Resolve task name from task ID against all tasks
92 --
93 function all_task_idtoname
94 ( X_task_id in number
95 ) return varchar2;
96
97
98 --
99 -- Resolve task number from project ID and task ID against current valid
100 -- projects and tasks only
101 --
102 function val_task_idtonum
103 ( X_project_id in number
104 , X_task_id in number
105 ) return varchar2;
106
107
108 --
109 -- Resolve task name from project ID and task ID against current valid
110 -- projects and tasks only
111 --
112 function val_task_idtoname
113 ( X_project_id in number
114 , X_task_id in number
115 ) return varchar2;
116
117
118 --
119 -- Resolve task ID from project number and task number against current valid
120 -- projects and tasks only
121 --
122 function val_task_numtoid
123 ( X_project_num in varchar2
124 , X_task_num in varchar2
125 ) return number;
126
127
128 --
129 -- Resolve task ID from project name and task name against current valid
130 -- projects and tasks only
131 --
132 function val_task_nametoid
133 ( X_project_name in varchar2
134 , X_task_name in varchar2
135 ) return number;
136
137 --
138 -- Validate project references for a particular calling function
139 --
140 G_VALIDATE_SUCCESS constant varchar2(1) := 'S';
141 G_VALIDATE_WARNING constant varchar2(1) := 'W';
142 G_VALIDATE_FAILURE constant varchar2(1) := 'E';
143
144 --
145 -- Old version kept for backward compatibility
146 --
147 function validate_proj_references
148 ( X_inventory_org_id in number
149 , X_project_id in number
150 , X_task_id in number
151 , X_calling_function in varchar2
152 , X_error_code out nocopy varchar2
153 ) return boolean;
154
155 --
156 -- This variant does not include the error code out parameter
157 -- and can be used in SQL
158 --
159 function validate_proj_references
160 ( X_inventory_org_id in number
161 , X_project_id in number
162 , X_task_id in number
163 , X_date1 in date default null
164 , X_date2 in date default null
165 , X_calling_function in varchar2
166 ) return varchar2;
167
168 --
169 -- This variant uses the current operating unit as the default
170 --
171 function validate_proj_references
172 ( X_inventory_org_id in number
173 , X_project_id in number
174 , X_task_id in number
175 , X_date1 in date default null
176 , X_date2 in date default null
177 , X_calling_function in varchar2
178 , X_error_code out nocopy varchar2
179 ) return varchar2;
180
181 --
182 -- This is the main definition of the function
183 --
184 function validate_proj_references
185 ( X_inventory_org_id in number
186 , X_operating_unit in number
187 , X_project_id in number
188 , X_task_id in number
189 , X_date1 in date default null
190 , X_date2 in date default null
191 , X_calling_function in varchar2
192 , X_error_code out nocopy varchar2
193 ) return varchar2;
194
195 end PJM_PROJECT;