APPS.PSP_EXTERNAL_EFFORT_LINES_API dependencies on HR_API

Line 7: p_legislation_code varchar(50):=hr_api.userenv_lang;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' psp_external_effort_lines_api.';
7: p_legislation_code varchar(50):=hr_api.userenv_lang;
8:
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< insert_external_effort_line >--------------------|

Line 115: when hr_api.cannot_find_prog_unit then

111: , p_attribute14 => p_attribute14
112: , p_attribute15 => p_attribute15
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'insert_external_effort_line'
118: ,p_hook_type => 'BP'
119: );

Line 116: hr_api.cannot_find_prog_unit_error

112: , p_attribute15 => p_attribute15
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'insert_external_effort_line'
118: ,p_hook_type => 'BP'
119: );
120: end;

Line 206: when hr_api.cannot_find_prog_unit then

202: , p_external_effort_line_id => l_external_effort_line_id
203: , p_return_status => l_return_status
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'insert_external_effort_line'
209: ,p_hook_type => 'AP'
210: );

Line 207: hr_api.cannot_find_prog_unit_error

203: , p_return_status => l_return_status
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'insert_external_effort_line'
209: ,p_hook_type => 'AP'
210: );
211: end;

Line 216: raise hr_api.validate_enabled;

212: --
213: -- When in validation only mode raise the Validate_Enabled exception
214: --
215: if p_validate then
216: raise hr_api.validate_enabled;
217: end if;
218: --
219: -- Set all IN OUT and OUT parameters with out values
220: --

Line 227: when hr_api.validate_enabled then

223: p_return_status := l_return_status;
224:
225: hr_utility.set_location(' Leaving:'||l_proc, 70);
226: exception
227: when hr_api.validate_enabled then
228: --
229: -- As the Validate_Enabled exception has been raised
230: -- we must rollback to the savepoint
231: --

Line 273: , p_batch_name in varchar2 default hr_api.g_varchar2

