DBA Data[Home] [Help]

APPS.PQH_DOCUMENTS_API dependencies on HR_API

Line 57: ,p_datetrack_mode => hr_api.g_update

53: --
54: pqh_documents_api.update_document
55: (p_validate => false
56: ,p_effective_date => p_effective_date+1
57: ,p_datetrack_mode => hr_api.g_update
58: ,p_short_name => l_short_name
59: ,p_document_name => l_document_name
60: ,p_file_id => l_file_id
61: ,p_formula_id => l_formula_id

Line 139: when hr_api.cannot_find_prog_unit then

135: ,p_language => p_language
136: ,p_territory => p_territory
137: );
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'CREATE_PRINT_DOCUMENT'
142: ,p_hook_type => 'BP'
143: );

Line 140: hr_api.cannot_find_prog_unit_error

136: ,p_territory => p_territory
137: );
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'CREATE_PRINT_DOCUMENT'
142: ,p_hook_type => 'BP'
143: );
144: end;

Line 190: when hr_api.cannot_find_prog_unit then

186: ,p_language => p_language
187: ,p_territory => p_territory
188: );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'CREATE_PRINT_DOCUMENT'
193: ,p_hook_type => 'AP'
194: );

Line 191: hr_api.cannot_find_prog_unit_error

187: ,p_territory => p_territory
188: );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'CREATE_PRINT_DOCUMENT'
193: ,p_hook_type => 'AP'
194: );
195: end;

Line 201: raise hr_api.validate_enabled;

197: --
198: -- When in validation only mode raise the Validate_Enabled exception
199: --
200: if p_validate then
201: raise hr_api.validate_enabled;
202: end if;
203: --
204: -- Set all output arguments
205: --

Line 213: when hr_api.validate_enabled then

209: p_effective_end_date := l_effective_end_date;
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 70);
212: exception
213: when hr_api.validate_enabled then
214: --
215: -- As the Validate_Enabled exception has been raised
216: -- we must rollback to the savepoint
217: --

Line 300: ,p_short_name in varchar2 default hr_api.g_varchar2

296: procedure update_print_document
297: (p_validate in boolean default false
298: ,p_effective_date in date
299: ,p_datetrack_mode in varchar2
300: ,p_short_name in varchar2 default hr_api.g_varchar2
301: ,p_document_name in varchar2 default hr_api.g_varchar2
302: ,p_file_id in number default hr_api.g_number
303: ,p_formula_id in number default hr_api.g_number
304: ,p_enable_flag in varchar2 default hr_api.g_varchar2

Line 301: ,p_document_name in varchar2 default hr_api.g_varchar2

297: (p_validate in boolean default false
298: ,p_effective_date in date
299: ,p_datetrack_mode in varchar2
300: ,p_short_name in varchar2 default hr_api.g_varchar2
301: ,p_document_name in varchar2 default hr_api.g_varchar2
302: ,p_file_id in number default hr_api.g_number
303: ,p_formula_id in number default hr_api.g_number
304: ,p_enable_flag in varchar2 default hr_api.g_varchar2
305: ,p_document_category in varchar2 default hr_api.g_varchar2

Line 302: ,p_file_id in number default hr_api.g_number

298: ,p_effective_date in date
299: ,p_datetrack_mode in varchar2
300: ,p_short_name in varchar2 default hr_api.g_varchar2
301: ,p_document_name in varchar2 default hr_api.g_varchar2
302: ,p_file_id in number default hr_api.g_number
303: ,p_formula_id in number default hr_api.g_number
304: ,p_enable_flag in varchar2 default hr_api.g_varchar2
305: ,p_document_category in varchar2 default hr_api.g_varchar2
306: ,p_document_id in number

Line 303: ,p_formula_id in number default hr_api.g_number

299: ,p_datetrack_mode in varchar2
300: ,p_short_name in varchar2 default hr_api.g_varchar2
301: ,p_document_name in varchar2 default hr_api.g_varchar2
302: ,p_file_id in number default hr_api.g_number
303: ,p_formula_id in number default hr_api.g_number
304: ,p_enable_flag in varchar2 default hr_api.g_varchar2
305: ,p_document_category in varchar2 default hr_api.g_varchar2
306: ,p_document_id in number
307: ,p_object_version_number in OUT NOCOPY number

Line 304: ,p_enable_flag in varchar2 default hr_api.g_varchar2

300: ,p_short_name in varchar2 default hr_api.g_varchar2
301: ,p_document_name in varchar2 default hr_api.g_varchar2
302: ,p_file_id in number default hr_api.g_number
303: ,p_formula_id in number default hr_api.g_number
304: ,p_enable_flag in varchar2 default hr_api.g_varchar2
305: ,p_document_category in varchar2 default hr_api.g_varchar2
306: ,p_document_id in number
307: ,p_object_version_number in OUT NOCOPY number
308: ,p_effective_start_date OUT NOCOPY date

Line 305: ,p_document_category in varchar2 default hr_api.g_varchar2

301: ,p_document_name in varchar2 default hr_api.g_varchar2
302: ,p_file_id in number default hr_api.g_number
303: ,p_formula_id in number default hr_api.g_number
304: ,p_enable_flag in varchar2 default hr_api.g_varchar2
305: ,p_document_category in varchar2 default hr_api.g_varchar2
306: ,p_document_id in number
307: ,p_object_version_number in OUT NOCOPY number
308: ,p_effective_start_date OUT NOCOPY date
309: ,p_effective_end_date OUT NOCOPY date

Line 355: when hr_api.cannot_find_prog_unit then

351: ,p_language => p_language
352: ,p_territory => p_territory
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'UPDATE_PRINT_DOCUMENT'
358: ,p_hook_type => 'BP'
359: );

Line 356: hr_api.cannot_find_prog_unit_error

352: ,p_territory => p_territory
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'UPDATE_PRINT_DOCUMENT'
358: ,p_hook_type => 'BP'
359: );
360: end;

