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

Line 116: l_rlm_alias pa_resource_list_members.alias%TYPE;

112: l_progress_exists varchar2(1);
113:
114: l_task_elem_version_id NUMBER;
115: l_task_name pa_proj_elements.name%TYPE;
116: l_rlm_alias pa_resource_list_members.alias%TYPE;
117:
118: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,
119: p_task_id in NUMBER,
120: p_project_id IN NUMBER) IS

Line 166: from pa_resource_list_members

162: L_FuncProc varchar2(2000);
163:
164: CURSOR get_resource_alias(c_resource_list_member_id IN NUMBER) IS
165: SELECT alias
166: from pa_resource_list_members
167: where resource_list_member_id = c_resource_list_member_id;
168:
169: CURSOR get_task_name(c_task_id NUMBER) IS
170: SELECT NAME

Line 181: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

177: p_project_id IN NUMBER,
178: p_wbs_version_id IN NUMBER,
179: p_resource_list_member_id IN NUMBER ) IS
180: Select a.alias, b.resource_assignment_id
181: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
182: where a.resource_list_member_id = b.resource_list_member_id
183: and b.resource_list_member_id = p_resource_list_member_id
184: and b.ta_display_flag = 'Y'
185: and b.budget_version_id = bv.budget_version_id

Line 1528: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE

1524: ( p_project_id IN PA_PROJECTS_ALL.project_id%TYPE
1525: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
1526: ,p_scheduled_start IN DATE
1527: ,p_scheduled_end IN DATE
1528: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
1529: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE
1530: ,p_unplanned_flag IN PA_RESOURCE_ASSIGNMENTS.unplanned_flag%TYPE
1531: ,x_resource_assignment_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint
1532: ,x_task_version_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint

Line 1529: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE

1525: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
1526: ,p_scheduled_start IN DATE
1527: ,p_scheduled_end IN DATE
1528: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
1529: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE
1530: ,p_unplanned_flag IN PA_RESOURCE_ASSIGNMENTS.unplanned_flag%TYPE
1531: ,x_resource_assignment_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint
1532: ,x_task_version_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint
1533: ,x_resource_list_member_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint

Line 2024: p_rlm_alias IN pa_resource_list_members.alias%TYPE,

2020: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2021: p_accounted_period_type IN gl_periods.period_type%TYPE,
2022: p_pa_period_type IN gl_periods.period_type%TYPE,
2023: p_task_name IN pa_proj_elements.name%TYPE,
2024: p_rlm_alias IN pa_resource_list_members.alias%TYPE,
2025: P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, -- 4537865
2026: P_PERIOD_START_DATE IN OUT NOCOPY DATE, -- 4537865
2027: P_PERIOD_END_DATE IN OUT NOCOPY DATE, -- 4537865
2028: x_return_status OUT NOCOPY VARCHAR2