269: --
270: procedure update_external_effort_line
271: ( p_validate in boolean default false
272: , p_external_effort_line_id in number
273: , p_batch_name in varchar2 default hr_api.g_varchar2
274: , p_distribution_date in date default hr_api.g_date
275: , p_person_id in number default hr_api.g_number
276: , p_assignment_id in number default hr_api.g_number
277: , p_currency_code in varchar2 default hr_api.g_varchar2

Line 274: , p_distribution_date in date default hr_api.g_date

270: procedure update_external_effort_line
271: ( p_validate in boolean default false
272: , p_external_effort_line_id in number
273: , p_batch_name in varchar2 default hr_api.g_varchar2
274: , p_distribution_date in date default hr_api.g_date
275: , p_person_id in number default hr_api.g_number
276: , p_assignment_id in number default hr_api.g_number
277: , p_currency_code in varchar2 default hr_api.g_varchar2
278: , p_distribution_amount in number default hr_api.g_number

Line 275: , p_person_id in number default hr_api.g_number

271: ( p_validate in boolean default false
272: , p_external_effort_line_id in number
273: , p_batch_name in varchar2 default hr_api.g_varchar2
274: , p_distribution_date in date default hr_api.g_date
275: , p_person_id in number default hr_api.g_number
276: , p_assignment_id in number default hr_api.g_number
277: , p_currency_code in varchar2 default hr_api.g_varchar2
278: , p_distribution_amount in number default hr_api.g_number
279: , p_business_group_id in number default hr_api.g_number

Line 276: , p_assignment_id in number default hr_api.g_number

272: , p_external_effort_line_id in number
273: , p_batch_name in varchar2 default hr_api.g_varchar2
274: , p_distribution_date in date default hr_api.g_date
275: , p_person_id in number default hr_api.g_number
276: , p_assignment_id in number default hr_api.g_number
277: , p_currency_code in varchar2 default hr_api.g_varchar2
278: , p_distribution_amount in number default hr_api.g_number
279: , p_business_group_id in number default hr_api.g_number
280: , p_set_of_books_id in number default hr_api.g_number

Line 277: , p_currency_code in varchar2 default hr_api.g_varchar2

273: , p_batch_name in varchar2 default hr_api.g_varchar2
274: , p_distribution_date in date default hr_api.g_date
275: , p_person_id in number default hr_api.g_number
276: , p_assignment_id in number default hr_api.g_number
277: , p_currency_code in varchar2 default hr_api.g_varchar2
278: , p_distribution_amount in number default hr_api.g_number
279: , p_business_group_id in number default hr_api.g_number
280: , p_set_of_books_id in number default hr_api.g_number
281: , p_gl_code_combination_id in number default hr_api.g_number

Line 278: , p_distribution_amount in number default hr_api.g_number

274: , p_distribution_date in date default hr_api.g_date
275: , p_person_id in number default hr_api.g_number
276: , p_assignment_id in number default hr_api.g_number
277: , p_currency_code in varchar2 default hr_api.g_varchar2
278: , p_distribution_amount in number default hr_api.g_number
279: , p_business_group_id in number default hr_api.g_number
280: , p_set_of_books_id in number default hr_api.g_number
281: , p_gl_code_combination_id in number default hr_api.g_number
282: , p_project_id in number default hr_api.g_number

Line 279: , p_business_group_id in number default hr_api.g_number

275: , p_person_id in number default hr_api.g_number
276: , p_assignment_id in number default hr_api.g_number
277: , p_currency_code in varchar2 default hr_api.g_varchar2
278: , p_distribution_amount in number default hr_api.g_number
279: , p_business_group_id in number default hr_api.g_number
280: , p_set_of_books_id in number default hr_api.g_number
281: , p_gl_code_combination_id in number default hr_api.g_number
282: , p_project_id in number default hr_api.g_number
283: , p_task_id in number default hr_api.g_number

Line 280: , p_set_of_books_id in number default hr_api.g_number

276: , p_assignment_id in number default hr_api.g_number
277: , p_currency_code in varchar2 default hr_api.g_varchar2
278: , p_distribution_amount in number default hr_api.g_number
279: , p_business_group_id in number default hr_api.g_number
280: , p_set_of_books_id in number default hr_api.g_number
281: , p_gl_code_combination_id in number default hr_api.g_number
282: , p_project_id in number default hr_api.g_number
283: , p_task_id in number default hr_api.g_number
284: , p_award_id in number default hr_api.g_number

Line 281: , p_gl_code_combination_id in number default hr_api.g_number

277: , p_currency_code in varchar2 default hr_api.g_varchar2
278: , p_distribution_amount in number default hr_api.g_number
279: , p_business_group_id in number default hr_api.g_number
280: , p_set_of_books_id in number default hr_api.g_number
281: , p_gl_code_combination_id in number default hr_api.g_number
282: , p_project_id in number default hr_api.g_number
283: , p_task_id in number default hr_api.g_number
284: , p_award_id in number default hr_api.g_number
285: , p_expenditure_organization_id in number default hr_api.g_number

Line 282: , p_project_id in number default hr_api.g_number

278: , p_distribution_amount in number default hr_api.g_number
279: , p_business_group_id in number default hr_api.g_number
280: , p_set_of_books_id in number default hr_api.g_number
281: , p_gl_code_combination_id in number default hr_api.g_number
282: , p_project_id in number default hr_api.g_number
283: , p_task_id in number default hr_api.g_number
284: , p_award_id in number default hr_api.g_number
285: , p_expenditure_organization_id in number default hr_api.g_number
286: , p_expenditure_type in varchar2 default hr_api.g_varchar2

Line 283: , p_task_id in number default hr_api.g_number

279: , p_business_group_id in number default hr_api.g_number
280: , p_set_of_books_id in number default hr_api.g_number
281: , p_gl_code_combination_id in number default hr_api.g_number
282: , p_project_id in number default hr_api.g_number
283: , p_task_id in number default hr_api.g_number
284: , p_award_id in number default hr_api.g_number
285: , p_expenditure_organization_id in number default hr_api.g_number
286: , p_expenditure_type in varchar2 default hr_api.g_varchar2
287: , p_attribute_category in varchar2 default hr_api.g_varchar2

Line 284: , p_award_id in number default hr_api.g_number

280: , p_set_of_books_id in number default hr_api.g_number
281: , p_gl_code_combination_id in number default hr_api.g_number
282: , p_project_id in number default hr_api.g_number
283: , p_task_id in number default hr_api.g_number
284: , p_award_id in number default hr_api.g_number
285: , p_expenditure_organization_id in number default hr_api.g_number
286: , p_expenditure_type in varchar2 default hr_api.g_varchar2
287: , p_attribute_category in varchar2 default hr_api.g_varchar2
288: , p_attribute1 in varchar2 default hr_api.g_varchar2

Line 285: , p_expenditure_organization_id in number default hr_api.g_number

281: , p_gl_code_combination_id in number default hr_api.g_number
282: , p_project_id in number default hr_api.g_number
283: , p_task_id in number default hr_api.g_number
284: , p_award_id in number default hr_api.g_number
285: , p_expenditure_organization_id in number default hr_api.g_number
286: , p_expenditure_type in varchar2 default hr_api.g_varchar2
287: , p_attribute_category in varchar2 default hr_api.g_varchar2
288: , p_attribute1 in varchar2 default hr_api.g_varchar2
289: , p_attribute2 in varchar2 default hr_api.g_varchar2

Line 286: , p_expenditure_type in varchar2 default hr_api.g_varchar2

282: , p_project_id in number default hr_api.g_number
283: , p_task_id in number default hr_api.g_number
284: , p_award_id in number default hr_api.g_number
285: , p_expenditure_organization_id in number default hr_api.g_number
286: , p_expenditure_type in varchar2 default hr_api.g_varchar2
287: , p_attribute_category in varchar2 default hr_api.g_varchar2
288: , p_attribute1 in varchar2 default hr_api.g_varchar2
289: , p_attribute2 in varchar2 default hr_api.g_varchar2
290: , p_attribute3 in varchar2 default hr_api.g_varchar2

Line 287: , p_attribute_category in varchar2 default hr_api.g_varchar2

283: , p_task_id in number default hr_api.g_number
284: , p_award_id in number default hr_api.g_number
285: , p_expenditure_organization_id in number default hr_api.g_number
286: , p_expenditure_type in varchar2 default hr_api.g_varchar2
287: , p_attribute_category in varchar2 default hr_api.g_varchar2
288: , p_attribute1 in varchar2 default hr_api.g_varchar2
289: , p_attribute2 in varchar2 default hr_api.g_varchar2
290: , p_attribute3 in varchar2 default hr_api.g_varchar2
291: , p_attribute4 in varchar2 default hr_api.g_varchar2

Line 288: , p_attribute1 in varchar2 default hr_api.g_varchar2

284: , p_award_id in number default hr_api.g_number
285: , p_expenditure_organization_id in number default hr_api.g_number
286: , p_expenditure_type in varchar2 default hr_api.g_varchar2
287: , p_attribute_category in varchar2 default hr_api.g_varchar2
288: , p_attribute1 in varchar2 default hr_api.g_varchar2
289: , p_attribute2 in varchar2 default hr_api.g_varchar2
290: , p_attribute3 in varchar2 default hr_api.g_varchar2
291: , p_attribute4 in varchar2 default hr_api.g_varchar2
292: , p_attribute5 in varchar2 default hr_api.g_varchar2

Line 289: , p_attribute2 in varchar2 default hr_api.g_varchar2

285: , p_expenditure_organization_id in number default hr_api.g_number
286: , p_expenditure_type in varchar2 default hr_api.g_varchar2
287: , p_attribute_category in varchar2 default hr_api.g_varchar2
288: , p_attribute1 in varchar2 default hr_api.g_varchar2
289: , p_attribute2 in varchar2 default hr_api.g_varchar2
290: , p_attribute3 in varchar2 default hr_api.g_varchar2
291: , p_attribute4 in varchar2 default hr_api.g_varchar2
292: , p_attribute5 in varchar2 default hr_api.g_varchar2
293: , p_attribute6 in varchar2 default hr_api.g_varchar2

Line 290: , p_attribute3 in varchar2 default hr_api.g_varchar2

286: , p_expenditure_type in varchar2 default hr_api.g_varchar2
287: , p_attribute_category in varchar2 default hr_api.g_varchar2
288: , p_attribute1 in varchar2 default hr_api.g_varchar2
289: , p_attribute2 in varchar2 default hr_api.g_varchar2
290: , p_attribute3 in varchar2 default hr_api.g_varchar2
291: , p_attribute4 in varchar2 default hr_api.g_varchar2
292: , p_attribute5 in varchar2 default hr_api.g_varchar2
293: , p_attribute6 in varchar2 default hr_api.g_varchar2
294: , p_attribute7 in varchar2 default hr_api.g_varchar2

Line 291: , p_attribute4 in varchar2 default hr_api.g_varchar2

287: , p_attribute_category in varchar2 default hr_api.g_varchar2
288: , p_attribute1 in varchar2 default hr_api.g_varchar2
289: , p_attribute2 in varchar2 default hr_api.g_varchar2
290: , p_attribute3 in varchar2 default hr_api.g_varchar2
291: , p_attribute4 in varchar2 default hr_api.g_varchar2
292: , p_attribute5 in varchar2 default hr_api.g_varchar2
293: , p_attribute6 in varchar2 default hr_api.g_varchar2
294: , p_attribute7 in varchar2 default hr_api.g_varchar2
295: , p_attribute8 in varchar2 default hr_api.g_varchar2

Line 292: , p_attribute5 in varchar2 default hr_api.g_varchar2

288: , p_attribute1 in varchar2 default hr_api.g_varchar2
289: , p_attribute2 in varchar2 default hr_api.g_varchar2
290: , p_attribute3 in varchar2 default hr_api.g_varchar2
291: , p_attribute4 in varchar2 default hr_api.g_varchar2
292: , p_attribute5 in varchar2 default hr_api.g_varchar2
293: , p_attribute6 in varchar2 default hr_api.g_varchar2
294: , p_attribute7 in varchar2 default hr_api.g_varchar2
295: , p_attribute8 in varchar2 default hr_api.g_varchar2
296: , p_attribute9 in varchar2 default hr_api.g_varchar2

Line 293: , p_attribute6 in varchar2 default hr_api.g_varchar2

289: , p_attribute2 in varchar2 default hr_api.g_varchar2
290: , p_attribute3 in varchar2 default hr_api.g_varchar2
291: , p_attribute4 in varchar2 default hr_api.g_varchar2
292: , p_attribute5 in varchar2 default hr_api.g_varchar2
293: , p_attribute6 in varchar2 default hr_api.g_varchar2
294: , p_attribute7 in varchar2 default hr_api.g_varchar2
295: , p_attribute8 in varchar2 default hr_api.g_varchar2
296: , p_attribute9 in varchar2 default hr_api.g_varchar2
297: , p_attribute10 in varchar2 default hr_api.g_varchar2

Line 294: , p_attribute7 in varchar2 default hr_api.g_varchar2

290: , p_attribute3 in varchar2 default hr_api.g_varchar2
291: , p_attribute4 in varchar2 default hr_api.g_varchar2
292: , p_attribute5 in varchar2 default hr_api.g_varchar2
293: , p_attribute6 in varchar2 default hr_api.g_varchar2
294: , p_attribute7 in varchar2 default hr_api.g_varchar2
295: , p_attribute8 in varchar2 default hr_api.g_varchar2
296: , p_attribute9 in varchar2 default hr_api.g_varchar2
297: , p_attribute10 in varchar2 default hr_api.g_varchar2
298: , p_attribute11 in varchar2 default hr_api.g_varchar2

Line 295: , p_attribute8 in varchar2 default hr_api.g_varchar2

291: , p_attribute4 in varchar2 default hr_api.g_varchar2
292: , p_attribute5 in varchar2 default hr_api.g_varchar2
293: , p_attribute6 in varchar2 default hr_api.g_varchar2
294: , p_attribute7 in varchar2 default hr_api.g_varchar2
295: , p_attribute8 in varchar2 default hr_api.g_varchar2
296: , p_attribute9 in varchar2 default hr_api.g_varchar2
297: , p_attribute10 in varchar2 default hr_api.g_varchar2
298: , p_attribute11 in varchar2 default hr_api.g_varchar2
299: , p_attribute12 in varchar2 default hr_api.g_varchar2

Line 296: , p_attribute9 in varchar2 default hr_api.g_varchar2

292: , p_attribute5 in varchar2 default hr_api.g_varchar2
293: , p_attribute6 in varchar2 default hr_api.g_varchar2
294: , p_attribute7 in varchar2 default hr_api.g_varchar2
295: , p_attribute8 in varchar2 default hr_api.g_varchar2
296: , p_attribute9 in varchar2 default hr_api.g_varchar2
297: , p_attribute10 in varchar2 default hr_api.g_varchar2
298: , p_attribute11 in varchar2 default hr_api.g_varchar2
299: , p_attribute12 in varchar2 default hr_api.g_varchar2
300: , p_attribute13 in varchar2 default hr_api.g_varchar2

Line 297: , p_attribute10 in varchar2 default hr_api.g_varchar2

293: , p_attribute6 in varchar2 default hr_api.g_varchar2
294: , p_attribute7 in varchar2 default hr_api.g_varchar2
295: , p_attribute8 in varchar2 default hr_api.g_varchar2
296: , p_attribute9 in varchar2 default hr_api.g_varchar2
297: , p_attribute10 in varchar2 default hr_api.g_varchar2
298: , p_attribute11 in varchar2 default hr_api.g_varchar2
299: , p_attribute12 in varchar2 default hr_api.g_varchar2
300: , p_attribute13 in varchar2 default hr_api.g_varchar2
301: , p_attribute14 in varchar2 default hr_api.g_varchar2

Line 298: , p_attribute11 in varchar2 default hr_api.g_varchar2

294: , p_attribute7 in varchar2 default hr_api.g_varchar2
295: , p_attribute8 in varchar2 default hr_api.g_varchar2
296: , p_attribute9 in varchar2 default hr_api.g_varchar2
297: , p_attribute10 in varchar2 default hr_api.g_varchar2
298: , p_attribute11 in varchar2 default hr_api.g_varchar2
299: , p_attribute12 in varchar2 default hr_api.g_varchar2
300: , p_attribute13 in varchar2 default hr_api.g_varchar2
301: , p_attribute14 in varchar2 default hr_api.g_varchar2
302: , p_attribute15 in varchar2 default hr_api.g_varchar2

Line 299: , p_attribute12 in varchar2 default hr_api.g_varchar2

295: , p_attribute8 in varchar2 default hr_api.g_varchar2
296: , p_attribute9 in varchar2 default hr_api.g_varchar2
297: , p_attribute10 in varchar2 default hr_api.g_varchar2
298: , p_attribute11 in varchar2 default hr_api.g_varchar2
299: , p_attribute12 in varchar2 default hr_api.g_varchar2
300: , p_attribute13 in varchar2 default hr_api.g_varchar2
301: , p_attribute14 in varchar2 default hr_api.g_varchar2
302: , p_attribute15 in varchar2 default hr_api.g_varchar2
303: , p_object_version_number in out nocopy number

Line 300: , p_attribute13 in varchar2 default hr_api.g_varchar2

296: , p_attribute9 in varchar2 default hr_api.g_varchar2
297: , p_attribute10 in varchar2 default hr_api.g_varchar2
298: , p_attribute11 in varchar2 default hr_api.g_varchar2
299: , p_attribute12 in varchar2 default hr_api.g_varchar2
300: , p_attribute13 in varchar2 default hr_api.g_varchar2
301: , p_attribute14 in varchar2 default hr_api.g_varchar2
302: , p_attribute15 in varchar2 default hr_api.g_varchar2
303: , p_object_version_number in out nocopy number
304: , p_return_status out nocopy boolean

Line 301: , p_attribute14 in varchar2 default hr_api.g_varchar2

297: , p_attribute10 in varchar2 default hr_api.g_varchar2
298: , p_attribute11 in varchar2 default hr_api.g_varchar2
299: , p_attribute12 in varchar2 default hr_api.g_varchar2
300: , p_attribute13 in varchar2 default hr_api.g_varchar2
301: , p_attribute14 in varchar2 default hr_api.g_varchar2
302: , p_attribute15 in varchar2 default hr_api.g_varchar2
303: , p_object_version_number in out nocopy number
304: , p_return_status out nocopy boolean
305: ) IS

Line 302: , p_attribute15 in varchar2 default hr_api.g_varchar2

298: , p_attribute11 in varchar2 default hr_api.g_varchar2
299: , p_attribute12 in varchar2 default hr_api.g_varchar2
300: , p_attribute13 in varchar2 default hr_api.g_varchar2
301: , p_attribute14 in varchar2 default hr_api.g_varchar2
302: , p_attribute15 in varchar2 default hr_api.g_varchar2
303: , p_object_version_number in out nocopy number
304: , p_return_status out nocopy boolean
305: ) IS
306: --

Line 370: when hr_api.cannot_find_prog_unit then

366: , p_attribute15 => p_attribute15
367: , p_object_version_number => l_object_version_number
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'update_external_effort_line'
373: ,p_hook_type => 'BP'
374: );

