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 12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 93: if p_commit = FND_API.G_TRUE then

89: if (p_debug_mode = 'Y') then
90: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Create_Proj_Workplan_Attrs BEGIN');
91: end if;
92:
93: if p_commit = FND_API.G_TRUE then
94: savepoint create_proj_workplan_attrs_pvt;
95: end if;
96:
97: if p_approval_reqd_flag <> 'Y' then

Line 107: if p_txn_date_sync_buf_days = FND_API.G_MISS_NUM THEN

103: l_approver_source_id := p_approver_source_id;
104: l_approver_source_type := p_approver_source_type;
105: end if;
106:
107: if p_txn_date_sync_buf_days = FND_API.G_MISS_NUM THEN
108: l_txn_date_sync_buf_days := NULL;
109: else
110: l_txn_date_sync_buf_days := p_txn_date_sync_buf_days;
111: end if;

Line 113: If p_lifecycle_version_id = FND_API.G_MISS_NUM THEN

109: else
110: l_txn_date_sync_buf_days := p_txn_date_sync_buf_days;
111: end if;
112:
113: If p_lifecycle_version_id = FND_API.G_MISS_NUM THEN
114: l_lifecycle_version_id := NULL;
115: else
116: l_lifecycle_version_id := p_lifecycle_version_id;
117: end if;

Line 119: IF p_current_phase_version_id = FND_API.G_MISS_NUM THEN

115: else
116: l_lifecycle_version_id := p_lifecycle_version_id;
117: end if;
118:
119: IF p_current_phase_version_id = FND_API.G_MISS_NUM THEN
120: l_current_phase_version_id := NULL;
121: else
122: l_current_phase_version_id := p_current_phase_version_id;
123: end if;

Line 126: IF (p_allow_lowest_tsk_dep_flag = FND_API.G_MISS_CHAR) THEN

122: l_current_phase_version_id := p_current_phase_version_id;
123: end if;
124:
125: --bug 3325803: FP M
126: IF (p_allow_lowest_tsk_dep_flag = FND_API.G_MISS_CHAR) THEN
127: l_allow_lowest_tsk_dep_flag := 'N';
128: ELSE
129: l_allow_lowest_tsk_dep_flag := p_allow_lowest_tsk_dep_flag;
130: END IF;

Line 132: IF (p_schedule_third_party_flag = FND_API.G_MISS_CHAR) THEN

128: ELSE
129: l_allow_lowest_tsk_dep_flag := p_allow_lowest_tsk_dep_flag;
130: END IF;
131:
132: IF (p_schedule_third_party_flag = FND_API.G_MISS_CHAR) THEN
133: l_schedule_third_party_flag := 'N';
134: ELSE
135: l_schedule_third_party_flag := p_schedule_third_party_flag;
136: END IF;

Line 138: IF (p_third_party_schedule_code = FND_API.G_MISS_CHAR) THEN

134: ELSE
135: l_schedule_third_party_flag := p_schedule_third_party_flag;
136: END IF;
137:
138: IF (p_third_party_schedule_code = FND_API.G_MISS_CHAR) THEN
139: l_third_party_schedule_code := NULL;
140: ELSE
141: l_third_party_schedule_code := p_third_party_schedule_code;
142: END IF;

Line 144: IF (p_auto_rollup_subproj_flag = FND_API.G_MISS_CHAR) THEN

140: ELSE
141: l_third_party_schedule_code := p_third_party_schedule_code;
142: END IF;
143:
144: IF (p_auto_rollup_subproj_flag = FND_API.G_MISS_CHAR) THEN
145: --l_auto_rollup_subproj_flag := 'N';
146: l_auto_rollup_subproj_flag := 'Y';
147: ELSE
148: l_auto_rollup_subproj_flag := p_auto_rollup_subproj_flag;

Line 152: if p_validate_only <> FND_API.G_TRUE then

148: l_auto_rollup_subproj_flag := p_auto_rollup_subproj_flag;
149: END IF;
150: --end bug 3325803
151:
152: if p_validate_only <> FND_API.G_TRUE then
153: INSERT INTO PA_PROJ_WORKPLAN_ATTR (
154: project_id
155: ,proj_element_id
156: ,wp_approval_reqd_flag

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

203: ,p_project_id
204: ,'PA_PROJECTS');
205: end if;
206:
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: if p_commit = FND_API.G_TRUE then
210: commit work;
211: end if;

Line 209: if p_commit = FND_API.G_TRUE then

205: end if;
206:
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: if p_commit = FND_API.G_TRUE then
210: commit work;
211: end if;
212:
213: if (p_debug_mode = 'Y') then

Line 218: when FND_API.G_EXC_ERROR then

214: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Create_Proj_Workplan_Attrs END');
215: end if;
216:
217: EXCEPTION
218: when FND_API.G_EXC_ERROR then
219: if p_commit = FND_API.G_TRUE then
220: rollback to create_proj_workplan_attrs_pvt;
221: end if;
222: x_return_status := FND_API.G_RET_STS_ERROR;

Line 219: if p_commit = FND_API.G_TRUE then

215: end if;
216:
217: EXCEPTION
218: when FND_API.G_EXC_ERROR then
219: if p_commit = FND_API.G_TRUE then
220: rollback to create_proj_workplan_attrs_pvt;
221: end if;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 222: x_return_status := FND_API.G_RET_STS_ERROR;

