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 1355: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

1351: l_context varchar2(200);
1352: l_calling_module varchar2(200);
1353: l_struct_elem_version_id number;
1354: l_budget_version_id number;
1355: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1356: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1357: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1358: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1359: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();

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

1352: l_calling_module varchar2(200);
1353: l_struct_elem_version_id number;
1354: l_budget_version_id number;
1355: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1356: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1357: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1358: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1359: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
1360: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();

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

1353: l_struct_elem_version_id number;
1354: l_budget_version_id number;
1355: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1356: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1357: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1358: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1359: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
1360: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
1361: l_start_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();

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

1354: l_budget_version_id number;
1355: lk_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1356: lk_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1357: l_task_elem_version_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1358: l_resource_list_member_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1359: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
1360: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
1361: l_start_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
1362: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();

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

1359: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
1360: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
1361: l_start_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
1362: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
1363: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1364: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1365: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1366: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1367: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

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

1360: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
1361: l_start_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
1362: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
1363: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1364: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1365: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1366: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1367: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1368: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();

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

1362: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
1363: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1364: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1365: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1366: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1367: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1368: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1369: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1370: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

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

1363: l_planned_people_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1364: l_planned_equip_effort_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1365: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1366: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1367: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1368: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1369: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1370: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1371: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

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

1365: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
1366: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1367: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1368: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1369: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1370: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1371: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1372: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

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

1366: l_project_assignment_id_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1367: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1368: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1369: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1370: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1371: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1372: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

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

1367: l_quantity_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1368: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1369: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1370: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1371: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1372: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

1368: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1369: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1370: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1371: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1372: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
1376: l_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.

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

1369: l_raw_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1370: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1371: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1372: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
1376: l_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.
1377: l_attribute_category_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

1370: l_burdened_cost_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1371: l_revenue_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1372: l_cost_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1373: l_bill_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1374: l_burdened_rate_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1375: l_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
1376: l_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.
1377: l_attribute_category_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
1378: l_attribute1 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();

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

1405: l_attribute28 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1406: l_attribute29 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1407: l_attribute30 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1408: --Added following two collections for for Bug 3940284
1409: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1410: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1411:
1412: --This table is added for Bug 3948128: TA Delay CR by DHI
1413: l_scheduled_delay_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();

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

1406: l_attribute29 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1407: l_attribute30 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
1408: --Added following two collections for for Bug 3940284
1409: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1410: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1411:
1412: --This table is added for Bug 3948128: TA Delay CR by DHI
1413: l_scheduled_delay_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1414:

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

1409: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1410: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1411:
1412: --This table is added for Bug 3948128: TA Delay CR by DHI
1413: l_scheduled_delay_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1414:
1415: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is
1416: select budget_version_id
1417: from pa_budget_versions

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

3573: l_context varchar2(200);
3574: l_calling_module varchar2(200);
3575: l_struct_elem_version_id number;
3576: l_budget_version_id number;
3577: l_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3578: l_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3579: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3580: l_incur_by_resource_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type() ;
3581: l_incur_by_resource_name_tbl system.pa_varchar2_240_tbl_type :=system.pa_varchar2_240_tbl_type() ;

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

3579: l_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3580: l_incur_by_resource_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type() ;
3581: l_incur_by_resource_name_tbl system.pa_varchar2_240_tbl_type :=system.pa_varchar2_240_tbl_type() ;
3582: l_incur_by_res_class_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type();
3583: lu_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3584: ld_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3585: l_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3586: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3587: l_planning_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();

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

3580: l_incur_by_resource_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type() ;
3581: l_incur_by_resource_name_tbl system.pa_varchar2_240_tbl_type :=system.pa_varchar2_240_tbl_type() ;
3582: l_incur_by_res_class_code_tbl system.pa_varchar2_30_tbl_type :=system.pa_varchar2_30_tbl_type();
3583: lu_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3584: ld_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3585: l_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3586: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3587: l_planning_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3588: l_planning_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();

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

