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 2693: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

2689: )
2690: RETURN NUMBER IS
2691: l_index NUMBER;
2692: l_task_id pa_tasks.task_id%TYPE;
2693: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2694: BEGIN
2695: IF p_resource_assignment_id IS NULL AND p_fin_plan_level_code IS NULL THEN
2696:
2697: l_task_id:=p_task_id;

Line 2738: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

2734: )
2735: RETURN VARCHAR2 IS
2736: l_index NUMBER;
2737: l_task_id pa_tasks.task_id%TYPE;
2738: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2739:
2740: BEGIN
2741: IF p_resource_assignment_id IS NULL AND p_fin_plan_level_code IS NULL THEN
2742:

Line 3265: l_targ_delta_amt_adj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

3261: l_retain_manual_lines_flag VARCHAR2(1);
3262:
3263: -- Start of variables declared for bug 4035856
3264: l_src_delta_amt_adj_task_id pa_tasks.task_id%TYPE;
3265: l_targ_delta_amt_adj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3266: l_src_delta_amt_adj_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
3267: l_src_delta_amt_adj_start_date pa_budget_lines.start_date%TYPE;
3268: l_pc_revenue_delta pa_budget_lines.project_revenue%TYPE;
3269: l_pfc_revenue_delta pa_budget_lines.revenue%TYPE;

Line 3275: l_src_dummy2 pa_resource_list_members.alias%TYPE;

3271: l_pfc_rev_merged pa_budget_lines.revenue%TYPE;
3272: l_pc_rev_for_merge pa_budget_lines.project_revenue%TYPE;
3273: l_pfc_rev_for_merge pa_budget_lines.revenue%TYPE;
3274: l_src_dummy1 number;
3275: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3276: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3277: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3278: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3279: l_agreement_id pa_agreements_all.agreement_id%TYPE;

Line 3300: FROM pa_resource_assignments pra, pa_resource_list_members rlm

3296: CURSOR src_delta_amt_adj_ra_cur
3297: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3298: SELECT pra.task_id, pra.resource_list_member_id, pra.resource_assignment_id,
3299: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3300: FROM pa_resource_assignments pra, pa_resource_list_members rlm
3301: WHERE pra.budget_version_id = c_budget_version_id
3302: AND rlm.resource_list_member_id = pra.resource_list_member_id
3303: AND EXISTS (SELECT 1
3304: FROM pa_budget_lines pbl

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

3311: CURSOR src_delta_amt_adj_ra_cur1
3312: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3313: SELECT pra.task_id, tmp4.resource_list_member_id, pra.resource_assignment_id,
3314: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3315: FROM pa_resource_assignments pra, pa_resource_list_members rlm,pa_res_list_map_tmp4 tmp4
3316: WHERE pra.budget_version_id = c_budget_version_id
3317: AND pra.resource_assignment_id=tmp4.txn_source_id
3318: AND rlm.resource_list_member_id = tmp4.resource_list_member_id
3319: AND EXISTS (SELECT 1