218: when FND_API.G_EXC_ERROR then
219: if p_commit = FND_API.G_TRUE then
220: rollback to create_proj_workplan_attrs_pvt;
221: end if;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: when FND_API.G_EXC_UNEXPECTED_ERROR then
224: if p_commit = FND_API.G_TRUE then
225: rollback to create_proj_workplan_attrs_pvt;
226: end if;

Line 223: when FND_API.G_EXC_UNEXPECTED_ERROR then

219: if p_commit = FND_API.G_TRUE then
220: rollback to create_proj_workplan_attrs_pvt;
221: end if;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: when FND_API.G_EXC_UNEXPECTED_ERROR then
224: if p_commit = FND_API.G_TRUE then
225: rollback to create_proj_workplan_attrs_pvt;
226: end if;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 224: if p_commit = FND_API.G_TRUE then

220: rollback to create_proj_workplan_attrs_pvt;
221: end if;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: when FND_API.G_EXC_UNEXPECTED_ERROR then
224: if p_commit = FND_API.G_TRUE then
225: rollback to create_proj_workplan_attrs_pvt;
226: end if;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223: when FND_API.G_EXC_UNEXPECTED_ERROR then
224: if p_commit = FND_API.G_TRUE then
225: rollback to create_proj_workplan_attrs_pvt;
226: end if;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
229: p_procedure_name => 'Create_Proj_Workplan_Attrs',
230: p_error_text => SUBSTRB(SQLERRM,1,240));
231: when OTHERS then

Line 232: if p_commit = FND_API.G_TRUE then

228: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
229: p_procedure_name => 'Create_Proj_Workplan_Attrs',
230: p_error_text => SUBSTRB(SQLERRM,1,240));
231: when OTHERS then
232: if p_commit = FND_API.G_TRUE then
233: rollback to create_proj_workplan_attrs_pvt;
234: end if;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: when OTHERS then
232: if p_commit = FND_API.G_TRUE then
233: rollback to create_proj_workplan_attrs_pvt;
234: end if;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
237: p_procedure_name => 'Create_Proj_Workplan_Attrs',
238: p_error_text => SUBSTRB(SQLERRM,1,240));
239: raise;

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

243: -- API name : Update_Proj_Workplan_Attrs
244: -- Type : Private
245: -- Pre-reqs : None.
246: -- Parameters :
247: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
248: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
251: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

244: -- Type : Private
245: -- Pre-reqs : None.
246: -- Parameters :
247: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
248: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
251: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
252: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

245: -- Pre-reqs : None.
246: -- Parameters :
247: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
248: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
251: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
252: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
253: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM

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

248: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
251: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
252: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
253: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
254: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
255: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
251: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
252: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
253: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
254: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
255: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

250: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
251: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
252: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
253: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
254: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
255: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

251: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
252: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
253: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
254: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
255: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM

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

252: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
253: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
254: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
255: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

253: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
254: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
255: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

254: -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
255: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

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

255: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
263: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

256: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
263: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
264: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

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

257: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
263: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
264: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
265: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

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

258: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
263: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
264: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
265: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
266: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

259: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
263: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
264: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
265: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
266: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
267: -- x_return_status OUT VARCHAR2 Required

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

260: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
263: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
264: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
265: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
266: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
267: -- x_return_status OUT VARCHAR2 Required
268: -- x_msg_count OUT NUMBER Required

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

261: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
263: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
264: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
265: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
266: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
267: -- x_return_status OUT VARCHAR2 Required
268: -- x_msg_count OUT NUMBER Required
269: -- x_msg_data OUT VARCHAR2 Optional

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

262: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
263: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
264: -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
265: -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
266: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
267: -- x_return_status OUT VARCHAR2 Required
268: -- x_msg_count OUT NUMBER Required
269: -- x_msg_data OUT VARCHAR2 Optional
270:

Line 274: p_commit IN VARCHAR2 := FND_API.G_FALSE

