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_FP_ELEMENTS_PUB dependencies on PA_NUM_TBL_TYPE

Line 3801: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

3797:
3798: --Bug # 3507156 : Patchset M: B and F impact changes : AMG
3799: --Added some variables.
3800: l_context VARCHAR2(30);
3801: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3802: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3803: -- Added for CBS 16598322
3804: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3805: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3802: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

3798: --Bug # 3507156 : Patchset M: B and F impact changes : AMG
3799: --Added some variables.
3800: l_context VARCHAR2(30);
3801: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3802: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3803: -- Added for CBS 16598322
3804: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3805: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3806: /*Bug # 3622551 --Added some parameters */

Line 3804: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

3800: l_context VARCHAR2(30);
3801: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3802: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3803: -- Added for CBS 16598322
3804: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3805: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3806: /*Bug # 3622551 --Added some parameters */
3807:
3808: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;

Line 3805: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

3801: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3802: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3803: -- Added for CBS 16598322
3804: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3805: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3806: /*Bug # 3622551 --Added some parameters */
3807:
3808: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;
3809: l_task_id_tmp_tbl SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();

Line 3809: l_task_id_tmp_tbl SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();

3805: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3806: /*Bug # 3622551 --Added some parameters */
3807:
3808: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;
3809: l_task_id_tmp_tbl SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
3810:
3811:
3812: /*Bug # 3622551 -- Added a join to the cursor to get the value of wbs_element_version_id*/
3813: CURSOR res_assign_cur(c_version_id NUMBER

Line 4162: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

4158: l_plan_version_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4159:
4160: /* PL/SQL table types to be passed to create_res_task_map */
4161:
4162: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4163: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4164: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4165: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4166: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;

Line 4163: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

4159:
4160: /* PL/SQL table types to be passed to create_res_task_map */
4161:
4162: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4163: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4164: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4165: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4166: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4167: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;

Line 4164: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

4160: /* PL/SQL table types to be passed to create_res_task_map */
4161:
4162: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4163: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4164: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4165: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4166: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4167: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4168: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;

Line 4165: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

4161:
4162: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4163: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4164: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4165: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4166: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4167: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4168: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4169: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;

Line 4170: l_targ_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE; -- bug 3615617

4166: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4167: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4168: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4169: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4170: l_targ_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE; -- bug 3615617
4171:
4172: /* The existing cursors were replaced by the following cursors to get the resource assignments
4173: * for the impacted task, or its childrens or its parent's childrens as the case may be
4174: */