Line 371: hr_api.cannot_find_prog_unit_error

367: , p_object_version_number => l_object_version_number
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'update_external_effort_line'
373: ,p_hook_type => 'BP'
374: );
375: end;

Line 460: when hr_api.cannot_find_prog_unit then

456: , p_object_version_number => l_object_version_number
457: , p_return_status => l_return_status
458: );
459: exception
460: when hr_api.cannot_find_prog_unit then
461: hr_api.cannot_find_prog_unit_error
462: (p_module_name => 'update_external_effort_line'
463: ,p_hook_type => 'AP'
464: );

Line 461: hr_api.cannot_find_prog_unit_error

457: , p_return_status => l_return_status
458: );
459: exception
460: when hr_api.cannot_find_prog_unit then
461: hr_api.cannot_find_prog_unit_error
462: (p_module_name => 'update_external_effort_line'
463: ,p_hook_type => 'AP'
464: );
465: end;

Line 470: raise hr_api.validate_enabled;

466: --
467: -- When in validation only mode raise the Validate_Enabled exception
468: --
469: if p_validate then
470: raise hr_api.validate_enabled;
471: end if;
472: --
473: -- Set all IN OUT and OUT parameters with out values
474: --

Line 479: when hr_api.validate_enabled then

475: p_object_version_number := l_object_version_number;
476: p_return_status := l_return_status;
477: hr_utility.set_location(' Leaving:'||l_proc, 70);
478: exception
479: when hr_api.validate_enabled then
480: --
481: -- As the Validate_Enabled exception has been raised
482: -- we must rollback to the savepoint
483: --

