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.

APPS.PA_TASK_TYPE_PKG dependencies on PA_TASK_TYPES

Line 5: (p_task_type_id IN pa_task_types.task_type_id%TYPE :=0 --3279978 FP M Development avaithia 29-Dec-2003

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

Line 6: ,p_task_type IN pa_task_types.task_type%TYPE

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

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 8: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL

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

Line 9: ,p_description IN pa_task_types.description%TYPE := NULL

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

Line 10: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

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

Line 11: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL

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

Line 12: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL

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

Line 13: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%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

Line 14: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%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

Line 15: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL

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

Line 17: ,p_wq_enable_flag IN pa_task_types.wq_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

Line 18: ,p_work_item_code IN pa_task_types.work_item_code%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

Line 19: ,p_uom_code IN pa_task_types.uom_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

Line 20: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%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

Line 21: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%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

Line 22: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%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

Line 23: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_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

Line 24: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%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

Line 25: ,p_attribute_category IN pa_task_types.attribute_category%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

Line 26: ,p_attribute1 IN pa_task_types.attribute1%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

Line 27: ,p_attribute2 IN pa_task_types.attribute2%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

Line 28: ,p_attribute3 IN pa_task_types.attribute3%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

Line 29: ,p_attribute4 IN pa_task_types.attribute4%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

Line 30: ,p_attribute5 IN pa_task_types.attribute5%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

Line 31: ,p_attribute6 IN pa_task_types.attribute6%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

Line 32: ,p_attribute7 IN pa_task_types.attribute7%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

Line 33: ,p_attribute8 IN pa_task_types.attribute8%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

Line 34: ,p_attribute9 IN pa_task_types.attribute9%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

Line 35: ,p_attribute10 IN pa_task_types.attribute10%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

Line 36: ,p_attribute11 IN pa_task_types.attribute11%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

Line 37: ,p_attribute12 IN pa_task_types.attribute12%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,

Line 38: ,p_attribute13 IN pa_task_types.attribute13%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

Line 39: ,p_attribute14 IN pa_task_types.attribute14%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

Line 40: ,p_attribute15 IN pa_task_types.attribute15%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

Line 41: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type, Progress Rollup Method,

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

Line 42: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified avaithia 28-dec-2003

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

Line 43: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1 -- 3279978 inserted avaithia 28-dec-2003

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

Line 44: ,p_wf_item_type IN pa_task_types.wf_item_type%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

Line 45: ,p_wf_process IN pa_task_types.wf_process%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

Line 46: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL

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

Line 55: ( p_task_type_id IN pa_task_types.task_type_id%TYPE

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

Line 56: ,p_task_type IN pa_task_types.task_type%TYPE

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

Line 57: ,p_start_date_active IN pa_task_types.start_date_active%TYPE

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

Line 58: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL

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

Line 59: ,p_description IN pa_task_types.description%TYPE := NULL

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

Line 60: ,p_task_type_class_code IN pa_task_types.task_type_class_code%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

Line 61: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL

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

Line 62: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL

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

Line 63: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%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

Line 64: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%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

Line 65: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL

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

Line 67: ,p_wq_enable_flag IN pa_task_types.wq_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

Line 68: ,p_work_item_code IN pa_task_types.work_item_code%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

Line 69: ,p_uom_code IN pa_task_types.uom_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

Line 70: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%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

Line 71: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%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

Line 72: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%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

Line 73: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_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

Line 74: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%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

Line 75: ,p_attribute_category IN pa_task_types.attribute_category%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

Line 76: ,p_attribute1 IN pa_task_types.attribute1%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

Line 77: ,p_attribute2 IN pa_task_types.attribute2%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

Line 78: ,p_attribute3 IN pa_task_types.attribute3%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

Line 79: ,p_attribute4 IN pa_task_types.attribute4%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

Line 80: ,p_attribute5 IN pa_task_types.attribute5%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

Line 81: ,p_attribute6 IN pa_task_types.attribute6%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

Line 82: ,p_attribute7 IN pa_task_types.attribute7%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

Line 83: ,p_attribute8 IN pa_task_types.attribute8%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

Line 84: ,p_attribute9 IN pa_task_types.attribute9%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

Line 85: ,p_attribute10 IN pa_task_types.attribute10%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

Line 86: ,p_attribute11 IN pa_task_types.attribute11%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

Line 87: ,p_attribute12 IN pa_task_types.attribute12%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,

Line 88: ,p_attribute13 IN pa_task_types.attribute13%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

Line 89: ,p_attribute14 IN pa_task_types.attribute14%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

Line 90: ,p_attribute15 IN pa_task_types.attribute15%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

Line 91: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type, Progress Rollup Method,

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

Line 92: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns --modified avaithia 28-dec-2003

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

Line 93: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1 -- 3279978 inserted avaithia 28-dec-2003

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

Line 94: ,p_wf_item_type IN pa_task_types.wf_item_type%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

Line 95: ,p_wf_process IN pa_task_types.wf_process%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

Line 96: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL

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: );

Line 104: (p_task_type_id IN pa_task_types.task_type_id%TYPE

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

Line 105: ,p_record_version_number IN pa_task_types.record_version_number%TYPE :=0 --3279978 inserted avaithia 07-Jan-2004

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: );