DBA Data[Home] [Help]

APPS.PA_TASK_TYPE_PKG dependencies on PA_TASK_TYPES_S

Line 7: ,p_start_date_active IN pa_task_types.start_date_active%TYPE

3:
4: PROCEDURE insert_row
5: (p_task_type_id IN pa_task_types.task_type_id%TYPE :=0 --3279978 FP M Development avaithia 29-Dec-2003
6: ,p_task_type IN pa_task_types.task_type%TYPE
7: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
8: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
9: ,p_description IN pa_task_types.description%TYPE := NULL
10: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
11: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL

Line 58: SELECT pa_task_types_s.nextval FROM sys.dual;

54: --3279978 FP M Development avaithia 29-Dec-2003
55: l_task_type_id pa_task_types.task_type_id%TYPE :=p_task_type_id;
56:
57: CURSOR c_task_type_id IS
58: SELECT pa_task_types_s.nextval FROM sys.dual;
59: ---end of insert by avaithia
60: ------------------------------------------------------------------------------------------------------------
61: BEGIN
62:

Line 204: ,p_start_date_active IN pa_task_types.start_date_active%TYPE

200:
201: PROCEDURE update_row
202: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
203: ,p_task_type IN pa_task_types.task_type%TYPE
204: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
205: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
206: ,p_description IN pa_task_types.description%TYPE := NULL
207: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
208: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL