APPS.PA_DDC_API dependencies on PA_DDC_API

Line 1: PACKAGE BODY PA_DDC_API AS

1: PACKAGE BODY PA_DDC_API AS
2: /* $Header: PAXDDC0B.pls 120.2 2005/08/19 17:13:17 mwasowic ship $ */
3:
4: FUNCTION Check_Alias (x_alias IN VARCHAR2
5: , x_folder_code IN VARCHAR2) RETURN VARCHAR2 IS

Line 143: IF (PA_DDC_API.Check_Alias('A.','P') = 'Y') THEN

139: where_clause := '''Y''' ||' in (select pa_security.allow_query(pah.project_id) from sys.dual) AND p.project_id = pah.project_id AND pah.task_id = 0 AND pah.resource_list_id = 0
140: AND pah.project_id = r.project_id AND pah.project_id = c.project_id';
141:
142:
143: IF (PA_DDC_API.Check_Alias('A.','P') = 'Y') THEN
144:
145: from_clause := from_clause||',pa_project_accum_actuals a';
146:
147: where_clause := where_clause||' AND pah.project_accum_id = a.project_accum_id (+)';

Line 151: IF (PA_DDC_API.Check_Alias('M.','P') = 'Y') THEN

147: where_clause := where_clause||' AND pah.project_accum_id = a.project_accum_id (+)';
148:
149: END IF;
150:
151: IF (PA_DDC_API.Check_Alias('M.','P') = 'Y') THEN
152:
153: from_clause := from_clause||',pa_project_accum_commitments m';
154:
155: where_clause := where_clause||' AND pah.project_accum_id = m.project_accum_id (+)';

Line 244: IF (PA_DDC_API.Check_Alias('A.','T') = 'Y') THEN

240:
241:
242: where_clause :='t.project_id = PA_STATUS.GetProjId AND t.task_id = c.task_id (+) AND t.task_id = r.task_id (+)';
243:
244: IF (PA_DDC_API.Check_Alias('A.','T') = 'Y') THEN
245:
246: from_clause := from_clause||', pa_status_task_act_v a';
247:
248: where_clause := where_clause||' AND t.task_id = a.task_id (+)';

Line 252: IF (PA_DDC_API.Check_Alias('M.','T') = 'Y') THEN

248: where_clause := where_clause||' AND t.task_id = a.task_id (+)';
249:
250: END IF;
251:
252: IF (PA_DDC_API.Check_Alias('M.','T') = 'Y') THEN
253:
254: from_clause := from_clause||', pa_status_task_cmt_v m';
255:
256: where_clause := where_clause||' AND t.task_id = m.task_id (+)';

Line 351: IF (PA_DDC_API.Check_Alias('RES.','R') = 'Y') THEN

347:
348:
349: where_clause :='pah.project_id = PA_STATUS.GetProjId AND pah.resource_list_id = PA_STATUS.GetRsrcListId AND pah.task_id = PA_STATUS.GetTaskId AND pah.resource_list_member_id = rlm1.resource_list_member_id';
350:
351: IF (PA_DDC_API.Check_Alias('RES.','R') = 'Y') THEN
352:
353: from_clause := from_clause||',pa_resources res';
354:
355: where_clause := where_clause||' AND rlm1.resource_id = res.resource_id';

Line 360: IF (PA_DDC_API.Check_Alias('A.','R') = 'Y') THEN

356:
357: END IF;
358:
359:
360: IF (PA_DDC_API.Check_Alias('A.','R') = 'Y') THEN
361:
362: from_clause := from_clause||',pa_status_rsrc_act_high_v a';
363:
364: where_clause := where_clause||' AND pah.resource_list_member_id = a.resource_list_member_id (+)';

Line 369: IF (PA_DDC_API.Check_Alias('M.','R') = 'Y') THEN

365:
366: END IF;
367:
368:
369: IF (PA_DDC_API.Check_Alias('M.','R') = 'Y') THEN
370:
371: from_clause := from_clause||',pa_status_rsrc_cmt_high_v m';
372:
373: where_clause := where_clause||' AND pah.resource_list_member_id = m.resource_list_member_id (+)';

Line 378: IF (PA_DDC_API.Check_Alias('C.','R') = 'Y') THEN

374:
375: END IF;
376:
377:
378: IF (PA_DDC_API.Check_Alias('C.','R') = 'Y') THEN
379:
380: from_clause := from_clause||',pa_status_rsrc_bgt_cost_high_v c';
381:
382: where_clause := where_clause||' AND pah.resource_list_member_id = c.resource_list_member_id (+)';

Line 387: IF (PA_DDC_API.Check_Alias('R.','R') = 'Y') THEN

383:
384: END IF;
385:
386:
387: IF (PA_DDC_API.Check_Alias('R.','R') = 'Y') THEN
388:
389: from_clause := from_clause||',pa_status_rsrc_bgt_rev_high_v r';
390:
391: where_clause := where_clause||' AND pah.resource_list_member_id = r.resource_list_member_id (+)';

Line 433: END PA_DDC_API;

429:
430: END create_psi_generic_views;
431:
432:
433: END PA_DDC_API;