270:
271:
272: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
273: (
274: p_commit IN VARCHAR2 := FND_API.G_FALSE
275: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
276: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
278: ,p_debug_mode IN VARCHAR2 := 'N'

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

271:
272: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
273: (
274: p_commit IN VARCHAR2 := FND_API.G_FALSE
275: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
276: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
278: ,p_debug_mode IN VARCHAR2 := 'N'
279: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

272: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
273: (
274: p_commit IN VARCHAR2 := FND_API.G_FALSE
275: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
276: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
278: ,p_debug_mode IN VARCHAR2 := 'N'
279: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
280: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

275: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
276: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
278: ,p_debug_mode IN VARCHAR2 := 'N'
279: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
280: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
281: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
282: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

276: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
278: ,p_debug_mode IN VARCHAR2 := 'N'
279: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
280: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
281: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
282: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

277: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
278: ,p_debug_mode IN VARCHAR2 := 'N'
279: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
280: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
281: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
282: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

278: ,p_debug_mode IN VARCHAR2 := 'N'
279: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
280: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
281: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
282: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

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

279: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
280: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
281: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
282: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

280: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
281: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
282: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

281: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
282: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
289: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

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

282: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
289: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
290: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

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

283: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
289: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
290: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
291: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM

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

284: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
289: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
290: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
291: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM

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

285: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
289: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
290: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
291: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
293: --bug 3325803: FP M

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

286: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
289: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
290: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
291: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
293: --bug 3325803: FP M
294: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

287: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
289: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
290: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
291: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
293: --bug 3325803: FP M
294: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
295: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

288: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
289: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
290: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
291: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
293: --bug 3325803: FP M
294: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
295: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

290: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
291: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
293: --bug 3325803: FP M
294: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
295: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
298: --bug 3325803: FP M

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

291: ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
293: --bug 3325803: FP M
294: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
295: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
298: --bug 3325803: FP M
299: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

292: ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
293: --bug 3325803: FP M
294: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
295: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
298: --bug 3325803: FP M
299: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
300: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

293: --bug 3325803: FP M
294: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
295: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
298: --bug 3325803: FP M
299: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
300: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
301: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

295: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
298: --bug 3325803: FP M
299: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
300: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
301: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
302: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
303: )

Line 372: if (p_commit = FND_API.G_TRUE) then

368: if (p_debug_mode = 'Y') then
369: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Proj_Workplan_Attrs BEGIN');
370: end if;
371:
372: if (p_commit = FND_API.G_TRUE) then
373: savepoint update_proj_workplan_attrs_pvt;
374: end if;
375:
376: --LDENG

Line 407: IF l_is_lifecycle_tracking = FND_API.G_TRUE THEN

403: x_msg_count => l_msg_count ,
404: x_msg_data => l_msg_data );
405:
406:
407: IF l_is_lifecycle_tracking = FND_API.G_TRUE THEN
408: IF( p_lifecycle_version_id IS NOT NULL ) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM) AND (l_lifecycle_version_id IS NOT NULL) AND (l_lifecycle_version_id <> p_lifecycle_version_id) THEN
409:
410: /* Bug2760719 -- Added code to populate error message */
411:

Line 408: IF( p_lifecycle_version_id IS NOT NULL ) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM) AND (l_lifecycle_version_id IS NOT NULL) AND (l_lifecycle_version_id <> p_lifecycle_version_id) THEN

404: x_msg_data => l_msg_data );
405:
406:
407: IF l_is_lifecycle_tracking = FND_API.G_TRUE THEN
408: IF( p_lifecycle_version_id IS NOT NULL ) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM) AND (l_lifecycle_version_id IS NOT NULL) AND (l_lifecycle_version_id <> p_lifecycle_version_id) THEN
409:
410: /* Bug2760719 -- Added code to populate error message */
411:
412: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 424: raise FND_API.G_EXC_ERROR;

420: IF x_msg_count = 1 THEN
421: x_msg_data := l_msg_data;
422: END IF;
423:
424: raise FND_API.G_EXC_ERROR;
425: END IF;
426: END IF;
427: END IF;
428:

Line 431: if p_validate_only <> FND_API.G_TRUE then

427: END IF;
428:
429: --END mrajput
430:
431: if p_validate_only <> FND_API.G_TRUE then
432: BEGIN
433: SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID
434: INTO l_lifecycle_version_id, l_current_phase_version_id
435: FROM pa_proj_workplan_attr

Line 491: raise FND_API.G_EXC_ERROR;

487: x_msg_count := l_msg_count;
488: if x_msg_count = 1 then
489: x_msg_data := l_msg_data;
490: end if;
491: raise FND_API.G_EXC_ERROR;
492: end if;
493:
494: if p_approval_reqd_flag <> 'Y' then
495: l_auto_publish_flag := 'N';

Line 504: if p_txn_date_sync_buf_days = FND_API.G_MISS_NUM THEN

500: l_approver_source_id := p_approver_source_id;
501: l_approver_source_type := p_approver_source_type;
502: end if;
503:
504: if p_txn_date_sync_buf_days = FND_API.G_MISS_NUM THEN
505: l_txn_date_sync_buf_days := NULL;
506: else
507: l_txn_date_sync_buf_days := p_txn_date_sync_buf_days;
508: end if;

Line 512: IF (l_is_lifecycle_tracking = FND_API.G_TRUE ) THEN

508: end if;
509:
510: --mrajput
511: -- 18 Nov 2002. For Product Lifecycle Management through Bug2665633.
512: IF (l_is_lifecycle_tracking = FND_API.G_TRUE ) THEN
513:
514: -- changes for bug 2808582
515: OPEN c_current_display_sequence;
516: FETCH c_current_display_sequence into l_current_sequence,l_curr_phase_id;

Line 523: -- IF (l_current_phase_version_id is not NULL) and (p_current_phase_version_id <> FND_API.G_MISS_NUM) THEN

519: OPEN c_change_display_sequence;
520: FETCH c_change_display_sequence into l_change_sequence,l_future_phase_id;
521: CLOSE c_change_display_sequence;
522:
523: -- IF (l_current_phase_version_id is not NULL) and (p_current_phase_version_id <> FND_API.G_MISS_NUM) THEN
524: --changes for bug 2742365
525:
526: -- Changes for Bug 2760719 , Added condition so that it considers the case of nulling out the phase
527:

Line 528: IF (p_current_phase_version_id <> FND_API.G_MISS_NUM OR p_current_phase_version_id is null ) THEN