3587: l_planning_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3588: l_planning_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3589:
3590: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3591: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3592: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3593: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3594: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3595: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3588: l_planning_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3589:
3590: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3591: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3592: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3593: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3594: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3595: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3596: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3589:
3590: l_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3591: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3592: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3593: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3594: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3595: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3596: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3597: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3591: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3592: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3593: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3594: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3595: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3596: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3597: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3598: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3599: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3592: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3593: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3594: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3595: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3596: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3597: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3598: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3599: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3600: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3593: l_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3594: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3595: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3596: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3597: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3598: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3599: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3600: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3601: l_resource_class_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

3594: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3595: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3596: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3597: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3598: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3599: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3600: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3601: l_resource_class_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3602: l_resource_alias_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();

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

3595: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3596: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3597: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3598: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3599: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3600: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3601: l_resource_class_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3602: l_resource_alias_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();
3603: l_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

3596: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3597: l_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3598: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3599: lp_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3600: ld_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3601: l_resource_class_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3602: l_resource_alias_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();
3603: l_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3604: l_resource_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

3602: l_resource_alias_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();
3603: l_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3604: l_resource_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3605: l_resource_name system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3606: l_project_role_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3607: l_project_role_name_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3608: l_supplier_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3609: l_supplier_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3610: l_organization_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3604: l_resource_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3605: l_resource_name system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3606: l_project_role_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3607: l_project_role_name_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3608: l_supplier_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3609: l_supplier_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3610: l_organization_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3611: l_organization_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3612: l_fc_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

3606: l_project_role_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3607: l_project_role_name_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3608: l_supplier_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3609: l_supplier_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3610: l_organization_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3611: l_organization_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3612: l_fc_res_type_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3613: l_financial_category_name_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type();
3614: l_named_role_tbl system.pa_varchar2_80_tbl_type := system.pa_varchar2_80_tbl_type() ;

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

3645: l_attribute29_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3646: l_attribute30_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3647: l_description_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3648: l_use_task_schedule_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3649: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3650: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3651: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3652: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3653:

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

3646: l_attribute30_tbl system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3647: l_description_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3648: l_use_task_schedule_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3649: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3650: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3651: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3652: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3653:
3654: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI

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

3647: l_description_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3648: l_use_task_schedule_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3649: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3650: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3651: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3652: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3653:
3654: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3655:

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

3648: l_use_task_schedule_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3649: l_raw_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3650: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3651: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3652: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3653:
3654: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3655:
3656: --For create.

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

3650: l_burd_cost_rate_override_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3651: l_billable_work_percent_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3652: l_mfc_cost_type_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3653:
3654: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3655:
3656: --For create.
3657: lc_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3658: lc_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();

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

3653:
3654: l_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3655:
3656: --For create.
3657: lc_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3658: lc_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3659: lc_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3660: lc_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3661: lc_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();

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

3658: lc_task_name_tbl system.pa_varchar2_240_tbl_type := system.pa_varchar2_240_tbl_type();
3659: lc_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3660: lc_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3661: lc_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3662: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3663: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3664: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3665: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3666: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3659: lc_task_number_tbl system.pa_varchar2_100_tbl_type := system.pa_varchar2_100_tbl_type();
3660: lc_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3661: lc_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3662: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3663: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3664: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3665: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3666: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3667: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3661: lc_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
3662: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3663: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3664: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3665: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3666: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3667: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3668: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3669: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3662: lc_planned_people_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3663: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3664: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3665: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3666: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3667: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3668: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3669: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3670: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3663: lc_planned_equip_effort_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3664: lc_latest_eff_pub_flag_tbl system.pa_varchar2_1_tbl_type := system.pa_varchar2_1_tbl_type();
3665: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3666: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3667: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3668: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3669: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3670: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3671: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3665: lc_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3666: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3667: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3668: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3669: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3670: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3671: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3672: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3673: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3666: lc_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3667: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3668: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3669: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3670: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3671: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3672: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3673: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3674: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3667: lc_quantity_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3668: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3669: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3670: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3671: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3672: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3673: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3674: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3675: lc_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();

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

