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: -- p_use_task_schedule_flag IN VARCHAR2 Optional
30: -- x_return_status OUT VARCHAR2 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: -- p_use_task_schedule_flag IN VARCHAR2 Optional
30: -- x_return_status OUT VARCHAR2 Required
31: -- x_msg_count OUT NUMBER Required

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: -- p_use_task_schedule_flag IN VARCHAR2 Optional
30: -- x_return_status OUT VARCHAR2 Required
31: -- x_msg_count OUT NUMBER Required
32: -- x_msg_data OUT VARCHAR2 Optional

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

52: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
53: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
54: --bug 3325803: FP M
55: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: -- gboomina bug 8586393 - start
60: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

53: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
54: --bug 3325803: FP M
55: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: -- gboomina bug 8586393 - start
60: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61: -- gboomina bug 8586393 - end

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

54: --bug 3325803: FP M
55: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: -- gboomina bug 8586393 - start
60: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61: -- gboomina bug 8586393 - end
62: --bug 3325803: FP M

Line 60: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

56: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59: -- gboomina bug 8586393 - start
60: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61: -- gboomina bug 8586393 - end
62: --bug 3325803: FP M
63: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

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

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

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

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

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

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

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

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

75: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
76: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
77: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
78: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
79: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
80: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
81: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
82: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

76: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
77: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
78: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
79: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
80: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
81: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
82: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

77: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
78: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
79: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
80: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
81: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
82: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM

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

78: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
79: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
80: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
81: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
82: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

79: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
80: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
81: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
82: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

80: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
81: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
82: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

81: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
82: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

82: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
90: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

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

83: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
90: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
91: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

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

84: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
90: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
91: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
92: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

85: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
90: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
91: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
92: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_use_task_schedule_flag IN NUMBER Optional

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

86: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
90: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
91: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
92: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_use_task_schedule_flag IN NUMBER Optional
94: -- x_return_status OUT VARCHAR2 Required

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

87: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
90: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
91: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
92: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_use_task_schedule_flag IN NUMBER Optional
94: -- x_return_status OUT VARCHAR2 Required
95: -- x_msg_count OUT NUMBER Required

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

88: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
90: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
91: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
92: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
93: -- p_use_task_schedule_flag IN NUMBER Optional
94: -- x_return_status OUT VARCHAR2 Required
95: -- x_msg_count OUT NUMBER Required
96: -- x_msg_data OUT VARCHAR2 Optional

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

95: -- x_msg_count OUT NUMBER Required
96: -- x_msg_data OUT VARCHAR2 Optional
97:
98: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
99: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
100: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
101: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
102: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
103: ,p_debug_mode IN VARCHAR2 := 'N'

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

96: -- x_msg_data OUT VARCHAR2 Optional
97:
98: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
99: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
100: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
101: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
102: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
103: ,p_debug_mode IN VARCHAR2 := 'N'
104: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

97:
98: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
99: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
100: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
101: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
102: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
103: ,p_debug_mode IN VARCHAR2 := 'N'
104: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
105: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

100: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
101: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
102: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
103: ,p_debug_mode IN VARCHAR2 := 'N'
104: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
105: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

101: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
102: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
103: ,p_debug_mode IN VARCHAR2 := 'N'
104: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
105: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

102: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
103: ,p_debug_mode IN VARCHAR2 := 'N'
104: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
105: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

103: ,p_debug_mode IN VARCHAR2 := 'N'
104: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
105: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

104: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
105: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

105: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

106: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

107: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
115: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

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

108: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
115: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
116: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

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

109: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
115: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
116: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
117: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

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

110: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
115: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
116: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
117: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
118: --bug 3325803: FP M

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

111: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
115: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
116: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
117: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
118: --bug 3325803: FP M
119: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

112: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
115: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
116: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
117: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
118: --bug 3325803: FP M
119: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
120: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

113: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
115: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
116: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
117: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
118: --bug 3325803: FP M
119: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
120: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
121: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

115: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
116: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
117: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
118: --bug 3325803: FP M
119: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
120: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
121: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
122: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
123: --bug 3325803: FP M

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

116: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
117: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
118: --bug 3325803: FP M
119: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
120: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
121: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
122: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
123: --bug 3325803: FP M
124: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

117: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
118: --bug 3325803: FP M
119: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
120: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
121: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
122: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
123: --bug 3325803: FP M
124: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
125: -- gboomina bug 8586393 - start

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

