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

Line 339: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

335: -- FPM Dev CR 3
336: l_record_version_number NUMBER;
337: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
338: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
339: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
340: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
341:
342: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648
343: l_etc_effort_this_period NUMBER;--Bug 3595585

Line 340: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

336: l_record_version_number NUMBER;
337: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
338: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
339: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
340: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
341:
342: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648
343: l_etc_effort_this_period NUMBER;--Bug 3595585
344: l_last_submitted_etc_effort NUMBER;--Bug 3595585

Line 6989: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

6985: l_as_of_date date;
6986:
6987: l_task_ver_id_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6988: l_planned_effort_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6989: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
6990: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
6991:
6992: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6993: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 6990: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

6986:
6987: l_task_ver_id_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6988: l_planned_effort_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6989: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
6990: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
6991:
6992: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6993: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6994:

Line 6999: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

6995: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6996: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6997: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6998: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6999: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7000: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7001: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7002: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7003: l_currency_code_tbl_assgn SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 7000: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

6996: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6997: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6998: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6999: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7000: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7001: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7002: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7003: l_currency_code_tbl_assgn SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
7004:

Line 7030: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

7026: l_version_enabled_flag VARCHAR2(1) := null;
7027:
7028: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7029: l_struture_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7030: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7031:
7032: l_res_assign_id_out NUMBER := null;
7033: l_task_version_id_out NUMBER := null;
7034: l_txn_curr_code_out VARCHAR2(15) := null;

Line 8894: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type() ;

8890: L_SHARING_ENABLED VARCHAR2(1) ;
8891: L_SPLIT_WORKPLAN VARCHAR2(1) ;
8892: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;
8893: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;
8894: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type() ;
8895: -- Bug 3722011 End
8896:
8897: -- BEGIN: Code to fix Bug # 3821106.
8898:

Line 12911: proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();

12907: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
12908: latest_wp_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
12909: res_list_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
12910: proj_org_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
12911: proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
12912: calendar_type_tbl SYSTEM.pa_varchar2_1_tbl_type:= SYSTEM.pa_varchar2_1_tbl_type();
12913: proj_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();
12914: proj_func_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();
12915: proj_pgm_level_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 12930: skip_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();

12926: l_skip_exception Exception;
12927: l_pji_wp_exception Exception;
12928: skip_proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
12929: skip_latest_wp_str_ver_id_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
12930: skip_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
12931: /* End: Fix for Bug # 5526638. */
12932:
12933: cursor max_as_of_Date is
12934: select max(date_computed) from pa_percent_completes ppc

Line 21114: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

21110: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21111: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
21112: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21113: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21114: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21115: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21116: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21117: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
21118: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()

Line 21128: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

21124: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
21125: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
21126: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type()
21127: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type()
21128: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21129: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21130: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21131: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21132: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

Line 21129: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

21125: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
21126: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type()
21127: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type()
21128: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21129: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21130: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21131: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21132: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21133: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

Line 21130: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

21126: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type()
21127: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type()
21128: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21129: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21130: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21131: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21132: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21133: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21134: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 21131: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

21127: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type()
21128: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21129: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21130: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21131: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21132: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21133: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21134: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21135: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 21132: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

21128: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21129: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21130: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21131: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21132: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21133: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21134: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21135: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21136: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 21133: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

21129: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21130: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21131: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21132: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21133: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
21134: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21135: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21136: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
21137: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 21211: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();

21207: L_SPLIT_WORKPLAN VARCHAR2(1);
21208: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
21209: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
21210: l_struture_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
21211: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
21212: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
21213: l_wp_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
21214: l_fin_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
21215: l_object_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();