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 BODY PA_TASK_TYPE_PKG AS
2: /*$Header: PATTPKGB.pls 120.1 2005/08/19 17:06:14 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: PATTPKGB.pls 120.1 2005/08/19 17:06:14 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' -- 3279987 : 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' -- 3279987 : 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--3279978 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' -- 3279987 : 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--3279978 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' -- 3279987 : 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--3279978 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' -- 3279987 : 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' -- 3279987 : 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--3279978 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--3279978 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' -- 3279987 : 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--3279978 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' -- 3279987 : 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--3279978 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' -- 3279987 : 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--3279978 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' -- 3279987 : 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--3279978 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--3279978 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: l_task_type_id pa_task_types.task_type_id%TYPE :=p_task_type_id;

51: )
52: IS
53: ------------------------------------------------------------------------------------------------------------
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

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 86: INSERT INTO pa_task_types

82: PA_DEBUG.WRITE('Inside Table handler','p_record_version_number '||p_record_version_number,3);
83: ---end of insert by avaithia
84: -------------------------------------------------------------------------------------------------------------
85:
86: INSERT INTO pa_task_types
87: (task_type_id --3279978 :Inserted avaithia 29-Dec-2003 FP M
88: ,task_type
89: ,start_date_active
90: ,end_date_active

Line 202: ( p_task_type_id IN pa_task_types.task_type_id%TYPE

198: END insert_row;
199:
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

Line 203: ,p_task_type IN pa_task_types.task_type%TYPE

199:
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

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

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

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
209: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL

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

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
209: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL

Line 207: ,p_task_type_class_code IN pa_task_types.task_type_class_code%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
209: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL

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

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
209: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
212: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL

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

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
209: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
212: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
213: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL

Line 210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%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
209: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
212: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
213: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL

Line 211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%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
209: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
212: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
213: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL

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

208: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
209: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
212: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
213: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL

Line 214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL

210: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
212: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
213: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL

Line 215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL

211: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
212: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
213: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL

Line 216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL

212: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
213: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL

Line 217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL

213: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL

Line 218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL

214: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL

Line 219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL

215: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL

Line 220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL

216: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL

Line 221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL

217: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL

Line 222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL

218: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL

Line 223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL

219: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL

Line 224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL

220: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL

Line 225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL

221: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL

Line 226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL

222: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL

Line 227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL

223: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL

Line 228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL

224: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL

Line 229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL

225: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL

Line 230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL

226: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL

Line 231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL

227: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL

Line 232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL

228: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL

Line 233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL

229: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL

Line 234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL

230: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,

Line 235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL

231: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,
239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003

Line 236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL

232: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,
239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003
240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1

Line 237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL

233: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,
239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003
240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1
241: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL

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

234: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,
239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003
240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1
241: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
242: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL

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

235: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,
239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003
240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1
241: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
242: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
243: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL

Line 240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1

236: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,
239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003
240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1
241: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
242: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
243: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 241: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL

237: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,
239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003
240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1
241: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
242: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
243: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 242: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL

238: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279987 : Added Object Type, Progress Rollup Method,
239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003
240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1
241: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
242: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
243: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
246: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

239: ,p_enable_dlvr_actions_flag IN pa_task_types.enable_dlvr_actions_flag%TYPE :=NULL -- Method code columns--modified 3279978 avaithia 28-dec-2003
240: ,p_record_version_number IN pa_task_types.record_version_number%TYPE := 1
241: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
242: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
243: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
246: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247: )

Line 256: UPDATE pa_task_types

252:
253: -- Initialize the return status to success
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255:
256: UPDATE pa_task_types
257: SET
258: task_type = p_task_type
259: ,start_date_active = p_start_date_active
260: ,end_date_active = p_end_date_active

Line 316: (p_task_type_id IN pa_task_types.task_type_id%TYPE

312: END update_row;
313:
314:
315: PROCEDURE delete_row
316: (p_task_type_id IN pa_task_types.task_type_id%TYPE
317: ,p_record_version_number IN pa_task_types.record_version_number%TYPE :=0 -- 3279978 inserted avaithia 7-Jan-2004
318: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
319: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
320: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

313:
314:
315: PROCEDURE delete_row
316: (p_task_type_id IN pa_task_types.task_type_id%TYPE
317: ,p_record_version_number IN pa_task_types.record_version_number%TYPE :=0 -- 3279978 inserted avaithia 7-Jan-2004
318: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
319: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
320: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
321: )

Line 330: DELETE FROM pa_task_types

326: -- Initialize the return status to success
327: x_return_status := FND_API.G_RET_STS_SUCCESS;
328:
329: IF(p_record_version_number =0) THEN
330: DELETE FROM pa_task_types
331: WHERE task_type_id = p_task_type_id;
332: ELSE
333: DELETE FROM pa_task_types
334: WHERE task_type_id = p_task_type_id

Line 333: DELETE FROM pa_task_types

329: IF(p_record_version_number =0) THEN
330: DELETE FROM pa_task_types
331: WHERE task_type_id = p_task_type_id;
332: ELSE
333: DELETE FROM pa_task_types
334: WHERE task_type_id = p_task_type_id
335: AND record_version_number=p_record_version_number;
336: END IF;
337: