DBA Data[Home] [Help]

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: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3804: /*Bug # 3622551 --Added some parameters */
3805:

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: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3804: /*Bug # 3622551 --Added some parameters */
3805:
3806: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;

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

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: l_rlm_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3804: /*Bug # 3622551 --Added some parameters */
3805:
3806: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;
3807: l_task_id_tmp_tbl SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();

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

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

Line 4153: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

4149: l_plan_version_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4150:
4151: /* PL/SQL table types to be passed to create_res_task_map */
4152:
4153: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4154: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4155: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;

Line 4154: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

4150:
4151: /* PL/SQL table types to be passed to create_res_task_map */
4152:
4153: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4154: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4155: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4158: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;

Line 4155: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

4151: /* PL/SQL table types to be passed to create_res_task_map */
4152:
4153: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4154: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4155: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4158: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4159: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;

Line 4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

4152:
4153: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4154: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4155: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4158: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4159: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4160: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;

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

4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4158: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4159: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4160: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4161: l_targ_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE; -- bug 3615617
4162:
4163: /* The existing cursors were replaced by the following cursors to get the resource assignments
4164: * for the impacted task, or its childrens or its parent's childrens as the case may be
4165: */