DBA Data[Home] [Help]

APPS.PA_MASS_ASGMT_TRX dependencies on PA_PROJECT_LISTS_V

Line 788: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;

784: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
789: l_project_customer pa_project_lists_v.customer_name%TYPE;
790: l_project_manager pa_project_lists_v.person_name%TYPE;
791: l_err_code VARCHAR2(2000);
792: l_err_stage VARCHAR2(2000);

Line 789: l_project_customer pa_project_lists_v.customer_name%TYPE;

785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
789: l_project_customer pa_project_lists_v.customer_name%TYPE;
790: l_project_manager pa_project_lists_v.person_name%TYPE;
791: l_err_code VARCHAR2(2000);
792: l_err_stage VARCHAR2(2000);
793: l_err_stack VARCHAR2(2000);

Line 790: l_project_manager pa_project_lists_v.person_name%TYPE;

786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
789: l_project_customer pa_project_lists_v.customer_name%TYPE;
790: l_project_manager pa_project_lists_v.person_name%TYPE;
791: l_err_code VARCHAR2(2000);
792: l_err_stage VARCHAR2(2000);
793: l_err_stack VARCHAR2(2000);
794: l_return_status VARCHAR2(1);

Line 1045: -- FROM pa_project_lists_v proj

1041: -- l_project_number,
1042: -- l_project_organization,
1043: -- l_project_manager,
1044: -- l_project_customer
1045: -- FROM pa_project_lists_v proj
1046: -- WHERE project_id = l_project_id;
1047:
1048: -- Added for Perf fix 4918687 SQL ID 14910543
1049: SELECT proj.name,

Line 1309: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;

1305: l_success_assignments NUMBER;
1306: l_failure_assignments NUMBER;
1307: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1308: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1309: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1310: l_project_customer pa_project_lists_v.customer_name%TYPE;
1311: l_project_manager pa_project_lists_v.person_name%TYPE;
1312: l_err_code VARCHAR2(2000);
1313: l_err_stage VARCHAR2(2000);

Line 1310: l_project_customer pa_project_lists_v.customer_name%TYPE;

1306: l_failure_assignments NUMBER;
1307: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1308: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1309: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1310: l_project_customer pa_project_lists_v.customer_name%TYPE;
1311: l_project_manager pa_project_lists_v.person_name%TYPE;
1312: l_err_code VARCHAR2(2000);
1313: l_err_stage VARCHAR2(2000);
1314: l_err_stack VARCHAR2(2000);

Line 1311: l_project_manager pa_project_lists_v.person_name%TYPE;

1307: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1308: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1309: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1310: l_project_customer pa_project_lists_v.customer_name%TYPE;
1311: l_project_manager pa_project_lists_v.person_name%TYPE;
1312: l_err_code VARCHAR2(2000);
1313: l_err_stage VARCHAR2(2000);
1314: l_err_stack VARCHAR2(2000);
1315: l_return_status VARCHAR2(1);