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

Line 5: (p_task_type IN pa_task_types.task_type%TYPE

1: PACKAGE PA_TASK_TYPE_PUB AS
2: /*$Header: PATTPUBS.pls 120.1 2005/08/19 17:06:27 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: PATTPUBS.pls 120.1 2005/08/19 17:06:27 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_api_version IN NUMBER := 1.0

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_api_version IN NUMBER := 1.0
41: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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_api_version IN NUMBER := 1.0
41: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
42: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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_api_version IN NUMBER := 1.0
41: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
42: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

40: ,p_api_version IN NUMBER := 1.0
41: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
42: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
44: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
45: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
46: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
47: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
48: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

41: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
42: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
44: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
45: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
46: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
47: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
48: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

42: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
44: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
45: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
46: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
47: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
48: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

43: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
44: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
45: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
46: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
47: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
48: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
51: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 56: ( p_task_type_id IN pa_task_types.task_type_id%TYPE

52: );
53:
54:
55: PROCEDURE Update_Task_Type
56: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
57: ,p_task_type IN pa_task_types.task_type%TYPE
58: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
59: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
60: ,p_description IN pa_task_types.description%TYPE := NULL

Line 57: ,p_task_type IN pa_task_types.task_type%TYPE

53:
54:
55: PROCEDURE Update_Task_Type
56: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
57: ,p_task_type IN pa_task_types.task_type%TYPE
58: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
59: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
60: ,p_description IN pa_task_types.description%TYPE := NULL
61: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

Line 58: ,p_start_date_active IN pa_task_types.start_date_active%TYPE

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

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

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

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

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

Line 61: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

85: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
86: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
87: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
88: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
89: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
90: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
91: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
92: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
93: ,p_api_version IN NUMBER := 1.0

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

86: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
87: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
88: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
89: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
90: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
91: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
92: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
93: ,p_api_version IN NUMBER := 1.0
94: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

87: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
88: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
89: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
90: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
91: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
92: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
93: ,p_api_version IN NUMBER := 1.0
94: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
95: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

88: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
89: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
90: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
91: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
92: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
93: ,p_api_version IN NUMBER := 1.0
94: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
95: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
96: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

93: ,p_api_version IN NUMBER := 1.0
94: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
95: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
96: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
97: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
98: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
99: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%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

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

94: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
95: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
96: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
97: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
98: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
99: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%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

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

95: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
96: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
97: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
98: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
99: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%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 107: (p_Task_Type_id IN pa_task_types.Task_Type_id%TYPE := NULL

103: );
104:
105:
106: PROCEDURE Delete_Task_Type
107: (p_Task_Type_id IN pa_task_types.Task_Type_id%TYPE := NULL
108: ,p_api_version IN NUMBER := 1.0
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 126: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

122: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
126: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
127: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
128: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
129: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

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

123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
126: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
127: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
128: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
129: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

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

124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
126: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
127: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
128: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
129: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

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

125: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
126: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
127: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
128: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
129: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
133: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

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

126: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
127: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
128: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
129: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
133: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
134: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL

Line 131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

127: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
128: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
129: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
133: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
134: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
135: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1

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

128: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
129: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
133: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
134: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
135: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
136: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

129: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
133: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
134: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
135: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
136: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

130: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
133: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
134: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
135: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
136: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
138: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

131: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
133: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
134: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
135: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
136: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
138: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
139: );

Line 150: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
148: ,p_debug_mode IN VARCHAR2 := 'N'
149: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
150: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
151: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
152: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
153: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

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

147: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
148: ,p_debug_mode IN VARCHAR2 := 'N'
149: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
150: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
151: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
152: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
153: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

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

148: ,p_debug_mode IN VARCHAR2 := 'N'
149: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
150: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
151: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
152: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
153: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

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

149: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
150: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
151: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
152: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
153: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
157: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

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

150: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
151: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
152: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
153: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
157: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
158: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

Line 155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

151: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
152: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
153: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
157: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
158: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
159: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

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

152: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
153: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
157: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
158: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
159: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

153: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
157: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
158: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
159: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
161: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 158: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

154: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
157: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
158: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
159: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
161: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
162: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 159: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

155: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
157: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
158: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
159: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
161: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
162: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163: );

Line 174: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

170: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
171: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
172: ,p_debug_mode IN VARCHAR2 := 'N'
173: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
174: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
175: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
176: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
177: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
178: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 175: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

171: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
172: ,p_debug_mode IN VARCHAR2 := 'N'
173: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
174: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
175: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
176: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
177: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
178: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179: );

Line 190: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

186: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
187: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
188: ,p_debug_mode IN VARCHAR2 := 'N'
189: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
190: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
191: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
192: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
193: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

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

187: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
188: ,p_debug_mode IN VARCHAR2 := 'N'
189: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
190: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
191: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
192: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
193: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

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

188: ,p_debug_mode IN VARCHAR2 := 'N'
189: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
190: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
191: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
192: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
193: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
196: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

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

189: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
190: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
191: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
192: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
193: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
196: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
197: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

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

190: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
191: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
192: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
193: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
196: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
197: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
198: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL

Line 195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

191: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
192: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
193: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
196: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
197: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
198: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
199: ,p_insert_or_update IN VARCHAR2 := 'INSERT'

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

192: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
193: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
196: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
197: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
198: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
199: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
200: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE :=1

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

193: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
196: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
197: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
198: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
199: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
200: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE :=1
201: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

194: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
196: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
197: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
198: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
199: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
200: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE :=1
201: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
202: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

196: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
197: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
198: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
199: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
200: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE :=1
201: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
202: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
203: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
204: );