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 396: x_planning_start_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,

392: p_old_task_sch_finish IN DATE DEFAULT NULL,
393: p_new_task_sch_start IN DATE,
394: p_new_task_sch_finish IN DATE,
395: x_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
396: x_planning_start_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
397: x_planning_end_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
398: x_return_status OUT NOCOPY VARCHAR2
399: )
400:

Line 397: x_planning_end_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,

393: p_new_task_sch_start IN DATE,
394: p_new_task_sch_finish IN DATE,
395: x_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
396: x_planning_start_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
397: x_planning_end_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
398: x_return_status OUT NOCOPY VARCHAR2
399: )
400:
401: IS

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

412: l_finish_flg_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
413: k number;
414: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
415: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
416: l_schedule_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
417: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
418: l_delay_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
419: l_duration_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
420: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

413: k number;
414: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
415: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
416: l_schedule_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
417: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
418: l_delay_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
419: l_duration_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
420: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
421: l_new_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

416: l_schedule_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
417: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
418: l_delay_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
419: l_duration_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
420: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
421: l_new_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
422: l_resource_rec_tbl l_resource_rec_tbl_type;
423: l_task_rec task_rec_type;
424: l_msg_data VARCHAR2(4000);

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

417: l_schedule_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
418: l_delay_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
419: l_duration_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
420: l_new_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
421: l_new_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
422: l_resource_rec_tbl l_resource_rec_tbl_type;
423: l_task_rec task_rec_type;
424: l_msg_data VARCHAR2(4000);
425: l_msg_count NUMBER;

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

423: l_task_rec task_rec_type;
424: l_msg_data VARCHAR2(4000);
425: l_msg_count NUMBER;
426: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
427: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
428: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
429: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
430: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
431: l_num_of_tasks NUMBER;

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

424: l_msg_data VARCHAR2(4000);
425: l_msg_count NUMBER;
426: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
427: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
428: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
429: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
430: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
431: l_num_of_tasks NUMBER;
432: l_db_block_size NUMBER;

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

425: l_msg_count NUMBER;
426: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
427: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
428: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
429: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
430: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
431: l_num_of_tasks NUMBER;
432: l_db_block_size NUMBER;
433: l_num_blocks NUMBER;

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

426: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
427: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
428: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
429: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
430: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
431: l_num_of_tasks NUMBER;
432: l_db_block_size NUMBER;
433: l_num_blocks NUMBER;
434:

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

502:
503: IF l_num_of_tasks > 0 THEN
504:
505: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE() ;
506: x_planning_start_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;
507: x_planning_end_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;
508:
509: OPEN get_bvid;
510: FETCH get_bvid into l_budget_ver_id, l_struct_ver_id;

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

503: IF l_num_of_tasks > 0 THEN
504:
505: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE() ;
506: x_planning_start_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;
507: x_planning_end_tbl := SYSTEM.PA_DATE_TBL_TYPE() ;
508:
509: OPEN get_bvid;
510: FETCH get_bvid into l_budget_ver_id, l_struct_ver_id;
511: CLOSE get_bvid;

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

1410: lr_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1411: lr_financial_category_code_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1412: lr_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1413: lr_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1414: lr_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1415: lr_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1416: lr_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1417: lr_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1418: lr_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1411: lr_financial_category_code_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1412: lr_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1413: lr_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1414: lr_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1415: lr_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1416: lr_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1417: lr_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1418: lr_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1419: lr_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1417: lr_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1418: lr_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1419: lr_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1420: lr_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1421: lr_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1422: lr_financial_category_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1423: lr_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1424: --End of variables for Variable for Resource Attributes
1425:

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

2717: l_ta_named_role_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
2718: l_ta_role_in_format_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2719: -- \Bug 4097749.
2720: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2722: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2723: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2724: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2725: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

2718: l_ta_role_in_format_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2719: -- \Bug 4097749.
2720: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2722: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2723: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2724: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2725: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

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

2719: -- \Bug 4097749.
2720: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2722: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2723: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2724: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2725: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2727: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

2720: l_ta_wbs_elem_ver_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_ta_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2722: l_ta_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2723: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2724: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2725: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2727: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2728: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

2723: l_ta_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2724: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2725: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2727: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2728: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2729: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2730: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2731: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

2724: l_ta_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2725: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2727: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2728: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2729: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2730: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2731: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

2725: l_ta_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2727: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2728: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2729: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2730: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2731: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2733: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

2726: l_ta_display_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2727: l_t_src_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2728: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2729: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2730: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2731: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2733: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2734: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

2728: l_t_src_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2729: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2730: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2731: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2733: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2734: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2735: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2736: l_c_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

2729: l_t_target_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2730: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2731: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2733: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2734: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2735: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2736: l_c_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2737: l_src_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

2730: l_t_target_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2731: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2733: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2734: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2735: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2736: l_c_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2737: l_src_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2738:

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

2731: l_c_resource_assgt_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_c_schedule_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2733: l_c_schedule_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2734: l_c_planning_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2735: l_c_planning_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2736: l_c_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2737: l_src_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2738:
2739: l_src_resource_list_id NUMBER;

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

2797: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2798:
2799: l_element_version_index NUMBER;
2800: -- NEW plsql table to hold the ordered src date
2801: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2802: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2803: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2804: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2805: l_t_src_elem_ver_id NUMBER;

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

2798:
2799: l_element_version_index NUMBER;
2800: -- NEW plsql table to hold the ordered src date
2801: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2802: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2803: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2804: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2805: l_t_src_elem_ver_id NUMBER;
2806: l_t_src_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

2799: l_element_version_index NUMBER;
2800: -- NEW plsql table to hold the ordered src date
2801: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2802: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2803: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2804: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2805: l_t_src_elem_ver_id NUMBER;
2806: l_t_src_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2807: l_t_target_elem_ver_id NUMBER;

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

2800: -- NEW plsql table to hold the ordered src date
2801: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2802: l_adj_src_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2803: l_adj_tar_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2804: l_adj_tar_t_end_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2805: l_t_src_elem_ver_id NUMBER;
2806: l_t_src_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2807: l_t_target_elem_ver_id NUMBER;
2808: l_t_target_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();