APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_FP_RES_ASSIGNMENTS_TMP

Line 2383: INSERT INTO pa_fp_res_assignments_tmp

2379:
2380: IF NVL(l_return_status,'S') = 'S' Then
2381: print_msg(p_pa_debug_mode,'populate_res_details','populating res assignments tmp');
2382: FORALL i IN p_resource_list_member_Id_tab.FIRST .. p_resource_list_member_Id_tab.LAST
2383: INSERT INTO pa_fp_res_assignments_tmp
2384: (project_id
2385: ,budget_version_id
2386: ,resource_assignment_id
2387: ,resource_list_member_id

Line 2438: UPDATE pa_fp_res_assignments_tmp TMP

2434: ;
2435:
2436: /* Now Update the tmp table with rates and currencys passed */
2437: FORALL i IN p_resource_list_member_Id_tab.FIRST .. p_resource_list_member_Id_tab.LAST
2438: UPDATE pa_fp_res_assignments_tmp TMP
2439: SET tmp.txn_currency_code = p_txn_currency_code_tab(i)
2440: ,txn_currency_code_override = p_txn_currency_code_ovr_tab(i)
2441: ,rw_cost_rate_override = p_cost_rate_override_tab(i)
2442: ,burden_cost_rate_override = p_burden_rate_override_tab(i)

Line 2487: INSERT INTO pa_fp_res_assignments_tmp

2483: x_return_status := 'S';
2484: IF p_resource_assignment_id_tab.COUNT > 0 Then
2485: print_msg(p_pa_debug_mode,'populate_ra_details','bulk insert to res_assignments_tmp table');
2486: FORALL i IN p_resource_assignment_id_tab.FIRST .. p_resource_assignment_id_tab.LAST
2487: INSERT INTO pa_fp_res_assignments_tmp
2488: (project_id
2489: ,budget_version_id
2490: ,resource_assignment_id
2491: ,resource_list_member_id

Line 2821: FROM pa_fp_res_assignments_tmp tmp

2817: ,NVL(tmp.billable_flag,'N') billable_flag
2818: ,to_number(null) budget_line_id
2819: ,tmp.task_name
2820: ,tmp.resource_name
2821: FROM pa_fp_res_assignments_tmp tmp
2822: WHERE tmp.budget_version_id = NVL(p_budget_version_id,-9999)
2823: ORDER BY tmp.rbs_element_id ; /* added this to ensure that In and Out plsql table indexes are mapped */
2824:
2825: l_txn_currency_code Varchar2(100);

Line 2879: DELETE FROM PA_FP_RES_ASSIGNMENTS_TMP;

2875: l_stage := l_stage||' SourceContext['||p_source_context||']';
2876: print_msg(l_debug_flag,l_proc_name,l_stage);
2877:
2878: /* Initialize tmp tables */
2879: DELETE FROM PA_FP_RES_ASSIGNMENTS_TMP;
2880: DELETE FROM PA_FP_ROLLUP_TMP;
2881:
2882: /* Validate Input Params */
2883: l_resource_assignment_id_tab := p_resource_assignment_id_tab;

Line 3038: UPDATE pa_fp_res_assignments_tmp tmp

3034: IF l_return_status = 'S' Then
3035: l_stage := '15: Update tmp table with task level details';
3036: print_msg(l_debug_flag,l_proc_name,l_stage);
3037: /* update the task details */
3038: UPDATE pa_fp_res_assignments_tmp tmp
3039: SET (tmp.task_bill_rate_org_id ---non_labor_bill_rate_org_id
3040: ,tmp.task_sch_discount ---non_labor_schedule_discount
3041: ,tmp.task_sch_date ---non_labor_schedule_fixed_date
3042: ,tmp.task_std_bill_rate_sch ---non_lab_std_bill_rt_sch_id