DBA Data[Home] [Help]

APPS.PA_MASS_ASGMT_TRX dependencies on PA_PROJECT_LISTS_V

Line 790: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;

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);

Line 791: l_project_customer pa_project_lists_v.customer_name%TYPE;

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);

Line 792: l_project_manager pa_project_lists_v.person_name%TYPE;

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);

Line 1101: -- FROM pa_project_lists_v proj

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,

Line 1366: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;

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);

Line 1367: l_project_customer pa_project_lists_v.customer_name%TYPE;

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);

Line 1368: l_project_manager pa_project_lists_v.person_name%TYPE;

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);