3668: lc_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
3669: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3670: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3671: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3672: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3673: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3674: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3675: lc_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3676: lc_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.

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

3669: lc_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3670: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3671: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3672: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3673: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3674: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3675: lc_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3676: lc_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.
3677: -- l_attribute_category_tbl system.pa_varchar2_30_tbl_type;

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

3670: lc_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3671: lc_revenue_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3672: lc_cost_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3673: lc_bill_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3674: lc_burdened_rate_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3675: lc_product_code_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type();
3676: lc_product_reference_tbl system.pa_varchar2_30_tbl_type := system.pa_varchar2_30_tbl_type(); --incorrect to change to 25.
3677: -- l_attribute_category_tbl system.pa_varchar2_30_tbl_type;
3678: lc_attribute1 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();

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

3705: lc_attribute28 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3706: lc_attribute29 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3707: lc_attribute30 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3708:
3709: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3710:
3711: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3712: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3713: -- l_cost_rate_tbl system.pa_num_tbl_type;

Line 3711: -- l_planned_people_effort_tbl system.pa_num_tbl_type;

3707: lc_attribute30 system.pa_varchar2_150_tbl_type := system.pa_varchar2_150_tbl_type();
3708:
3709: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3710:
3711: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3712: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3713: -- l_cost_rate_tbl system.pa_num_tbl_type;
3714: -- l_bill_rate_tbl system.pa_num_tbl_type;
3715: -- l_burdened_rate_tbl system.pa_num_tbl_type;

Line 3712: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;

3708:
3709: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3710:
3711: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3712: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3713: -- l_cost_rate_tbl system.pa_num_tbl_type;
3714: -- l_bill_rate_tbl system.pa_num_tbl_type;
3715: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3716:

Line 3713: -- l_cost_rate_tbl system.pa_num_tbl_type;

3709: lc_scheduled_delay_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();--Bug 3948128: TA Delay CR by DHI
3710:
3711: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3712: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3713: -- l_cost_rate_tbl system.pa_num_tbl_type;
3714: -- l_bill_rate_tbl system.pa_num_tbl_type;
3715: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3716:
3717: --Added following two collections for for Bug 3940284

Line 3714: -- l_bill_rate_tbl system.pa_num_tbl_type;

3710:
3711: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3712: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3713: -- l_cost_rate_tbl system.pa_num_tbl_type;
3714: -- l_bill_rate_tbl system.pa_num_tbl_type;
3715: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3716:
3717: --Added following two collections for for Bug 3940284
3718: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 3715: -- l_burdened_rate_tbl system.pa_num_tbl_type;

3711: -- l_planned_people_effort_tbl system.pa_num_tbl_type;
3712: -- l_planned_equip_effort_tbl system.pa_num_tbl_type;
3713: -- l_cost_rate_tbl system.pa_num_tbl_type;
3714: -- l_bill_rate_tbl system.pa_num_tbl_type;
3715: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3716:
3717: --Added following two collections for for Bug 3940284
3718: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3719: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

3714: -- l_bill_rate_tbl system.pa_num_tbl_type;
3715: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3716:
3717: --Added following two collections for for Bug 3940284
3718: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3719: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3720:
3721: none_resource_list_flag varchar2(1);
3722:

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

3715: -- l_burdened_rate_tbl system.pa_num_tbl_type;
3716:
3717: --Added following two collections for for Bug 3940284
3718: l_delete_task_res_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3719: l_delete_task_elem_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3720:
3721: none_resource_list_flag varchar2(1);
3722:
3723: CURSOR C_Check_Res_List_None (c_resource_list_id IN NUMBER) IS