Line 408: when hr_api.cannot_find_prog_unit then

404: ,p_language => p_language
405: ,p_territory => p_territory
406: );
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'UPDATE_PRINT_DOCUMENT'
411: ,p_hook_type => 'AP'
412: );

Line 409: hr_api.cannot_find_prog_unit_error

405: ,p_territory => p_territory
406: );
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'UPDATE_PRINT_DOCUMENT'
411: ,p_hook_type => 'AP'
412: );
413: end;

Line 418: raise hr_api.validate_enabled;

414: --
415: -- When in validation only mode raise the Validate_Enabled exception
416: --
417: if p_validate then
418: raise hr_api.validate_enabled;
419: end if;
420: --
421: -- Set all output arguments
422: --

Line 430: when hr_api.validate_enabled then

426: p_effective_end_date := l_effective_end_date;
427: --
428: hr_utility.set_location(' Leaving:'||l_proc, 70);
429: exception
430: when hr_api.validate_enabled then
431: --
432: -- As the Validate_Enabled exception has been raised
433: -- we must rollback to the savepoint
434: --

Line 466: ,p_short_name in varchar2 default hr_api.g_varchar2

462: procedure update_document
463: (p_validate in boolean default false
464: ,p_effective_date in date
465: ,p_datetrack_mode in varchar2
466: ,p_short_name in varchar2 default hr_api.g_varchar2
467: ,p_document_name in varchar2 default hr_api.g_varchar2
468: ,p_file_id in number default hr_api.g_number
469: ,p_formula_id in number default hr_api.g_number
470: ,p_enable_flag in varchar2 default hr_api.g_varchar2

Line 467: ,p_document_name in varchar2 default hr_api.g_varchar2

463: (p_validate in boolean default false
464: ,p_effective_date in date
465: ,p_datetrack_mode in varchar2
466: ,p_short_name in varchar2 default hr_api.g_varchar2
467: ,p_document_name in varchar2 default hr_api.g_varchar2
468: ,p_file_id in number default hr_api.g_number
469: ,p_formula_id in number default hr_api.g_number
470: ,p_enable_flag in varchar2 default hr_api.g_varchar2
471: ,p_document_category in varchar2 default hr_api.g_varchar2

Line 468: ,p_file_id in number default hr_api.g_number

464: ,p_effective_date in date
465: ,p_datetrack_mode in varchar2
466: ,p_short_name in varchar2 default hr_api.g_varchar2
467: ,p_document_name in varchar2 default hr_api.g_varchar2
468: ,p_file_id in number default hr_api.g_number
469: ,p_formula_id in number default hr_api.g_number
470: ,p_enable_flag in varchar2 default hr_api.g_varchar2
471: ,p_document_category in varchar2 default hr_api.g_varchar2
472: ,p_document_id in number

Line 469: ,p_formula_id in number default hr_api.g_number

465: ,p_datetrack_mode in varchar2
466: ,p_short_name in varchar2 default hr_api.g_varchar2
467: ,p_document_name in varchar2 default hr_api.g_varchar2
468: ,p_file_id in number default hr_api.g_number
469: ,p_formula_id in number default hr_api.g_number
470: ,p_enable_flag in varchar2 default hr_api.g_varchar2
471: ,p_document_category in varchar2 default hr_api.g_varchar2
472: ,p_document_id in number
473: ,p_object_version_number in OUT NOCOPY number

Line 470: ,p_enable_flag in varchar2 default hr_api.g_varchar2

466: ,p_short_name in varchar2 default hr_api.g_varchar2
467: ,p_document_name in varchar2 default hr_api.g_varchar2
468: ,p_file_id in number default hr_api.g_number
469: ,p_formula_id in number default hr_api.g_number
470: ,p_enable_flag in varchar2 default hr_api.g_varchar2
471: ,p_document_category in varchar2 default hr_api.g_varchar2
472: ,p_document_id in number
473: ,p_object_version_number in OUT NOCOPY number
474: ,p_effective_start_date OUT NOCOPY date

Line 471: ,p_document_category in varchar2 default hr_api.g_varchar2

467: ,p_document_name in varchar2 default hr_api.g_varchar2
468: ,p_file_id in number default hr_api.g_number
469: ,p_formula_id in number default hr_api.g_number
470: ,p_enable_flag in varchar2 default hr_api.g_varchar2
471: ,p_document_category in varchar2 default hr_api.g_varchar2
472: ,p_document_id in number
473: ,p_object_version_number in OUT NOCOPY number
474: ,p_effective_start_date OUT NOCOPY date
475: ,p_effective_end_date OUT NOCOPY date

Line 575: when hr_api.cannot_find_prog_unit then

571: ,p_document_id => p_document_id
572: ,p_object_version_number => p_object_version_number
573: );
574: exception
575: when hr_api.cannot_find_prog_unit then
576: hr_api.cannot_find_prog_unit_error
577: (p_module_name => 'DELETE_PRINT_DOCUMENT'
578: ,p_hook_type => 'BP'
579: );

Line 576: hr_api.cannot_find_prog_unit_error

572: ,p_object_version_number => p_object_version_number
573: );
574: exception
575: when hr_api.cannot_find_prog_unit then
576: hr_api.cannot_find_prog_unit_error
577: (p_module_name => 'DELETE_PRINT_DOCUMENT'
578: ,p_hook_type => 'BP'
579: );
580: end;

