eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_RESOURCE_LIST_MEMBERS

Line 220: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

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
224: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then

Line 274: from pa_resource_list_members

270: else
271: -- p_resource_list_member_id is not 0 here
272: select nvl(parent_member_id, -99)
273: into l_res_parent_member_id
274: from pa_resource_list_members
275: where resource_list_member_id = p_resource_list_member_id;
276: if p_task_id = 0 then
277: -- resource is direct descendant of the project
278: if l_res_parent_member_id = -99 then

Line 329: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

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
333: l_return_value := -1;

Line 330: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

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
333: l_return_value := -1;
334: -- NEED TO ACCOUNT FOR PROJECT AND TASK LEVEL ROWS THAT ARE USER-ENTERED

Line 391: from pa_resource_list_members

387: select nvl(parent_member_id, -99),
388: resource_list_id
389: into l_res_parent_member_id,
390: l_resource_list_id
391: from pa_resource_list_members
392: where resource_list_member_id = p_resource_list_member_id;
393: if p_task_id = 0 then
394: -- resource is direct descendant of the project
395: if l_res_parent_member_id = -99 then

Line 411: from pa_resource_list_members

407: where resource_list_id = l_resource_list_id;
408: */
409: select alias
410: into l_return_value
411: from pa_resource_list_members
412: where resource_list_member_id = l_res_parent_member_id;
413: end if; -- res_parent_member_id is null
414: else
415: -- task_id is not 0, so see if it has a parent

Line 444: from pa_resource_list_members

440: where resource_list_id = l_resource_list_id;
441: */
442: select alias
443: into l_return_value
444: from pa_resource_list_members
445: where resource_list_member_id = l_res_parent_member_id;
446: end if; -- res_parent_member_id is null
447: else
448: if l_res_parent_member_id = -99 then

Line 465: from pa_resource_list_members

461: where resource_list_id = l_resource_list_id;
462: */
463: select alias
464: into l_return_value
465: from pa_resource_list_members
466: where resource_list_member_id = l_res_parent_member_id;
467: end if; -- res_parent_member_id is null
468: end if; -- parent_task_id is null
469: end if; -- p_task_id=0

Line 486: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

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
490: l_return_value := 'dummy element name';

Line 487: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

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
490: l_return_value := 'dummy element name';
491: -- NEED TO ACCOUNT FOR PROJECT AND TASK LEVEL ROWS THAT ARE USER-ENTERED

Line 532: from pa_resource_list_members

528: select nvl(parent_member_id, -99),
529: resource_list_id
530: into l_res_parent_member_id,
531: l_resource_list_id
532: from pa_resource_list_members
533: where resource_list_member_id = p_resource_list_member_id;
534: if l_res_parent_member_id = -99 then
535: -- resource is RESOURCE list
536: -- get RESOURCE GROUP NAME

Line 545: from pa_resource_list_members

541: where resource_list_id = l_resource_list_id;
542: */
543: select alias
544: into l_return_value
545: from pa_resource_list_members
546: where resource_list_member_id = p_resource_list_member_id;
547: else
548: -- resource is RESOURCE child
549: -- get RESOURCE CHILD NAME

Line 552: from pa_resource_list_members

548: -- resource is RESOURCE child
549: -- get RESOURCE CHILD NAME
550: select alias
551: into l_return_value
552: from pa_resource_list_members
553: where resource_list_member_id = p_resource_list_member_id;
554: end if; -- res_parent_member_id is null
555: end if; -- p_resource_list_member_id=0
556: end if;

Line 572: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

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:
576: BEGIN

Line 573: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

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:
576: BEGIN
577: l_return_value := 'dummy element level';

Line 601: from pa_resource_list_members

597: select nvl(parent_member_id, -99),
598: resource_list_id
599: into l_res_parent_member_id,
600: l_resource_list_id
601: from pa_resource_list_members
602: where resource_list_member_id = p_resource_list_member_id;
603: if l_res_parent_member_id = -99 then
604: -- resource is RESOURCE list
605: l_return_value := 'RESOURCE_LIST';

Line 637: l_resource_name pa_resource_list_members.alias%TYPE;

633: p_element_type IN VARCHAR2)
634: return VARCHAR2
635: is
636: l_return_value VARCHAR2(80);
637: l_resource_name pa_resource_list_members.alias%TYPE;
638: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
639: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
640: BEGIN
641: l_return_value := '';

Line 638: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

634: return VARCHAR2
635: is
636: l_return_value VARCHAR2(80);
637: l_resource_name pa_resource_list_members.alias%TYPE;
638: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
639: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
640: BEGIN
641: l_return_value := '';
642: if p_element_type = 'TASK' then

Line 639: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

635: is
636: l_return_value VARCHAR2(80);
637: l_resource_name pa_resource_list_members.alias%TYPE;
638: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
639: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
640: BEGIN
641: l_return_value := '';
642: if p_element_type = 'TASK' then
643: if p_task_id > 0 then

Line 657: from pa_resource_list_members

653: resource_list_id
654: into l_resource_name,
655: l_res_parent_member_id,
656: l_resource_list_id
657: from pa_resource_list_members
658: where resource_list_member_id = p_resource_list_member_id;
659: if p_element_type = 'RESOURCE' then
660: -- make sure that the element is a resource (ie. has a parent member)
661: if l_res_parent_member_id > 0 then

Line 4983: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

4979:
4980: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
4981: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
4982: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4983: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4984: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4985: l_version_type pa_budget_versions.version_type%TYPE;
4986: l_resource_level VARCHAR2(1); -- used to store temp value of return variable
4987: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

Line 5073: from pa_resource_list_members

5069: end;
5070: if nvl(l_prj_rlm_id,0) > 0 then
5071: select decode(parent_member_id,null,'G','R')
5072: into x_resource_level
5073: from pa_resource_list_members
5074: where resource_list_member_id = l_prj_rlm_id;
5075: end if;
5076: else
5077: /*** NOT PROJECT-LEVEL PLANNING ***/