DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_NUM_TBL_TYPE

Line 215: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type

211: PROCEDURE copy_wp_budget_versions
212: (
213: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
214: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
215: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
216: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
217: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type DEFAULT null -- bug 3847386
218: ,p_copy_people_flag IN VARCHAR2 DEFAULT 'Y'
219: ,p_copy_equip_flag IN VARCHAR2 DEFAULT 'Y'

Line 216: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type

212: (
213: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
214: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
215: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
216: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
217: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type DEFAULT null -- bug 3847386
218: ,p_copy_people_flag IN VARCHAR2 DEFAULT 'Y'
219: ,p_copy_equip_flag IN VARCHAR2 DEFAULT 'Y'
220: ,p_copy_mat_item_flag IN VARCHAR2 DEFAULT 'Y'

Line 217: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type DEFAULT null -- bug 3847386

213: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
214: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
215: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
216: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
217: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type DEFAULT null -- bug 3847386
218: ,p_copy_people_flag IN VARCHAR2 DEFAULT 'Y'
219: ,p_copy_equip_flag IN VARCHAR2 DEFAULT 'Y'
220: ,p_copy_mat_item_flag IN VARCHAR2 DEFAULT 'Y'
221: ,p_copy_fin_elem_flag IN VARCHAR2 DEFAULT 'Y'

Line 253: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

249: p_targ_rlm_id_tbl -> target resource list member ids corresponding to the source resource assignment ids
250: =====================================================================================*/
251: PROCEDURE create_res_task_maps(
252: p_context IN VARCHAR2 --Can be WORKPLAN, BUDGET
253: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
256: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
257: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617

Line 254: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

250: =====================================================================================*/
251: PROCEDURE create_res_task_maps(
252: p_context IN VARCHAR2 --Can be WORKPLAN, BUDGET
253: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
256: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
257: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
258: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 255: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

251: PROCEDURE create_res_task_maps(
252: p_context IN VARCHAR2 --Can be WORKPLAN, BUDGET
253: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
256: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
257: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
258: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
259: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 256: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

252: p_context IN VARCHAR2 --Can be WORKPLAN, BUDGET
253: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
256: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
257: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
258: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
259: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
260: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 257: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617

253: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
254: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
255: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
256: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
257: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
258: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
259: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
260: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
261: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE