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

Line 3443: pa_resource_list_members prlms,

3439: ,pra.txn_accum_header_id
3440: ,scheduled_delay --For Bug 3948128
3441: ,pra.CBS_ELEMENT_ID -- bug#16200605
3442: FROM PA_RESOURCE_ASSIGNMENTS pra,
3443: pa_resource_list_members prlms,
3444: pa_resource_list_members prlmt
3445: WHERE pra.budget_version_id = p_source_plan_version_id
3446: AND prlms.resource_list_member_id=pra.resource_list_member_id
3447: AND prlms.resource_list_id=l_resource_list_id

Line 3444: pa_resource_list_members prlmt

3440: ,scheduled_delay --For Bug 3948128
3441: ,pra.CBS_ELEMENT_ID -- bug#16200605
3442: FROM PA_RESOURCE_ASSIGNMENTS pra,
3443: pa_resource_list_members prlms,
3444: pa_resource_list_members prlmt
3445: WHERE pra.budget_version_id = p_source_plan_version_id
3446: AND prlms.resource_list_member_id=pra.resource_list_member_id
3447: AND prlms.resource_list_id=l_resource_list_id
3448: AND prlms.object_id=l_source_project_id

Line 3722: pa_resource_list_members prlms,

3718: UNION ALL
3719: SELECT 0 source_task_id,
3720: 0 target_task_id
3721: FROM dual) pelm,
3722: pa_resource_list_members prlms,
3723: pa_resource_list_members prlmt
3724: WHERE pra.budget_version_id = p_source_plan_version_id
3725: AND prlms.resource_list_member_id=pra.resource_list_member_id
3726: AND prlms.resource_list_id=l_resource_list_id

Line 3723: pa_resource_list_members prlmt

3719: SELECT 0 source_task_id,
3720: 0 target_task_id
3721: FROM dual) pelm,
3722: pa_resource_list_members prlms,
3723: pa_resource_list_members prlmt
3724: WHERE pra.budget_version_id = p_source_plan_version_id
3725: AND prlms.resource_list_member_id=pra.resource_list_member_id
3726: AND prlms.resource_list_id=l_resource_list_id
3727: AND prlms.object_id=l_source_project_id

Line 4016: organiztion_id is null in the pa_resource_list_members we are overriding

4012: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults and use the new
4013: attributes. But organization_id is the only column which is depending
4014: on the project when the resource format contains job and doesn't contain organization_id.
4015: So for all resource assignments with resource format having job in workplan if the
4016: organiztion_id is null in the pa_resource_list_members we are overriding
4017: with current project carrying_out_organization_id.
4018: */
4019: IF p_calling_context='WORKPLAN' THEN
4020:

Line 4033: pa_resource_list_members prlm

4029: set organization_id=l_project_org
4030: where resource_assignment_id in
4031: (select pra.resource_assignment_id
4032: from pa_resource_assignments pra,
4033: pa_resource_list_members prlm
4034: where pra.budget_version_id=p_target_plan_version_id
4035: and pra.resource_list_member_id=prlm.resource_list_member_id
4036: and pra.job_id = prlm.job_id
4037: and prlm.organization_id is null);

Line 10118: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10114: --End of variables used for debugging
10115:
10116: l_resource_list_change_flag VARCHAR2(1);
10117: l_rbs_version_change_flag VARCHAR2(1);
10118: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10119: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10120: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10121: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10122:

Line 10119: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10115:
10116: l_resource_list_change_flag VARCHAR2(1);
10117: l_rbs_version_change_flag VARCHAR2(1);
10118: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10119: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10120: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10121: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10122:
10123: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10120: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10116: l_resource_list_change_flag VARCHAR2(1);
10117: l_rbs_version_change_flag VARCHAR2(1);
10118: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10119: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10120: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10121: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10122:
10123: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10124: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10121: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10117: l_rbs_version_change_flag VARCHAR2(1);
10118: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10119: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10120: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10121: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10122:
10123: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10124: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10125: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();