eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_WORKPLAN_ATTR_PVT dependencies on FND_API

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

6: -- API name : Create_Proj_Workplan_Attrs
7: -- Type : Private
8: -- Pre-reqs : None.
9: -- Parameters :
10: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

7: -- Type : Private
8: -- Pre-reqs : None.
9: -- Parameters :
10: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
15: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

8: -- Pre-reqs : None.
9: -- Parameters :
10: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
15: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
16: -- p_project_id IN NUMBER Required

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

11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
15: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
16: -- p_project_id IN NUMBER Required
17: -- p_proj_element_id IN NUMBER Required
18: -- p_approval_reqd_flag IN VARCHAR2 Required
19: -- p_auto_publish_flag IN VARCHAR2 Required

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

22: -- p_default_display_lvl IN NUMBER Required
23: -- p_enable_wp_version_flag IN VARCHAR2 Required
24: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
25: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
26: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
28: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
29: -- x_return_status OUT VARCHAR2 Required
30: -- x_msg_count OUT NUMBER Required

Line 27: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

23: -- p_enable_wp_version_flag IN VARCHAR2 Required
24: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
25: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
26: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
28: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
29: -- x_return_status OUT VARCHAR2 Required
30: -- x_msg_count OUT NUMBER Required
31: -- x_msg_data OUT VARCHAR2 Optional

Line 28: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

24: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
25: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
26: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
27: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
28: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
29: -- x_return_status OUT VARCHAR2 Required
30: -- x_msg_count OUT NUMBER Required
31: -- x_msg_data OUT VARCHAR2 Optional
32:

Line 34: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

30: -- x_msg_count OUT NUMBER Required
31: -- x_msg_data OUT VARCHAR2 Optional
32:
33: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
34: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'

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

31: -- x_msg_data OUT VARCHAR2 Optional
32:
33: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
34: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'
39: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

32:
33: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
34: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'
39: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
40: ,p_project_id IN NUMBER

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

35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'
39: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
40: ,p_project_id IN NUMBER
41: ,p_proj_element_id IN NUMBER
42: ,p_approval_reqd_flag IN VARCHAR2
43: ,p_auto_publish_flag IN VARCHAR2

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

46: ,p_default_display_lvl IN NUMBER
47: ,p_enable_wp_version_flag IN VARCHAR2
48: ,p_auto_pub_upon_creation_flag IN VARCHAR2
49: ,p_auto_sync_txn_date_flag IN VARCHAR2
50: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
51: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
53: --bug 3325803: FP M
54: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

47: ,p_enable_wp_version_flag IN VARCHAR2
48: ,p_auto_pub_upon_creation_flag IN VARCHAR2
49: ,p_auto_sync_txn_date_flag IN VARCHAR2
50: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
51: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
53: --bug 3325803: FP M
54: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
55: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 52: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

48: ,p_auto_pub_upon_creation_flag IN VARCHAR2
49: ,p_auto_sync_txn_date_flag IN VARCHAR2
50: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
51: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
53: --bug 3325803: FP M
54: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
55: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 54: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

50: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
51: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
53: --bug 3325803: FP M
54: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
55: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: --bug 3325803: FP M

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

51: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
52: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
53: --bug 3325803: FP M
54: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
55: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: --bug 3325803: FP M
59: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

52: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
53: --bug 3325803: FP M
54: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
55: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: --bug 3325803: FP M
59: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

53: --bug 3325803: FP M
54: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
55: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
58: --bug 3325803: FP M
59: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
61: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

65: -- API name : Update_Proj_Workplan_Attrs
66: -- Type : Private
67: -- Pre-reqs : None.
68: -- Parameters :
69: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
70: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
73: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

66: -- Type : Private
67: -- Pre-reqs : None.
68: -- Parameters :
69: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
70: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
73: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
74: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

67: -- Pre-reqs : None.
68: -- Parameters :
69: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
70: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
73: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
74: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
75: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM

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

70: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
73: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
74: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
75: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
76: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 75: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM

71: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
73: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
74: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
75: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
76: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 76: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM

72: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
73: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
74: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
75: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
76: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM

73: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
74: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
75: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
76: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM

Line 78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

74: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
75: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
76: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

75: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
76: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

76: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM

77: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
85: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

78: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
85: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
86: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

79: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
85: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
86: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
87: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

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

80: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
85: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
86: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
87: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
88: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

81: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
85: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
86: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
87: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
88: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
89: -- x_return_status OUT VARCHAR2 Required

Line 86: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

82: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
85: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
86: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
87: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
88: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
89: -- x_return_status OUT VARCHAR2 Required
90: -- x_msg_count OUT NUMBER Required

Line 87: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

83: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
85: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
86: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
87: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
88: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
89: -- x_return_status OUT VARCHAR2 Required
90: -- x_msg_count OUT NUMBER Required
91: -- x_msg_data OUT VARCHAR2 Optional

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

84: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
85: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
86: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
87: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
88: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
89: -- x_return_status OUT VARCHAR2 Required
90: -- x_msg_count OUT NUMBER Required
91: -- x_msg_data OUT VARCHAR2 Optional
92:

Line 94: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

90: -- x_msg_count OUT NUMBER Required
91: -- x_msg_data OUT VARCHAR2 Optional
92:
93: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
94: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'

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

