255: IF (task_rec.tpid IS NULL) THEN
256: -- This will be the case for Project Level funding and Project
257: -- Level assignment.
258: -- Do not have to change this stmt for MCB, because user is going to select from the
259: -- view pa_billing_extn_params_v ( all the newly added columns in pa_billing_assignments table)
260:
261: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
262: get_rec.proc_name || '(' || to_char(x_project_id) ||
263: ','''',''' || x_calling_process ||
496: it will be data issue */
497: BEGIN
498: SELECT default_cost_plan_type_id,default_rev_plan_type_id
499: INTO l_cost_plan_type_id,l_rev_plan_type_id
500: FROM pa_billing_extn_params_v;
501: EXCEPTION
502: WHEN OTHERS THEN
503: IF g1_debug_mode = 'Y' THEN
504: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);
500: FROM pa_billing_extn_params_v;
501: EXCEPTION
502: WHEN OTHERS THEN
503: IF g1_debug_mode = 'Y' THEN
504: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);
505: END IF;
506: RAISE;
507: END;
508: /* till here */