DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 1223: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

1219: ,p_project_id IN Pa_projects_all.project_id%TYPE
1220: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1221: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1222: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1223: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1224: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
1225: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1226: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1227: -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added

Line 1382: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

1378: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1379: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1380: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1381: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1383: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1384: l_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1385: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1386: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 1384: l_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

1380: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1381: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1383: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1384: l_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1385: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1386: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1387: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1388: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1386: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

1382: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1383: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1384: l_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1385: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1386: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1387: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1388: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1389: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1390: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 1402: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

1398: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1399: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1400: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1401: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1402: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1403: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1404: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1405: l_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1406: l_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 5306: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE

5302: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
5303: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
5304: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
5305: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5306: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5307: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
5308: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5309: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5310: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5314: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE

5310: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5311: -- One pl/sql record in The Above tables
5312: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5313: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5314: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5315: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5316: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5317: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5318: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 5322: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537

5318: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5319: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5320: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5321: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5322: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537
5323: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5324: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5325: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5326: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5333: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE

5329: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5330: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5331: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5332: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5333: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5334: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5335: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5336: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 5348: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE

5344: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5345: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5346: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5347: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5348: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5349: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5350: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5351: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5352: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 5372: ,p_supplier_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE

5368: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5369: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5370: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5371: ,p_financial_category_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5372: ,p_supplier_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5373: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5374: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5375: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5376: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE

Line 5443: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

5439: /* Start of variables for Variable for Resource Attributes
5440: */
5441: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5442: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5443: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5444: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
5445: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5446: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5447: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 5463: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

5459: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5460: -- bug 3455288, 19-FEB-04, jwhite: Changed varchar2 length to 240 from 30 --------------------------------
5461: -- l_organization_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5462:
5463: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5464:
5465: -- End, bug 3455288, 19-FEB-04, jwhite: ------------------------------------------------------------------
5466:
5467: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 5480: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

5476: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5477: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5478: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5479: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5480: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5481: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5482: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5483: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5484: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 5497: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

5493: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5494: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5495: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
5496: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
5497: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5498: l_wbs_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5499: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5500: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5501: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 8502: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

8498: p_context IN VARCHAR2
8499: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
8500: ,p_task_or_res IN VARCHAR2 DEFAULT 'TASKS'
8501: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
8502: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
8503: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
8504: ,p_resource_assignment_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
8505: --Introduced for bug 3589130. If this parameter is passed as Y then an error will be thrown
8506: --When its required to delete a resource assignment containing budget lines. This parameter

Line 8503: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

8499: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
8500: ,p_task_or_res IN VARCHAR2 DEFAULT 'TASKS'
8501: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
8502: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
8503: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
8504: ,p_resource_assignment_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
8505: --Introduced for bug 3589130. If this parameter is passed as Y then an error will be thrown
8506: --When its required to delete a resource assignment containing budget lines. This parameter
8507: --will be considered only for BUDGET and FORECAST context

Line 10606: ,p_task_name_tbl => SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

10602: ,p_project_id => p_project_id
10603: ,p_struct_elem_version_id => p_struct_elem_version_id
10604: ,p_budget_version_id => NULL
10605: ,p_task_elem_version_id_tbl => l_element_version_id_tbl
10606: ,p_task_name_tbl => SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
10607: ,p_task_number_tbl => SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
10608: ,p_start_date_tbl => l_planning_start_date_tbl
10609: ,p_end_date_tbl => l_planning_end_date_tbl
10610: ,p_planned_people_effort_tbl => l_planned_people_effort_tbl

Line 11761: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

11757:
11758: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11759: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11760: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11761: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
11762: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
11763: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11764:
11765: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

Line 11762: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

11758: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11759: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11760: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11761: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
11762: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
11763: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11764:
11765: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11766: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;