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.
PACKAGE: APPS.PA_TASK_TYPE_PKG

Source


1 PACKAGE PA_TASK_TYPE_PKG AS
2 /*$Header: PATTPKGS.pls 120.1 2005/08/19 17:06:18 mwasowic noship $*/
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
12  ,p_prog_entry_enable_flag        IN    pa_task_types.prog_entry_enable_flag%TYPE   := NULL
13  ,p_prog_entry_req_flag           IN    pa_task_types.prog_entry_req_flag%TYPE      := NULL
14  ,p_initial_progress_status_code  IN    pa_task_types.initial_progress_status_code%TYPE  := NULL
15  ,p_task_prog_entry_page_id       IN    pa_task_types.task_progress_entry_page_id%TYPE   := NULL
16  ,p_task_prog_entry_page_name     IN    pa_page_layouts.page_name%TYPE                   := NULL
17  ,p_wq_enable_flag                IN    pa_task_types.wq_enable_flag%TYPE            := NULL
18  ,p_work_item_code                IN    pa_task_types.work_item_code%TYPE            := NULL
19  ,p_uom_code                      IN    pa_task_types.uom_code%TYPE                  := NULL
20  ,p_actual_wq_entry_code          IN    pa_task_types.actual_wq_entry_code%TYPE      := NULL
21  ,p_percent_comp_enable_flag      IN    pa_task_types.percent_comp_enable_flag%TYPE  := NULL
22  ,p_base_percent_comp_deriv_code  IN    pa_task_types.base_percent_comp_deriv_code%TYPE  := NULL
23  ,p_task_weighting_deriv_code     IN    pa_task_types.task_weighting_deriv_code%TYPE     := NULL
24  ,p_remain_effort_enable_flag     IN    pa_task_types.remain_effort_enable_flag%TYPE     := NULL
25  ,p_attribute_category     IN    pa_task_types.attribute_category%TYPE       := NULL
26  ,p_attribute1             IN    pa_task_types.attribute1%TYPE               := NULL
27  ,p_attribute2             IN    pa_task_types.attribute2%TYPE               := NULL
28  ,p_attribute3             IN    pa_task_types.attribute3%TYPE               := NULL
29  ,p_attribute4             IN    pa_task_types.attribute4%TYPE               := NULL
30  ,p_attribute5             IN    pa_task_types.attribute5%TYPE               := NULL
31  ,p_attribute6             IN    pa_task_types.attribute6%TYPE               := NULL
32  ,p_attribute7             IN    pa_task_types.attribute7%TYPE               := NULL
33  ,p_attribute8             IN    pa_task_types.attribute8%TYPE               := NULL
34  ,p_attribute9             IN    pa_task_types.attribute9%TYPE               := NULL
35  ,p_attribute10            IN    pa_task_types.attribute10%TYPE              := NULL
36  ,p_attribute11            IN    pa_task_types.attribute11%TYPE              := NULL
37  ,p_attribute12            IN    pa_task_types.attribute12%TYPE              := NULL
38  ,p_attribute13            IN    pa_task_types.attribute13%TYPE              := NULL
39  ,p_attribute14            IN    pa_task_types.attribute14%TYPE              := NULL
40  ,p_attribute15            IN    pa_task_types.attribute15%TYPE              := NULL
41  ,p_object_type            IN    pa_task_types.object_type%TYPE              := 'PA_TASKS'    -- 3279978 : Added Object Type, Progress Rollup Method,
42  ,p_enable_dlvr_actions_flag    IN    pa_task_types.enable_dlvr_actions_flag%TYPE      :=NULL           --  Method code columns--modified avaithia 28-dec-2003
43  ,p_record_version_number  IN    pa_task_types.record_version_number%TYPE    := 1             -- 3279978 inserted avaithia 28-dec-2003
44  ,p_wf_item_type            IN    pa_task_types.wf_item_type%TYPE           :=NULL
45  ,p_wf_process              IN    pa_task_types.wf_process%TYPE             :=NULL
46  ,p_wf_lead_days            IN    pa_task_types.wf_start_lead_days%TYPE     :=NULL
47  ,x_task_type_id          OUT    NOCOPY NUMBER --File.Sql.39 bug 4440895
48  ,x_return_status         OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49  ,x_msg_count             OUT    NOCOPY NUMBER --File.Sql.39 bug 4440895
50  ,x_msg_data              OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
51 );
52 
53 
54 PROCEDURE update_row
55 ( p_task_type_id                  IN    pa_task_types.task_type_id%TYPE
56  ,p_task_type                     IN    pa_task_types.task_type%TYPE
57  ,p_start_date_active             IN    pa_task_types.start_date_active%TYPE
58  ,p_end_date_active               IN    pa_task_types.end_date_active%TYPE          := NULL
59  ,p_description                   IN    pa_task_types.description%TYPE              := NULL
60  ,p_task_type_class_code          IN    pa_task_types.task_type_class_code%TYPE
61  ,p_initial_status_code           IN    pa_task_types.initial_status_code%TYPE      := NULL
62  ,p_prog_entry_enable_flag        IN    pa_task_types.prog_entry_enable_flag%TYPE   := NULL
63  ,p_prog_entry_req_flag           IN    pa_task_types.prog_entry_req_flag%TYPE      := NULL
64  ,p_initial_progress_status_code  IN    pa_task_types.initial_progress_status_code%TYPE  := NULL
65  ,p_task_prog_entry_page_id       IN    pa_task_types.task_progress_entry_page_id%TYPE   := NULL
66  ,p_task_prog_entry_page_name     IN    pa_page_layouts.page_name%TYPE              := NULL
67  ,p_wq_enable_flag                IN    pa_task_types.wq_enable_flag%TYPE           := NULL
68  ,p_work_item_code                IN    pa_task_types.work_item_code%TYPE           := NULL
69  ,p_uom_code                      IN    pa_task_types.uom_code%TYPE                 := NULL
70  ,p_actual_wq_entry_code          IN    pa_task_types.actual_wq_entry_code%TYPE     := NULL
71  ,p_percent_comp_enable_flag      IN    pa_task_types.percent_comp_enable_flag%TYPE := NULL
72  ,p_base_percent_comp_deriv_code  IN    pa_task_types.base_percent_comp_deriv_code%TYPE  := NULL
73  ,p_task_weighting_deriv_code     IN    pa_task_types.task_weighting_deriv_code%TYPE     := NULL
74  ,p_remain_effort_enable_flag     IN    pa_task_types.remain_effort_enable_flag%TYPE     := NULL
75  ,p_attribute_category     IN    pa_task_types.attribute_category%TYPE       := NULL
76  ,p_attribute1             IN    pa_task_types.attribute1%TYPE               := NULL
77  ,p_attribute2             IN    pa_task_types.attribute2%TYPE               := NULL
78  ,p_attribute3             IN    pa_task_types.attribute3%TYPE               := NULL
79  ,p_attribute4             IN    pa_task_types.attribute4%TYPE               := NULL
80  ,p_attribute5             IN    pa_task_types.attribute5%TYPE               := NULL
81  ,p_attribute6             IN    pa_task_types.attribute6%TYPE               := NULL
82  ,p_attribute7             IN    pa_task_types.attribute7%TYPE               := NULL
83  ,p_attribute8             IN    pa_task_types.attribute8%TYPE               := NULL
84  ,p_attribute9             IN    pa_task_types.attribute9%TYPE               := NULL
85  ,p_attribute10            IN    pa_task_types.attribute10%TYPE              := NULL
86  ,p_attribute11            IN    pa_task_types.attribute11%TYPE              := NULL
87  ,p_attribute12            IN    pa_task_types.attribute12%TYPE              := NULL
88  ,p_attribute13            IN    pa_task_types.attribute13%TYPE              := NULL
89  ,p_attribute14            IN    pa_task_types.attribute14%TYPE              := NULL
90  ,p_attribute15            IN    pa_task_types.attribute15%TYPE              := NULL
91  ,p_object_type            IN    pa_task_types.object_type%TYPE              := 'PA_TASKS'    -- 3279978 : Added Object Type, Progress Rollup Method,
92  ,p_enable_dlvr_actions_flag    IN    pa_task_types.enable_dlvr_actions_flag%TYPE      :=NULL           --           Method code columns --modified avaithia 28-dec-2003
93  ,p_record_version_number  IN    pa_task_types.record_version_number%TYPE    := 1  -- 3279978 inserted avaithia 28-dec-2003
94  ,p_wf_item_type            IN    pa_task_types.wf_item_type%TYPE           :=NULL
95  ,p_wf_process              IN    pa_task_types.wf_process%TYPE             :=NULL
96  ,p_wf_lead_days            IN    pa_task_types.wf_start_lead_days%TYPE     :=NULL
97  ,x_return_status         OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98  ,x_msg_count             OUT    NOCOPY NUMBER --File.Sql.39 bug 4440895
99  ,x_msg_data              OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
100 );
101 
102 
103 PROCEDURE delete_row
104  (p_task_type_id           IN    pa_task_types.task_type_id%TYPE
105  ,p_record_version_number  IN    pa_task_types.record_version_number%TYPE  :=0 --3279978 inserted avaithia 07-Jan-2004
106  ,x_return_status         OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
107  ,x_msg_count             OUT    NOCOPY NUMBER --File.Sql.39 bug 4440895
108  ,x_msg_data              OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
109 );
110 
111 
112 END PA_TASK_TYPE_PKG;