APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_FP_RES_ASSIGNMENTS_TMP

Line 2390: INSERT INTO pa_fp_res_assignments_tmp

2386:
2387: IF NVL(l_return_status,'S') = 'S' Then
2388: print_msg(p_pa_debug_mode,'populate_res_details','populating res assignments tmp');
2389: FORALL i IN p_resource_list_member_Id_tab.FIRST .. p_resource_list_member_Id_tab.LAST
2390: INSERT INTO pa_fp_res_assignments_tmp
2391: (project_id
2392: ,budget_version_id
2393: ,resource_assignment_id
2394: ,resource_list_member_id

Line 2445: UPDATE pa_fp_res_assignments_tmp TMP

2441: ;
2442:
2443: /* Now Update the tmp table with rates and currencys passed */
2444: FORALL i IN p_resource_list_member_Id_tab.FIRST .. p_resource_list_member_Id_tab.LAST
2445: UPDATE pa_fp_res_assignments_tmp TMP
2446: SET tmp.txn_currency_code = p_txn_currency_code_tab(i)
2447: ,txn_currency_code_override = p_txn_currency_code_ovr_tab(i)
2448: ,rw_cost_rate_override = p_cost_rate_override_tab(i)
2449: ,burden_cost_rate_override = p_burden_rate_override_tab(i)

Line 2494: INSERT INTO pa_fp_res_assignments_tmp

2490: x_return_status := 'S';
2491: IF p_resource_assignment_id_tab.COUNT > 0 Then
2492: print_msg(p_pa_debug_mode,'populate_ra_details','bulk insert to res_assignments_tmp table');
2493: FORALL i IN p_resource_assignment_id_tab.FIRST .. p_resource_assignment_id_tab.LAST
2494: INSERT INTO pa_fp_res_assignments_tmp
2495: (project_id
2496: ,budget_version_id
2497: ,resource_assignment_id
2498: ,resource_list_member_id

Line 2828: FROM pa_fp_res_assignments_tmp tmp

2824: ,NVL(tmp.billable_flag,'N') billable_flag
2825: ,to_number(null) budget_line_id
2826: ,tmp.task_name
2827: ,tmp.resource_name
2828: FROM pa_fp_res_assignments_tmp tmp
2829: WHERE tmp.budget_version_id = NVL(p_budget_version_id,-9999)
2830: ORDER BY tmp.rbs_element_id ; /* added this to ensure that In and Out plsql table indexes are mapped */
2831:
2832: l_txn_currency_code Varchar2(100);

Line 2886: DELETE FROM PA_FP_RES_ASSIGNMENTS_TMP;

2882: l_stage := l_stage||' SourceContext['||p_source_context||']';
2883: print_msg(l_debug_flag,l_proc_name,l_stage);
2884:
2885: /* Initialize tmp tables */
2886: DELETE FROM PA_FP_RES_ASSIGNMENTS_TMP;
2887: DELETE FROM PA_FP_ROLLUP_TMP;
2888:
2889: /* Validate Input Params */
2890: l_resource_assignment_id_tab := p_resource_assignment_id_tab;

Line 3045: UPDATE pa_fp_res_assignments_tmp tmp

3041: IF l_return_status = 'S' Then
3042: l_stage := '15: Update tmp table with task level details';
3043: print_msg(l_debug_flag,l_proc_name,l_stage);
3044: /* update the task details */
3045: UPDATE pa_fp_res_assignments_tmp tmp
3046: SET (tmp.task_bill_rate_org_id ---non_labor_bill_rate_org_id
3047: ,tmp.task_sch_discount ---non_labor_schedule_discount
3048: ,tmp.task_sch_date ---non_labor_schedule_fixed_date
3049: ,tmp.task_std_bill_rate_sch ---non_lab_std_bill_rt_sch_id