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.IRC_DOCUMENT_API dependencies on HR_API

Line 107: when hr_api.cannot_find_prog_unit then

103: ,p_end_date => p_end_date
104: );
105:
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_DOCUMENT'
110: ,p_hook_type => 'BP'
111: );

Line 108: hr_api.cannot_find_prog_unit_error

104: );
105:
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_DOCUMENT'
110: ,p_hook_type => 'BP'
111: );
112: end;

Line 148: when hr_api.cannot_find_prog_unit then

144: ,p_end_date => p_end_date
145: );
146:
147: exception
148: when hr_api.cannot_find_prog_unit then
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'CREATE_DOCUMENT'
151: ,p_hook_type => 'AP'
152: );

Line 149: hr_api.cannot_find_prog_unit_error

145: );
146:
147: exception
148: when hr_api.cannot_find_prog_unit then
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'CREATE_DOCUMENT'
151: ,p_hook_type => 'AP'
152: );
153: end;

Line 158: raise hr_api.validate_enabled;

154: --
155: -- When in validation only mode raise the Validate_Enabled exception
156: --
157: if p_validate then
158: raise hr_api.validate_enabled;
159: end if;
160: --
161: -- Set all output arguments
162: --

Line 167: when hr_api.validate_enabled then

163: p_document_id := l_document_id;
164: p_object_version_number := l_object_version_number;
165: hr_utility.set_location(' Leaving:'||l_proc, 70);
166: exception
167: when hr_api.validate_enabled then
168: --
169: -- As the Validate_Enabled exception has been raised
170: -- we must rollback to the savepoint
171: --

Line 204: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2

200: procedure UPDATE_DOCUMENT
201: (p_validate in boolean default false
202: ,p_effective_date in date
203: ,p_document_id in number
204: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
205: ,p_type in varchar2 default HR_API.G_VARCHAR2
206: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
207: ,p_description in varchar2 default HR_API.G_VARCHAR2
208: ,p_object_version_number in out nocopy number

Line 205: ,p_type in varchar2 default HR_API.G_VARCHAR2

201: (p_validate in boolean default false
202: ,p_effective_date in date
203: ,p_document_id in number
204: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
205: ,p_type in varchar2 default HR_API.G_VARCHAR2
206: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
207: ,p_description in varchar2 default HR_API.G_VARCHAR2
208: ,p_object_version_number in out nocopy number
209: ) is

Line 206: ,p_file_name in varchar2 default HR_API.G_VARCHAR2

202: ,p_effective_date in date
203: ,p_document_id in number
204: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
205: ,p_type in varchar2 default HR_API.G_VARCHAR2
206: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
207: ,p_description in varchar2 default HR_API.G_VARCHAR2
208: ,p_object_version_number in out nocopy number
209: ) is
210: --

Line 207: ,p_description in varchar2 default HR_API.G_VARCHAR2

203: ,p_document_id in number
204: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
205: ,p_type in varchar2 default HR_API.G_VARCHAR2
206: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
207: ,p_description in varchar2 default HR_API.G_VARCHAR2
208: ,p_object_version_number in out nocopy number
209: ) is
210: --
211: -- Declare cursors and local variables

Line 273: when hr_api.cannot_find_prog_unit then

269: ,p_object_version_number => p_object_version_number
270: );
271:
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'UPDATE_DOCUMENT'
276: ,p_hook_type => 'BP'
277: );

Line 274: hr_api.cannot_find_prog_unit_error

270: );
271:
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'UPDATE_DOCUMENT'
276: ,p_hook_type => 'BP'
277: );
278: end;

Line 314: when hr_api.cannot_find_prog_unit then

310: ,p_object_version_number => p_object_version_number
311: );
312:
313: exception
314: when hr_api.cannot_find_prog_unit then
315: hr_api.cannot_find_prog_unit_error
316: (p_module_name => 'UPDATE_DOCUMENT'
317: ,p_hook_type => 'AP'
318: );

Line 315: hr_api.cannot_find_prog_unit_error

311: );
312:
313: exception
314: when hr_api.cannot_find_prog_unit then
315: hr_api.cannot_find_prog_unit_error
316: (p_module_name => 'UPDATE_DOCUMENT'
317: ,p_hook_type => 'AP'
318: );
319: end;

Line 324: raise hr_api.validate_enabled;

320: --
321: -- When in validation only mode raise the Validate_Enabled exception
322: --
323: if p_validate then
324: raise hr_api.validate_enabled;
325: end if;
326: --
327: -- Set all output arguments
328: --

Line 332: when hr_api.validate_enabled then

328: --
329: p_object_version_number := l_object_version_number;
330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: exception
332: when hr_api.validate_enabled then
333: --
334: -- As the Validate_Enabled exception has been raised
335: -- we must rollback to the savepoint
336: --

Line 365: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2

