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_WEBADI_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 606: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;

602: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
603: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
604: l_row_id ROWID;
605: ll_error_flag VARCHAR2(1);
606: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
607: l_dummy_res_list_id NUMBER;
608: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;
609: l_dummy_id NUMBER;
610: l_return_status VARCHAR2(1);

Line 643: from pa_resource_list_members

639: Begin
640:
641: Select resource_list_member_id
642: into l_rlm_id_gp
643: from pa_resource_list_members
644: where resource_list_id = l_resource_list_id
645: and parent_member_id is NULL
646: and alias = p_resource_group_name;
647:

Line 661: FROM pa_resource_list_members

657:
658: -- 4497318.Perf Fix.An AND condition is added in the WHERE clause.
659: SELECT count(*)
660: INTO l_dummy_id
661: FROM pa_resource_list_members
662: WHERE resource_list_id = l_resource_list_id
663: AND parent_member_id = l_rlm_id_gp
664: AND rownum=1;
665:

Line 677: from pa_resource_list_members

673: Begin
674:
675: Select resource_list_member_id
676: into l_rlm_id_alias
677: from pa_resource_list_members
678: where resource_list_id = l_resource_list_id
679: and parent_member_id = l_rlm_id_gp
680: and alias = p_resource_alias;
681:

Line 700: from pa_resource_list_members

696: Begin
697:
698: Select resource_list_member_id
699: into l_rlm_id_alias
700: from pa_resource_list_members
701: where resource_list_id = l_resource_list_id
702: and alias = p_resource_alias;
703:
704: Exception

Line 738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895

734: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
735: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
736: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895
737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
740: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895
741: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE --File.Sql.39 bug 4440895
742: ,x_resource_id OUT NOCOPY pa_resource_list_members.resource_id%TYPE --File.Sql.39 bug 4440895

Line 739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895

735: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
736: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895
737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
740: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895
741: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE --File.Sql.39 bug 4440895
742: ,x_resource_id OUT NOCOPY pa_resource_list_members.resource_id%TYPE --File.Sql.39 bug 4440895
743: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 741: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE --File.Sql.39 bug 4440895

737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
740: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895
741: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE --File.Sql.39 bug 4440895
742: ,x_resource_id OUT NOCOPY pa_resource_list_members.resource_id%TYPE --File.Sql.39 bug 4440895
743: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
744: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
745: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 742: ,x_resource_id OUT NOCOPY pa_resource_list_members.resource_id%TYPE --File.Sql.39 bug 4440895

738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
740: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895
741: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE --File.Sql.39 bug 4440895
742: ,x_resource_id OUT NOCOPY pa_resource_list_members.resource_id%TYPE --File.Sql.39 bug 4440895
743: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
744: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
745: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
746: IS

Line 773: ,pa_resource_list_members prlm

769: ,prlm.resource_list_member_id
770: ,prlm.resource_id
771: FROM pa_tasks pt
772: ,pa_resource_assignments pra
773: ,pa_resource_list_members prlm
774: ,pa_resource_list_members prlm_parent
775: ,pa_resource_lists_all_bg prl
776: WHERE pra.resource_assignment_id = c_resource_assignment_id
777: AND pra.project_id = pt.project_id

Line 774: ,pa_resource_list_members prlm_parent

770: ,prlm.resource_id
771: FROM pa_tasks pt
772: ,pa_resource_assignments pra
773: ,pa_resource_list_members prlm
774: ,pa_resource_list_members prlm_parent
775: ,pa_resource_lists_all_bg prl
776: WHERE pra.resource_assignment_id = c_resource_assignment_id
777: AND pra.project_id = pt.project_id
778: AND pra.task_id = pt.task_id

Line 797: ,pa_resource_list_members prlm

793: ,pra.parent_assignment_id
794: ,prlm.resource_list_member_id
795: ,prlm.resource_id
796: FROM pa_resource_assignments pra
797: ,pa_resource_list_members prlm
798: ,pa_resource_list_members prlm_parent
799: ,pa_resource_lists_all_bg prl
800: WHERE pra.resource_assignment_id = c_resource_assignment_id
801: AND prlm.resource_list_member_id = pra.resource_list_member_id

Line 798: ,pa_resource_list_members prlm_parent

794: ,prlm.resource_list_member_id
795: ,prlm.resource_id
796: FROM pa_resource_assignments pra
797: ,pa_resource_list_members prlm
798: ,pa_resource_list_members prlm_parent
799: ,pa_resource_lists_all_bg prl
800: WHERE pra.resource_assignment_id = c_resource_assignment_id
801: AND prlm.resource_list_member_id = pra.resource_list_member_id
802: AND prl.resource_list_id = prlm.resource_list_id