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: ,p_enable_wf_flag IN VARCHAR2 := 'N'
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: ,p_enable_wf_flag IN VARCHAR2 := 'N'
70: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77: -- Type : Public
78: -- Pre-reqs : None.
79: -- Parameters :
80: -- p_api_version IN NUMBER Required Default = 1.0
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
82: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
83: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
78: -- Pre-reqs : None.
79: -- Parameters :
80: -- p_api_version IN NUMBER Required Default = 1.0
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
82: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
83: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
86: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
79: -- Parameters :
80: -- p_api_version IN NUMBER Required Default = 1.0
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
82: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
83: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
86: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
87: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_api_version IN NUMBER Required Default = 1.0
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
82: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
83: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
86: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
87: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
88: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
83: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
86: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
87: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
88: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
89: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
90: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
86: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
87: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
88: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
89: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
90: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
86: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
87: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
88: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
89: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
90: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
86: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
87: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
88: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
89: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
90: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
87: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
88: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
89: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
90: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
89: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
90: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
89: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
90: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
90: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
91: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
92: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
95: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: --bug 3325803: FP M
97: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: --bug 3325803: FP M
105: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: --bug 3325803: FP M
105: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
106: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: --bug 3325803: FP M
105: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
106: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
107: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: --bug 3325803: FP M
105: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
106: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
107: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
108: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: --bug 3325803: FP M
102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
103: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: --bug 3325803: FP M
105: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
106: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
107: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
108: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: --bug 3325803: FP M
110: -- x_return_status OUT VARCHAR2 Required
103: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
104: --bug 3325803: FP M
105: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
106: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
107: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
108: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: --bug 3325803: FP M
110: -- x_return_status OUT VARCHAR2 Required
111: -- x_msg_count OUT NUMBER Required
104: --bug 3325803: FP M
105: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
106: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
107: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
108: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109: --bug 3325803: FP M
110: -- x_return_status OUT VARCHAR2 Required
111: -- x_msg_count OUT NUMBER Required
112: -- x_msg_data OUT VARCHAR2 Optional
112: -- x_msg_data OUT VARCHAR2 Optional
113:
114: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
115: ( p_api_version IN NUMBER := 1.0
116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
117: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
118: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
119: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
120: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
113:
114: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
115: ( p_api_version IN NUMBER := 1.0
116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
117: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
118: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
119: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
120: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
121: ,p_debug_mode IN VARCHAR2 := 'N'
114: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
115: ( p_api_version IN NUMBER := 1.0
116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
117: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
118: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
119: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
120: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
121: ,p_debug_mode IN VARCHAR2 := 'N'
122: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
115: ( p_api_version IN NUMBER := 1.0
116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
117: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
118: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
119: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
120: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
121: ,p_debug_mode IN VARCHAR2 := 'N'
122: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
123: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
118: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
119: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
120: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
121: ,p_debug_mode IN VARCHAR2 := 'N'
122: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
123: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
124: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
119: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
120: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
121: ,p_debug_mode IN VARCHAR2 := 'N'
122: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
123: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
124: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
120: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
121: ,p_debug_mode IN VARCHAR2 := 'N'
122: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
123: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
124: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
121: ,p_debug_mode IN VARCHAR2 := 'N'
122: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
123: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
124: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
122: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
123: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
124: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
123: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
124: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
124: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
127: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
139: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
132: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
139: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
140: --bug 3325803: FP M
133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
139: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
140: --bug 3325803: FP M
141: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
139: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
140: --bug 3325803: FP M
141: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
139: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
140: --bug 3325803: FP M
141: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
139: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
140: --bug 3325803: FP M
141: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: --bug 3325803: FP M
138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
139: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
140: --bug 3325803: FP M
141: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: --bug 3325803: FP M
146: --FP M: Workflow attributes
139: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
140: --bug 3325803: FP M
141: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: --bug 3325803: FP M
146: --FP M: Workflow attributes
147: ,p_enable_wf_flag IN VARCHAR2 := 'N'
140: --bug 3325803: FP M
141: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
142: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
143: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
144: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145: --bug 3325803: FP M
146: --FP M: Workflow attributes
147: ,p_enable_wf_flag IN VARCHAR2 := 'N'
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
154: -- Type : Public
155: -- Pre-reqs : None.
156: -- Parameters :
157: -- p_api_version IN NUMBER Required Default = 1.0
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
159: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
160: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
155: -- Pre-reqs : None.
156: -- Parameters :
157: -- p_api_version IN NUMBER Required Default = 1.0
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
159: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
160: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
163: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
156: -- Parameters :
157: -- p_api_version IN NUMBER Required Default = 1.0
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
159: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
160: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
163: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
164: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
157: -- p_api_version IN NUMBER Required Default = 1.0
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
159: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
160: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
163: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
164: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_proj_element_id IN NUMBER Required
160: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
163: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
164: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_proj_element_id IN NUMBER Required
166: -- p_structure_name IN VARCHAR2 Required
167: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
168: -- x_return_status OUT VARCHAR2 Required
163: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
164: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
165: -- p_proj_element_id IN NUMBER Required
166: -- p_structure_name IN VARCHAR2 Required
167: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
168: -- x_return_status OUT VARCHAR2 Required
169: -- x_msg_count OUT NUMBER Required
170: -- x_msg_data OUT VARCHAR2 Optional
171:
170: -- x_msg_data OUT VARCHAR2 Optional
171:
172: PROCEDURE UPDATE_STRUCTURE_NAME
173: ( p_api_version IN NUMBER := 1.0
174: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
175: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
176: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
171:
172: PROCEDURE UPDATE_STRUCTURE_NAME
173: ( p_api_version IN NUMBER := 1.0
174: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
175: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
176: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
179: ,p_debug_mode IN VARCHAR2 := 'N'
172: PROCEDURE UPDATE_STRUCTURE_NAME
173: ( p_api_version IN NUMBER := 1.0
174: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
175: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
176: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
179: ,p_debug_mode IN VARCHAR2 := 'N'
180: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
173: ( p_api_version IN NUMBER := 1.0
174: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
175: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
176: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
179: ,p_debug_mode IN VARCHAR2 := 'N'
180: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
181: ,p_proj_element_id IN NUMBER
176: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
179: ,p_debug_mode IN VARCHAR2 := 'N'
180: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
181: ,p_proj_element_id IN NUMBER
182: ,p_structure_name IN VARCHAR2
183: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
184: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179: ,p_debug_mode IN VARCHAR2 := 'N'
180: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
181: ,p_proj_element_id IN NUMBER
182: ,p_structure_name IN VARCHAR2
183: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
184: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
185: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
186: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
187: );
190: -- Type : Public
191: -- Pre-reqs : None.
192: -- Parameters :
193: -- p_api_version IN NUMBER Required Default = 1.0
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
195: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
196: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
191: -- Pre-reqs : None.
192: -- Parameters :
193: -- p_api_version IN NUMBER Required Default = 1.0
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
195: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
196: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
199: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
192: -- Parameters :
193: -- p_api_version IN NUMBER Required Default = 1.0
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
195: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
196: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
199: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
200: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
193: -- p_api_version IN NUMBER Required Default = 1.0
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
195: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
196: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
199: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
200: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
201: -- p_project_id IN NUMBER Required
196: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
199: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
200: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
201: -- p_project_id IN NUMBER Required
202: -- p_proj_element_id IN NUMBER Required
203: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
204: -- x_return_status OUT VARCHAR2 Required
199: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
200: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
201: -- p_project_id IN NUMBER Required
202: -- p_proj_element_id IN NUMBER Required
203: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
204: -- x_return_status OUT VARCHAR2 Required
205: -- x_msg_count OUT NUMBER Required
206: -- x_msg_data OUT VARCHAR2 Optional
207:
206: -- x_msg_data OUT VARCHAR2 Optional
207:
208: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
209: ( p_api_version IN NUMBER := 1.0
210: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
211: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
212: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
213: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
214: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
207:
208: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
209: ( p_api_version IN NUMBER := 1.0
210: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
211: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
212: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
213: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
214: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
215: ,p_debug_mode IN VARCHAR2 := 'N'
208: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
209: ( p_api_version IN NUMBER := 1.0
210: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
211: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
212: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
213: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
214: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
215: ,p_debug_mode IN VARCHAR2 := 'N'
216: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
209: ( p_api_version IN NUMBER := 1.0
210: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
211: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
212: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
213: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
214: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
215: ,p_debug_mode IN VARCHAR2 := 'N'
216: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
217: ,p_project_id IN NUMBER
212: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
213: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
214: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
215: ,p_debug_mode IN VARCHAR2 := 'N'
216: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
217: ,p_project_id IN NUMBER
218: ,p_proj_element_id IN NUMBER
219: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
220: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
215: ,p_debug_mode IN VARCHAR2 := 'N'
216: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
217: ,p_project_id IN NUMBER
218: ,p_proj_element_id IN NUMBER
219: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
220: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
221: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
222: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
223: );