4698: x_err_stage := 'copying project level job bill title overrides';
4699:
4700: --Below condition added for selective copy project. Tracking Bug No. 3464332
4701: IF 'Y' = l_fn_cb_overrides_flag THEN
4702: INSERT INTO pa_job_bill_title_overrides (
4703: JOB_ID
4704: , LAST_UPDATE_DATE
4705: , LAST_UPDATED_BY
4706: , CREATION_DATE
4724: start_date_active + x_delta)
4725: , BILLING_TITLE
4726: , x_new_project_id
4727: , null
4728: , pa_job_bill_title_overrides_s.NEXTVAL
4729: , RECORD_VERSION_NUMBER
4730: , decode(x_delta, null, x_completion_date,
4731: end_date_active + x_delta)
4732: FROM
4729: , RECORD_VERSION_NUMBER
4730: , decode(x_delta, null, x_completion_date,
4731: end_date_active + x_delta)
4732: FROM
4733: pa_job_bill_title_overrides
4734: WHERE project_id = x_orig_project_id
4735: and task_id is null;
4736: END IF;
4737: