eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_NUM_TBL_TYPE

Line 1372: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1368: l_context varchar2(200);
1369: l_calling_module varchar2(200);
1370: l_struct_elem_version_id number;
1371: l_budget_version_id number;
1372: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1376: l_cbs_element_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type(); -- Added for 16598322

Line 1373: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1369: l_calling_module varchar2(200);
1370: l_struct_elem_version_id number;
1371: l_budget_version_id number;
1372: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1376: l_cbs_element_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type(); -- Added for 16598322
1377: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();

Line 1374: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1370: l_struct_elem_version_id number;
1371: l_budget_version_id number;
1372: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1376: l_cbs_element_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type(); -- Added for 16598322
1377: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
1378: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();

Line 1375: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1371: l_budget_version_id number;
1372: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1376: l_cbs_element_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type(); -- Added for 16598322
1377: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
1378: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
1379: l_start_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();

Line 1376: l_cbs_element_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type(); -- Added for 16598322

1372: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1376: l_cbs_element_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type(); -- Added for 16598322
1377: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
1378: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
1379: l_start_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
1380: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();

Line 1381: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1377: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
1378: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
1379: l_start_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
1380: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
1381: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1382: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1383: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1384: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1385: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

Line 1382: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1378: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
1379: l_start_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
1380: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
1381: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1382: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1383: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1384: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1385: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1386: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();

Line 1384: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1380: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
1381: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1382: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1383: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1384: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1385: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1386: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1387: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

Line 1385: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1381: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1382: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1383: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1384: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1385: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1386: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1387: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1389: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

Line 1387: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1383: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1384: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1385: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1386: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1387: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1389: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1390: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1391: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

Line 1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1384: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1385: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1386: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1387: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1389: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1390: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1391: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1392: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

Line 1389: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1385: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1386: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1387: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1389: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1390: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1391: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1392: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1393: l_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 1390: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1386: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1387: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1389: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1390: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1391: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1392: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1393: l_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
1394: l_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.

Line 1391: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1387: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1389: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1390: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1391: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1392: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1393: l_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
1394: l_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.
1395: l_attribute_category_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 1392: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1388: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1389: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1390: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1391: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1392: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1393: l_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
1394: l_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.
1395: l_attribute_category_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
1396: l_attribute1 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();

Line 1427: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

1423: l_attribute28 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1424: l_attribute29 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1425: l_attribute30 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1426: --Added following two collections for for Bug 3940284
1427: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1428: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1429:
1430: --This table is added for Bug 3948128: TA Delay CR by DHI
1431: l_scheduled_delay_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

Line 1428: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

1424: l_attribute29 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1425: l_attribute30 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1426: --Added following two collections for for Bug 3940284
1427: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1428: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1429:
1430: --This table is added for Bug 3948128: TA Delay CR by DHI
1431: l_scheduled_delay_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1432:

Line 1431: l_scheduled_delay_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1427: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1428: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1429:
1430: --This table is added for Bug 3948128: TA Delay CR by DHI
1431: l_scheduled_delay_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1432:
1433: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is
1434: select budget_version_id
1435: from pa_budget_versions

Line 3820: l_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3816: l_context varchar2(200);
3817: l_calling_module varchar2(200);
3818: l_struct_elem_version_id number;
3819: l_budget_version_id number;
3820: l_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3821: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3822: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3823: l_incur_by_resource_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type() ;
3824: l_incur_by_resource_name_tbl system.pa_varchar2_240_tbl_type :=system.pa_varchar2_240_tbl_type() ;

Line 3826: lu_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3822: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3823: l_incur_by_resource_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type() ;
3824: l_incur_by_resource_name_tbl system.pa_varchar2_240_tbl_type :=system.pa_varchar2_240_tbl_type() ;
3825: l_incur_by_res_class_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type();
3826: lu_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3827: ld_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3828: l_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3829: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3830: l_planning_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();

Line 3827: ld_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3823: l_incur_by_resource_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type() ;
3824: l_incur_by_resource_name_tbl system.pa_varchar2_240_tbl_type :=system.pa_varchar2_240_tbl_type() ;
3825: l_incur_by_res_class_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type();
3826: lu_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3827: ld_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3828: l_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3829: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3830: l_planning_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3831: l_planning_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();

Line 3834: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3830: l_planning_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3831: l_planning_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3832:
3833: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3834: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3835: l_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); -- Added for CBS 16598322
3836: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3837: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3838: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();

Line 3835: l_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); -- Added for CBS 16598322

3831: l_planning_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3832:
3833: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3834: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3835: l_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); -- Added for CBS 16598322
3836: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3837: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3838: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3836: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3832:
3833: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3834: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3835: l_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); -- Added for CBS 16598322
3836: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3837: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3838: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3837: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3833: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3834: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3835: l_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); -- Added for CBS 16598322
3836: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3837: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3838: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3841: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3835: l_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); -- Added for CBS 16598322
3836: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3837: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3838: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3841: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3842: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3843: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3836: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3837: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3838: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3841: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3842: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3843: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3844: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3841: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3837: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3838: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3841: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3842: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3843: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3844: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3845: l_resource_class_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 3842: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3838: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3841: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3842: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3843: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3844: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3845: l_resource_class_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3846: l_resource_alias_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();

Line 3843: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3839: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3841: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3842: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3843: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3844: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3845: l_resource_class_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3846: l_resource_alias_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();
3847: l_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 3844: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3840: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3841: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3842: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3843: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3844: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3845: l_resource_class_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3846: l_resource_alias_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();
3847: l_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3848: l_resource_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 3850: l_project_role_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3846: l_resource_alias_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();
3847: l_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3848: l_resource_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3849: l_resource_name system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3850: l_project_role_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3851: l_project_role_name_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3852: l_supplier_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3853: l_supplier_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3854: l_organization_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3852: l_supplier_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3848: l_resource_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3849: l_resource_name system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3850: l_project_role_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3851: l_project_role_name_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3852: l_supplier_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3853: l_supplier_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3854: l_organization_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3855: l_organization_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3856: l_fc_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 3854: l_organization_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3850: l_project_role_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3851: l_project_role_name_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3852: l_supplier_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3853: l_supplier_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3854: l_organization_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3855: l_organization_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3856: l_fc_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3857: l_financial_category_name_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();
3858: l_named_role_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type() ;

Line 3893: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3889: l_attribute29_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3890: l_attribute30_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3891: l_description_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3892: l_use_task_schedule_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3893: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3894: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3895: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3896: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3897:

Line 3894: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3890: l_attribute30_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3891: l_description_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3892: l_use_task_schedule_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3893: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3894: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3895: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3896: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3897:
3898: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI

Line 3895: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3891: l_description_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3892: l_use_task_schedule_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3893: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3894: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3895: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3896: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3897:
3898: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3899:

Line 3896: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3892: l_use_task_schedule_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3893: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3894: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3895: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3896: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3897:
3898: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3899:
3900: --For create.

Line 3898: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI

3894: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3895: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3896: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3897:
3898: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3899:
3900: --For create.
3901: lc_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3902: lc_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();

Line 3901: lc_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3897:
3898: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3899:
3900: --For create.
3901: lc_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3902: lc_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3903: lc_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3904: lc_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3905: lc_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();

Line 3906: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3902: lc_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3903: lc_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3904: lc_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3905: lc_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3906: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3907: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3908: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3909: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3910: lc_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3907: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3903: lc_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3904: lc_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3905: lc_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3906: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3907: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3908: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3909: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3910: lc_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3911: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3909: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3905: lc_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3906: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3907: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3908: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3909: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3910: lc_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3911: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3912: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3913: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();

Line 3910: lc_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3906: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3907: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3908: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3909: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3910: lc_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3911: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3912: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3913: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3911: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3907: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3908: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3909: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3910: lc_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3911: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3912: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3913: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3912: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3908: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3909: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3910: lc_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3911: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3912: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3913: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3916: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3910: lc_cbs_element_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3911: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3912: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3913: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3916: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3917: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3918: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3911: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3912: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3913: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3916: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3917: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3918: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3919: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3916: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3912: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3913: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3916: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3917: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3918: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3919: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3920: lc_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

Line 3917: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3913: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3916: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3917: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3918: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3919: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3920: lc_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3921: lc_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.

Line 3918: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3914: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3916: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3917: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3918: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3919: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3920: lc_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3921: lc_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.
3922: -- l_attribute_category_tbl system.pa_varchar2_30_tbl_type;

Line 3919: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3915: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3916: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3917: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3918: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3919: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3920: lc_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3921: lc_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.
3922: -- l_attribute_category_tbl system.pa_varchar2_30_tbl_type;
3923: lc_attribute1 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();

Line 3954: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI

3950: lc_attribute28 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3951: lc_attribute29 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3952: lc_attribute30 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3953:
3954: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3955:
3956: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3957: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3958: -- l_cost_rate_tbl system.pa_num_tbl_type;

Line 3956: -- l_planned_people_effort_tbl system.pa_num_tbl_type;

3952: lc_attribute30 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3953:
3954: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3955:
3956: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3957: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3958: -- l_cost_rate_tbl system.pa_num_tbl_type;
3959: -- l_bill_rate_tbl system.pa_num_tbl_type;
3960: -- l_burdened_rate_tbl system.pa_num_tbl_type;

Line 3957: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;

3953:
3954: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3955:
3956: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3957: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3958: -- l_cost_rate_tbl system.pa_num_tbl_type;
3959: -- l_bill_rate_tbl system.pa_num_tbl_type;
3960: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3961:

Line 3958: -- l_cost_rate_tbl system.pa_num_tbl_type;

3954: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3955:
3956: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3957: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3958: -- l_cost_rate_tbl system.pa_num_tbl_type;
3959: -- l_bill_rate_tbl system.pa_num_tbl_type;
3960: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3961:
3962: --Added following two collections for for Bug 3940284

Line 3959: -- l_bill_rate_tbl system.pa_num_tbl_type;

3955:
3956: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3957: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3958: -- l_cost_rate_tbl system.pa_num_tbl_type;
3959: -- l_bill_rate_tbl system.pa_num_tbl_type;
3960: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3961:
3962: --Added following two collections for for Bug 3940284
3963: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3960: -- l_burdened_rate_tbl system.pa_num_tbl_type;

3956: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3957: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3958: -- l_cost_rate_tbl system.pa_num_tbl_type;
3959: -- l_bill_rate_tbl system.pa_num_tbl_type;
3960: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3961:
3962: --Added following two collections for for Bug 3940284
3963: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3964: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3963: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3959: -- l_bill_rate_tbl system.pa_num_tbl_type;
3960: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3961:
3962: --Added following two collections for for Bug 3940284
3963: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3964: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3965:
3966: none_resource_list_flag varchar2(1);
3967: --Added by rbanerje - Bug 8646853 -start

Line 3964: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3960: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3961:
3962: --Added following two collections for for Bug 3940284
3963: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3964: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3965:
3966: none_resource_list_flag varchar2(1);
3967: --Added by rbanerje - Bug 8646853 -start
3968: l_spread_curve_id NUMBER;

Line 3971: l_spread_curve_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

3967: --Added by rbanerje - Bug 8646853 -start
3968: l_spread_curve_id NUMBER;
3969: l_spread_curve_exists VARCHAR2(1);
3970: l_fixed_date DATE;
3971: l_spread_curve_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3972: l_spread_curve_code pa_spread_curves_b.spread_curve_code%TYPE ;
3973: l_fixed_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
3974: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; --8429604
3975: --Bug#8646853 -Addition end