[Home] [Help]
12: x_return_status := 0;
13:
14: select 1
15: into x_dummy
16: from sys.dual
17: where not exists
18: (select 1
19: from pa_lookups p
20: where p.lookup_type = x_lookup_type
49:
50: Begin
51: select 1
52: into x_dummy
53: from sys.dual
54: where not exists
55: (select 1
56: from pa_credit_receivers cr
57: where cr.credit_type_code = x_lookup_code);
72: Begin
73: -- Unit Type, Expenditure Types
74: select 1
75: into x_dummy
76: from sys.dual
77: where not exists
78: (select 1
79: from pa_expenditure_types et
80: where et.unit_of_measure = x_lookup_code);
93: Begin
94: -- Unit Type, Bill Rates
95: select 1
96: into x_dummy
97: from sys.dual
98: where not exists
99: (select 1
100: from pa_bill_rates br
101: where br.bill_rate_unit = x_lookup_code);
113: Begin
114: -- Unit Type, Resources
115: select 1
116: into x_dummy
117: from sys.dual
118: where not exists
119: (select 1
120: from pa_resources r
121: where r.unit_of_measure = x_lookup_code);
133: Begin
134: -- Unit Type, Employee Bill Rates Overrides
135: select 1
136: into x_dummy
137: from sys.dual
138: where not exists
139: (select 1
140: from pa_emp_bill_rate_overrides eb
141: where eb.bill_rate_unit = x_lookup_code);
153: Begin
154: -- Unit Type, Job Bill Rate Overrides
155: select 1
156: into x_dummy
157: from sys.dual
158: where not exists
159: (select 1
160: from pa_job_bill_rate_overrides jb
161: where jb.bill_rate_unit = x_lookup_code);
180: Begin
181: -- Service Type, Project Types
182: select 1
183: into x_dummy
184: from sys.dual
185: where not exists
186: (select 1
187: from pa_project_types pt
188: where pt.service_type_code = x_lookup_code);
201: Begin
202: -- Service Type, Tasks
203: select 1
204: into x_dummy
205: from sys.dual
206: where not exists
207: (select 1
208: from pa_tasks t
209: where t.service_type_code = x_lookup_code);
227: Begin
228: -- Revenue Category, Expenditure Types
229: select 1
230: into x_dummy
231: from sys.dual
232: where not exists
233: (select 1
234: from pa_expenditure_types et
235: where et.revenue_category_code = x_lookup_code);
247: Begin
248: -- Revenue Category, Event Types
249: select 1
250: into x_dummy
251: from sys.dual
252: where not exists
253: (select 1
254: from pa_event_types et
255: where et.revenue_category_code = x_lookup_code);
267: Begin
268: -- Revenue Category, Resource Txn Attributes
269: select 1
270: into x_dummy
271: from sys.dual
272: where not exists
273: (select 1
274: from pa_resource_txn_attributes rt
275: where rt.revenue_category = x_lookup_code);
290: -- Project Statuses
291: Begin
292: select 1
293: into x_dummy
294: from sys.dual
295: where not exists
296: (select 1
297: from pa_projects p
298: where p.project_status_code = x_lookup_code);
313:
314: Begin
315: select 1
316: into x_dummy
317: from sys.dual
318: where not exists
319: (select 1
320: from pa_project_customers pc
321: where pc.project_relationship_code = x_lookup_code);
336:
337: Begin
338: select 1
339: into x_dummy
340: from sys.dual
341: where not exists
342: (select 1
343: from pa_project_contacts pc
344: where pc.project_contact_type_code = x_lookup_code);
360: Begin
361: -- Budget Change Reason, Budget Lines
362: select 1
363: into x_dummy
364: from sys.dual
365: where not exists
366: (select 1
367: from pa_budget_lines bl
368: where bl.change_reason_code = x_lookup_code);
380: Begin
381: -- Budget Change Reason, Budget Versions
382: select 1
383: into x_dummy
384: from sys.dual
385: where not exists
386: (select 1
387: from pa_budget_versions bv
388: where bv.change_reason_code = x_lookup_code);
402: elsif (x_stage = 90) then
403: -- PM Product code Pa projects
404: Begin
405: select 1 into x_dummy
406: from sys.dual
407: where not exists
408: (select 1 from pa_projects where pm_product_code
409: = x_lookup_code );
410: EXCEPTION
419: End;
420: -- PM Product code Pa budget versions
421: Begin
422: select 1 into x_dummy
423: from sys.dual
424: where not exists
425: (select 1 from pa_budget_versions where pm_product_code
426: = x_lookup_code );
427: EXCEPTION