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

Line 35: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;

31: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
32: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
33:
34: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
35: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;
36: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;
37: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;
38: l_err_code NUMBER;
39: l_err_stage VARCHAR2(100);

Line 36: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;

32: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
33:
34: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
35: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;
36: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;
37: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;
38: l_err_code NUMBER;
39: l_err_stage VARCHAR2(100);
40: l_err_stack VARCHAR2(1000);

Line 264: FROM pa_resource_assignments pra, pa_resource_list_members prlm

260: SELECT resource_assignment_id
261: ,parent_assignment_id
262: ,decode(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_ROLLED_UP,
263: PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,pra.unit_of_measure) unit_of_measure
264: FROM pa_resource_assignments pra, pa_resource_list_members prlm
265: WHERE pra.budget_version_id = p_budget_version_id
266: AND pra.resource_list_member_id = prlm.resource_list_member_id
267: AND prlm.parent_member_id IS NOT NULL
268: AND pra.parent_assignment_id > g_first_ra_id;

Line 287: FROM pa_resource_assignments pra, pa_resource_list_members prlm

283: SELECT resource_assignment_id
284: ,parent_assignment_id
285: ,decode(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_ROLLED_UP,
286: PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,pra.unit_of_measure) unit_of_measure
287: FROM pa_resource_assignments pra, pa_resource_list_members prlm
288: WHERE pra.budget_version_id = p_budget_version_id
289: AND pra.resource_list_member_id = prlm.resource_list_member_id
290: AND prlm.parent_member_id IS NULL
291: AND pra.parent_assignment_id > g_first_ra_id;

Line 807: ,pa_resource_list_members prlm

803: 'HOURS',NULL)) unit_of_measure -- Modified for bug #2697999
804: ,MAX(parent_prlm.track_as_labor_flag) track_as_labor_flag
805: -- Modified for bug #2697999
806: FROM pa_resource_assignments pra
807: ,pa_resource_list_members prlm
808: ,pa_resource_list_members parent_prlm -- Added for bug #2697999
809: WHERE pra.budget_version_id = c_budget_version_id
810: AND pra.resource_list_member_id <> 0
811: AND pra.resource_list_member_id = prlm.resource_list_member_id

Line 808: ,pa_resource_list_members parent_prlm -- Added for bug #2697999

804: ,MAX(parent_prlm.track_as_labor_flag) track_as_labor_flag
805: -- Modified for bug #2697999
806: FROM pa_resource_assignments pra
807: ,pa_resource_list_members prlm
808: ,pa_resource_list_members parent_prlm -- Added for bug #2697999
809: WHERE pra.budget_version_id = c_budget_version_id
810: AND pra.resource_list_member_id <> 0
811: AND pra.resource_list_member_id = prlm.resource_list_member_id
812: AND prlm.parent_member_id = parent_prlm.resource_list_member_id

Line 1713: ,pa_resource_list_members prlm

1709: UPDATE pa_resource_assignments pra1
1710: SET parent_assignment_id =
1711: (SELECT resource_assignment_id
1712: FROM pa_resource_assignments pra2
1713: ,pa_resource_list_members prlm
1714: WHERE pra1.resource_list_member_id = prlm.resource_list_member_id
1715: AND pra1.task_id = pra2.task_id
1716: AND pra2.resource_list_member_id = prlm.parent_member_id
1717: AND pra2.budget_version_id = p_budget_version_id

Line 2548: pa_resource_list_members prlm

2544: ,c_project_id IN NUMBER ) IS --bug#2708524
2545: SELECT pra1.resource_assignment_id child_ra_id , pra2.resource_assignment_id parent_ra_id
2546: FROM pa_resource_assignments pra1,
2547: pa_resource_assignments pra2,
2548: pa_resource_list_members prlm
2549: WHERE pra1.resource_list_member_id = prlm.resource_list_member_id
2550: AND pra2.resource_list_member_id = prlm.parent_member_id
2551: AND pra1.task_id = pra2.task_id
2552: AND pra2.budget_version_id = c_budget_version_id

Line 2577: ,pa_resource_list_members prlm

2573: ,NULL)) unit_of_measure -- Added for bug #2697999
2574: ,max(parent_prlm.track_as_labor_flag) track_as_labor_flag
2575: -- Added for bug #2697999
2576: FROM pa_resource_assignments pra
2577: ,pa_resource_list_members prlm
2578: ,pa_resource_list_members parent_prlm
2579: WHERE pra.project_id = c_project_id --bug#2708524
2580: AND pra.budget_version_id = c_budget_version_id
2581: AND pra.resource_list_member_id <> 0

Line 2578: ,pa_resource_list_members parent_prlm

2574: ,max(parent_prlm.track_as_labor_flag) track_as_labor_flag
2575: -- Added for bug #2697999
2576: FROM pa_resource_assignments pra
2577: ,pa_resource_list_members prlm
2578: ,pa_resource_list_members parent_prlm
2579: WHERE pra.project_id = c_project_id --bug#2708524
2580: AND pra.budget_version_id = c_budget_version_id
2581: AND pra.resource_list_member_id <> 0
2582: AND pra.resource_list_member_id = prlm.resource_list_member_id

Line 2730: FROM pa_resource_assignments pra2, pa_resource_list_members prlm

2726:
2727: /* UPDATE pa_resource_assignments pra1
2728: SET parent_assignment_id =
2729: (SELECT resource_assignment_id
2730: FROM pa_resource_assignments pra2, pa_resource_list_members prlm
2731: WHERE pra1.resource_list_member_id = prlm.resource_list_member_id
2732: AND pra2.resource_list_member_id = prlm.parent_member_id
2733: AND pra1.task_id = pra2.task_id
2734: AND pra2.budget_version_id = p_budget_version_id)

Line 4422: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;

4418: l_return_status VARCHAR2(2000);
4419: l_debug_mode VARCHAR2(30);
4420:
4421: l_task_id pa_tasks.task_id%type;
4422: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
4423:
4424: --Bug # 2615807.
4425: l_project_currency_code pa_projects_all.project_currency_code%type;
4426: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;