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

Line 35: ,resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE

31: --INSERT indicates that the target resource assignment has to be inserted . UPDATE indicates that the target
32: --resource assignment already exists.Bug 3678314
33: TYPE res_assmt_map_rec IS RECORD
34: (task_id pa_tasks.task_id%TYPE
35: ,resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE
36: ,resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE
37: ,ra_dml_code VARCHAR2(30));
38:
39: TYPE res_assmt_map_rec_tbl_type IS TABLE OF res_assmt_map_rec

Line 3337: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

3333: )
3334: RETURN NUMBER IS
3335: l_index NUMBER;
3336: l_task_id pa_tasks.task_id%TYPE;
3337: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3338: BEGIN
3339: IF p_resource_assignment_id IS NULL AND p_fin_plan_level_code IS NULL THEN
3340:
3341: l_task_id:=p_task_id;

Line 3382: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

3378: )
3379: RETURN VARCHAR2 IS
3380: l_index NUMBER;
3381: l_task_id pa_tasks.task_id%TYPE;
3382: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3383:
3384: BEGIN
3385: IF p_resource_assignment_id IS NULL AND p_fin_plan_level_code IS NULL THEN
3386:

Line 3905: l_targ_delta_amt_adj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

3901: l_retain_manual_lines_flag VARCHAR2(1);
3902:
3903: -- Start of variables declared for bug 4035856
3904: l_src_delta_amt_adj_task_id pa_tasks.task_id%TYPE;
3905: l_targ_delta_amt_adj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3906: l_src_delta_amt_adj_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
3907: l_src_delta_amt_adj_start_date pa_budget_lines.start_date%TYPE;
3908: l_pc_revenue_delta pa_budget_lines.project_revenue%TYPE;
3909: l_pfc_revenue_delta pa_budget_lines.revenue%TYPE;

Line 3915: l_src_dummy2 pa_resource_list_members.alias%TYPE;

3911: l_pfc_rev_merged pa_budget_lines.revenue%TYPE;
3912: l_pc_rev_for_merge pa_budget_lines.project_revenue%TYPE;
3913: l_pfc_rev_for_merge pa_budget_lines.revenue%TYPE;
3914: l_src_dummy1 number;
3915: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3916: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3917: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3918: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3919: l_agreement_id pa_agreements_all.agreement_id%TYPE;

Line 3940: FROM pa_resource_assignments pra, pa_resource_list_members rlm

3936: CURSOR src_delta_amt_adj_ra_cur
3937: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3938: SELECT pra.task_id, pra.resource_list_member_id, pra.resource_assignment_id,
3939: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3940: FROM pa_resource_assignments pra, pa_resource_list_members rlm
3941: WHERE pra.budget_version_id = c_budget_version_id
3942: AND rlm.resource_list_member_id = pra.resource_list_member_id
3943: AND EXISTS (SELECT 1
3944: FROM pa_budget_lines pbl

Line 3955: FROM pa_resource_assignments pra, pa_resource_list_members rlm,pa_res_list_map_tmp4 tmp4

3951: CURSOR src_delta_amt_adj_ra_cur1
3952: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3953: SELECT pra.task_id, tmp4.resource_list_member_id, pra.resource_assignment_id,
3954: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3955: FROM pa_resource_assignments pra, pa_resource_list_members rlm,pa_res_list_map_tmp4 tmp4
3956: WHERE pra.budget_version_id = c_budget_version_id
3957: AND pra.resource_assignment_id=tmp4.txn_source_id
3958: AND rlm.resource_list_member_id = tmp4.resource_list_member_id
3959: AND EXISTS (SELECT 1