APPS.PA_FP_CI_MERGE dependencies on PA_TASKS

Line 34: (task_id pa_tasks.task_id%TYPE

30: --id corresponding to a task id and resource list member id in the target. ra_dml_code can be either INSERT or UPDATE.
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:

Line 2676: from pa_tasks pt

2672: l_temp := l_src_targ_task_tbl.COUNT +1;
2673: l_src_targ_task_tbl(l_temp).key:=p_task_id;
2674: select decode(p_planning_level, 'P',0,'T',pt.top_task_id, pt.task_id)
2675: into l_src_targ_task_tbl(l_temp).value
2676: from pa_tasks pt
2677: where pt.task_id = p_task_id;
2678:
2679: IF P_PA_DEBUG_MODE='Y' THEN
2680: pa_debug.write('PAFPCIMB.get_task_id','l_src_targ_task_tbl(l_temp).value is '||l_src_targ_task_tbl(l_temp).value,3);

Line 2692: l_task_id pa_tasks.task_id%TYPE;

2688: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%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:

Line 2737: l_task_id pa_tasks.task_id%TYPE;

2733:
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

Line 3264: l_src_delta_amt_adj_task_id pa_tasks.task_id%TYPE;

3260: -- variables introduced for bug 3934574
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;