91: -- x_msg_data OUT VARCHAR2 Optional
92:
93: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
94: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

92:
93: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
94: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

95: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
101: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
102: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
101: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
102: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

97: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
101: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
102: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

98: ,p_debug_mode IN VARCHAR2 := 'N'
99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
101: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
102: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

99: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
101: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
102: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

100: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
101: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
102: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

101: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
102: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

102: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
110: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

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

103: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
110: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

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

104: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
110: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

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

105: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
110: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
113: --bug 3325803: FP M

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

106: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
110: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
113: --bug 3325803: FP M
114: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

107: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
110: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
113: --bug 3325803: FP M
114: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

108: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
110: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
113: --bug 3325803: FP M
114: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
116: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 114: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

110: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
113: --bug 3325803: FP M
114: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
116: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
118: --bug 3325803: FP M

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

111: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
113: --bug 3325803: FP M
114: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
116: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
118: --bug 3325803: FP M
119: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

112: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
113: --bug 3325803: FP M
114: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
116: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
118: --bug 3325803: FP M
119: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
120: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

113: --bug 3325803: FP M
114: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
116: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
118: --bug 3325803: FP M
119: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
120: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
121: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

115: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
116: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
118: --bug 3325803: FP M
119: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
120: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
121: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
122: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
123: );

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

126: -- API name : Update_Structure_Name
127: -- Type : Private
128: -- Pre-reqs : None.
129: -- Parameters :
130: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
131: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
134: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

127: -- Type : Private
128: -- Pre-reqs : None.
129: -- Parameters :
130: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
131: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
134: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
135: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

128: -- Pre-reqs : None.
129: -- Parameters :
130: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
131: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
134: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
135: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
136: -- p_proj_element_id IN NUMBER Required

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

131: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
134: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
135: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
136: -- p_proj_element_id IN NUMBER Required
137: -- p_structure_name IN VARCHAR2 Required
138: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
139: -- x_return_status OUT VARCHAR2 Required

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

134: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
135: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
136: -- p_proj_element_id IN NUMBER Required
137: -- p_structure_name IN VARCHAR2 Required
138: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
139: -- x_return_status OUT VARCHAR2 Required
140: -- x_msg_count OUT NUMBER Required
141: -- x_msg_data OUT VARCHAR2 Optional
142:

Line 144: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

140: -- x_msg_count OUT NUMBER Required
141: -- x_msg_data OUT VARCHAR2 Optional
142:
143: PROCEDURE UPDATE_STRUCTURE_NAME
144: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
145: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
148: ,p_debug_mode IN VARCHAR2 := 'N'

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

141: -- x_msg_data OUT VARCHAR2 Optional
142:
143: PROCEDURE UPDATE_STRUCTURE_NAME
144: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
145: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
148: ,p_debug_mode IN VARCHAR2 := 'N'
149: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

142:
143: PROCEDURE UPDATE_STRUCTURE_NAME
144: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
145: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
148: ,p_debug_mode IN VARCHAR2 := 'N'
149: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
150: ,p_proj_element_id IN NUMBER

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

145: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
148: ,p_debug_mode IN VARCHAR2 := 'N'
149: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
150: ,p_proj_element_id IN NUMBER
151: ,p_structure_name IN VARCHAR2
152: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
153: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

148: ,p_debug_mode IN VARCHAR2 := 'N'
149: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
150: ,p_proj_element_id IN NUMBER
151: ,p_structure_name IN VARCHAR2
152: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
153: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
154: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
155: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: );

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

159: -- API name : Delete_Proj_Workplan_Attrs
160: -- Type : Private
161: -- Pre-reqs : None.
162: -- Parameters :
163: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
164: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
167: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

160: -- Type : Private
161: -- Pre-reqs : None.
162: -- Parameters :
163: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
164: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
167: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
168: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

161: -- Pre-reqs : None.
162: -- Parameters :
163: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
164: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
167: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
168: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
169: -- p_project_id IN NUMBER Required

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

164: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
167: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
168: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
169: -- p_project_id IN NUMBER Required
170: -- p_proj_element_id IN NUMBER Required
171: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
172: -- x_return_status OUT VARCHAR2 Required

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

167: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
168: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
169: -- p_project_id IN NUMBER Required
170: -- p_proj_element_id IN NUMBER Required
171: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
172: -- x_return_status OUT VARCHAR2 Required
173: -- x_msg_count OUT NUMBER Required
174: -- x_msg_data OUT VARCHAR2 Optional
175:

Line 177: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

173: -- x_msg_count OUT NUMBER Required
174: -- x_msg_data OUT VARCHAR2 Optional
175:
176: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
177: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'

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

174: -- x_msg_data OUT VARCHAR2 Optional
175:
176: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
177: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'
182: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

175:
176: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
177: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'
182: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
183: ,p_project_id IN NUMBER

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

178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 := 'N'
182: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
183: ,p_project_id IN NUMBER
184: ,p_proj_element_id IN NUMBER
185: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
186: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

181: ,p_debug_mode IN VARCHAR2 := 'N'
182: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
183: ,p_project_id IN NUMBER
184: ,p_proj_element_id IN NUMBER
185: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
186: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
187: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
188: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
189: );