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

Line 60: when hr_api.cannot_find_prog_unit then

56: ,p_status => p_status
57: ,p_effective_date => trunc(p_effective_date)
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'CREATE_FYI_NOTIFY'
64: ,p_hook_type => 'BP'

Line 61: hr_api.cannot_find_prog_unit_error

57: ,p_effective_date => trunc(p_effective_date)
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'CREATE_FYI_NOTIFY'
64: ,p_hook_type => 'BP'
65: );

Line 103: when hr_api.cannot_find_prog_unit then

99: ,p_object_version_number => l_object_version_number
100: ,p_effective_date => trunc(p_effective_date)
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_FYI_NOTIFY'
106: ,p_hook_type => 'AP'
107: );

Line 104: hr_api.cannot_find_prog_unit_error

100: ,p_effective_date => trunc(p_effective_date)
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_FYI_NOTIFY'
106: ,p_hook_type => 'AP'
107: );
108: --

Line 118: raise hr_api.validate_enabled;

114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then
118: raise hr_api.validate_enabled;
119: end if;
120: --
121: -- Set all output arguments
122: --

Line 130: when hr_api.validate_enabled then

126: hr_utility.set_location(' Leaving:'||l_proc, 70);
127: --
128: exception
129: --
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --

Line 162: ,p_transaction_category_id in number default hr_api.g_number

158: --
159: procedure update_fyi_notify
160: (p_validate in boolean default false
161: ,p_fyi_notified_id in number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2

Line 163: ,p_transaction_id in number default hr_api.g_number

159: procedure update_fyi_notify
160: (p_validate in boolean default false
161: ,p_fyi_notified_id in number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date

Line 164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2

160: (p_validate in boolean default false
161: ,p_fyi_notified_id in number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2

Line 165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2

161: ,p_fyi_notified_id in number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number

Line 166: ,p_notified_name in varchar2 default hr_api.g_varchar2

162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number
170: ,p_effective_date in date

Line 167: ,p_notification_date in date default hr_api.g_date

163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number
170: ,p_effective_date in date
171: ) is

Line 168: ,p_status in varchar2 default hr_api.g_varchar2

164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number
170: ,p_effective_date in date
171: ) is
172: --

Line 210: when hr_api.cannot_find_prog_unit then

206: ,p_object_version_number => p_object_version_number
207: ,p_effective_date => trunc(p_effective_date)
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'UPDATE_FYI_NOTIFY'
213: ,p_hook_type => 'BP'
214: );

Line 211: hr_api.cannot_find_prog_unit_error

207: ,p_effective_date => trunc(p_effective_date)
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'UPDATE_FYI_NOTIFY'
213: ,p_hook_type => 'BP'
214: );
215: --

Line 252: when hr_api.cannot_find_prog_unit then

248: ,p_object_version_number => l_object_version_number
249: ,p_effective_date => trunc(p_effective_date)
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'UPDATE_FYI_NOTIFY'
255: ,p_hook_type => 'AP'
256: );

Line 253: hr_api.cannot_find_prog_unit_error

249: ,p_effective_date => trunc(p_effective_date)
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'UPDATE_FYI_NOTIFY'
255: ,p_hook_type => 'AP'
256: );
257: --

Line 267: raise hr_api.validate_enabled;

263: --
264: -- When in validation only mode raise the Validate_Enabled exception
265: --
266: if p_validate then
267: raise hr_api.validate_enabled;
268: end if;
269: --
270: -- Set all output arguments
271: --

Line 278: when hr_api.validate_enabled then

274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
279: --
280: -- As the Validate_Enabled exception has been raised
281: -- we must rollback to the savepoint
282: --

Line 342: when hr_api.cannot_find_prog_unit then

338: ,p_object_version_number => p_object_version_number
339: ,p_effective_date => trunc(p_effective_date)
340: );
341: exception
342: when hr_api.cannot_find_prog_unit then
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'DELETE_FYI_NOTIFY'
345: ,p_hook_type => 'BP'
346: );

Line 343: hr_api.cannot_find_prog_unit_error

339: ,p_effective_date => trunc(p_effective_date)
340: );
341: exception
342: when hr_api.cannot_find_prog_unit then
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'DELETE_FYI_NOTIFY'
345: ,p_hook_type => 'BP'
346: );
347: --

Line 370: when hr_api.cannot_find_prog_unit then

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

Line 371: hr_api.cannot_find_prog_unit_error

367: ,p_effective_date => trunc(p_effective_date)
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'DELETE_FYI_NOTIFY'
373: ,p_hook_type => 'AP'
374: );
375: --

Line 385: raise hr_api.validate_enabled;

381: --
382: -- When in validation only mode raise the Validate_Enabled exception
383: --
384: if p_validate then
385: raise hr_api.validate_enabled;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 70);
389: --

Line 392: when hr_api.validate_enabled then

388: hr_utility.set_location(' Leaving:'||l_proc, 70);
389: --
390: exception
391: --
392: when hr_api.validate_enabled then
393: --
394: -- As the Validate_Enabled exception has been raised
395: -- we must rollback to the savepoint
396: --