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_PVT dependencies on PA_TASK_TYPES

Line 5: (p_task_type IN pa_task_types.task_type%TYPE

1: PACKAGE PA_TASK_TYPE_PVT AS
2: /*$Header: PATTPVTS.pls 120.1 2005/08/19 17:06:36 mwasowic noship $*/
3:
4: PROCEDURE create_task_type
5: (p_task_type IN pa_task_types.task_type%TYPE
6: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
7: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
8: ,p_description IN pa_task_types.description%TYPE := NULL
9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

Line 6: ,p_start_date_active IN pa_task_types.start_date_active%TYPE

2: /*$Header: PATTPVTS.pls 120.1 2005/08/19 17:06:36 mwasowic noship $*/
3:
4: PROCEDURE create_task_type
5: (p_task_type IN pa_task_types.task_type%TYPE
6: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
7: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
8: ,p_description IN pa_task_types.description%TYPE := NULL
9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL

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

3:
4: PROCEDURE create_task_type
5: (p_task_type IN pa_task_types.task_type%TYPE
6: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
7: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
8: ,p_description IN pa_task_types.description%TYPE := NULL
9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL

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

4: PROCEDURE create_task_type
5: (p_task_type IN pa_task_types.task_type%TYPE
6: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
7: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
8: ,p_description IN pa_task_types.description%TYPE := NULL
9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL

Line 9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

5: (p_task_type IN pa_task_types.task_type%TYPE
6: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
7: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
8: ,p_description IN pa_task_types.description%TYPE := NULL
9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL

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

6: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
7: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
8: ,p_description IN pa_task_types.description%TYPE := NULL
9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
14: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL

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

7: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
8: ,p_description IN pa_task_types.description%TYPE := NULL
9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
14: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
15: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL

Line 12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL

8: ,p_description IN pa_task_types.description%TYPE := NULL
9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
14: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
15: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
16: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL

Line 13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL

9: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
14: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
15: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
16: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
17: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL

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

10: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
14: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
15: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
16: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
17: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
18: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL

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

12: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
14: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
15: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
16: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
17: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
18: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
19: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL

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

13: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
14: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
15: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
16: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
17: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
18: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
19: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL

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

14: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
15: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
16: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
17: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
18: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
19: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL

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

15: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
16: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
17: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
18: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
19: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL

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

16: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
17: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
18: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
19: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL

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

17: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
18: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
19: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL

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

18: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
19: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL

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

19: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL

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

20: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL

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

21: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL

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

22: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL

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

23: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL

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

24: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL

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

25: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL

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

26: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL

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

27: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL

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

28: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL

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

29: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL

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

30: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL

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

31: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL

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

32: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method

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

33: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
41: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL

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

34: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
41: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
42: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL

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

35: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
41: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
42: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
43: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL

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

36: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
41: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
42: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
43: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
44: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

37: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
41: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
42: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
43: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
44: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
45: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

38: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
41: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
42: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
43: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
44: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
45: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

39: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
41: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
42: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
43: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
44: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
45: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
47: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 52: ( p_task_type_id IN pa_task_types.task_type_id%TYPE

48: );
49:
50:
51: PROCEDURE Update_Task_Type
52: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
53: ,p_task_type IN pa_task_types.task_type%TYPE
54: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
55: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
56: ,p_description IN pa_task_types.description%TYPE := NULL

Line 53: ,p_task_type IN pa_task_types.task_type%TYPE

49:
50:
51: PROCEDURE Update_Task_Type
52: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
53: ,p_task_type IN pa_task_types.task_type%TYPE
54: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
55: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
56: ,p_description IN pa_task_types.description%TYPE := NULL
57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

Line 54: ,p_start_date_active IN pa_task_types.start_date_active%TYPE

50:
51: PROCEDURE Update_Task_Type
52: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
53: ,p_task_type IN pa_task_types.task_type%TYPE
54: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
55: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
56: ,p_description IN pa_task_types.description%TYPE := NULL
57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL

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

51: PROCEDURE Update_Task_Type
52: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
53: ,p_task_type IN pa_task_types.task_type%TYPE
54: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
55: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
56: ,p_description IN pa_task_types.description%TYPE := NULL
57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
59: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL

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

52: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
53: ,p_task_type IN pa_task_types.task_type%TYPE
54: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
55: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
56: ,p_description IN pa_task_types.description%TYPE := NULL
57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
59: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL

Line 57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

53: ,p_task_type IN pa_task_types.task_type%TYPE
54: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
55: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
56: ,p_description IN pa_task_types.description%TYPE := NULL
57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
59: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL

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

54: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
55: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
56: ,p_description IN pa_task_types.description%TYPE := NULL
57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
59: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
62: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL

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

55: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
56: ,p_description IN pa_task_types.description%TYPE := NULL
57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
59: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
62: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
63: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL

Line 60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL

56: ,p_description IN pa_task_types.description%TYPE := NULL
57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
59: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
62: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
63: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
64: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL

Line 61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL

57: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
59: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
62: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
63: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
64: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
65: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL

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

58: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
59: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
62: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
63: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
64: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
65: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
66: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL

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

60: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
62: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
63: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
64: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
65: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
66: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
67: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL

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

61: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
62: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
63: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
64: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
65: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
66: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
67: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL

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

62: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
63: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
64: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
65: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
66: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
67: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL

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

63: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
64: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
65: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
66: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
67: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL

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

64: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
65: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
66: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
67: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL

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

65: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
66: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
67: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL

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

66: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
67: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL

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

67: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL

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

68: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL

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

69: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL

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

70: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL

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

71: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL

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

72: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL

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

73: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL

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

74: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL

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

75: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL

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

76: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL

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

77: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL

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

78: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL

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

79: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL

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

80: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
88: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method

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

81: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
88: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
89: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL

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

82: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
88: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
89: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
90: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL

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

83: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
88: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
89: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
90: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
91: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL

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

84: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
88: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
89: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
90: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
91: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
92: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

85: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
88: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
89: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
90: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
91: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
92: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

86: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
88: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
89: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
90: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
91: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
92: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
94: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

87: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
88: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
89: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
90: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
91: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
92: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
94: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: );

Line 99: (p_task_type_id IN pa_task_types.task_type_id%TYPE := NULL

95: );
96:
97:
98: PROCEDURE Delete_Task_Type
99: (p_task_type_id IN pa_task_types.task_type_id%TYPE := NULL
100: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
101: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
102: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
103: );

Line 114: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

110: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
111: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
112: ,p_debug_mode IN VARCHAR2 := 'N'
113: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
114: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
115: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
116: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

Line 115: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'

111: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
112: ,p_debug_mode IN VARCHAR2 := 'N'
113: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
114: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
115: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
116: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

Line 116: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'

112: ,p_debug_mode IN VARCHAR2 := 'N'
113: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
114: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
115: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
116: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

Line 117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'

113: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
114: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
115: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
116: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
121: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

Line 118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

114: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
115: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
116: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
121: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
122: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL

Line 119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

115: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
116: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
121: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
122: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
123: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1

Line 120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

116: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
121: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
122: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
123: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
124: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 121: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

117: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
121: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
122: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
123: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
124: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
125: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 122: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL

118: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
121: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
122: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
123: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
124: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
125: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
126: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 123: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1

119: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
120: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
121: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
122: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
123: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
124: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
125: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
126: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
127: );

Line 138: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

134: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
135: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
136: ,p_debug_mode IN VARCHAR2 := 'N'
137: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
138: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
139: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
140: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

Line 139: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'

135: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
136: ,p_debug_mode IN VARCHAR2 := 'N'
137: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
138: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
139: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
140: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

Line 140: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'

136: ,p_debug_mode IN VARCHAR2 := 'N'
137: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
138: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
139: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
140: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

Line 141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'

137: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
138: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
139: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
140: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
145: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

Line 142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

138: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
139: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
140: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
145: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
146: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

Line 143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

139: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
140: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
145: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
146: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
147: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

Line 144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

140: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
145: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
146: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
147: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 145: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

141: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
145: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
146: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
147: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 146: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

142: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
145: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
146: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
147: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
150: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 147: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

143: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
144: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
145: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
146: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
147: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
150: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
151: );

Line 162: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

158: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
159: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
160: ,p_debug_mode IN VARCHAR2 := 'N'
161: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
162: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
163: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
164: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
165: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
166: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 163: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

159: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
160: ,p_debug_mode IN VARCHAR2 := 'N'
161: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
162: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
163: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
164: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
165: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
166: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
167: );