361: procedure UPDATE_DOCUMENT_TRACK
362: (p_validate in boolean default false
363: ,p_effective_date in date
364: ,p_document_id in number
365: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
366: ,p_type in varchar2 default HR_API.G_VARCHAR2
367: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
368: ,p_description in varchar2 default HR_API.G_VARCHAR2
369: ,p_person_id in number default HR_API.G_NUMBER

Line 366: ,p_type in varchar2 default HR_API.G_VARCHAR2

362: (p_validate in boolean default false
363: ,p_effective_date in date
364: ,p_document_id in number
365: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
366: ,p_type in varchar2 default HR_API.G_VARCHAR2
367: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
368: ,p_description in varchar2 default HR_API.G_VARCHAR2
369: ,p_person_id in number default HR_API.G_NUMBER
370: ,p_party_id in number default HR_API.G_NUMBER

Line 367: ,p_file_name in varchar2 default HR_API.G_VARCHAR2

363: ,p_effective_date in date
364: ,p_document_id in number
365: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
366: ,p_type in varchar2 default HR_API.G_VARCHAR2
367: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
368: ,p_description in varchar2 default HR_API.G_VARCHAR2
369: ,p_person_id in number default HR_API.G_NUMBER
370: ,p_party_id in number default HR_API.G_NUMBER
371: ,p_end_date in date default HR_API.G_DATE

Line 368: ,p_description in varchar2 default HR_API.G_VARCHAR2

364: ,p_document_id in number
365: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
366: ,p_type in varchar2 default HR_API.G_VARCHAR2
367: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
368: ,p_description in varchar2 default HR_API.G_VARCHAR2
369: ,p_person_id in number default HR_API.G_NUMBER
370: ,p_party_id in number default HR_API.G_NUMBER
371: ,p_end_date in date default HR_API.G_DATE
372: ,p_assignment_id in number default HR_API.G_NUMBER

Line 369: ,p_person_id in number default HR_API.G_NUMBER

365: ,p_mime_type in varchar2 default HR_API.G_VARCHAR2
366: ,p_type in varchar2 default HR_API.G_VARCHAR2
367: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
368: ,p_description in varchar2 default HR_API.G_VARCHAR2
369: ,p_person_id in number default HR_API.G_NUMBER
370: ,p_party_id in number default HR_API.G_NUMBER
371: ,p_end_date in date default HR_API.G_DATE
372: ,p_assignment_id in number default HR_API.G_NUMBER
373: ,p_object_version_number in out nocopy number

Line 370: ,p_party_id in number default HR_API.G_NUMBER

366: ,p_type in varchar2 default HR_API.G_VARCHAR2
367: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
368: ,p_description in varchar2 default HR_API.G_VARCHAR2
369: ,p_person_id in number default HR_API.G_NUMBER
370: ,p_party_id in number default HR_API.G_NUMBER
371: ,p_end_date in date default HR_API.G_DATE
372: ,p_assignment_id in number default HR_API.G_NUMBER
373: ,p_object_version_number in out nocopy number
374: ,p_new_doc_id out nocopy number

Line 371: ,p_end_date in date default HR_API.G_DATE

367: ,p_file_name in varchar2 default HR_API.G_VARCHAR2
368: ,p_description in varchar2 default HR_API.G_VARCHAR2
369: ,p_person_id in number default HR_API.G_NUMBER
370: ,p_party_id in number default HR_API.G_NUMBER
371: ,p_end_date in date default HR_API.G_DATE
372: ,p_assignment_id in number default HR_API.G_NUMBER
373: ,p_object_version_number in out nocopy number
374: ,p_new_doc_id out nocopy number
375: ) is

Line 372: ,p_assignment_id in number default HR_API.G_NUMBER

368: ,p_description in varchar2 default HR_API.G_VARCHAR2
369: ,p_person_id in number default HR_API.G_NUMBER
370: ,p_party_id in number default HR_API.G_NUMBER
371: ,p_end_date in date default HR_API.G_DATE
372: ,p_assignment_id in number default HR_API.G_NUMBER
373: ,p_object_version_number in out nocopy number
374: ,p_new_doc_id out nocopy number
375: ) is
376: --

Line 387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;

383: l_job_appln number := 0;
384: --
385: l_end_date date; --to populate end_date in irc_documents table for internet applicants
386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;

Line 388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;

384: --
385: l_end_date date; --to populate end_date in irc_documents table for internet applicants
386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;
392: l_doc_id irc_documents.document_id%type;

Line 389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;

385: l_end_date date; --to populate end_date in irc_documents table for internet applicants
386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;
392: l_doc_id irc_documents.document_id%type;
393: l_obj_version_number number(9);

Line 390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;

386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;
392: l_doc_id irc_documents.document_id%type;
393: l_obj_version_number number(9);
394:

Line 446: when hr_api.cannot_find_prog_unit then

442: ,p_end_date => l_end_date
443: );
444:
445: exception
446: when hr_api.cannot_find_prog_unit then
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'UPDATE_DOCUMENT_TRACK'
449: ,p_hook_type => 'BP'
450: );

Line 447: hr_api.cannot_find_prog_unit_error

443: );
444:
445: exception
446: when hr_api.cannot_find_prog_unit then
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'UPDATE_DOCUMENT_TRACK'
449: ,p_hook_type => 'BP'
450: );
451: end;

