DBA Data[Home] [Help]

APPS.PA_WORKPLAN_ATTR_PUB dependencies on FND_API

Line 10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

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'

Line 11: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

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'

Line 12: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

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

Line 13: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 16: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 21: -- p_approver_source_id 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
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

Line 22: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 23: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

Line 26: -- p_lifecycle_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
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

Line 27: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

Line 28: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 29: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

Line 32: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

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:

Line 39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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'

Line 40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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'

Line 41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

Line 42: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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

Line 45: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

Line 50: ,p_approver_source_id 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
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

Line 51: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM

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

Line 52: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 55: ,p_lifecycle_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
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

Line 56: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 57: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 58: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 61: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

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

Line 63: ,p_allow_lowest_tsk_dep_flag 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

Line 64: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 65: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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'

Line 66: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

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'

Line 82: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

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'

Line 83: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

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

Line 84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 87: -- p_max_msg_count IN NUMBER Optional 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

Line 88: -- p_project_id IN NUMBER Required 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

Line 89: -- p_approval_reqd_flag IN VARCHAR2 Required 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

Line 90: -- p_auto_publish_flag IN VARCHAR2 Required 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

Line 91: -- p_approver_source_id IN NUMBER Optional 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

Line 92: -- p_approver_source_type 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
96: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 93: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

Line 94: -- p_default_display_lvl IN NUMBER 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
98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 95: -- p_enable_wp_version_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
99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 96: -- p_lifecycle_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
100: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 97: -- p_lifecycle_name IN VARCHAR2 Optional 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

Line 98: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 99: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

Line 100: -- p_auto_pub_upon_creation_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
104: --bug 3325803: FP M

Line 101: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

Line 102: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 103: -- p_record_version_number 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
107: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 105: -- p_allow_lowest_tsk_dep_flag 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

Line 106: -- p_schedule_third_party_flag IN VARCHAR2 := 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
110: -- x_return_status OUT VARCHAR2 Required

Line 107: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 108: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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'

Line 117: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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'

Line 118: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

Line 119: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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 */

Line 122: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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 */

Line 123: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* 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

Line 124: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

Line 125: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

Line 126: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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 */

Line 127: ,p_approver_source_id 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 */
131: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 128: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM

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

Line 129: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 130: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* 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
134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

Line 131: ,p_enable_wp_version_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
135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 132: ,p_lifecycle_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
136: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 133: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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 */

Line 134: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 135: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 136: ,p_auto_pub_upon_creation_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
140: --bug 3325803: FP M

Line 137: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

Line 138: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

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

Line 139: ,p_record_version_number 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
143: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 141: ,p_allow_lowest_tsk_dep_flag 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

Line 142: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 143: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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'

Line 144: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

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'

Line 159: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

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'

Line 160: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

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

Line 161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 164: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 167: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

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:

Line 174: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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'

Line 175: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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'

Line 176: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

Line 177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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

Line 180: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

Line 183: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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: );

Line 194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

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'

Line 195: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

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'

Line 196: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

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

Line 197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 200: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 203: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM

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:

Line 210: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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'

Line 211: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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'

Line 212: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

Line 213: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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

Line 216: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

Line 219: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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: );