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

Line 53: nvl(nre.required_flag,hr_api.g_varchar2) = 'Y';

49: where pa_request_id = p_pa_request_id
50: )
51: )
52: and
53: nvl(nre.required_flag,hr_api.g_varchar2) = 'Y';
54:
55:
56: l_proc varchar2(72) := g_package || 'create_pa_remarks';
57: l_exists boolean := false;

Line 91: when hr_api.cannot_find_prog_unit then

87: ,p_remark_code_information4 => p_remark_code_information4
88: ,p_remark_code_information5 => p_remark_code_information5
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'create_ghr_pa_remarks',
94: p_hook_type => 'BP'
95: );

Line 92: hr_api.cannot_find_prog_unit_error

88: ,p_remark_code_information5 => p_remark_code_information5
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'create_ghr_pa_remarks',
94: p_hook_type => 'BP'
95: );
96: end;

Line 153: when hr_api.cannot_find_prog_unit then

149: ,p_remark_code_information5 => p_remark_code_information5
150: ,p_object_version_number => l_object_version_number
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'create_ghr_pa_remarks',
156: p_hook_type => 'AP'
157: );

Line 154: hr_api.cannot_find_prog_unit_error

150: ,p_object_version_number => l_object_version_number
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'create_ghr_pa_remarks',
156: p_hook_type => 'AP'
157: );
158: end;

Line 163: raise hr_api.validate_enabled;

159: --
160: -- End of Before Process User Hook call
161: --
162: if p_validate then
163: raise hr_api.validate_enabled;
164: end if;
165: --
166: -- Set all output arguments
167: --

Line 174: when hr_api.validate_enabled then

170:
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 11);
173: exception
174: when hr_api.validate_enabled then
175: --
176: -- As the Validate_Enabled exception has been raised
177: -- we must rollback to the savepoint
178: --

Line 207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2

203: procedure update_pa_remarks
204: (p_validate in boolean default false
205: ,p_pa_remark_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2

Line 208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2

204: (p_validate in boolean default false
205: ,p_pa_remark_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2

Line 209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2

205: ,p_pa_remark_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
213: )

Line 210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2

206: ,p_object_version_number in out nocopy number
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
213: )
214: is

Line 211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2

207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
213: )
214: is
215: l_proc varchar2(72) := g_package || 'update_pa_remarks';

Line 212: ,p_description in varchar2 default hr_api.g_varchar2

208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
213: )
214: is
215: l_proc varchar2(72) := g_package || 'update_pa_remarks';
216: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;

Line 239: when hr_api.cannot_find_prog_unit then

235: ,p_remark_code_information5 => p_remark_code_information5
236: ,p_object_version_number => p_object_version_number
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'update_ghr_pa_remarks',
242: p_hook_type => 'BP'
243: );

Line 240: hr_api.cannot_find_prog_unit_error

236: ,p_object_version_number => p_object_version_number
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'update_ghr_pa_remarks',
242: p_hook_type => 'BP'
243: );
244: end;

Line 281: when hr_api.cannot_find_prog_unit then

277: ,p_remark_code_information5 => p_remark_code_information5
278: ,p_object_version_number => l_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'update_ghr_pa_remarks',
284: p_hook_type => 'AP'
285: );

Line 282: hr_api.cannot_find_prog_unit_error

278: ,p_object_version_number => l_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'update_ghr_pa_remarks',
284: p_hook_type => 'AP'
285: );
286: end;

Line 291: raise hr_api.validate_enabled;

287: --
288: -- End of After Process User Hook call
289: --
290: if p_validate then
291: raise hr_api.validate_enabled;
292: end if;
293: --
294: -- Set all output arguments
295: --

Line 300: when hr_api.validate_enabled then

296: -- p_object_version_number := l_object_version_number;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 11);
299: exception
300: when hr_api.validate_enabled then
301: --
302: -- As the Validate_Enabled exception has been raised
303: -- we must rollback to the savepoint
304: --

Line 388: when hr_api.cannot_find_prog_unit then

384: p_pa_remark_id => p_pa_remark_id
385: ,p_object_version_number => p_object_version_number
386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'delete_ghr_pa_remarks',
391: p_hook_type => 'BP'
392: );

Line 389: hr_api.cannot_find_prog_unit_error

385: ,p_object_version_number => p_object_version_number
386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'delete_ghr_pa_remarks',
391: p_hook_type => 'BP'
392: );
393: end;

Line 442: when hr_api.cannot_find_prog_unit then

438: p_pa_remark_id => p_pa_remark_id
439: ,p_object_version_number => p_object_version_number
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'delete_ghr_pa_remarks',
445: p_hook_type => 'AP'
446: );

Line 443: hr_api.cannot_find_prog_unit_error

439: ,p_object_version_number => p_object_version_number
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'delete_ghr_pa_remarks',
445: p_hook_type => 'AP'
446: );
447: end;

Line 454: raise hr_api.validate_enabled;

450: --
451: -- When in validation only mode raise the Validate_Enabled exception
452: --
453: if p_validate then
454: raise hr_api.validate_enabled;
455: end if;
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 11);
458: exception

Line 459: when hr_api.validate_enabled then

455: end if;
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 11);
458: exception
459: when hr_api.validate_enabled then
460: --
461: -- As the Validate_Enabled exception has been raised
462: -- we must rollback to the savepoint
463: --