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 3320: from pa_tasks pt

3316: l_temp := l_src_targ_task_tbl.COUNT +1;
3317: l_src_targ_task_tbl(l_temp).key:=p_task_id;
3318: select decode(p_planning_level, 'P',0,'T',pt.top_task_id, pt.task_id)
3319: into l_src_targ_task_tbl(l_temp).value
3320: from pa_tasks pt
3321: where pt.task_id = p_task_id;
3322:
3323: IF P_PA_DEBUG_MODE='Y' THEN
3324: 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 3336: l_task_id pa_tasks.task_id%TYPE;

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

Line 3381: l_task_id pa_tasks.task_id%TYPE;

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

Line 3904: l_src_delta_amt_adj_task_id pa_tasks.task_id%TYPE;

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