APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_TASKS

Line 218: l_parent_task_id pa_tasks.parent_task_id%TYPE;

214: return NUMBER
215: is
216: /* local variables */
217: l_return_value NUMBER;
218: l_parent_task_id pa_tasks.parent_task_id%TYPE;
219: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
220: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
221: BEGIN
222: l_return_value := -1;

Line 219: l_parent_wbs_level pa_tasks.wbs_level%TYPE;

215: is
216: /* local variables */
217: l_return_value NUMBER;
218: l_parent_task_id pa_tasks.parent_task_id%TYPE;
219: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
220: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
221: BEGIN
222: l_return_value := -1;
223: -- NEED TO ACCOUNT FOR PROJECT AND TASK LEVEL ROWS THAT ARE USER-ENTERED

Line 232: from pa_tasks

228: else
229: -- this is a TASK row
230: select nvl(parent_task_id, -99)
231: into l_parent_task_id
232: from pa_tasks
233: where task_id = p_task_id and project_id = p_project_id;
234: if l_parent_task_id = -99 then
235: -- this task has no parent; so it must be a top-level task
236: l_return_value := 2;

Line 241: from pa_tasks

237: else
238: -- this task has a parent; so the level is one more than the parent
239: select wbs_level
240: into l_parent_wbs_level
241: from pa_tasks
242: where task_id = l_parent_task_id;
243: l_return_value := 1 + l_parent_wbs_level + 1; -- 1 for project, wbs_level, and 1 for child
244: end if; -- parent_task_id is null
245: end if;

Line 256: from pa_tasks

252: else
253: -- p_resource_list_member_id is 0, but p_task_id is not 0 --> TASK row
254: select nvl(parent_task_id, -99)
255: into l_parent_task_id
256: from pa_tasks
257: where task_id = p_task_id and project_id = p_project_id;
258: if l_parent_task_id = -99 then
259: -- this task has no parent; so it must be a top-level task
260: l_return_value := 2;

Line 265: from pa_tasks

261: else
262: -- this task has a parent; so the level is one more than the parent
263: select wbs_level
264: into l_parent_wbs_level
265: from pa_tasks
266: where task_id = l_parent_task_id;
267: l_return_value := 1 + l_parent_wbs_level + 1; -- 1 for project, wbs_level, and 1 for child
268: end if; -- parent_task_id is null
269: end if; -- p_task_id=0

Line 289: from pa_tasks

285: else
286: -- task_id is not 0, so see if it has a parent
287: select nvl(parent_task_id, -99)
288: into l_parent_task_id
289: from pa_tasks
290: where task_id = p_task_id and project_id = p_project_id;
291: if l_parent_task_id = -99 then
292: if l_res_parent_member_id = -99 then
293: -- this resource is RESOURCE PARENT: assign level to top_task_level (2) + 1

Line 302: from pa_tasks

298: end if; -- res_parent_member_id is null
299: else
300: select wbs_level
301: into l_parent_wbs_level
302: from pa_tasks
303: where task_id = l_parent_task_id;
304: if l_res_parent_member_id = -99 then
305: -- this resource is RESOURCE PARENT: assign level to parent_task_level + 1 + 1 + 1
306: l_return_value := 1 + l_parent_wbs_level + 1 + 1;

Line 327: l_parent_task_id pa_tasks.parent_task_id%TYPE;

323: return VARCHAR2
324: as
325: /* local variables */
326: l_return_value VARCHAR2(2000);
327: l_parent_task_id pa_tasks.parent_task_id%TYPE;
328: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
329: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
330: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
331:

Line 328: l_parent_wbs_level pa_tasks.wbs_level%TYPE;

324: as
325: /* local variables */
326: l_return_value VARCHAR2(2000);
327: l_parent_task_id pa_tasks.parent_task_id%TYPE;
328: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
329: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
330: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
331:
332: BEGIN

Line 343: from pa_tasks

339: else
340: -- this is a TASK ROW
341: select nvl(parent_task_id, -99)
342: into l_parent_task_id
343: from pa_tasks
344: where task_id = p_task_id and project_id = p_project_id;
345: if l_parent_task_id = -99 then
346: -- this task has no parent; so it must be a top-level task, so PARENT = PROJECT
347: select name || ' (' || segment1 || ')'

Line 355: from pa_tasks

351: else
352: -- this task has a parent; so PARENT = TASK NAME
353: select task_name || ' (' || task_number || ')'
354: into l_return_value
355: from pa_tasks
356: where task_id = l_parent_task_id;
357: end if; -- parent_task_id is null
358: end if;
359:

Line 369: from pa_tasks

