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 3435: pa_resource_list_members prlms,

3431: ,pra.named_role
3432: ,pra.txn_accum_header_id
3433: ,scheduled_delay --For Bug 3948128
3434: FROM PA_RESOURCE_ASSIGNMENTS pra,
3435: pa_resource_list_members prlms,
3436: pa_resource_list_members prlmt
3437: WHERE pra.budget_version_id = p_source_plan_version_id
3438: AND prlms.resource_list_member_id=pra.resource_list_member_id
3439: AND prlms.resource_list_id=l_resource_list_id

Line 3436: pa_resource_list_members prlmt

3432: ,pra.txn_accum_header_id
3433: ,scheduled_delay --For Bug 3948128
3434: FROM PA_RESOURCE_ASSIGNMENTS pra,
3435: pa_resource_list_members prlms,
3436: pa_resource_list_members prlmt
3437: WHERE pra.budget_version_id = p_source_plan_version_id
3438: AND prlms.resource_list_member_id=pra.resource_list_member_id
3439: AND prlms.resource_list_id=l_resource_list_id
3440: AND prlms.object_id=l_source_project_id

Line 3712: pa_resource_list_members prlms,

3708: UNION ALL
3709: SELECT 0 source_task_id,
3710: 0 target_task_id
3711: FROM dual) pelm,
3712: pa_resource_list_members prlms,
3713: pa_resource_list_members prlmt
3714: WHERE pra.budget_version_id = p_source_plan_version_id
3715: AND prlms.resource_list_member_id=pra.resource_list_member_id
3716: AND prlms.resource_list_id=l_resource_list_id

Line 3713: pa_resource_list_members prlmt

3709: SELECT 0 source_task_id,
3710: 0 target_task_id
3711: FROM dual) pelm,
3712: pa_resource_list_members prlms,
3713: pa_resource_list_members prlmt
3714: WHERE pra.budget_version_id = p_source_plan_version_id
3715: AND prlms.resource_list_member_id=pra.resource_list_member_id
3716: AND prlms.resource_list_id=l_resource_list_id
3717: AND prlms.object_id=l_source_project_id

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

4000: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults and use the new
4001: attributes. But organization_id is the only column which is depending
4002: on the project when the resource format contains job and doesn't contain organization_id.
4003: So for all resource assignments with resource format having job in workplan if the
4004: organiztion_id is null in the pa_resource_list_members we are overriding
4005: with current project carrying_out_organization_id.
4006: */
4007: IF p_calling_context='WORKPLAN' THEN
4008:

Line 4021: pa_resource_list_members prlm

4017: set organization_id=l_project_org
4018: where resource_assignment_id in
4019: (select pra.resource_assignment_id
4020: from pa_resource_assignments pra,
4021: pa_resource_list_members prlm
4022: where pra.budget_version_id=p_target_plan_version_id
4023: and pra.resource_list_member_id=prlm.resource_list_member_id
4024: and pra.job_id = prlm.job_id
4025: and prlm.organization_id is null);

Line 10091: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10087: --End of variables used for debugging
10088:
10089: l_resource_list_change_flag VARCHAR2(1);
10090: l_rbs_version_change_flag VARCHAR2(1);
10091: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10092: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10093: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10094: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10095:

Line 10092: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10088:
10089: l_resource_list_change_flag VARCHAR2(1);
10090: l_rbs_version_change_flag VARCHAR2(1);
10091: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10092: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10093: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10094: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10095:
10096: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10093: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10089: l_resource_list_change_flag VARCHAR2(1);
10090: l_rbs_version_change_flag VARCHAR2(1);
10091: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10092: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10093: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10094: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10095:
10096: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10097: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10094: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10090: l_rbs_version_change_flag VARCHAR2(1);
10091: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10092: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10093: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10094: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10095:
10096: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10097: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10098: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();