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

Line 87: When hr_api.check_integrity_violated Then

83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
90: ben_ola_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
90: ben_ola_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
95: ben_ola_shd.constraint_error

Line 92: When hr_api.parent_integrity_violated Then

88: -- A check constraint has been violated
89: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
90: ben_ola_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
95: ben_ola_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
95: ben_ola_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
100: ben_ola_shd.constraint_error

Line 97: When hr_api.unique_integrity_violated Then

93: -- Parent integrity has been violated
94: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
95: ben_ola_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
100: ben_ola_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
100: ben_ola_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: ben_ola_shd.g_api_dml := false; -- Unset the api dml status
104: Raise;
105: End update_dml;

Line 216: when hr_api.cannot_find_prog_unit then

212: );
213: --
214: exception
215: --
216: when hr_api.cannot_find_prog_unit then
217: --
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'ben_csr_activities'
220: ,p_hook_type => 'AU');

Line 218: hr_api.cannot_find_prog_unit_error

214: exception
215: --
216: when hr_api.cannot_find_prog_unit then
217: --
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'ben_csr_activities'
220: ,p_hook_type => 'AU');
221: --
222: end;

Line 286: If (p_rec.ordr_num = hr_api.g_number) then

282: -- p_rec plsql record structure
283: -- to see if a system default is being used. If a system default
284: -- is being used then we must set to the 'current' argument value.
285: --
286: If (p_rec.ordr_num = hr_api.g_number) then
287: p_rec.ordr_num :=
288: ben_ola_shd.g_old_rec.ordr_num;
289: End If;
290: If (p_rec.function_name = hr_api.g_varchar2) then

Line 290: If (p_rec.function_name = hr_api.g_varchar2) then

286: If (p_rec.ordr_num = hr_api.g_number) then
287: p_rec.ordr_num :=
288: ben_ola_shd.g_old_rec.ordr_num;
289: End If;
290: If (p_rec.function_name = hr_api.g_varchar2) then
291: p_rec.function_name :=
292: ben_ola_shd.g_old_rec.function_name;
293: End If;
294: If (p_rec.user_function_name = hr_api.g_varchar2) then

Line 294: If (p_rec.user_function_name = hr_api.g_varchar2) then

290: If (p_rec.function_name = hr_api.g_varchar2) then
291: p_rec.function_name :=
292: ben_ola_shd.g_old_rec.function_name;
293: End If;
294: If (p_rec.user_function_name = hr_api.g_varchar2) then
295: p_rec.user_function_name :=
296: ben_ola_shd.g_old_rec.user_function_name;
297: End If;
298: If (p_rec.function_type = hr_api.g_varchar2) then

Line 298: If (p_rec.function_type = hr_api.g_varchar2) then

294: If (p_rec.user_function_name = hr_api.g_varchar2) then
295: p_rec.user_function_name :=
296: ben_ola_shd.g_old_rec.user_function_name;
297: End If;
298: If (p_rec.function_type = hr_api.g_varchar2) then
299: p_rec.function_type :=
300: ben_ola_shd.g_old_rec.function_type;
301: End If;
302: If (p_rec.business_group_id = hr_api.g_number) then

Line 302: If (p_rec.business_group_id = hr_api.g_number) then

298: If (p_rec.function_type = hr_api.g_varchar2) then
299: p_rec.function_type :=
300: ben_ola_shd.g_old_rec.function_type;
301: End If;
302: If (p_rec.business_group_id = hr_api.g_number) then
303: p_rec.business_group_id :=
304: ben_ola_shd.g_old_rec.business_group_id;
305: End If;
306: If (p_rec.start_date = hr_api.g_date) then

Line 306: If (p_rec.start_date = hr_api.g_date) then

302: If (p_rec.business_group_id = hr_api.g_number) then
303: p_rec.business_group_id :=
304: ben_ola_shd.g_old_rec.business_group_id;
305: End If;
306: If (p_rec.start_date = hr_api.g_date) then
307: p_rec.start_date :=
308: ben_ola_shd.g_old_rec.start_date;
309: End If;
310: If (p_rec.end_date = hr_api.g_date) then

