DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_NUM_TBL_TYPE

Line 212: x_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

208: p_old_task_sch_start IN DATE,
209: p_old_task_sch_finish IN DATE DEFAULT NULL,
210: p_new_task_sch_start IN DATE,
211: p_new_task_sch_finish IN DATE,
212: x_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
213: x_planning_start_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
214: x_planning_end_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
215: x_return_status OUT NOCOPY VARCHAR2);
216:

Line 257: p_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

253: PROCEDURE Validate_Delete_Assignment
254: ( p_context IN VARCHAR2,
255: p_calling_context IN VARCHAR2 DEFAULT NULL, -- Added for Bug 6856934
256: p_task_or_res IN VARCHAR2 DEFAULT 'ASSIGNMENT',
257: p_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
258: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
259: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
260: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
261: x_delete_task_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

Line 260: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

256: p_task_or_res IN VARCHAR2 DEFAULT 'ASSIGNMENT',
257: p_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
258: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
259: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
260: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
261: x_delete_task_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
262: x_delete_asgmt_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
263: x_task_assmt_ids_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --Bug 4951422
264: x_return_status OUT NOCOPY VARCHAR2);

Line 263: x_task_assmt_ids_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --Bug 4951422

259: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
260: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
261: x_delete_task_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
262: x_delete_asgmt_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
263: x_task_assmt_ids_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --Bug 4951422
264: x_return_status OUT NOCOPY VARCHAR2);
265:
266: -- This procedure will Validate the Copying of Planning Transaction
267: -- and return Assignments that can be copied.

Line 272: p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

268:
269: PROCEDURE Validate_Copy_Assignment(
270: p_src_project_id IN NUMBER,
271: p_target_project_id IN NUMBER,
272: p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
273: p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
274: p_copy_people_flag IN VARCHAR2,
275: p_copy_equip_flag IN VARCHAR2,
276: p_copy_mat_item_flag IN VARCHAR2,

Line 273: p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

269: PROCEDURE Validate_Copy_Assignment(
270: p_src_project_id IN NUMBER,
271: p_target_project_id IN NUMBER,
272: p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
273: p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
274: p_copy_people_flag IN VARCHAR2,
275: p_copy_equip_flag IN VARCHAR2,
276: p_copy_mat_item_flag IN VARCHAR2,
277: p_copy_fin_elem_flag IN VARCHAR2,