6: -- Type : Public
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- p_api_version IN NUMBER Required Default = 1.0
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- p_api_version IN NUMBER Required Default = 1.0
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
8: -- Parameters :
9: -- p_api_version IN NUMBER Required Default = 1.0
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
9: -- p_api_version IN NUMBER Required Default = 1.0
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER Required
12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
17: -- p_project_id IN NUMBER Required
18: -- p_proj_element_id IN NUMBER Required
19: -- p_approval_reqd_flag IN VARCHAR2 Required
20: -- p_auto_publish_flag IN VARCHAR2 Required
17: -- p_project_id IN NUMBER Required
18: -- p_proj_element_id IN NUMBER Required
19: -- p_approval_reqd_flag IN VARCHAR2 Required
20: -- p_auto_publish_flag IN VARCHAR2 Required
21: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_default_display_lvl IN NUMBER Required
25: -- p_enable_wp_version_flag IN VARCHAR2 Required
18: -- p_proj_element_id IN NUMBER Required
19: -- p_approval_reqd_flag IN VARCHAR2 Required
20: -- p_auto_publish_flag IN VARCHAR2 Required
21: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_default_display_lvl IN NUMBER Required
25: -- p_enable_wp_version_flag IN VARCHAR2 Required
26: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
19: -- p_approval_reqd_flag IN VARCHAR2 Required
20: -- p_auto_publish_flag IN VARCHAR2 Required
21: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_default_display_lvl IN NUMBER Required
25: -- p_enable_wp_version_flag IN VARCHAR2 Required
26: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
22: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_default_display_lvl IN NUMBER Required
25: -- p_enable_wp_version_flag IN VARCHAR2 Required
26: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
23: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24: -- p_default_display_lvl IN NUMBER Required
25: -- p_enable_wp_version_flag IN VARCHAR2 Required
26: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
31: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
24: -- p_default_display_lvl IN NUMBER Required
25: -- p_enable_wp_version_flag IN VARCHAR2 Required
26: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
31: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
32: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
25: -- p_enable_wp_version_flag IN VARCHAR2 Required
26: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
31: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
32: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- x_return_status OUT VARCHAR2 Required
28: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
31: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
32: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
33: -- x_return_status OUT VARCHAR2 Required
34: -- x_msg_count OUT NUMBER Required
35: -- x_msg_data OUT VARCHAR2 Optional
36:
35: -- x_msg_data OUT VARCHAR2 Optional
36:
37: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
38: ( p_api_version IN NUMBER := 1.0
39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
36:
37: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
38: ( p_api_version IN NUMBER := 1.0
39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
44: ,p_debug_mode IN VARCHAR2 := 'N'
37: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
38: ( p_api_version IN NUMBER := 1.0
39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
44: ,p_debug_mode IN VARCHAR2 := 'N'
45: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
38: ( p_api_version IN NUMBER := 1.0
39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
44: ,p_debug_mode IN VARCHAR2 := 'N'
45: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
46: ,p_project_id IN NUMBER
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
44: ,p_debug_mode IN VARCHAR2 := 'N'
45: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
46: ,p_project_id IN NUMBER
47: ,p_proj_element_id IN NUMBER
48: ,p_approval_reqd_flag IN VARCHAR2
49: ,p_auto_publish_flag IN VARCHAR2
46: ,p_project_id IN NUMBER
47: ,p_proj_element_id IN NUMBER
48: ,p_approval_reqd_flag IN VARCHAR2
49: ,p_auto_publish_flag IN VARCHAR2
50: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
51: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
52: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_default_display_lvl IN NUMBER
54: ,p_enable_wp_version_flag IN VARCHAR2
47: ,p_proj_element_id IN NUMBER
48: ,p_approval_reqd_flag IN VARCHAR2
49: ,p_auto_publish_flag IN VARCHAR2
50: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
51: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
52: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_default_display_lvl IN NUMBER
54: ,p_enable_wp_version_flag IN VARCHAR2
55: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
48: ,p_approval_reqd_flag IN VARCHAR2
49: ,p_auto_publish_flag IN VARCHAR2
50: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
51: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
52: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_default_display_lvl IN NUMBER
54: ,p_enable_wp_version_flag IN VARCHAR2
55: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
56: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
52: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_default_display_lvl IN NUMBER
54: ,p_enable_wp_version_flag IN VARCHAR2
55: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
56: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
58: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_auto_pub_upon_creation_flag IN VARCHAR2
52: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53: ,p_default_display_lvl IN NUMBER
54: ,p_enable_wp_version_flag IN VARCHAR2
55: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
56: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
58: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_auto_pub_upon_creation_flag IN VARCHAR2
60: ,p_auto_sync_txn_date_flag IN VARCHAR2
53: ,p_default_display_lvl IN NUMBER
54: ,p_enable_wp_version_flag IN VARCHAR2
55: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
56: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
58: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_auto_pub_upon_creation_flag IN VARCHAR2
60: ,p_auto_sync_txn_date_flag IN VARCHAR2
61: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
54: ,p_enable_wp_version_flag IN VARCHAR2
55: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
56: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
58: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_auto_pub_upon_creation_flag IN VARCHAR2
60: ,p_auto_sync_txn_date_flag IN VARCHAR2
61: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
62: --bug 3325803: FP M
57: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
58: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_auto_pub_upon_creation_flag IN VARCHAR2
60: ,p_auto_sync_txn_date_flag IN VARCHAR2
61: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
62: --bug 3325803: FP M
63: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
64: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
59: ,p_auto_pub_upon_creation_flag IN VARCHAR2
60: ,p_auto_sync_txn_date_flag IN VARCHAR2
61: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
62: --bug 3325803: FP M
63: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
64: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: --bug 3325803: FP M
60: ,p_auto_sync_txn_date_flag IN VARCHAR2
61: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
62: --bug 3325803: FP M
63: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
64: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: --bug 3325803: FP M
68: --FP M: Workflow attributes
61: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
62: --bug 3325803: FP M
63: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
64: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: --bug 3325803: FP M
68: --FP M: Workflow attributes
69: -- gboomina Bug 8586393 - start
62: --bug 3325803: FP M
63: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
64: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
65: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: --bug 3325803: FP M
68: --FP M: Workflow attributes
69: -- gboomina Bug 8586393 - start
70: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
66: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: --bug 3325803: FP M
68: --FP M: Workflow attributes
69: -- gboomina Bug 8586393 - start
70: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
71: -- gboomina Bug 8586393 - end
72: ,p_enable_wf_flag IN VARCHAR2 := 'N'
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
80: -- Type : Public
81: -- Pre-reqs : None.
82: -- Parameters :
83: -- p_api_version IN NUMBER Required Default = 1.0
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
86: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
81: -- Pre-reqs : None.
82: -- Parameters :
83: -- p_api_version IN NUMBER Required Default = 1.0
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
86: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
89: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
82: -- Parameters :
83: -- p_api_version IN NUMBER Required Default = 1.0
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
86: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
89: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
90: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
83: -- p_api_version IN NUMBER Required Default = 1.0
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
85: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
86: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
89: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
90: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
91: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
89: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
90: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
91: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
92: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
93: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
89: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
90: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
91: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
92: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
93: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
88: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
89: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
90: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
91: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
92: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
93: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
89: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
90: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
91: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
92: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
93: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
90: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
91: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
92: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
93: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
92: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
93: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
93: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
93: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
94: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
95: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
104: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
97: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
104: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
105: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
98: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
104: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
105: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
106: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
104: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
105: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
106: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
107: --bug 3325803: FP M
100: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
104: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
105: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
106: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
107: --bug 3325803: FP M
108: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
101: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
104: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
105: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
106: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
107: --bug 3325803: FP M
108: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
102: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
104: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
105: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
106: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
107: --bug 3325803: FP M
108: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
110: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
104: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
105: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
106: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
107: --bug 3325803: FP M
108: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
110: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
112: --bug 3325803: FP M
105: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
106: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
107: --bug 3325803: FP M
108: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
110: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
112: --bug 3325803: FP M
113: -- x_return_status OUT VARCHAR2 Required
106: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
107: --bug 3325803: FP M
108: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
110: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
112: --bug 3325803: FP M
113: -- x_return_status OUT VARCHAR2 Required
114: -- x_msg_count OUT NUMBER Required
107: --bug 3325803: FP M
108: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
110: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
112: --bug 3325803: FP M
113: -- x_return_status OUT VARCHAR2 Required
114: -- x_msg_count OUT NUMBER Required
115: -- x_msg_data OUT VARCHAR2 Optional
115: -- x_msg_data OUT VARCHAR2 Optional
116:
117: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
118: ( p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
116:
117: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
118: ( p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
117: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
118: ( p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
118: ( p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
126: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
121: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
126: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
127: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
128: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
122: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
126: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
127: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
128: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
123: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
126: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
127: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
128: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
124: ,p_debug_mode IN VARCHAR2 := 'N'
125: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
126: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
127: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
128: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
125: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
126: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
127: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
128: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
126: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
127: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
128: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
128: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
129: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
130: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
131: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
140: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
133: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
140: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
141: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
134: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
140: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
141: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
142: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
135: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
140: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
141: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
142: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
143: --bug 3325803: FP M
136: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
140: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
141: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
142: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
143: --bug 3325803: FP M
144: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
140: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
141: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
142: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
143: --bug 3325803: FP M
144: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
138: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
140: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
141: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
142: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
143: --bug 3325803: FP M
144: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
146: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
140: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
141: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
142: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
143: --bug 3325803: FP M
144: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
146: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
147: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
148: --bug 3325803: FP M
141: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
142: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
143: --bug 3325803: FP M
144: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
146: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
147: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
148: --bug 3325803: FP M
149: --FP M: Workflow attributes
142: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
143: --bug 3325803: FP M
144: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
146: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
147: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
148: --bug 3325803: FP M
149: --FP M: Workflow attributes
150: -- gboomina Bug 8586393 - start
143: --bug 3325803: FP M
144: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
146: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
147: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
148: --bug 3325803: FP M
149: --FP M: Workflow attributes
150: -- gboomina Bug 8586393 - start
151: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
147: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
148: --bug 3325803: FP M
149: --FP M: Workflow attributes
150: -- gboomina Bug 8586393 - start
151: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
152: -- gboomina Bug 8586393 - end
153: ,p_enable_wf_flag IN VARCHAR2 := 'N'
154: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
155: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
160: -- Type : Public
161: -- Pre-reqs : None.
162: -- Parameters :
163: -- p_api_version IN NUMBER Required Default = 1.0
164: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
165: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
166: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
161: -- Pre-reqs : None.
162: -- Parameters :
163: -- p_api_version IN NUMBER Required Default = 1.0
164: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
165: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
166: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
169: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
162: -- Parameters :
163: -- p_api_version IN NUMBER Required Default = 1.0
164: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
165: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
166: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
169: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
170: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
163: -- p_api_version IN NUMBER Required Default = 1.0
164: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
165: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
166: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
169: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
170: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
171: -- p_proj_element_id IN NUMBER Required
166: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
169: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
170: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
171: -- p_proj_element_id IN NUMBER Required
172: -- p_structure_name IN VARCHAR2 Required
173: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
174: -- x_return_status OUT VARCHAR2 Required
169: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
170: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
171: -- p_proj_element_id IN NUMBER Required
172: -- p_structure_name IN VARCHAR2 Required
173: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
174: -- x_return_status OUT VARCHAR2 Required
175: -- x_msg_count OUT NUMBER Required
176: -- x_msg_data OUT VARCHAR2 Optional
177:
176: -- x_msg_data OUT VARCHAR2 Optional
177:
178: PROCEDURE UPDATE_STRUCTURE_NAME
179: ( p_api_version IN NUMBER := 1.0
180: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
181: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
183: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
177:
178: PROCEDURE UPDATE_STRUCTURE_NAME
179: ( p_api_version IN NUMBER := 1.0
180: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
181: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
183: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
185: ,p_debug_mode IN VARCHAR2 := 'N'
178: PROCEDURE UPDATE_STRUCTURE_NAME
179: ( p_api_version IN NUMBER := 1.0
180: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
181: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
183: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
185: ,p_debug_mode IN VARCHAR2 := 'N'
186: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
179: ( p_api_version IN NUMBER := 1.0
180: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
181: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
183: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
185: ,p_debug_mode IN VARCHAR2 := 'N'
186: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
187: ,p_proj_element_id IN NUMBER
182: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
183: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
185: ,p_debug_mode IN VARCHAR2 := 'N'
186: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
187: ,p_proj_element_id IN NUMBER
188: ,p_structure_name IN VARCHAR2
189: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
190: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
185: ,p_debug_mode IN VARCHAR2 := 'N'
186: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
187: ,p_proj_element_id IN NUMBER
188: ,p_structure_name IN VARCHAR2
189: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
190: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
191: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
192: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
193: );
196: -- Type : Public
197: -- Pre-reqs : None.
198: -- Parameters :
199: -- p_api_version IN NUMBER Required Default = 1.0
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
201: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
202: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
197: -- Pre-reqs : None.
198: -- Parameters :
199: -- p_api_version IN NUMBER Required Default = 1.0
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
201: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
202: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
205: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
198: -- Parameters :
199: -- p_api_version IN NUMBER Required Default = 1.0
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
201: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
202: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
205: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
206: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
199: -- p_api_version IN NUMBER Required Default = 1.0
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
201: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
202: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
205: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
206: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
207: -- p_project_id IN NUMBER Required
202: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
205: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
206: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
207: -- p_project_id IN NUMBER Required
208: -- p_proj_element_id IN NUMBER Required
209: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
210: -- x_return_status OUT VARCHAR2 Required
205: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
206: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
207: -- p_project_id IN NUMBER Required
208: -- p_proj_element_id IN NUMBER Required
209: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
210: -- x_return_status OUT VARCHAR2 Required
211: -- x_msg_count OUT NUMBER Required
212: -- x_msg_data OUT VARCHAR2 Optional
213:
212: -- x_msg_data OUT VARCHAR2 Optional
213:
214: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
215: ( p_api_version IN NUMBER := 1.0
216: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
217: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
218: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
219: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
220: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
213:
214: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
215: ( p_api_version IN NUMBER := 1.0
216: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
217: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
218: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
219: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
220: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
221: ,p_debug_mode IN VARCHAR2 := 'N'
214: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
215: ( p_api_version IN NUMBER := 1.0
216: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
217: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
218: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
219: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
220: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
221: ,p_debug_mode IN VARCHAR2 := 'N'
222: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
215: ( p_api_version IN NUMBER := 1.0
216: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
217: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
218: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
219: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
220: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
221: ,p_debug_mode IN VARCHAR2 := 'N'
222: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
223: ,p_project_id IN NUMBER
218: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
219: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
220: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
221: ,p_debug_mode IN VARCHAR2 := 'N'
222: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
223: ,p_project_id IN NUMBER
224: ,p_proj_element_id IN NUMBER
225: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
226: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
221: ,p_debug_mode IN VARCHAR2 := 'N'
222: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
223: ,p_project_id IN NUMBER
224: ,p_proj_element_id IN NUMBER
225: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
226: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
227: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
228: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
229: );