786: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
789: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
790: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
791: l_project_customer pa_project_lists_v.customer_name%TYPE;
792: l_project_manager pa_project_lists_v.person_name%TYPE;
793: l_err_code VARCHAR2(2000);
794: l_err_stage VARCHAR2(2000);
787: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
789: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
790: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
791: l_project_customer pa_project_lists_v.customer_name%TYPE;
792: l_project_manager pa_project_lists_v.person_name%TYPE;
793: l_err_code VARCHAR2(2000);
794: l_err_stage VARCHAR2(2000);
795: l_err_stack VARCHAR2(2000);
788: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
789: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
790: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
791: l_project_customer pa_project_lists_v.customer_name%TYPE;
792: l_project_manager pa_project_lists_v.person_name%TYPE;
793: l_err_code VARCHAR2(2000);
794: l_err_stage VARCHAR2(2000);
795: l_err_stack VARCHAR2(2000);
796: l_return_status VARCHAR2(1);
1097: -- l_project_number,
1098: -- l_project_organization,
1099: -- l_project_manager,
1100: -- l_project_customer
1101: -- FROM pa_project_lists_v proj
1102: -- WHERE project_id = l_project_id;
1103:
1104: -- Added for Perf fix 4918687 SQL ID 14910543
1105: SELECT proj.name,
1362: l_success_assignments NUMBER;
1363: l_failure_assignments NUMBER;
1364: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1365: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1366: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1367: l_project_customer pa_project_lists_v.customer_name%TYPE;
1368: l_project_manager pa_project_lists_v.person_name%TYPE;
1369: l_err_code VARCHAR2(2000);
1370: l_err_stage VARCHAR2(2000);
1363: l_failure_assignments NUMBER;
1364: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1365: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1366: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1367: l_project_customer pa_project_lists_v.customer_name%TYPE;
1368: l_project_manager pa_project_lists_v.person_name%TYPE;
1369: l_err_code VARCHAR2(2000);
1370: l_err_stage VARCHAR2(2000);
1371: l_err_stack VARCHAR2(2000);
1364: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1365: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1366: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1367: l_project_customer pa_project_lists_v.customer_name%TYPE;
1368: l_project_manager pa_project_lists_v.person_name%TYPE;
1369: l_err_code VARCHAR2(2000);
1370: l_err_stage VARCHAR2(2000);
1371: l_err_stack VARCHAR2(2000);
1372: l_return_status VARCHAR2(1);