Line 552: when hr_api.cannot_find_prog_unit then

548: ( p_external_effort_line_id => p_external_effort_line_id
549: , p_object_version_number => l_object_version_number
550: );
551: exception
552: when hr_api.cannot_find_prog_unit then
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'delete_external_effort_line'
555: ,p_hook_type => 'BP'
556: );

Line 553: hr_api.cannot_find_prog_unit_error

549: , p_object_version_number => l_object_version_number
550: );
551: exception
552: when hr_api.cannot_find_prog_unit then
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'delete_external_effort_line'
555: ,p_hook_type => 'BP'
556: );
557: end;

Line 584: when hr_api.cannot_find_prog_unit then

580: ( p_external_effort_line_id => p_external_effort_line_id
581: , p_object_version_number => l_object_version_number
582: );
583: exception
584: when hr_api.cannot_find_prog_unit then
585: hr_api.cannot_find_prog_unit_error
586: (p_module_name => 'delete_external_effort_line'
587: ,p_hook_type => 'AP'
588: );

Line 585: hr_api.cannot_find_prog_unit_error

581: , p_object_version_number => l_object_version_number
582: );
583: exception
584: when hr_api.cannot_find_prog_unit then
585: hr_api.cannot_find_prog_unit_error
586: (p_module_name => 'delete_external_effort_line'
587: ,p_hook_type => 'AP'
588: );
589: end;