524: --changes for bug 2742365
525:
526: -- Changes for Bug 2760719 , Added condition so that it considers the case of nulling out the phase
527:
528: IF (p_current_phase_version_id <> FND_API.G_MISS_NUM OR p_current_phase_version_id is null ) THEN
529: IF ((l_current_phase_version_id IS NOT NULL ) AND (l_current_phase_version_id <> p_current_phase_version_id) AND (p_current_phase_version_id IS NOT NULL)
530: OR
531: ((l_current_phase_version_id IS NOT NULL ) AND (p_current_phase_version_id IS NULL)))THEN
532:

Line 554: raise FND_API.G_EXC_UNEXPECTED_ERROR;

550: from pa_proj_element_versions
551: where element_version_id = l_lifecycle_version_id;
552: EXCEPTION
553: WHEN OTHERS THEN
554: raise FND_API.G_EXC_UNEXPECTED_ERROR;
555: END;
556:
557: --hsiu
558: --bug 3254091

Line 581: IF l_policy_code IN ('CHANGE_ORDER_REQUIRED','NOT_ALLOWED') OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- bug 3423005

577: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'EGO',
578: p_msg_name => l_error_message);
579: END IF;
580:
581: IF l_policy_code IN ('CHANGE_ORDER_REQUIRED','NOT_ALLOWED') OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- bug 3423005
582: l_msg_count := FND_MSG_PUB.count_msg;
583: If l_msg_count > 0 THEN
584: x_msg_count := l_msg_count;
585: If l_msg_count = 1 THEN

Line 587: (p_encoded => FND_API.G_TRUE ,

583: If l_msg_count > 0 THEN
584: x_msg_count := l_msg_count;
585: If l_msg_count = 1 THEN
586: pa_interface_utils_pub.get_messages
587: (p_encoded => FND_API.G_TRUE ,
588: p_msg_index => 1 ,
589: p_msg_count => l_msg_count ,
590: p_msg_data => l_msg_data ,
591: p_data => l_data ,

Line 597: RAISE FND_API.G_EXC_ERROR;

593: );
594: x_msg_data := l_data;
595: End if;
596: End if;
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599: end if;
600: --end bug 3254091
601:

Line 609: IF (l_lifecycle_version_id is not NULL) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null) THEN

605: END IF;
606: ---END mrajput
607:
608: --LDENG
609: IF (l_lifecycle_version_id is not NULL) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null) THEN
610: IF(p_lifecycle_version_id is null or l_lifecycle_version_id <> p_lifecycle_version_id) THEN
611: l_clear_phase_flag := 'Y';
612: END IF;
613: END IF;

Line 615: If p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null THEN

611: l_clear_phase_flag := 'Y';
612: END IF;
613: END IF;
614:
615: If p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null THEN
616: l_lifecycle_version_id := p_lifecycle_version_id;
617: end if;
618:
619: IF p_current_phase_version_id <> FND_API.G_MISS_NUM or p_current_phase_version_id is null THEN

Line 619: IF p_current_phase_version_id <> FND_API.G_MISS_NUM or p_current_phase_version_id is null THEN

615: If p_lifecycle_version_id <> FND_API.G_MISS_NUM or p_lifecycle_version_id is null THEN
616: l_lifecycle_version_id := p_lifecycle_version_id;
617: end if;
618:
619: IF p_current_phase_version_id <> FND_API.G_MISS_NUM or p_current_phase_version_id is null THEN
620: l_current_phase_version_id := p_current_phase_version_id;
621: end if;
622: --END LDENG
623:

Line 640: raise FND_API.G_EXC_ERROR;

636: x_msg_count := l_msg_count;
637: if x_msg_count = 1 then
638: x_msg_data := l_msg_data;
639: end if;
640: raise FND_API.G_EXC_ERROR;
641: end if;
642: END IF;
643:
644: --bug 3305199: FP M

Line 664: raise FND_API.G_EXC_ERROR;

660: x_msg_count := l_msg_count;
661: IF x_msg_count = 1 THEN
662: x_msg_data := l_msg_data;
663: END IF;
664: raise FND_API.G_EXC_ERROR;
665: END IF;
666: END IF;
667:
668: END LOOP;

Line 674: IF (p_allow_lowest_tsk_dep_flag <> FND_API.G_MISS_CHAR) THEN

670: END IF;
671:
672: /*** bug 3305199 ****/
673:
674: IF (p_allow_lowest_tsk_dep_flag <> FND_API.G_MISS_CHAR) THEN
675: l_allow_lowest_tsk_dep_flag := p_allow_lowest_tsk_dep_flag;
676: END IF;
677:
678: IF (p_schedule_third_party_flag <> FND_API.G_MISS_CHAR) THEN

Line 678: IF (p_schedule_third_party_flag <> FND_API.G_MISS_CHAR) THEN

674: IF (p_allow_lowest_tsk_dep_flag <> FND_API.G_MISS_CHAR) THEN
675: l_allow_lowest_tsk_dep_flag := p_allow_lowest_tsk_dep_flag;
676: END IF;
677:
678: IF (p_schedule_third_party_flag <> FND_API.G_MISS_CHAR) THEN
679: l_schedule_third_party_flag := p_schedule_third_party_flag;
680: END IF;
681:
682: IF (l_schedule_third_party_flag = 'N') THEN