365: else
366: -- p_resource_list_member_id is 0, but p_task_id is not 0 --> TASK row
367: select nvl(parent_task_id, -99)
368: into l_parent_task_id
369: from pa_tasks
370: where task_id = p_task_id and project_id = p_project_id;
371: if l_parent_task_id = -99 then
372: -- this task has no parent; so it must be a top-level task, so PARENT = PROJECT
373: select name || ' (' || segment1 || ')'

Line 381: from pa_tasks

377: else
378: -- this task has a parent; so PARENT = TASK NAME
379: select task_name || ' (' || task_number || ')'
380: into l_return_value
381: from pa_tasks
382: where task_id = l_parent_task_id;
383: end if; -- parent_task_id is null
384: end if; -- p_task_id=0
385: else

Line 418: from pa_tasks

414: else
415: -- task_id is not 0, so see if it has a parent
416: select nvl(parent_task_id, -99)
417: into l_parent_task_id
418: from pa_tasks
419: where task_id = p_task_id and project_id = p_project_id;
420: if l_parent_task_id = -99 then
421: if l_res_parent_member_id = -99 then
422: -- this resource is RESOURCE PARENT of a top-level task: so PARENT = PROJECT

Line 432: from pa_tasks

428: where project_id = p_project_id;
429: */
430: select task_name || ' (' || task_number || ')'
431: into l_return_value
432: from pa_tasks
433: where task_id=p_task_id;
434: else
435: -- this resource is a RESOURCE CHILD: so PARENT = RESOURCE GROUP NAME
436: /*

Line 452: from pa_tasks

448: if l_res_parent_member_id = -99 then
449: -- this resource is RESOURCE PARENT: PARENT = PARENT TASK
450: select task_name || ' (' || task_number || ')'
451: into l_return_value
452: from pa_tasks
453: where task_id = p_task_id;
454: -- where task_id = l_parent_task_id;
455: else
456: -- this resource is a RESOURCE CHILD: PARENT = RESOURCE GROUP NAME

Line 484: l_parent_task_id pa_tasks.parent_task_id%TYPE;

480: return VARCHAR2
481: is
482: /* local variables */
483: l_return_value VARCHAR2(2000);
484: l_parent_task_id pa_tasks.parent_task_id%TYPE;
485: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
486: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
487: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
488:

Line 485: l_parent_wbs_level pa_tasks.wbs_level%TYPE;

481: is
482: /* local variables */
483: l_return_value VARCHAR2(2000);
484: l_parent_task_id pa_tasks.parent_task_id%TYPE;
485: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
486: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
487: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
488:
489: BEGIN

Line 503: from pa_tasks

499: else
500: -- get TASK NAME
501: select task_name || ' (' || task_number || ')'
502: into l_return_value
503: from pa_tasks
504: where project_id = p_project_id and
505: task_id = p_task_id;
506: end if;
507:

Line 522: from pa_tasks

518: -- p_resource_list_member_id is 0, but p_task_id is not 0 --> TASK row
519: -- get TASK NAME
520: select task_name || ' (' || task_number || ')'
521: into l_return_value
522: from pa_tasks
523: where project_id = p_project_id and
524: task_id = p_task_id;
525: end if;
526: else

Line 570: l_parent_task_id pa_tasks.parent_task_id%TYPE;

566: return VARCHAR2
567: is
568: /* local variables */
569: l_return_value VARCHAR2(2000);
570: l_parent_task_id pa_tasks.parent_task_id%TYPE;
571: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
572: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
573: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
574: l_labor_res_flag pa_resource_assignments.track_as_labor_flag%TYPE;

Line 571: l_parent_wbs_level pa_tasks.wbs_level%TYPE;

567: is
568: /* local variables */
569: l_return_value VARCHAR2(2000);
570: l_parent_task_id pa_tasks.parent_task_id%TYPE;
571: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
572: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
573: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
574: l_labor_res_flag pa_resource_assignments.track_as_labor_flag%TYPE;
575:

Line 646: from pa_tasks

642: if p_element_type = 'TASK' then
643: if p_task_id > 0 then
644: select task_name || ' (' || task_number || ')'
645: into l_return_value
646: from pa_tasks
647: where task_id = p_task_id;
648: end if;
649: else
650: if p_resource_list_member_id > 0 then

Line 4995: pa_tasks t

4991: select fpe.task_id,
4992: fpe.resource_planning_level
4993: from
4994: pa_fp_elements fpe,
4995: pa_tasks t
4996: where
4997: fpe.proj_fp_options_id = c_fp_opt_id and
4998: fpe.element_type = c_ver_type and
4999: fpe.task_id = t.task_id and