118: --bug 3325803: FP M
119: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
120: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
121: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
122: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
123: --bug 3325803: FP M
124: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
125: -- gboomina bug 8586393 - start
126: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

120: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
121: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
122: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
123: --bug 3325803: FP M
124: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
125: -- gboomina bug 8586393 - start
126: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
127: -- gboomina bug 8586393 - end
128: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 126: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

122: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
123: --bug 3325803: FP M
124: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
125: -- gboomina bug 8586393 - start
126: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
127: -- gboomina bug 8586393 - end
128: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
130: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

134: -- API name : Update_Structure_Name
135: -- Type : Private
136: -- Pre-reqs : None.
137: -- Parameters :
138: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
139: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
142: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

135: -- Type : Private
136: -- Pre-reqs : None.
137: -- Parameters :
138: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
139: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
142: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
143: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

136: -- Pre-reqs : None.
137: -- Parameters :
138: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
139: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
142: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
143: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
144: -- p_proj_element_id IN NUMBER Required

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

139: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
142: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
143: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
144: -- p_proj_element_id IN NUMBER Required
145: -- p_structure_name IN VARCHAR2 Required
146: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
147: -- x_return_status OUT VARCHAR2 Required

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

142: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
143: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
144: -- p_proj_element_id IN NUMBER Required
145: -- p_structure_name IN VARCHAR2 Required
146: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
147: -- x_return_status OUT VARCHAR2 Required
148: -- x_msg_count OUT NUMBER Required
149: -- x_msg_data OUT VARCHAR2 Optional
150:

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

148: -- x_msg_count OUT NUMBER Required
149: -- x_msg_data OUT VARCHAR2 Optional
150:
151: PROCEDURE UPDATE_STRUCTURE_NAME
152: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
153: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
154: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
156: ,p_debug_mode IN VARCHAR2 := 'N'

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

149: -- x_msg_data OUT VARCHAR2 Optional
150:
151: PROCEDURE UPDATE_STRUCTURE_NAME
152: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
153: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
154: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
156: ,p_debug_mode IN VARCHAR2 := 'N'
157: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

150:
151: PROCEDURE UPDATE_STRUCTURE_NAME
152: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
153: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
154: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
156: ,p_debug_mode IN VARCHAR2 := 'N'
157: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
158: ,p_proj_element_id IN NUMBER

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

153: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
154: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
156: ,p_debug_mode IN VARCHAR2 := 'N'
157: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
158: ,p_proj_element_id IN NUMBER
159: ,p_structure_name IN VARCHAR2
160: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

156: ,p_debug_mode IN VARCHAR2 := 'N'
157: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
158: ,p_proj_element_id IN NUMBER
159: ,p_structure_name IN VARCHAR2
160: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
163: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164: );

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

167: -- API name : Delete_Proj_Workplan_Attrs
168: -- Type : Private
169: -- Pre-reqs : None.
170: -- Parameters :
171: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
172: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
175: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

168: -- Type : Private
169: -- Pre-reqs : None.
170: -- Parameters :
171: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
172: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
175: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
176: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

169: -- Pre-reqs : None.
170: -- Parameters :
171: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
172: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
175: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
176: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
177: -- p_project_id IN NUMBER Required

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

172: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
175: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
176: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
177: -- p_project_id IN NUMBER Required
178: -- p_proj_element_id IN NUMBER Required
179: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
180: -- x_return_status OUT VARCHAR2 Required

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

175: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
176: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
177: -- p_project_id IN NUMBER Required
178: -- p_proj_element_id IN NUMBER Required
179: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
180: -- x_return_status OUT VARCHAR2 Required
181: -- x_msg_count OUT NUMBER Required
182: -- x_msg_data OUT VARCHAR2 Optional
183:

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

181: -- x_msg_count OUT NUMBER Required
182: -- x_msg_data OUT VARCHAR2 Optional
183:
184: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
185: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 := 'N'

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

182: -- x_msg_data OUT VARCHAR2 Optional
183:
184: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
185: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 := 'N'
190: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

183:
184: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
185: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 := 'N'
190: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
191: ,p_project_id IN NUMBER

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

186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 := 'N'
190: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
191: ,p_project_id IN NUMBER
192: ,p_proj_element_id IN NUMBER
193: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
194: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

189: ,p_debug_mode IN VARCHAR2 := 'N'
190: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
191: ,p_project_id IN NUMBER
192: ,p_proj_element_id IN NUMBER
193: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
194: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
195: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
196: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
197: );