Line 594: raise hr_api.validate_enabled;

590: --
591: -- When in validation only mode raise the Validate_Enabled exception
592: --
593: if p_validate then
594: raise hr_api.validate_enabled;
595: end if;
596: --
597: -- Set all IN OUT and OUT parameters with out values
598: --

Line 602: when hr_api.validate_enabled then

598: --
599: p_object_version_number := l_object_version_number;
600: hr_utility.set_location(' Leaving:'||l_proc, 70);
601: exception
602: when hr_api.validate_enabled then
603: --
604: -- As the Validate_Enabled exception has been raised
605: -- we must rollback to the savepoint
606: --

Line 640: , p_person_id in number default hr_api.g_number

636:
637: procedure delete_external_effort_line_batch
638: ( p_validate in boolean default false
639: , p_batch_name in varchar2
640: , p_person_id in number default hr_api.g_number
641: , p_assignment_id in number default hr_api.g_number
642: , p_return_status out nocopy boolean
643: )
644: IS

Line 641: , p_assignment_id in number default hr_api.g_number

637: procedure delete_external_effort_line_batch
638: ( p_validate in boolean default false
639: , p_batch_name in varchar2
640: , p_person_id in number default hr_api.g_number
641: , p_assignment_id in number default hr_api.g_number
642: , p_return_status out nocopy boolean
643: )
644: IS
645: --

