[Home] [Help]
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;
2884: l_resource_list_member_Id_tab := p_resource_list_member_Id_tab;
3539: /*** Not required as re arrangig the plsql indexes
3540: IF l_rowid_tab.COUNT > 0 Then
3541: l_stage := 'Inserting rate api values into rollup tmp table';
3542: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
3543: INSERT INTO pa_fp_rollup_tmp tmp
3544: (resource_assignment_id
3545: ,system_reference1
3546: ,txn_currency_code
3547: ,cost_rate