Line 689: IF (p_third_party_schedule_code <> FND_API.G_MISS_CHAR) THEN

685: set SCHEDULE_DIRTY_FLAG = 'N'
686: WHERE project_id = p_project_id and proj_element_id = p_proj_element_id;
687: END IF;
688:
689: IF (p_third_party_schedule_code <> FND_API.G_MISS_CHAR) THEN
690: l_third_party_schedule_code := p_third_party_schedule_code;
691: END IF;
692:
693: IF (p_auto_rollup_subproj_flag <> FND_API.G_MISS_CHAR) THEN

Line 693: IF (p_auto_rollup_subproj_flag <> FND_API.G_MISS_CHAR) THEN

689: IF (p_third_party_schedule_code <> FND_API.G_MISS_CHAR) THEN
690: l_third_party_schedule_code := p_third_party_schedule_code;
691: END IF;
692:
693: IF (p_auto_rollup_subproj_flag <> FND_API.G_MISS_CHAR) THEN
694: l_auto_rollup_subproj_flag := p_auto_rollup_subproj_flag;
695: END IF;
696: --end bug 3325803
697:

Line 698: if p_validate_only <> FND_API.G_TRUE then

694: l_auto_rollup_subproj_flag := p_auto_rollup_subproj_flag;
695: END IF;
696: --end bug 3325803
697:
698: if p_validate_only <> FND_API.G_TRUE then
699: --added condition to specify proj_element_id
700: /*
701: Modified this update for task progress bug 3420093. Added decodes with default values in following columns
702: wp_approval_reqd_flag,wp_auto_publish_flag,wp_default_display_lvl,wp_enable_version_flag,auto_pub_upon_creation_flag,

Line 707: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),

703: auto_sync_txn_date_flag.
704: */
705: --bug 3905167: added nvl for p_default_display_lvl.
706: UPDATE PA_PROJ_WORKPLAN_ATTR
707: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
708: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
709: wp_approver_source_id = l_approver_source_id,
710: wp_approver_source_type = l_approver_source_type,
711: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),

Line 708: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),

704: */
705: --bug 3905167: added nvl for p_default_display_lvl.
706: UPDATE PA_PROJ_WORKPLAN_ATTR
707: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
708: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
709: wp_approver_source_id = l_approver_source_id,
710: wp_approver_source_type = l_approver_source_type,
711: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
712: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),

Line 711: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),

707: SET wp_approval_reqd_flag = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
708: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
709: wp_approver_source_id = l_approver_source_id,
710: wp_approver_source_type = l_approver_source_type,
711: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
712: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
713: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
714: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
715: txn_date_sync_buf_days = l_txn_date_sync_buf_days,

Line 712: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),

708: wp_auto_publish_flag = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
709: wp_approver_source_id = l_approver_source_id,
710: wp_approver_source_type = l_approver_source_type,
711: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
712: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
713: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
714: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
715: txn_date_sync_buf_days = l_txn_date_sync_buf_days,
716: lifecycle_version_id = l_lifecycle_version_id,

Line 713: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),

709: wp_approver_source_id = l_approver_source_id,
710: wp_approver_source_type = l_approver_source_type,
711: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
712: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
713: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
714: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
715: txn_date_sync_buf_days = l_txn_date_sync_buf_days,
716: lifecycle_version_id = l_lifecycle_version_id,
717: current_phase_version_id = l_current_phase_version_id,

Line 714: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),

710: wp_approver_source_type = l_approver_source_type,
711: wp_default_display_lvl = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
712: wp_enable_version_flag = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
713: auto_pub_upon_creation_flag = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
714: auto_sync_txn_date_flag = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
715: txn_date_sync_buf_days = l_txn_date_sync_buf_days,
716: lifecycle_version_id = l_lifecycle_version_id,
717: current_phase_version_id = l_current_phase_version_id,
718: schedule_third_party_flag = l_schedule_third_party_flag,

Line 731: IF (l_is_lifecycle_tracking = FND_API.G_TRUE) THEN