Line 310: If (p_rec.end_date = hr_api.g_date) then

306: If (p_rec.start_date = hr_api.g_date) then
307: p_rec.start_date :=
308: ben_ola_shd.g_old_rec.start_date;
309: End If;
310: If (p_rec.end_date = hr_api.g_date) then
311: p_rec.end_date :=
312: ben_ola_shd.g_old_rec.end_date;
313: End If;
314: --

Line 368: p_ordr_num in number default hr_api.g_number,

364: -- ----------------------------------------------------------------------------
365: Procedure upd
366: (
367: p_csr_activities_id in number,
368: p_ordr_num in number default hr_api.g_number,
369: p_function_name in varchar2 default hr_api.g_varchar2,
370: p_user_function_name in varchar2 default hr_api.g_varchar2,
371: p_function_type in varchar2 default hr_api.g_varchar2,
372: p_business_group_id in number default hr_api.g_number,

Line 369: p_function_name in varchar2 default hr_api.g_varchar2,

365: Procedure upd
366: (
367: p_csr_activities_id in number,
368: p_ordr_num in number default hr_api.g_number,
369: p_function_name in varchar2 default hr_api.g_varchar2,
370: p_user_function_name in varchar2 default hr_api.g_varchar2,
371: p_function_type in varchar2 default hr_api.g_varchar2,
372: p_business_group_id in number default hr_api.g_number,
373: p_object_version_number in out nocopy number,

Line 370: p_user_function_name in varchar2 default hr_api.g_varchar2,

366: (
367: p_csr_activities_id in number,
368: p_ordr_num in number default hr_api.g_number,
369: p_function_name in varchar2 default hr_api.g_varchar2,
370: p_user_function_name in varchar2 default hr_api.g_varchar2,
371: p_function_type in varchar2 default hr_api.g_varchar2,
372: p_business_group_id in number default hr_api.g_number,
373: p_object_version_number in out nocopy number,
374: p_start_date in date default hr_api.g_date,

Line 371: p_function_type in varchar2 default hr_api.g_varchar2,

367: p_csr_activities_id in number,
368: p_ordr_num in number default hr_api.g_number,
369: p_function_name in varchar2 default hr_api.g_varchar2,
370: p_user_function_name in varchar2 default hr_api.g_varchar2,
371: p_function_type in varchar2 default hr_api.g_varchar2,
372: p_business_group_id in number default hr_api.g_number,
373: p_object_version_number in out nocopy number,
374: p_start_date in date default hr_api.g_date,
375: p_end_date in date default hr_api.g_date

Line 372: p_business_group_id in number default hr_api.g_number,

368: p_ordr_num in number default hr_api.g_number,
369: p_function_name in varchar2 default hr_api.g_varchar2,
370: p_user_function_name in varchar2 default hr_api.g_varchar2,
371: p_function_type in varchar2 default hr_api.g_varchar2,
372: p_business_group_id in number default hr_api.g_number,
373: p_object_version_number in out nocopy number,
374: p_start_date in date default hr_api.g_date,
375: p_end_date in date default hr_api.g_date
376: ) is

Line 374: p_start_date in date default hr_api.g_date,

370: p_user_function_name in varchar2 default hr_api.g_varchar2,
371: p_function_type in varchar2 default hr_api.g_varchar2,
372: p_business_group_id in number default hr_api.g_number,
373: p_object_version_number in out nocopy number,
374: p_start_date in date default hr_api.g_date,
375: p_end_date in date default hr_api.g_date
376: ) is
377: --
378: l_rec ben_ola_shd.g_rec_type;

Line 375: p_end_date in date default hr_api.g_date

371: p_function_type in varchar2 default hr_api.g_varchar2,
372: p_business_group_id in number default hr_api.g_number,
373: p_object_version_number in out nocopy number,
374: p_start_date in date default hr_api.g_date,
375: p_end_date in date default hr_api.g_date
376: ) is
377: --
378: l_rec ben_ola_shd.g_rec_type;
379: l_proc varchar2(72) := g_package||'upd';