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

Line 82: When hr_api.check_integrity_violated Then

78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
85: pay_puc_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
85: pay_puc_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
90: pay_puc_shd.constraint_error

Line 87: When hr_api.parent_integrity_violated Then

83: -- A check constraint has been violated
84: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
85: pay_puc_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
90: pay_puc_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.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
90: pay_puc_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
95: pay_puc_shd.constraint_error

Line 92: When hr_api.unique_integrity_violated Then

88: -- Parent integrity has been violated
89: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
90: pay_puc_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
95: pay_puc_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.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
95: pay_puc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;
100: 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 => 'PAY_USER_COLUMNS'
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 => 'PAY_USER_COLUMNS'
220: ,p_hook_type => 'AU');
221: --
222: end;

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

277: -- p_rec plsql record structure
278: -- to see if a system default is being used. If a system default
279: -- is being used then we must set to the 'current' argument value.
280: --
281: If (p_rec.business_group_id = hr_api.g_number) then
282: p_rec.business_group_id :=
283: pay_puc_shd.g_old_rec.business_group_id;
284: End If;
285: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 285: If (p_rec.legislation_code = hr_api.g_varchar2) then

281: If (p_rec.business_group_id = hr_api.g_number) then
282: p_rec.business_group_id :=
283: pay_puc_shd.g_old_rec.business_group_id;
284: End If;
285: If (p_rec.legislation_code = hr_api.g_varchar2) then
286: p_rec.legislation_code :=
287: pay_puc_shd.g_old_rec.legislation_code;
288: End If;
289: If (p_rec.user_table_id = hr_api.g_number) then

Line 289: If (p_rec.user_table_id = hr_api.g_number) then

285: If (p_rec.legislation_code = hr_api.g_varchar2) then
286: p_rec.legislation_code :=
287: pay_puc_shd.g_old_rec.legislation_code;
288: End If;
289: If (p_rec.user_table_id = hr_api.g_number) then
290: p_rec.user_table_id :=
291: pay_puc_shd.g_old_rec.user_table_id;
292: End If;
293: If (p_rec.formula_id = hr_api.g_number) then

Line 293: If (p_rec.formula_id = hr_api.g_number) then

289: If (p_rec.user_table_id = hr_api.g_number) then
290: p_rec.user_table_id :=
291: pay_puc_shd.g_old_rec.user_table_id;
292: End If;
293: If (p_rec.formula_id = hr_api.g_number) then
294: p_rec.formula_id :=
295: pay_puc_shd.g_old_rec.formula_id;
296: End If;
297: If (p_rec.user_column_name = hr_api.g_varchar2) then

Line 297: If (p_rec.user_column_name = hr_api.g_varchar2) then

293: If (p_rec.formula_id = hr_api.g_number) then
294: p_rec.formula_id :=
295: pay_puc_shd.g_old_rec.formula_id;
296: End If;
297: If (p_rec.user_column_name = hr_api.g_varchar2) then
298: p_rec.user_column_name :=
299: pay_puc_shd.g_old_rec.user_column_name;
300: End If;
301: --

Line 367: ,p_user_column_name in varchar2 default hr_api.g_varchar2

363: -- ----------------------------------------------------------------------------
364: Procedure upd
365: (p_user_column_id in number
366: ,p_object_version_number in out nocopy number
367: ,p_user_column_name in varchar2 default hr_api.g_varchar2
368: ,p_formula_id in number default hr_api.g_number
369: ,p_formula_warning out nocopy boolean
370: ) is
371: --

Line 368: ,p_formula_id in number default hr_api.g_number

364: Procedure upd
365: (p_user_column_id in number
366: ,p_object_version_number in out nocopy number
367: ,p_user_column_name in varchar2 default hr_api.g_varchar2
368: ,p_formula_id in number default hr_api.g_number
369: ,p_formula_warning out nocopy boolean
370: ) is
371: --
372: l_rec pay_puc_shd.g_rec_type;

Line 384: ,hr_api.g_number

380: --
381: l_rec :=
382: pay_puc_shd.convert_args
383: (p_user_column_id
384: ,hr_api.g_number
385: ,hr_api.g_varchar2
386: ,hr_api.g_number
387: ,p_formula_id
388: ,p_user_column_name

Line 385: ,hr_api.g_varchar2

381: l_rec :=
382: pay_puc_shd.convert_args
383: (p_user_column_id
384: ,hr_api.g_number
385: ,hr_api.g_varchar2
386: ,hr_api.g_number
387: ,p_formula_id
388: ,p_user_column_name
389: ,p_object_version_number

Line 386: ,hr_api.g_number

382: pay_puc_shd.convert_args
383: (p_user_column_id
384: ,hr_api.g_number
385: ,hr_api.g_varchar2
386: ,hr_api.g_number
387: ,p_formula_id
388: ,p_user_column_name
389: ,p_object_version_number
390: );