727:
728: --mrajput
729: -- 18 Nov 2002. For Product Lifecycle Management through Bug2665633.
730: ---changes for bug2742365
731: IF (l_is_lifecycle_tracking = FND_API.G_TRUE) THEN
732:
733: PA_EGO_WRAPPER_PUB.sync_phase_change(
734: p_api_version => 1.0 ,
735: p_project_id => p_project_id ,

Line 753: raise FND_API.G_EXC_ERROR;

749: x_msg_count := l_msg_count;
750: if x_msg_count = 1 then
751: x_msg_data := l_msg_data;
752: end if;
753: raise FND_API.G_EXC_ERROR;
754: end if;
755: END IF;
756:
757:

Line 770: x_return_status := FND_API.G_RET_STS_SUCCESS;

766: end if;
767: --END LDENG
768: end if;
769:
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771:
772: if p_commit = FND_API.G_TRUE then
773: commit work;
774: end if;

Line 772: if p_commit = FND_API.G_TRUE then

768: end if;
769:
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771:
772: if p_commit = FND_API.G_TRUE then
773: commit work;
774: end if;
775:
776: if (p_debug_mode = 'Y') then

Line 781: when FND_API.G_EXC_ERROR then

777: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Proj_Workplan_Attrs END');
778: end if;
779:
780: EXCEPTION
781: when FND_API.G_EXC_ERROR then
782: if p_commit = FND_API.G_TRUE then
783: rollback to update_proj_workplan_attrs_pvt;
784: end if;
785: x_return_status := FND_API.G_RET_STS_ERROR;

Line 782: if p_commit = FND_API.G_TRUE then

778: end if;
779:
780: EXCEPTION
781: when FND_API.G_EXC_ERROR then
782: if p_commit = FND_API.G_TRUE then
783: rollback to update_proj_workplan_attrs_pvt;
784: end if;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 785: x_return_status := FND_API.G_RET_STS_ERROR;

781: when FND_API.G_EXC_ERROR then
782: if p_commit = FND_API.G_TRUE then
783: rollback to update_proj_workplan_attrs_pvt;
784: end if;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: when FND_API.G_EXC_UNEXPECTED_ERROR then
787: if p_commit = FND_API.G_TRUE then
788: rollback to update_proj_workplan_attrs_pvt;
789: end if;

Line 786: when FND_API.G_EXC_UNEXPECTED_ERROR then

782: if p_commit = FND_API.G_TRUE then
783: rollback to update_proj_workplan_attrs_pvt;
784: end if;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: when FND_API.G_EXC_UNEXPECTED_ERROR then
787: if p_commit = FND_API.G_TRUE then
788: rollback to update_proj_workplan_attrs_pvt;
789: end if;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 787: if p_commit = FND_API.G_TRUE then

783: rollback to update_proj_workplan_attrs_pvt;
784: end if;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: when FND_API.G_EXC_UNEXPECTED_ERROR then
787: if p_commit = FND_API.G_TRUE then
788: rollback to update_proj_workplan_attrs_pvt;
789: end if;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

786: when FND_API.G_EXC_UNEXPECTED_ERROR then
787: if p_commit = FND_API.G_TRUE then
788: rollback to update_proj_workplan_attrs_pvt;
789: end if;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
792: p_procedure_name => 'Update_Proj_Workplan_Attrs',
793: p_error_text => SUBSTRB(SQLERRM,1,240));
794: when OTHERS then

Line 795: if p_commit = FND_API.G_TRUE then

791: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
792: p_procedure_name => 'Update_Proj_Workplan_Attrs',
793: p_error_text => SUBSTRB(SQLERRM,1,240));
794: when OTHERS then
795: if p_commit = FND_API.G_TRUE then
796: rollback to update_proj_workplan_attrs_pvt;
797: end if;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794: when OTHERS then
795: if p_commit = FND_API.G_TRUE then
796: rollback to update_proj_workplan_attrs_pvt;
797: end if;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
800: p_procedure_name => 'Update_Proj_Workplan_Attrs',
801: p_error_text => SUBSTRB(SQLERRM,1,240));
802: raise;

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

806: -- API name : Update_Structure_Name
807: -- Type : Private
808: -- Pre-reqs : None.
809: -- Parameters :
810: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
811: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
812: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
813: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
814: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

807: -- Type : Private
808: -- Pre-reqs : None.
809: -- Parameters :
810: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
811: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
812: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
813: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
814: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
815: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

808: -- Pre-reqs : None.
809: -- Parameters :
810: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
811: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
812: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
813: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
814: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
815: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
816: -- p_proj_element_id IN NUMBER Required

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

811: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
812: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
813: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
814: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
815: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
816: -- p_proj_element_id IN NUMBER Required
817: -- p_structure_name IN VARCHAR2 Required
818: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
819: -- x_return_status OUT VARCHAR2 Required

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

814: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
815: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
816: -- p_proj_element_id IN NUMBER Required
817: -- p_structure_name IN VARCHAR2 Required
818: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
819: -- x_return_status OUT VARCHAR2 Required
820: -- x_msg_count OUT NUMBER Required
821: -- x_msg_data OUT VARCHAR2 Optional
822:

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

820: -- x_msg_count OUT NUMBER Required
821: -- x_msg_data OUT VARCHAR2 Optional
822:
823: PROCEDURE UPDATE_STRUCTURE_NAME
824: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
825: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
826: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
827: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
828: ,p_debug_mode IN VARCHAR2 := 'N'

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

821: -- x_msg_data OUT VARCHAR2 Optional
822:
823: PROCEDURE UPDATE_STRUCTURE_NAME
824: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
825: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
826: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
827: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
828: ,p_debug_mode IN VARCHAR2 := 'N'
829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

822:
823: PROCEDURE UPDATE_STRUCTURE_NAME
824: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
825: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
826: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
827: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
828: ,p_debug_mode IN VARCHAR2 := 'N'
829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
830: ,p_proj_element_id IN NUMBER

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

825: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
826: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
827: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
828: ,p_debug_mode IN VARCHAR2 := 'N'
829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
830: ,p_proj_element_id IN NUMBER
831: ,p_structure_name IN VARCHAR2
832: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
833: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

828: ,p_debug_mode IN VARCHAR2 := 'N'
829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
830: ,p_proj_element_id IN NUMBER
831: ,p_structure_name IN VARCHAR2
832: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
833: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
834: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
835: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
836: )

Line 851: if p_commit = FND_API.G_TRUE then

