396: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
397: IS
398: CURSOR c1 IS
399: SELECT opportunity_value, opp_value_currency_code, projfunc_opp_value, projfunc_opp_rate_type, projfunc_opp_rate_date, project_opp_value, project_opp_rate_type, project_opp_rate_date
400: FROM pa_project_opp_attrs
401: WHERE project_id = p_source_project_id;
402:
403: v_c1 c1%ROWTYPE;
404:
519: p_ei_date => v_c1.expected_approval_date,
520: p_gl_date => sysdate,
521: p_org_id => v_c1.org_id);
522: -- Convert pa_projects_all.project_value to prject_currency_code and
523: -- store it in pa_project_opp_attrs.project_opp_value.
524: -- Bug: 4537865
525:
526: l_tmp_number := l_dummy_number ;
527: l_new1_dummy_number := l_tmp_number;