[Home] [Help]
314: hr_utility.trace('budget ver id '||p_budget_version_id) ; */
315:
316: --dbms_output.put_line('No. of rows inserted in tmp1 : '|| sql%rowcount);
317:
318: INSERT INTO PA_FP_CALC_AMT_TMP2
319: (resource_assignment_id,
320: txn_currency_code,
321: total_plan_quantity,
322: total_txn_raw_cost,
470: WHERE ra.budget_version_id = l_source_bv_id);
471:
472: --dbms_output.put_line('No. of rows inserted in tmp1 : '|| sql%rowcount);
473:
474: INSERT INTO PA_FP_CALC_AMT_TMP2
475: (resource_assignment_id,
476: txn_currency_code,
477: total_plan_quantity,
478: total_txn_raw_cost,
629: AND v.proj_element_id = ra.task_id);
630:
631: --dbms_output.put_line('No. of rows inserted in tmp1 : '|| sql%rowcount);
632:
633: INSERT INTO PA_FP_CALC_AMT_TMP2
634: (resource_assignment_id,
635: txn_currency_code,
636: total_plan_quantity,
637: total_txn_raw_cost,
1180: END LOOP;
1181:
1182: /* bulk insert */
1183: FORALL m IN 1..l_res_asn_id_tab.count
1184: INSERT INTO pa_fp_calc_amt_tmp2
1185: (resource_assignment_id,
1186: total_pc_raw_cost,
1187: total_pc_burdened_cost,
1188: total_pc_revenue,
1209: INTO x_txn_amt_rec.quantity_sum,
1210: x_txn_amt_rec.txn_raw_cost_sum,
1211: x_txn_amt_rec.txn_burdened_cost_sum,
1212: x_txn_amt_rec.txn_revenue_sum
1213: FROM pa_fp_calc_amt_tmp2;
1214: */
1215: IF p_pa_debug_mode = 'Y' THEN
1216: PA_DEBUG.Reset_Curr_Function;
1217: END IF;
1314: LAST_UPDATE_LOGIN = l_last_update_login
1315: WHERE budget_version_id = p_budget_version_id
1316: and (resource_assignment_id,txn_currency_code) in
1317: (select target_res_asg_id,etc_currency_code
1318: from PA_FP_CALC_AMT_TMP2
1319: where transaction_source_code = 'ETC');
1320: -- Above and clause added for bug 4247647 ...
1321:
1322: IF p_pa_debug_mode = 'Y' THEN