847: if (p_debug_mode = 'Y') then
848: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Structure_Name BEGIN');
849: end if;
850:
851: if p_commit = FND_API.G_TRUE then
852: savepoint update_structure_name_pvt;
853: end if;
854:
855: if p_validate_only <> FND_API.G_TRUE then

Line 855: if p_validate_only <> FND_API.G_TRUE then

851: if p_commit = FND_API.G_TRUE then
852: savepoint update_structure_name_pvt;
853: end if;
854:
855: if p_validate_only <> FND_API.G_TRUE then
856: BEGIN
857: SELECT 'x' INTO l_dummy
858: FROM pa_proj_elements
859: WHERE proj_element_id = p_proj_element_id

Line 912: raise FND_API.G_EXC_ERROR;

908: x_msg_count := l_msg_count;
909: if x_msg_count = 1 then
910: x_msg_data := l_msg_data;
911: end if;
912: raise FND_API.G_EXC_ERROR;
913: end if;
914:
915: if p_validate_only <> FND_API.G_TRUE then
916: UPDATE PA_PROJ_ELEMENTS

Line 915: if p_validate_only <> FND_API.G_TRUE then

911: end if;
912: raise FND_API.G_EXC_ERROR;
913: end if;
914:
915: if p_validate_only <> FND_API.G_TRUE then
916: UPDATE PA_PROJ_ELEMENTS
917: SET name = p_structure_name,
918: record_version_number = record_version_number + 1,
919: last_update_date = SYSDATE,

Line 925: x_return_status := FND_API.G_RET_STS_SUCCESS;

921: last_update_login = FND_GLOBAL.LOGIN_ID
922: WHERE proj_element_id = p_proj_element_id;
923: end if;
924:
925: x_return_status := FND_API.G_RET_STS_SUCCESS;
926:
927: if p_commit = FND_API.G_TRUE then
928: commit work;
929: end if;

Line 927: if p_commit = FND_API.G_TRUE then

923: end if;
924:
925: x_return_status := FND_API.G_RET_STS_SUCCESS;
926:
927: if p_commit = FND_API.G_TRUE then
928: commit work;
929: end if;
930:
931: if (p_debug_mode = 'Y') then

Line 936: when FND_API.G_EXC_ERROR then

932: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Structure_Name END');
933: end if;
934:
935: EXCEPTION
936: when FND_API.G_EXC_ERROR then
937: if p_commit = FND_API.G_TRUE then
938: rollback to update_structure_name_pvt;
939: end if;
940: x_return_status := FND_API.G_RET_STS_ERROR;

Line 937: if p_commit = FND_API.G_TRUE then

933: end if;
934:
935: EXCEPTION
936: when FND_API.G_EXC_ERROR then
937: if p_commit = FND_API.G_TRUE then
938: rollback to update_structure_name_pvt;
939: end if;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 940: x_return_status := FND_API.G_RET_STS_ERROR;

936: when FND_API.G_EXC_ERROR then
937: if p_commit = FND_API.G_TRUE then
938: rollback to update_structure_name_pvt;
939: end if;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: if p_commit = FND_API.G_TRUE then
943: rollback to update_structure_name_pvt;
944: end if;

Line 941: when FND_API.G_EXC_UNEXPECTED_ERROR then

937: if p_commit = FND_API.G_TRUE then
938: rollback to update_structure_name_pvt;
939: end if;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: if p_commit = FND_API.G_TRUE then
943: rollback to update_structure_name_pvt;
944: end if;
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 942: if p_commit = FND_API.G_TRUE then

938: rollback to update_structure_name_pvt;
939: end if;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: if p_commit = FND_API.G_TRUE then
943: rollback to update_structure_name_pvt;
944: end if;
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: if p_commit = FND_API.G_TRUE then
943: rollback to update_structure_name_pvt;
944: end if;
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
947: p_procedure_name => 'Update_Structure_Name',
948: p_error_text => SUBSTRB(SQLERRM,1,240));
949: when OTHERS then

Line 950: if p_commit = FND_API.G_TRUE then

946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
947: p_procedure_name => 'Update_Structure_Name',
948: p_error_text => SUBSTRB(SQLERRM,1,240));
949: when OTHERS then
950: if p_commit = FND_API.G_TRUE then
951: rollback to update_structure_name_pvt;
952: end if;
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

949: when OTHERS then
950: if p_commit = FND_API.G_TRUE then
951: rollback to update_structure_name_pvt;
952: end if;
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
955: p_procedure_name => 'Update_Structure_Name',
956: p_error_text => SUBSTRB(SQLERRM,1,240));
957: raise;

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

961: -- API name : Delete_Proj_Workplan_Attrs
962: -- Type : Private
963: -- Pre-reqs : None.
964: -- Parameters :
965: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
966: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
967: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
968: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
969: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

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

962: -- Type : Private
963: -- Pre-reqs : None.
964: -- Parameters :
965: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
966: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
967: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
968: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
969: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
970: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

963: -- Pre-reqs : None.
964: -- Parameters :
965: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
966: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
967: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
968: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
969: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
970: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
971: -- p_project_id IN NUMBER Required

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

966: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
967: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
968: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
969: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
970: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
971: -- p_project_id IN NUMBER Required
972: -- p_proj_element_id IN NUMBER Required
973: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
974: -- x_return_status OUT VARCHAR2 Required

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

