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_ASSIGNMENT_UTILS dependencies on PA_DATE_TBL_TYPE

Line 461: x_planning_start_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,

457: p_old_task_sch_finish IN DATE DEFAULT NULL,
458: p_new_task_sch_start IN DATE,
459: p_new_task_sch_finish IN DATE,
460: x_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
461: x_planning_start_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
462: x_planning_end_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
463: x_return_status OUT NOCOPY VARCHAR2
464: )
465:

Line 462: x_planning_end_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,

458: p_new_task_sch_start IN DATE,
459: p_new_task_sch_finish IN DATE,
460: x_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
461: x_planning_start_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
462: x_planning_end_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
463: x_return_status OUT NOCOPY VARCHAR2
464: )
465:
466: IS

Line 481: l_schedule_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

477: l_finish_flg_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
478: k number;
479: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
480: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
481: l_schedule_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
482: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
483: l_delay_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
484: l_duration_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
485: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 482: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

478: k number;
479: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
480: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
481: l_schedule_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
482: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
483: l_delay_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
484: l_duration_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
485: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
486: l_new_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 485: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

481: l_schedule_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
482: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
483: l_delay_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
484: l_duration_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
485: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
486: l_new_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
487: l_resource_rec_tbl l_resource_rec_tbl_type;
488: l_task_rec task_rec_type;
489: l_msg_data VARCHAR2(4000);

Line 486: l_new_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

482: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
483: l_delay_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
484: l_duration_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
485: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
486: l_new_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
487: l_resource_rec_tbl l_resource_rec_tbl_type;
488: l_task_rec task_rec_type;
489: l_msg_data VARCHAR2(4000);
490: l_msg_count NUMBER;

Line 492: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

488: l_task_rec task_rec_type;
489: l_msg_data VARCHAR2(4000);
490: l_msg_count NUMBER;
491: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
492: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
493: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
494: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
495: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
496: l_num_of_tasks NUMBER;

Line 493: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

489: l_msg_data VARCHAR2(4000);
490: l_msg_count NUMBER;
491: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
492: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
493: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
494: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
495: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
496: l_num_of_tasks NUMBER;
497: l_db_block_size NUMBER;

Line 494: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

490: l_msg_count NUMBER;
491: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
492: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
493: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
494: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
495: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
496: l_num_of_tasks NUMBER;
497: l_db_block_size NUMBER;
498: l_num_blocks NUMBER;

Line 495: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

491: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
492: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
493: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
494: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
495: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
496: l_num_of_tasks NUMBER;
497: l_db_block_size NUMBER;
498: l_num_blocks NUMBER;
499:

Line 571: x_planning_start_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;

567:
568: IF l_num_of_tasks > 0 THEN
569:
570: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE() ;
571: x_planning_start_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;
572: x_planning_end_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;
573:
574: OPEN get_bvid;
575: FETCH get_bvid into l_budget_ver_id, l_struct_ver_id;

Line 572: x_planning_end_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;

568: IF l_num_of_tasks > 0 THEN
569:
570: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE() ;
571: x_planning_start_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;
572: x_planning_end_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;
573:
574: OPEN get_bvid;
575: FETCH get_bvid into l_budget_ver_id, l_struct_ver_id;
576: CLOSE get_bvid;

Line 1522: lr_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1518: lr_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1519: lr_financial_category_code_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1520: lr_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1521: lr_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1522: lr_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1523: lr_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1524: lr_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1525: lr_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1526: lr_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1523: lr_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1519: lr_financial_category_code_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1520: lr_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1521: lr_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1522: lr_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1523: lr_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1524: lr_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1525: lr_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1526: lr_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1527: lr_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1529: lr_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1525: lr_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1526: lr_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1527: lr_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1528: lr_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1529: lr_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1530: lr_financial_category_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1531: lr_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1532: --End of variables for Variable for Resource Attributes
1533:

Line 2836: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2832: l_ta_named_role_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
2833: l_ta_role_in_format_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2834: -- \Bug 4097749.
2835: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2836: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2837: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2838: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2839: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2840: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2837: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2833: l_ta_role_in_format_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2834: -- \Bug 4097749.
2835: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2836: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2837: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2838: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2839: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2840: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2841: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 2838: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2834: -- \Bug 4097749.
2835: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2836: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2837: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2838: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2839: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2840: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2841: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2842: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2839: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2835: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2836: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2837: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2838: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2839: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2840: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2841: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2842: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2843: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2842: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2838: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2839: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2840: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2841: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2842: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2843: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2844: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2845: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2846: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2843: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2839: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2840: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2841: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2842: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2843: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2844: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2845: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2846: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2847: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2844: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2840: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2841: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2842: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2843: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2844: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2845: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2846: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2847: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2848: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2845: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2841: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2842: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2843: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2844: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2845: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2846: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2847: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2848: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2849: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2847: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2843: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2844: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2845: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2846: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2847: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2848: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2849: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2850: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2851: l_c_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2848: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2844: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2845: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2846: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2847: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2848: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2849: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2850: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2851: l_c_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2852: l_src_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2849: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2845: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2846: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2847: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2848: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2849: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2850: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2851: l_c_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2852: l_src_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2853:

Line 2850: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2846: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2847: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2848: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2849: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2850: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2851: l_c_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2852: l_src_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2853:
2854: l_src_resource_list_id NUMBER;

Line 2916: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2912: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2913:
2914: l_element_version_index NUMBER;
2915: -- NEW plsql table to hold the ordered src date
2916: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2917: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2918: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2919: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2920: l_t_src_elem_ver_id NUMBER;

Line 2917: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2913:
2914: l_element_version_index NUMBER;
2915: -- NEW plsql table to hold the ordered src date
2916: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2917: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2918: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2919: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2920: l_t_src_elem_ver_id NUMBER;
2921: l_t_src_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2918: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2914: l_element_version_index NUMBER;
2915: -- NEW plsql table to hold the ordered src date
2916: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2917: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2918: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2919: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2920: l_t_src_elem_ver_id NUMBER;
2921: l_t_src_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2922: l_t_target_elem_ver_id NUMBER;

Line 2919: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2915: -- NEW plsql table to hold the ordered src date
2916: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2917: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2918: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2919: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2920: l_t_src_elem_ver_id NUMBER;
2921: l_t_src_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2922: l_t_target_elem_ver_id NUMBER;
2923: l_t_target_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();