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 290: from pa_tasks

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

Line 303: from pa_tasks

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

Line 328: l_parent_task_id pa_tasks.parent_task_id%TYPE;

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

Line 329: l_parent_wbs_level pa_tasks.wbs_level%TYPE;

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

Line 344: from pa_tasks

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

Line 356: from pa_tasks

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

Line 370: from pa_tasks

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

Line 382: from pa_tasks

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

Line 420: from pa_tasks

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

Line 434: from pa_tasks

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

Line 454: from pa_tasks

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

Line 486: l_parent_task_id pa_tasks.parent_task_id%TYPE;

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

Line 487: l_parent_wbs_level pa_tasks.wbs_level%TYPE;

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

Line 505: from pa_tasks

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

Line 524: from pa_tasks

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

Line 572: l_parent_task_id pa_tasks.parent_task_id%TYPE;

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

Line 573: l_parent_wbs_level pa_tasks.wbs_level%TYPE;

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

Line 648: from pa_tasks

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

Line 5165: pa_tasks t

5161: select fpe.task_id,
5162: fpe.resource_planning_level
5163: from
5164: pa_fp_elements fpe,
5165: pa_tasks t
5166: where
5167: fpe.proj_fp_options_id = c_fp_opt_id and
5168: fpe.element_type = c_ver_type and
5169: fpe.task_id = t.task_id and