[Home] [Help]
29: 08/05/05 raluthra Bug 4527617. Replaced fnd_user.customer_id with
30: fnd_user.person_party_id for R12 ATG Mandate fix.
31: 08/05/05 raluthra Bug 4358517: Changed the definition of
32: l_org local variable from VARCHAR2(60) to
33: pa_project_lists_v.carrying_out_organization_name%TYPE
34: 08/09/05 raluthra Bug 4565156. Added code for Manual NOCOPY Changes
35: for usage of same variable for In and Out parameter.
36: 06/02/06 posingha Bug 4940945 Changed the query to base tables instead of view
37: to improve performance.
699: l_err_stack VARCHAR2(240);
700: l_customer VARCHAR2(4000);
701: l_project_manager VARCHAR2(240);
702: l_project VARCHAR2(500);
703: l_org pa_project_lists_v.carrying_out_organization_name%TYPE; -- Bug 4358517.
704: l_report_type_name VARCHAR2(80);
705: l_url2 VARCHAR2(600);
706: l_project_id NUMBER;
707: l_report_start_date DATE;
731: pplv.carrying_out_organization_name,
732: pplv.name || '(' || pplv.segment1 || ')',
733: prt.name,
734: pplv.project_id
735: FROM pa_project_lists_v pplv, pa_object_page_layouts popl, pa_report_types prt
736: WHERE pplv.project_id = popl.object_id
737: AND popl.object_page_layout_id = p_object_id
738: AND popl.object_type = 'PA_PROJECTS'
739: and nvl(popl.report_type_id, 1) = prt.report_type_id
2487:
2488: CURSOR get_project_info(l_project_id number) IS
2489: SELECT
2490: /* Changed the query to base tables pa_projects_all and hr_all_organization_units instead of view
2491: pa_project_lists_v to improve performance. Bug :4940945 */
2492: ppa.name,
2493: PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(PPA.PROJECT_ID) customer_name,
2494: --project_type,
2495: --to_char(project_value) as project_value,