5:
6: INV_ARG_EXC EXCEPTION;
7:
8: PROCEDURE create_task_type
9: (p_task_type IN pa_task_types.task_type%TYPE
10: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
11: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
12: ,p_description IN pa_task_types.description%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
6: INV_ARG_EXC EXCEPTION;
7:
8: PROCEDURE create_task_type
9: (p_task_type IN pa_task_types.task_type%TYPE
10: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
11: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
12: ,p_description IN pa_task_types.description%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
7:
8: PROCEDURE create_task_type
9: (p_task_type IN pa_task_types.task_type%TYPE
10: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
11: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
12: ,p_description IN pa_task_types.description%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
15: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
8: PROCEDURE create_task_type
9: (p_task_type IN pa_task_types.task_type%TYPE
10: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
11: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
12: ,p_description IN pa_task_types.description%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
15: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
16: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
9: (p_task_type IN pa_task_types.task_type%TYPE
10: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
11: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
12: ,p_description IN pa_task_types.description%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
15: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
16: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
17: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
10: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
11: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
12: ,p_description IN pa_task_types.description%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
15: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
16: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
17: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
18: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
11: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
12: ,p_description IN pa_task_types.description%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
15: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
16: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
17: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
18: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
19: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
12: ,p_description IN pa_task_types.description%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
15: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
16: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
17: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
18: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
19: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
20: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
13: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
15: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
16: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
17: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
18: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
19: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
20: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
21: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
14: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
15: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
16: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
17: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
18: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
19: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
20: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
21: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
22: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
16: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
17: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
18: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
19: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
20: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
21: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
22: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
23: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
17: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
18: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
19: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
20: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
21: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
22: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
23: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
18: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
19: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
20: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
21: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
22: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
23: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
19: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
20: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
21: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
22: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
23: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
20: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
21: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
22: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
23: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
21: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
22: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
23: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
22: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
23: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
23: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
24: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
25: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
26: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
27: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
28: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
29: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
30: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
31: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
32: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
33: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
34: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
35: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
36: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
44: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
37: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
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
38: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
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
39: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
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
40: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
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
41: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
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
42: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
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
43: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
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
122: END Create_Task_Type;
123:
124:
125: PROCEDURE Update_Task_Type
126: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
127: ,p_task_type IN pa_task_types.task_type%TYPE
128: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
129: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
123:
124:
125: PROCEDURE Update_Task_Type
126: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
127: ,p_task_type IN pa_task_types.task_type%TYPE
128: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
129: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
124:
125: PROCEDURE Update_Task_Type
126: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
127: ,p_task_type IN pa_task_types.task_type%TYPE
128: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
129: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
125: PROCEDURE Update_Task_Type
126: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
127: ,p_task_type IN pa_task_types.task_type%TYPE
128: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
129: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
133: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
126: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
127: ,p_task_type IN pa_task_types.task_type%TYPE
128: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
129: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
133: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
134: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
127: ,p_task_type IN pa_task_types.task_type%TYPE
128: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
129: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
133: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
134: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
135: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
128: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
129: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
133: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
134: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
135: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
136: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
129: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
133: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
134: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
135: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
136: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
137: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
130: ,p_description IN pa_task_types.description%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
133: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
134: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
135: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
136: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
137: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
138: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
131: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
133: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
134: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
135: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
136: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
137: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
138: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
139: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
132: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
133: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
134: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
135: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
136: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
137: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
138: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
139: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
140: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
134: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
135: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
136: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
137: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
138: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
139: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
140: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
141: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
135: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
136: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
137: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
138: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
139: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
140: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
141: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
136: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
137: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
138: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
139: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
140: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
141: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
137: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
138: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
139: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
140: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
141: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
138: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
139: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
140: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
141: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
139: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
140: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
141: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
140: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
141: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
141: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
142: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
143: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
144: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
145: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
146: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
147: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
148: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
149: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
150: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
151: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
152: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
153: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
154: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
162: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
155: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
162: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
163: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
156: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
162: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
163: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
164: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
157: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
162: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
163: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
164: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
165: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
158: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
162: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
163: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
164: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
165: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
159: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
162: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
163: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
164: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
165: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
167: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
160: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
162: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
163: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
164: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
165: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
167: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
168: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
161: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
162: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
163: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
164: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
165: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
167: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
168: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
169: )
177: -- Initialize the return status to success
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: --Log Message
181: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PVT.Update_Task_Type.begin'
182: ,x_msg => 'Beginning of Update_Task_Type pvt'
183: ,x_log_level => 5);
184:
185:
240: END Update_Task_Type;
241:
242:
243: PROCEDURE Delete_Task_Type
244: (p_Task_Type_id IN pa_task_types.Task_Type_id%TYPE := NULL
245: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
246: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
247: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
248: )
255: -- Initialize the return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: --Log Message
259: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_task_types_PVT.Delete_Task_Type.begin'
260: ,x_msg => 'Beginning of Delete_Task_Type pvt'
261: ,x_log_level => 5);
262:
263:
281: -- Procedure : CREATE_DELIVERABLE_TYPE
282: -- Type : private Procedure
283: -- Purpose : This is the private API used to create the deliverable type .
284: -- Note : If the deliverable type name is unique and date range is valid then
285: -- this API places call to the table handler insert_row in PA_TASK_TYPES_PKG
286: -- Assumptions : None
287: -- List of parameters other than standard IN and OUT parameters
288: -- Parameters Type Null? Default Value Description and Purpose
289: -- --------------------------- ------------------------------------------ ------ -------------- ----------------------------
286: -- Assumptions : None
287: -- List of parameters other than standard IN and OUT parameters
288: -- Parameters Type Null? Default Value Description and Purpose
289: -- --------------------------- ------------------------------------------ ------ -------------- ----------------------------
290: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
291: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
292: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE N 'DLVR_NOT_STARTED'Initial Deliverable Status
293: --P_deliverable_type_class_code PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE Y 'ITEM' Deliverable Type Class
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
287: -- List of parameters other than standard IN and OUT parameters
288: -- Parameters Type Null? Default Value Description and Purpose
289: -- --------------------------- ------------------------------------------ ------ -------------- ----------------------------
290: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
291: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
292: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE N 'DLVR_NOT_STARTED'Initial Deliverable Status
293: --P_deliverable_type_class_code PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE Y 'ITEM' Deliverable Type Class
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
295: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
288: -- Parameters Type Null? Default Value Description and Purpose
289: -- --------------------------- ------------------------------------------ ------ -------------- ----------------------------
290: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
291: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
292: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE N 'DLVR_NOT_STARTED'Initial Deliverable Status
293: --P_deliverable_type_class_code PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE Y 'ITEM' Deliverable Type Class
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
295: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
296: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
289: -- --------------------------- ------------------------------------------ ------ -------------- ----------------------------
290: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
291: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
292: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE N 'DLVR_NOT_STARTED'Initial Deliverable Status
293: --P_deliverable_type_class_code PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE Y 'ITEM' Deliverable Type Class
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
295: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
296: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
297: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
290: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
291: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
292: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE N 'DLVR_NOT_STARTED'Initial Deliverable Status
293: --P_deliverable_type_class_code PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE Y 'ITEM' Deliverable Type Class
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
295: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
296: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
297: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
298: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
291: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
292: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE N 'DLVR_NOT_STARTED'Initial Deliverable Status
293: --P_deliverable_type_class_code PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE Y 'ITEM' Deliverable Type Class
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
295: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
296: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
297: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
298: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
299:
292: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE N 'DLVR_NOT_STARTED'Initial Deliverable Status
293: --P_deliverable_type_class_code PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE Y 'ITEM' Deliverable Type Class
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
295: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
296: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
297: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
298: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
299:
300:
293: --P_deliverable_type_class_code PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE Y 'ITEM' Deliverable Type Class
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
295: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
296: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
297: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
298: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
299:
300:
301: PROCEDURE CREATE_DELIVERABLE_TYPE
294: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
295: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
296: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
297: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
298: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
299:
300:
301: PROCEDURE CREATE_DELIVERABLE_TYPE
302: (p_api_version IN NUMBER := 1.0
306: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
307: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
308: ,p_debug_mode IN VARCHAR2 := 'N'
309: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
310: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
311: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
312: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
313: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
307: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
308: ,p_debug_mode IN VARCHAR2 := 'N'
309: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
310: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
311: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
312: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
313: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
308: ,p_debug_mode IN VARCHAR2 := 'N'
309: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
310: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
311: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
312: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
313: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
316: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
309: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
310: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
311: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
312: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
313: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
316: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
317: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
310: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
311: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
312: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
313: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
316: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
317: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
318: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
311: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
312: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
313: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
316: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
317: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
318: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
319: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
312: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
313: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
316: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
317: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
318: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
319: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
320: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
313: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
316: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
317: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
318: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
319: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
320: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
321: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
314: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
316: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
317: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
318: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
319: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
320: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
321: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
322: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
315: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
316: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
317: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
318: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
319: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
320: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
321: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
322: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
323: )
328: l_return_status VARCHAR2(1);
329: l_msg_count NUMBER;
330: l_data VARCHAR2(2000);
331: l_msg_data VARCHAR2(2000);
332: l_task_type_id_dummy PA_TASK_TYPES.TASK_TYPE_ID%TYPE ;
333:
334: l_debug_level2 CONSTANT NUMBER := 2;
335: l_debug_level3 CONSTANT NUMBER := 3;
336: l_debug_level4 CONSTANT NUMBER := 4;
547: -- Assumptions : None
548: -- List of parameters other than standard IN and OUT parameters
549: -- Parameters Type Null? Default Value Description and Purpose
550: -- --------------------------- -------- ------ --------------- ----------------------------
551: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
552: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
553: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
554: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
555: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
548: -- List of parameters other than standard IN and OUT parameters
549: -- Parameters Type Null? Default Value Description and Purpose
550: -- --------------------------- -------- ------ --------------- ----------------------------
551: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
552: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
553: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
554: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
555: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
556: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
549: -- Parameters Type Null? Default Value Description and Purpose
550: -- --------------------------- -------- ------ --------------- ----------------------------
551: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
552: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
553: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
554: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
555: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
556: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
557: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
550: -- --------------------------- -------- ------ --------------- ----------------------------
551: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
552: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
553: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
554: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
555: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
556: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
557: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
558: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
551: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
552: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
553: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
554: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
555: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
556: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
557: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
558: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
559:
552: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
553: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
554: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
555: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
556: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
557: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
558: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
559:
560: PROCEDURE UPDATE_DELIVERABLE_TYPE
553: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
554: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
555: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
556: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
557: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
558: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
559:
560: PROCEDURE UPDATE_DELIVERABLE_TYPE
561: (p_api_version IN NUMBER := 1.0
554: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
555: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
556: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
557: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
558: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
559:
560: PROCEDURE UPDATE_DELIVERABLE_TYPE
561: (p_api_version IN NUMBER := 1.0
562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
565: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
566: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
567: ,p_debug_mode IN VARCHAR2 := 'N'
568: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
569: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
570: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
571: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
572: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
566: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
567: ,p_debug_mode IN VARCHAR2 := 'N'
568: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
569: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
570: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
571: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
572: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
567: ,p_debug_mode IN VARCHAR2 := 'N'
568: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
569: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
570: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
571: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
572: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
575: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
568: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
569: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
570: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
571: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
572: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
575: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
576: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
569: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
570: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
571: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
572: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
575: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
576: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
577: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
570: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
571: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
572: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
575: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
576: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
577: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
578: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
571: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
572: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
575: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
576: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
577: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
578: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
579: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
572: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
575: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
576: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
577: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
578: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
579: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
580: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
573: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
575: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
576: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
577: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
578: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
579: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
580: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
581: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
574: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
575: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
576: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
577: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
578: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
579: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
580: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
581: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
582: )
618: ,INITIAL_STATUS_CODE
619: ,TASK_TYPE_CLASS_CODE
620: ,ENABLE_DLVR_ACTIONS_FLAG
621: ,PROG_ENTRY_ENABLE_FLAG
622: FROM PA_TASK_TYPES
623: WHERE TASK_TYPE_ID = p_deliverable_type_id
624: AND OBJECT_TYPE = 'PA_DLVR_TYPES';
625:
626: l_original_value_rec c_original_value_rec%ROWTYPE ;
639: END IF;
640:
641: IF l_debug_mode = 'Y'
642: THEN
643: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPES_PVT.UPDATE_DELIVERABLE_TYPE : Printing Input parameters';
644: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
645: l_debug_level3);
646: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
647: l_debug_level3);
677: THEN
678: savepoint UPDATE_DELIVERABLE_TYPE;
679: END IF;
680:
681: PA_DEBUG.WRITE(g_module_name,'After issuing save point in UPDATE_DLV_TYPE :PA_TASK_TYPES_PVT',
682: l_debug_level3);
683:
684: --the cursor contents into local variable
685: OPEN c_original_value_rec;
695: OR (p_deliverable_type_name IS NULL) OR (p_effective_from IS NULL)
696: THEN
697: IF l_debug_mode = 'Y'
698: THEN
699: Pa_Debug.g_err_stage:= 'PA_TASK_TYPES_PVT : UPDATE_DELIVERABLE_TYPE : The DeliverableTypeID/NAME/Startdate/RecVersionNumber is null';
700: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
701: l_debug_level3);
702: END IF;
703: RAISE INV_ARG_EXC;
1008: -- Assumptions : None
1009: -- List of parameters other than standard IN and OUT parameters
1010: -- Parameters Type Null? Description and Purpose
1011: -- --------------------------- ------------------------------- -------- -----------------------------------
1012: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
1013: --p_record_version_number PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE N Record Version Number
1014:
1015: PROCEDURE DELETE_DELIVERABLE_TYPE
1016: (p_api_version IN NUMBER := 1.0
1009: -- List of parameters other than standard IN and OUT parameters
1010: -- Parameters Type Null? Description and Purpose
1011: -- --------------------------- ------------------------------- -------- -----------------------------------
1012: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
1013: --p_record_version_number PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE N Record Version Number
1014:
1015: PROCEDURE DELETE_DELIVERABLE_TYPE
1016: (p_api_version IN NUMBER := 1.0
1017: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1020: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1021: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1022: ,p_debug_mode IN VARCHAR2 := 'N'
1023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1024: ,p_deliverable_type_id IN pa_task_types.Task_Type_id%TYPE
1025: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
1026: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1027: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1028: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1021: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1022: ,p_debug_mode IN VARCHAR2 := 'N'
1023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1024: ,p_deliverable_type_id IN pa_task_types.Task_Type_id%TYPE
1025: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
1026: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1027: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1028: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1029: )