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: l_res_parent_member_id := -99; /* Added for 7514054 */
277: if p_task_id = 0 then
278: -- resource is direct descendant of the project

Line 330: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

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

Line 331: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

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

Line 392: from pa_resource_list_members

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

Line 413: from pa_resource_list_members

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

Line 446: from pa_resource_list_members

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

Line 467: from pa_resource_list_members

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

Line 488: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

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

Line 489: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

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

Line 534: from pa_resource_list_members

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

Line 547: from pa_resource_list_members

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

Line 554: from pa_resource_list_members

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

Line 574: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

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

Line 575: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

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

Line 603: from pa_resource_list_members

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

Line 639: l_resource_name pa_resource_list_members.alias%TYPE;

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

Line 640: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

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

Line 641: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

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

Line 659: from pa_resource_list_members

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

Line 5153: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

5149:
5150: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
5151: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
5152: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
5153: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
5154: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5155: l_version_type pa_budget_versions.version_type%TYPE;
5156: l_resource_level VARCHAR2(1); -- used to store temp value of return variable
5157: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

Line 5243: from pa_resource_list_members

5239: end;
5240: if nvl(l_prj_rlm_id,0) > 0 then
5241: select decode(parent_member_id,null,'G','R')
5242: into x_resource_level
5243: from pa_resource_list_members
5244: where resource_list_member_id = l_prj_rlm_id;
5245: end if;
5246: else
5247: /*** NOT PROJECT-LEVEL PLANNING ***/