969: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
970: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
971: -- p_project_id IN NUMBER Required
972: -- p_proj_element_id IN NUMBER Required
973: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
974: -- x_return_status OUT VARCHAR2 Required
975: -- x_msg_count OUT NUMBER Required
976: -- x_msg_data OUT VARCHAR2 Optional
977:

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

975: -- x_msg_count OUT NUMBER Required
976: -- x_msg_data OUT VARCHAR2 Optional
977:
978: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
979: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
980: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
981: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
982: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
983: ,p_debug_mode IN VARCHAR2 := 'N'

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

976: -- x_msg_data OUT VARCHAR2 Optional
977:
978: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
979: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
980: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
981: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
982: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
983: ,p_debug_mode IN VARCHAR2 := 'N'
984: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

977:
978: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
979: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
980: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
981: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
982: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
983: ,p_debug_mode IN VARCHAR2 := 'N'
984: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
985: ,p_project_id IN NUMBER

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

980: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
981: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
982: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
983: ,p_debug_mode IN VARCHAR2 := 'N'
984: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
985: ,p_project_id IN NUMBER
986: ,p_proj_element_id IN NUMBER
987: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
988: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

983: ,p_debug_mode IN VARCHAR2 := 'N'
984: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
985: ,p_project_id IN NUMBER
986: ,p_proj_element_id IN NUMBER
987: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
988: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
989: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
990: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
991: )

Line 1004: if p_commit = FND_API.G_TRUE then

1000: if (p_debug_mode = 'Y') then
1001: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Delete_Proj_Workplan_Attrs BEGIN');
1002: end if;
1003:
1004: if p_commit = FND_API.G_TRUE then
1005: savepoint delete_proj_workplan_attrs_pvt;
1006: end if;
1007:
1008: if (p_debug_mode = 'Y') then

Line 1012: if p_validate_only <> FND_API.G_TRUE then

1008: if (p_debug_mode = 'Y') then
1009: pa_debug.debug('Locking record...');
1010: end if;
1011:
1012: if p_validate_only <> FND_API.G_TRUE then
1013: BEGIN
1014: SELECT 'x' INTO l_dummy
1015: FROM pa_proj_workplan_attr
1016: WHERE proj_element_id = p_proj_element_id

Line 1071: raise FND_API.G_EXC_ERROR;

1067: x_msg_count := l_msg_count;
1068: if x_msg_count = 1 then
1069: x_msg_data := l_msg_data;
1070: end if;
1071: raise FND_API.G_EXC_ERROR;
1072: end if;
1073:
1074: if p_validate_only <> FND_API.G_TRUE then
1075:

Line 1074: if p_validate_only <> FND_API.G_TRUE then

1070: end if;
1071: raise FND_API.G_EXC_ERROR;
1072: end if;
1073:
1074: if p_validate_only <> FND_API.G_TRUE then
1075:
1076: DELETE FROM PA_PROJ_WORKPLAN_ATTR
1077: WHERE proj_element_id = p_proj_element_id;
1078:

Line 1081: x_return_status := FND_API.G_RET_STS_SUCCESS;

1077: WHERE proj_element_id = p_proj_element_id;
1078:
1079: end if;
1080:
1081: x_return_status := FND_API.G_RET_STS_SUCCESS;
1082:
1083: if p_commit = FND_API.G_TRUE then
1084: commit work;
1085: end if;

Line 1083: if p_commit = FND_API.G_TRUE then

1079: end if;
1080:
1081: x_return_status := FND_API.G_RET_STS_SUCCESS;
1082:
1083: if p_commit = FND_API.G_TRUE then
1084: commit work;
1085: end if;
1086:
1087: if (p_debug_mode = 'Y') then

Line 1092: when FND_API.G_EXC_ERROR then

1088: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Delete_Proj_Workplan_Attrs END');
1089: end if;
1090:
1091: EXCEPTION
1092: when FND_API.G_EXC_ERROR then
1093: if p_commit = FND_API.G_TRUE then
1094: rollback to delete_proj_workplan_attrs_pvt;
1095: end if;
1096: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1093: if p_commit = FND_API.G_TRUE then

1089: end if;
1090:
1091: EXCEPTION
1092: when FND_API.G_EXC_ERROR then
1093: if p_commit = FND_API.G_TRUE then
1094: rollback to delete_proj_workplan_attrs_pvt;
1095: end if;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: when others then

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR;

1092: when FND_API.G_EXC_ERROR then
1093: if p_commit = FND_API.G_TRUE then
1094: rollback to delete_proj_workplan_attrs_pvt;
1095: end if;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: when others then
1098: if p_commit = FND_API.G_TRUE then
1099: rollback to delete_proj_workplan_attrs_pvt;
1100: end if;

Line 1098: if p_commit = FND_API.G_TRUE then

1094: rollback to delete_proj_workplan_attrs_pvt;
1095: end if;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: when others then
1098: if p_commit = FND_API.G_TRUE then
1099: rollback to delete_proj_workplan_attrs_pvt;
1100: end if;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

Line 1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1097: when others then
1098: if p_commit = FND_API.G_TRUE then
1099: rollback to delete_proj_workplan_attrs_pvt;
1100: end if;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
1103: p_procedure_name => 'Delete_Proj_Workplan_Attrs',
1104: p_error_text => SUBSTRB(SQLERRM,1,240));
1105: raise;