Line 657: AND (person_id = p_person_id OR p_person_id = hr_api.g_number)

653: CURSOR effort_interface_csr IS
654: SELECT external_effort_line_id, object_version_number
655: FROM psp_external_effort_lines
656: WHERE batch_name = p_batch_name
657: AND (person_id = p_person_id OR p_person_id = hr_api.g_number)
658: AND (assignment_id= p_assignment_id OR p_assignment_id = hr_api.g_number);
659:
660:
661: begin

Line 658: AND (assignment_id= p_assignment_id OR p_assignment_id = hr_api.g_number);

654: SELECT external_effort_line_id, object_version_number
655: FROM psp_external_effort_lines
656: WHERE batch_name = p_batch_name
657: AND (person_id = p_person_id OR p_person_id = hr_api.g_number)
658: AND (assignment_id= p_assignment_id OR p_assignment_id = hr_api.g_number);
659:
660:
661: begin
662: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 679: raise hr_api.validate_enabled;

675: );
676:
677: END LOOP;
678: if p_validate then
679: raise hr_api.validate_enabled;
680: end if;
681: exception
682: when hr_api.validate_enabled then
683: --

Line 682: when hr_api.validate_enabled then

678: if p_validate then
679: raise hr_api.validate_enabled;
680: end if;
681: exception
682: when hr_api.validate_enabled then
683: --
684: -- As the Validate_Enabled exception has been raised
685: -- we must rollback to the savepoint
686: --