Line 485: when hr_api.cannot_find_prog_unit then

481: ,p_end_date => l_end_date
482: );
483:
484: exception
485: when hr_api.cannot_find_prog_unit then
486: hr_api.cannot_find_prog_unit_error
487: (p_module_name => 'UPDATE_DOCUMENT_TRACK'
488: ,p_hook_type => 'AP'
489: );

Line 486: hr_api.cannot_find_prog_unit_error

482: );
483:
484: exception
485: when hr_api.cannot_find_prog_unit then
486: hr_api.cannot_find_prog_unit_error
487: (p_module_name => 'UPDATE_DOCUMENT_TRACK'
488: ,p_hook_type => 'AP'
489: );
490: end;

Line 528: raise hr_api.validate_enabled;

524: --
525: -- When in validation only mode raise the Validate_Enabled exception
526: --
527: if p_validate then
528: raise hr_api.validate_enabled;
529: end if;
530: --
531: -- Set all output arguments
532: --

Line 538: when hr_api.validate_enabled then

534: p_new_doc_id := l_new_doc_id;
535: hr_utility.set_location(' Leaving:'||l_proc, 70);
536: --
537: exception
538: when hr_api.validate_enabled then
539: --
540: -- As the Validate_Enabled exception has been raised
541: -- we must rollback to the savepoint
542: --

Line 598: when hr_api.cannot_find_prog_unit then

594: ,p_end_date => p_end_date
595: );
596:
597: exception
598: when hr_api.cannot_find_prog_unit then
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'UPDATE_DOCUMENT_TRACK'
601: ,p_hook_type => 'BP'
602: );

Line 599: hr_api.cannot_find_prog_unit_error

595: );
596:
597: exception
598: when hr_api.cannot_find_prog_unit then
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'UPDATE_DOCUMENT_TRACK'
601: ,p_hook_type => 'BP'
602: );
603: end;

Line 637: when hr_api.cannot_find_prog_unit then

633: ,p_end_date => p_end_date
634: );
635:
636: exception
637: when hr_api.cannot_find_prog_unit then
638: hr_api.cannot_find_prog_unit_error
639: (p_module_name => 'UPDATE_DOCUMENT_TRACK'
640: ,p_hook_type => 'AP'
641: );

Line 638: hr_api.cannot_find_prog_unit_error

634: );
635:
636: exception
637: when hr_api.cannot_find_prog_unit then
638: hr_api.cannot_find_prog_unit_error
639: (p_module_name => 'UPDATE_DOCUMENT_TRACK'
640: ,p_hook_type => 'AP'
641: );
642: end;

Line 647: raise hr_api.validate_enabled;

643: --
644: -- When in validation only mode raise the Validate_Enabled exception
645: --
646: if p_validate then
647: raise hr_api.validate_enabled;
648: end if;
649: --
650: -- Set all output arguments
651: --

Line 656: when hr_api.validate_enabled then

652: p_object_version_number := l_object_version_number;
653: p_new_doc_id := p_document_id;
654: hr_utility.set_location(' Leaving:'||l_proc, 70);
655: exception
656: when hr_api.validate_enabled then
657: --
658: -- As the Validate_Enabled exception has been raised
659: -- we must rollback to the savepoint
660: --

Line 792: when hr_api.cannot_find_prog_unit then

788: ,p_purge => p_purge
789: );
790:
791: exception
792: when hr_api.cannot_find_prog_unit then
793: hr_api.cannot_find_prog_unit_error
794: (p_module_name => 'DELETE_DOCUMENT'
795: ,p_hook_type => 'BP'
796: );

Line 793: hr_api.cannot_find_prog_unit_error

789: );
790:
791: exception
792: when hr_api.cannot_find_prog_unit then
793: hr_api.cannot_find_prog_unit_error
794: (p_module_name => 'DELETE_DOCUMENT'
795: ,p_hook_type => 'BP'
796: );
797: end;

Line 843: when hr_api.cannot_find_prog_unit then

839: ,p_purge => p_purge
840: );
841:
842: exception
843: when hr_api.cannot_find_prog_unit then
844: hr_api.cannot_find_prog_unit_error
845: (p_module_name => 'DELETE_DOCUMENT'
846: ,p_hook_type => 'AP'
847: );

Line 844: hr_api.cannot_find_prog_unit_error

840: );
841:
842: exception
843: when hr_api.cannot_find_prog_unit then
844: hr_api.cannot_find_prog_unit_error
845: (p_module_name => 'DELETE_DOCUMENT'
846: ,p_hook_type => 'AP'
847: );
848:

Line 852: raise hr_api.validate_enabled;

848:
849: end;
850:
851: if p_validate then
852: raise hr_api.validate_enabled;
853: end if;
854:
855: hr_utility.set_location(' Leaving:'||l_proc, 70);
856:

Line 858: when hr_api.validate_enabled then

854:
855: hr_utility.set_location(' Leaving:'||l_proc, 70);
856:
857: exception
858: when hr_api.validate_enabled then
859: --
860: -- As the Validate_Enabled exception has been raised
861: -- we must rollback to the savepoint
862: --