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 340: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

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

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

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

7394: l_as_of_date date;
7395:
7396: l_task_ver_id_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7397: l_planned_effort_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7398: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7399: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7400:
7401: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7402: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

7395:
7396: l_task_ver_id_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7397: l_planned_effort_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7398: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7399: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7400:
7401: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7402: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7403:

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

7404: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7409: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7410: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7411: l_cbs_element_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7412: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7409: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7410: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7411: l_cbs_element_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7412: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7413: l_currency_code_tbl_assgn SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

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

7436: l_version_enabled_flag VARCHAR2(1) := null;
7437:
7438: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7439: l_struture_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7440: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7441:
7442: l_res_assign_id_out NUMBER := null;
7443: l_task_version_id_out NUMBER := null;
7444: l_txn_curr_code_out VARCHAR2(15) := null;

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

9308: L_SHARING_ENABLED VARCHAR2(1) ;
9309: L_SPLIT_WORKPLAN VARCHAR2(1) ;
9310: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;
9311: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;
9312: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type() ;
9313: -- Bug 3722011 End
9314:
9315: -- BEGIN: Code to fix Bug # 3821106.
9316:

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

13377: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13378: latest_wp_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13379: res_list_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13380: proj_org_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13381: proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13382: calendar_type_tbl SYSTEM.pa_varchar2_1_tbl_type:= SYSTEM.pa_varchar2_1_tbl_type();
13383: proj_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();
13384: proj_func_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();
13385: proj_pgm_level_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

13397: l_skip_exception Exception;
13398: l_pji_wp_exception Exception;
13399: skip_proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13400: skip_latest_wp_str_ver_id_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13401: skip_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13402: /* End: Fix for Bug # 5526638. */
13403:
13404: cursor max_as_of_Date is
13405: select max(date_computed) from pa_percent_completes ppc

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

22573: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22574: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22576: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22577: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22578: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22579: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22580: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
22581: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()

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

22587: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
22588: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22589: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_4000_tbl_type2 := SYSTEM.pa_varchar2_4000_tbl_type2() /* 9754781 : Changes type */
22590: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_250_tbl_type := SYSTEM.pa_varchar2_250_tbl_type() /* 7709400 : Changed type */
22591: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22592: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22593: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22594: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

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

22588: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22589: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_4000_tbl_type2 := SYSTEM.pa_varchar2_4000_tbl_type2() /* 9754781 : Changes type */
22590: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_250_tbl_type := SYSTEM.pa_varchar2_250_tbl_type() /* 7709400 : Changed type */
22591: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22592: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22593: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22594: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

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

22589: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_4000_tbl_type2 := SYSTEM.pa_varchar2_4000_tbl_type2() /* 9754781 : Changes type */
22590: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_250_tbl_type := SYSTEM.pa_varchar2_250_tbl_type() /* 7709400 : Changed type */
22591: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22592: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22593: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22594: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

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

22590: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_250_tbl_type := SYSTEM.pa_varchar2_250_tbl_type() /* 7709400 : Changed type */
22591: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22592: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22593: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22594: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

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

22591: ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22592: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22593: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22594: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

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

22592: ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22593: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22594: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

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

22670: L_SPLIT_WORKPLAN VARCHAR2(1);
22671: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22672: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22673: l_struture_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22674: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
22675: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22676: l_wp_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22677: l_fin_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22678: l_object_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();