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 22: (p_task_type IN pa_task_types.task_type%TYPE

18: l_invalid_lead_day_exc EXCEPTION;
19: l_delete_delv_type_error EXCEPTION; -- Added for bug 4775641
20:
21: PROCEDURE create_task_type
22: (p_task_type IN pa_task_types.task_type%TYPE
23: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
24: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
25: ,p_description IN pa_task_types.description%TYPE := NULL
26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

Line 23: ,p_start_date_active IN pa_task_types.start_date_active%TYPE

19: l_delete_delv_type_error EXCEPTION; -- Added for bug 4775641
20:
21: PROCEDURE create_task_type
22: (p_task_type IN pa_task_types.task_type%TYPE
23: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
24: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
25: ,p_description IN pa_task_types.description%TYPE := NULL
26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL

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

20:
21: PROCEDURE create_task_type
22: (p_task_type IN pa_task_types.task_type%TYPE
23: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
24: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
25: ,p_description IN pa_task_types.description%TYPE := NULL
26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
28: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL

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

21: PROCEDURE create_task_type
22: (p_task_type IN pa_task_types.task_type%TYPE
23: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
24: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
25: ,p_description IN pa_task_types.description%TYPE := NULL
26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
28: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
29: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL

Line 26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

22: (p_task_type IN pa_task_types.task_type%TYPE
23: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
24: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
25: ,p_description IN pa_task_types.description%TYPE := NULL
26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
28: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
29: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
30: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL

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

23: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
24: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
25: ,p_description IN pa_task_types.description%TYPE := NULL
26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
28: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
29: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
30: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
31: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL

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

24: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
25: ,p_description IN pa_task_types.description%TYPE := NULL
26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
28: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
29: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
30: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
31: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
32: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL

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

25: ,p_description IN pa_task_types.description%TYPE := NULL
26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
28: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
29: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
30: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
31: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
32: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
33: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL

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

26: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
28: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
29: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
30: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
31: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
32: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
33: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
34: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL

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

27: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
28: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
29: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
30: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
31: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
32: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
33: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
34: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
35: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL

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

29: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
30: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
31: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
32: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
33: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
34: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
35: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
36: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL

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

30: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
31: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
32: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
33: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
34: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
35: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
36: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL

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

31: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
32: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
33: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
34: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
35: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
36: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL

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

32: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
33: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
34: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
35: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
36: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL

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

33: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
34: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
35: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
36: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL

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

34: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
35: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
36: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL

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

35: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
36: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL

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

36: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL

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

37: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL

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

38: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL

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

39: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL

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

40: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL

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

41: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL

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

42: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL

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

43: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL

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

44: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL

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

45: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
53: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL

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

46: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
53: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
54: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL

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

47: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
53: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
54: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
55: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL

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

48: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
53: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
54: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
55: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
56: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL

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

49: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
53: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
54: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
55: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
56: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
57: ,p_api_version IN NUMBER := 1.0

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

50: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
53: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
54: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
55: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
56: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
57: ,p_api_version IN NUMBER := 1.0
58: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

51: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
53: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
54: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
55: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
56: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
57: ,p_api_version IN NUMBER := 1.0
58: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

52: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
53: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
54: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
55: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
56: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
57: ,p_api_version IN NUMBER := 1.0
58: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

57: ,p_api_version IN NUMBER := 1.0
58: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
61: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
62: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
63: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
64: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
65:

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

58: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
61: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
62: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
63: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
64: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
65:
66: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
61: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
62: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
63: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
64: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
65:
66: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
67: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

60: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
61: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
62: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
63: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
64: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
65:
66: ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
67: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
68: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 79: l_task_weighting_deriv_code pa_task_types.task_weighting_deriv_code%TYPE;

75: l_new_msg_data VARCHAR2(2000);
76: --Bug: 4537865
77: l_error_message_code VARCHAR2(100);
78: l_task_prog_entry_page_id pa_page_layouts.page_id%TYPE;
79: l_task_weighting_deriv_code pa_task_types.task_weighting_deriv_code%TYPE;
80: l_task_type_class_code pa_task_types.task_type_class_code%TYPE;
81:
82: BEGIN
83:

Line 80: l_task_type_class_code pa_task_types.task_type_class_code%TYPE;

76: --Bug: 4537865
77: l_error_message_code VARCHAR2(100);
78: l_task_prog_entry_page_id pa_page_layouts.page_id%TYPE;
79: l_task_weighting_deriv_code pa_task_types.task_weighting_deriv_code%TYPE;
80: l_task_type_class_code pa_task_types.task_type_class_code%TYPE;
81:
82: BEGIN
83:
84: -- Initialize the Error Stack

Line 101: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Create_Task_Type.begin'

97: SAVEPOINT CREATE_TASK_TYPE_PUB;
98: END IF;
99:
100: --Log Message
101: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Create_Task_Type.begin'
102: ,x_msg => 'Beginning of Create_Task_Type pub'
103: ,x_log_level => 5);
104:
105:

Line 164: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Create_Task_Type.begin'

160: end if ;
161:
162: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
163: --Log Message
164: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Create_Task_Type.begin'
165: ,x_msg => 'calling create_Task_Type pvt'
166: ,x_log_level => 5);
167:
168: PA_TASK_TYPE_PVT.create_Task_Type

Line 314: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Create_Task_Type'

310: ROLLBACK TO CREATE_TASK_TYPE_PUB;
311: END IF;
312:
313: -- Set the excetption Message and the stack
314: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Create_Task_Type'
315: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
316: --
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: RAISE;

Line 324: ( p_task_type_id IN pa_task_types.task_type_id%TYPE

320: END Create_Task_Type;
321:
322:
323: PROCEDURE Update_Task_Type
324: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
325: ,p_task_type IN pa_task_types.task_type%TYPE
326: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
327: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
328: ,p_description IN pa_task_types.description%TYPE := NULL

Line 325: ,p_task_type IN pa_task_types.task_type%TYPE

321:
322:
323: PROCEDURE Update_Task_Type
324: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
325: ,p_task_type IN pa_task_types.task_type%TYPE
326: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
327: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
328: ,p_description IN pa_task_types.description%TYPE := NULL
329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

Line 326: ,p_start_date_active IN pa_task_types.start_date_active%TYPE

322:
323: PROCEDURE Update_Task_Type
324: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
325: ,p_task_type IN pa_task_types.task_type%TYPE
326: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
327: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
328: ,p_description IN pa_task_types.description%TYPE := NULL
329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL

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

323: PROCEDURE Update_Task_Type
324: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
325: ,p_task_type IN pa_task_types.task_type%TYPE
326: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
327: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
328: ,p_description IN pa_task_types.description%TYPE := NULL
329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
331: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL

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

324: ( p_task_type_id IN pa_task_types.task_type_id%TYPE
325: ,p_task_type IN pa_task_types.task_type%TYPE
326: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
327: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
328: ,p_description IN pa_task_types.description%TYPE := NULL
329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
331: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
332: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL

Line 329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE

325: ,p_task_type IN pa_task_types.task_type%TYPE
326: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
327: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
328: ,p_description IN pa_task_types.description%TYPE := NULL
329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
331: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
332: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
333: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL

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

326: ,p_start_date_active IN pa_task_types.start_date_active%TYPE
327: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
328: ,p_description IN pa_task_types.description%TYPE := NULL
329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
331: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
332: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
333: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
334: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL

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

327: ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
328: ,p_description IN pa_task_types.description%TYPE := NULL
329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
331: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
332: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
333: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
334: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
335: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL

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

328: ,p_description IN pa_task_types.description%TYPE := NULL
329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
331: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
332: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
333: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
334: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
335: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
336: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL

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

329: ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
331: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
332: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
333: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
334: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
335: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
336: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
337: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL

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

330: ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
331: ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
332: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
333: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
334: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
335: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
336: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
337: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
338: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL

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

332: ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
333: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
334: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
335: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
336: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
337: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
338: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
339: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL

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

333: ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
334: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
335: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
336: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
337: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
338: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
339: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL

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

334: ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
335: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
336: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
337: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
338: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
339: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL

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

335: ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
336: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
337: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
338: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
339: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL

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

336: ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
337: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
338: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
339: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL

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

337: ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
338: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
339: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL

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

338: ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
339: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL

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

339: ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL

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

340: ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL

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

341: ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL

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

342: ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL

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

343: ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL

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

344: ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL

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

345: ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL

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

346: ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL

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

347: ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL

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

348: ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL

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

349: ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
357: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL

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

350: ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
357: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
358: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL

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

351: ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
357: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
358: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
359: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL

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

352: ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
357: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
358: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
359: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
360: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method

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

353: ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
357: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
358: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
359: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
360: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
361: ,p_api_version IN NUMBER := 1.0

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

354: ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
357: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
358: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
359: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
360: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
361: ,p_api_version IN NUMBER := 1.0
362: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

355: ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
357: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
358: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
359: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
360: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
361: ,p_api_version IN NUMBER := 1.0
362: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
363: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

356: ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
357: ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
358: ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
359: ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
360: ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
361: ,p_api_version IN NUMBER := 1.0
362: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
363: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
364: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

361: ,p_api_version IN NUMBER := 1.0
362: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
363: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
364: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
365: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
366: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
367: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
369: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

362: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
363: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
364: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
365: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
366: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
367: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
369: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
370: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

363: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
364: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
365: ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
366: ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
367: ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
369: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
370: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
371: )

Line 381: l_task_weighting_deriv_code pa_task_types.task_weighting_deriv_code%TYPE;

377: l_new_msg_data VARCHAR2(2000);
378: --Bug: 4537865
379: l_error_message_code VARCHAR2(100);
380: l_task_prog_entry_page_id pa_page_layouts.page_id%TYPE;
381: l_task_weighting_deriv_code pa_task_types.task_weighting_deriv_code%TYPE;
382: l_is_task_type_used VARCHAR2(1);
383: l_task_type_class_code pa_task_types.task_type_class_code%TYPE;
384:
385: CURSOR c1 IS

Line 383: l_task_type_class_code pa_task_types.task_type_class_code%TYPE;

379: l_error_message_code VARCHAR2(100);
380: l_task_prog_entry_page_id pa_page_layouts.page_id%TYPE;
381: l_task_weighting_deriv_code pa_task_types.task_weighting_deriv_code%TYPE;
382: l_is_task_type_used VARCHAR2(1);
383: l_task_type_class_code pa_task_types.task_type_class_code%TYPE;
384:
385: CURSOR c1 IS
386: SELECT prog_entry_enable_flag, prog_entry_req_flag, wq_enable_flag, remain_effort_enable_flag, percent_comp_enable_flag, end_date_active
387: FROM pa_task_types

Line 387: FROM pa_task_types

383: l_task_type_class_code pa_task_types.task_type_class_code%TYPE;
384:
385: CURSOR c1 IS
386: SELECT prog_entry_enable_flag, prog_entry_req_flag, wq_enable_flag, remain_effort_enable_flag, percent_comp_enable_flag, end_date_active
387: FROM pa_task_types
388: WHERE task_type_id = p_task_type_id;
389:
390: v_c1 c1%ROWTYPE;
391:

Line 395: PA_DEBUG.init_err_stack('PA_TASK_TYPES_PUB.Update_Task_Type');

391:
392: BEGIN
393:
394: -- Initialize the Error Stack
395: PA_DEBUG.init_err_stack('PA_TASK_TYPES_PUB.Update_Task_Type');
396:
397: -- Initialize the return status to success
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399:

Line 411: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Update_Task_Type.begin'

407: SAVEPOINT UPDATE_TASK_TYPE_PUB;
408: END IF;
409:
410: --Log Message
411: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Update_Task_Type.begin'
412: ,x_msg => 'Beginning of Update_Task_Type pub'
413: ,x_log_level => 5);
414:
415:

Line 507: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Update_Task_Type.begin'

503: end if ;
504:
505: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
506: --Log Message
507: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Update_Task_Type.begin'
508: ,x_msg => 'calling Update_Task_Type pvt'
509: ,x_log_level => 5);
510:
511: PA_TASK_TYPE_PVT.Update_Task_Type

Line 764: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Update_Task_Type'

760: IF p_commit = FND_API.G_TRUE THEN
761: ROLLBACK TO UPDATE_TASK_TYPE_PUB;
762: END IF;
763: -- Set the excetption Message and the stack
764: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Update_Task_Type'
765: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
766: --
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
768: RAISE;

Line 774: (p_Task_Type_id IN pa_task_types.Task_Type_id%TYPE := NULL

770: END Update_Task_Type;
771:
772:
773: PROCEDURE Delete_Task_Type
774: (p_Task_Type_id IN pa_task_types.Task_Type_id%TYPE := NULL
775: ,p_api_version IN NUMBER := 1.0
776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
777: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
778: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 793: PA_DEBUG.init_err_stack('PA_task_types_PUB.Delete_Task_Type');

789:
790: BEGIN
791:
792: -- Initialize the Error Stack
793: PA_DEBUG.init_err_stack('PA_task_types_PUB.Delete_Task_Type');
794:
795: -- Initialize the return status to success
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:

Line 809: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_task_types_PUB.Delete_Task_Type.begin'

805: SAVEPOINT DELETE_TASK_TYPE_PUB;
806: END IF;
807:
808: --Log Message
809: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_task_types_PUB.Delete_Task_Type.begin'
810: ,x_msg => 'Beginning of Delete_Task_Type pub'
811: ,x_log_level => 5);
812:
813: --Log Message

Line 814: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Delete_Task_Type.begin'

810: ,x_msg => 'Beginning of Delete_Task_Type pub'
811: ,x_log_level => 5);
812:
813: --Log Message
814: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Delete_Task_Type.begin'
815: ,x_msg => 'calling Delete_Task_Type pvt'
816: ,x_log_level => 5);
817:
818: -- Check whether the task type is the seeded task type.

Line 901: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Delete_Task_Type'

897: ROLLBACK TO Delete_TASK_TYPE_PUB;
898: END IF;
899:
900: -- Set the exception Message and the stack
901: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Delete_Task_Type'
902: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
904: RAISE;
905:

Line 920: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name

916: --Assumptions : None
917: -- List of parameters other than standard IN and OUT parameters
918: -- Parameters Type Null? Default Value Description and Purpose
919: -- --------------------------- -------- ------ --------------- ----------------------------
920: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
921: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
922: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date

Line 921: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag

917: -- List of parameters other than standard IN and OUT parameters
918: -- Parameters Type Null? Default Value Description and Purpose
919: -- --------------------------- -------- ------ --------------- ----------------------------
920: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
921: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
922: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
925: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date

Line 922: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status

918: -- Parameters Type Null? Default Value Description and Purpose
919: -- --------------------------- -------- ------ --------------- ----------------------------
920: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
921: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
922: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
925: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
926: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description

Line 923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action

919: -- --------------------------- -------- ------ --------------- ----------------------------
920: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
921: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
922: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
925: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
926: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
927: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL

Line 924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date

920: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
921: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
922: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
925: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
926: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
927: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
928:

Line 925: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date

921: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
922: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
925: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
926: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
927: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
928:
929:

Line 926: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description

922: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
925: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
926: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
927: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
928:
929:
930: --28-Dec-2003 avaithia Created

Line 927: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL

923: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
924: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
925: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
926: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
927: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
928:
929:
930: --28-Dec-2003 avaithia Created
931:

Line 941: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

937: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
938: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
939: ,p_debug_mode IN VARCHAR2 := 'N'
940: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
941: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
942: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
943: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
944: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

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

938: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
939: ,p_debug_mode IN VARCHAR2 := 'N'
940: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
941: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
942: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
943: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
944: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

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

939: ,p_debug_mode IN VARCHAR2 := 'N'
940: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
941: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
942: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
943: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
944: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
947: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

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

940: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
941: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
942: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
943: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
944: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
947: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
948: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

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

941: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
942: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
943: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
944: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
947: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
948: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
949: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL

Line 946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

942: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
943: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
944: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
947: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
948: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
949: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
950: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1

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

943: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
944: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
947: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
948: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
949: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
950: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
951: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

944: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
947: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
948: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
949: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
950: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
951: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
952: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

945: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
947: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
948: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
949: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
950: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
951: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
952: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
953: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

946: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
947: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
948: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
949: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
950: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
951: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
952: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
953: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
954: )

Line 1182: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name

1178:
1179: -- List of parameters other than standard IN and OUT parameters
1180: -- Parameters Type Null? Default Value Description and Purpose
1181: -- --------------------------- -------- ------ --------------- ----------------------------
1182: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1183: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
1184: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date

Line 1183: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag

1179: -- List of parameters other than standard IN and OUT parameters
1180: -- Parameters Type Null? Default Value Description and Purpose
1181: -- --------------------------- -------- ------ --------------- ----------------------------
1182: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1183: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
1184: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1187: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date

Line 1184: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status

1180: -- Parameters Type Null? Default Value Description and Purpose
1181: -- --------------------------- -------- ------ --------------- ----------------------------
1182: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1183: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
1184: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1187: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1188: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description

Line 1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action

1181: -- --------------------------- -------- ------ --------------- ----------------------------
1182: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1183: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
1184: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1187: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1188: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1189: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N

Line 1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date

1182: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1183: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
1184: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1187: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1188: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1189: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
1190: --28-Dec-2003 avaithia Created

Line 1187: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date

1183: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entry Flag
1184: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1187: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1188: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1189: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
1190: --28-Dec-2003 avaithia Created
1191: PROCEDURE UPDATE_DELIVERABLE_TYPE

Line 1188: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description

1184: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED'Initial Deliverable Status
1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1187: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1188: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1189: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
1190: --28-Dec-2003 avaithia Created
1191: PROCEDURE UPDATE_DELIVERABLE_TYPE
1192: (p_api_version IN NUMBER := 1.0

Line 1189: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N

1185: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1186: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1187: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1188: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1189: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE N
1190: --28-Dec-2003 avaithia Created
1191: PROCEDURE UPDATE_DELIVERABLE_TYPE
1192: (p_api_version IN NUMBER := 1.0
1193: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 1200: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

1196: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1197: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1198: ,p_debug_mode IN VARCHAR2 := 'N'
1199: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1200: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1201: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1202: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1203: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

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

1197: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1198: ,p_debug_mode IN VARCHAR2 := 'N'
1199: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1200: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1201: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1202: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1203: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

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

1198: ,p_debug_mode IN VARCHAR2 := 'N'
1199: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1200: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1201: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1202: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1203: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1206: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

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

1199: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1200: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1201: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1202: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1203: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1206: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1207: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

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

1200: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1201: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1202: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1203: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1206: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1207: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1208: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

Line 1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

1201: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1202: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1203: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1206: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1207: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1208: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
1209: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

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

1202: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1203: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1206: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1207: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1208: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
1209: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
1210: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1203: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1206: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1207: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1208: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
1209: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
1210: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1211: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1208: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

1204: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1206: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1207: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1208: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
1209: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
1210: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1211: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1212: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1209: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

1205: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1206: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1207: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1208: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
1209: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
1210: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1211: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1212: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1213: )

Line 1297: FROM PA_TASK_TYPES

1293: --Perform the standard Locking
1294:
1295: BEGIN
1296: select 'x' into l_dummy
1297: FROM PA_TASK_TYPES
1298: WHERE TASK_TYPE_ID = p_deliverable_type_id
1299: AND OBJECT_TYPE = 'PA_DLVR_TYPES'
1300: AND record_version_number = p_record_version_number
1301: for UPDATE of record_version_number NOWAIT;

Line 1543: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id

1539: -- in which business logic validations are done and call to table handler is placed
1540: -- List of parameters other than standard IN and OUT parameters
1541: -- Parameters Type Null? Description and Purpose
1542: -- --------------------------- ------------------------------- -------- -----------------------------------
1543: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
1544: --p_record_version_number PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE N Record Version Number
1545:
1546: --This API is called by SS pages
1547: --28-Dec-2003 avaithia Created

Line 1544: --p_record_version_number PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE N Record Version Number

1540: -- List of parameters other than standard IN and OUT parameters
1541: -- Parameters Type Null? Description and Purpose
1542: -- --------------------------- ------------------------------- -------- -----------------------------------
1543: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
1544: --p_record_version_number PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE N Record Version Number
1545:
1546: --This API is called by SS pages
1547: --28-Dec-2003 avaithia Created
1548:

Line 1558: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

1554: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1555: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1556: ,p_debug_mode IN VARCHAR2 := 'N'
1557: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1558: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
1559: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
1560: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1561: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1562: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1559: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE

1555: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1556: ,p_debug_mode IN VARCHAR2 := 'N'
1557: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1558: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
1559: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
1560: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1561: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1562: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1563: )

Line 1786: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name

1782: -- Assumptions : None
1783: -- List of parameters other than standard IN and OUT parameters
1784: -- Parameters Type Null? Default Value Description and Purpose
1785: -- --------------------------- ------- -------- -------------------- ---------------------------
1786: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1787: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entrable Flag
1788: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED' Initial Deliverable Status
1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date

Line 1787: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entrable Flag

1783: -- List of parameters other than standard IN and OUT parameters
1784: -- Parameters Type Null? Default Value Description and Purpose
1785: -- --------------------------- ------- -------- -------------------- ---------------------------
1786: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1787: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entrable Flag
1788: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED' Initial Deliverable Status
1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1791: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date

Line 1788: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED' Initial Deliverable Status

1784: -- Parameters Type Null? Default Value Description and Purpose
1785: -- --------------------------- ------- -------- -------------------- ---------------------------
1786: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1787: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entrable Flag
1788: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED' Initial Deliverable Status
1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1791: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1792: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description

Line 1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action

1785: -- --------------------------- ------- -------- -------------------- ---------------------------
1786: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1787: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entrable Flag
1788: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED' Initial Deliverable Status
1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1791: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1792: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1793: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL

Line 1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date

1786: --P_deliverable_type_name PA_TASK_TYPES.TASK_TYPE%TYPE N Deliverable Type Name
1787: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entrable Flag
1788: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED' Initial Deliverable Status
1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1791: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1792: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1793: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
1794: --P_insert_or_update VARCHAR2 N 'INSERT' Insert/Update

Line 1791: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date

1787: --P_prog_entry_enable_flag PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE Y 'N' Progress Entrable Flag
1788: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED' Initial Deliverable Status
1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1791: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1792: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1793: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
1794: --P_insert_or_update VARCHAR2 N 'INSERT' Insert/Update
1795:

Line 1792: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description

1788: --P_initial_deliverable_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE Y 'DLVR_NOT_STARTED' Initial Deliverable Status
1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1791: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1792: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1793: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
1794: --P_insert_or_update VARCHAR2 N 'INSERT' Insert/Update
1795:
1796: --28-Dec-2003 avaithia Created

Line 1793: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL

1789: --P_enable_deliverable_actions PA_TASK_TYPES.ENABLE_DLVR_ACTIONS%TYPE Y 'N' Enable Deliverable Action
1790: --P_effective_from PA_TASK_TYPES.START_DATE_ACTIVE%TYPE N Effective from date
1791: --p_effective_to PA_TASK_TYPES. END_DATE_ACTIVE %TYPE Y NULL Effective to date
1792: --P_description PA_TASK_TYPES.DESCRIPTION%TYPE Y NULL Description
1793: --P_deliverable_type_id PA_TASK_TYPES.TASK_TYPE_ID%TPE Y NULL
1794: --P_insert_or_update VARCHAR2 N 'INSERT' Insert/Update
1795:
1796: --28-Dec-2003 avaithia Created
1797:

Line 1807: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE

1803: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1804: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1805: ,p_debug_mode IN VARCHAR2 := 'N'
1806: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1807: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1808: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1809: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1810: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'

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

1804: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1805: ,p_debug_mode IN VARCHAR2 := 'N'
1806: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1807: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1808: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1809: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1810: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

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

1805: ,p_debug_mode IN VARCHAR2 := 'N'
1806: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1807: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1808: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1809: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1810: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1813: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL

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

1806: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1807: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1808: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1809: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1810: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1813: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1814: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL

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

1807: ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
1808: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1809: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1810: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1813: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1814: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1815: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL

Line 1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE

1808: ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
1809: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1810: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1813: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1814: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1815: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
1816: ,p_insert_or_update IN VARCHAR2 := 'INSERT'

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

1809: ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
1810: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1813: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1814: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1815: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
1816: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
1817: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1

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

1810: ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1813: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1814: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1815: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
1816: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
1817: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
1818: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1811: ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
1812: ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
1813: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1814: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1815: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
1816: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
1817: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
1818: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1819: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

1813: ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
1814: ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
1815: ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
1816: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
1817: ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
1818: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1819: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1820: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1821: )