Line 608: when hr_api.cannot_find_prog_unit then

604: ,p_effective_start_date => l_effective_start_date
605: ,p_effective_end_date => l_effective_end_date
606: );
607: exception
608: when hr_api.cannot_find_prog_unit then
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'DELETE_PRINT_DOCUMENT'
611: ,p_hook_type => 'AP'
612: );

Line 609: hr_api.cannot_find_prog_unit_error

605: ,p_effective_end_date => l_effective_end_date
606: );
607: exception
608: when hr_api.cannot_find_prog_unit then
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'DELETE_PRINT_DOCUMENT'
611: ,p_hook_type => 'AP'
612: );
613: end;

Line 618: raise hr_api.validate_enabled;

614: --
615: -- When in validation only mode raise the Validate_Enabled exception
616: --
617: if p_validate then
618: raise hr_api.validate_enabled;
619: end if;
620: --
621: p_object_version_number := p_object_version_number;
622: p_effective_start_date := l_effective_start_date;

Line 628: when hr_api.validate_enabled then

624: --
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 70);
627: exception
628: when hr_api.validate_enabled then
629: --
630: -- As the Validate_Enabled exception has been raised
631: -- we must rollback to the savepoint
632: --

Line 671: if ( p_datetrack_mode = hr_api.g_delete) then

667: ) is
668:
669: begin
670:
671: if ( p_datetrack_mode = hr_api.g_delete) then
672: create_dummy_rec(
673: p_document_id => p_document_id,
674: p_object_version_number => p_object_version_number,
675: p_effective_date => p_effective_date);