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_SGB_UPD dependencies on HR_API

Line 86: When hr_api.check_integrity_violated Then

82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: --
85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: pay_sgb_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: pay_sgb_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: pay_sgb_shd.constraint_error

Line 91: When hr_api.parent_integrity_violated Then

87: -- A check constraint has been violated
88: --
89: pay_sgb_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: pay_sgb_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: pay_sgb_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: pay_sgb_shd.constraint_error

Line 96: When hr_api.unique_integrity_violated Then

92: -- Parent integrity has been violated
93: --
94: pay_sgb_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: pay_sgb_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: pay_sgb_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: Raise;
104: End update_dml;

Line 246: If (p_rec.source_id = hr_api.g_number) then

242: -- p_rec plsql record structure
243: -- to see if a system default is being used. If a system default
244: -- is being used then we must set to the 'current' argument value.
245: --
246: If (p_rec.source_id = hr_api.g_number) then
247: p_rec.source_id :=
248: pay_sgb_shd.g_old_rec.source_id;
249: End If;
250: If (p_rec.source_type = hr_api.g_varchar2) then

Line 250: If (p_rec.source_type = hr_api.g_varchar2) then

246: If (p_rec.source_id = hr_api.g_number) then
247: p_rec.source_id :=
248: pay_sgb_shd.g_old_rec.source_id;
249: End If;
250: If (p_rec.source_type = hr_api.g_varchar2) then
251: p_rec.source_type :=
252: pay_sgb_shd.g_old_rec.source_type;
253: End If;
254: If (p_rec.balance_type_name = hr_api.g_varchar2) then

Line 254: If (p_rec.balance_type_name = hr_api.g_varchar2) then

250: If (p_rec.source_type = hr_api.g_varchar2) then
251: p_rec.source_type :=
252: pay_sgb_shd.g_old_rec.source_type;
253: End If;
254: If (p_rec.balance_type_name = hr_api.g_varchar2) then
255: p_rec.balance_type_name :=
256: pay_sgb_shd.g_old_rec.balance_type_name;
257: End If;
258: If (p_rec.balance_type_id = hr_api.g_number) then

Line 258: If (p_rec.balance_type_id = hr_api.g_number) then

254: If (p_rec.balance_type_name = hr_api.g_varchar2) then
255: p_rec.balance_type_name :=
256: pay_sgb_shd.g_old_rec.balance_type_name;
257: End If;
258: If (p_rec.balance_type_id = hr_api.g_number) then
259: p_rec.balance_type_id :=
260: pay_sgb_shd.g_old_rec.balance_type_id;
261: End If;
262: If (p_rec.exclusion_rule_id = hr_api.g_number) then

Line 262: If (p_rec.exclusion_rule_id = hr_api.g_number) then

258: If (p_rec.balance_type_id = hr_api.g_number) then
259: p_rec.balance_type_id :=
260: pay_sgb_shd.g_old_rec.balance_type_id;
261: End If;
262: If (p_rec.exclusion_rule_id = hr_api.g_number) then
263: p_rec.exclusion_rule_id :=
264: pay_sgb_shd.g_old_rec.exclusion_rule_id;
265: End If;
266: --

Line 322: ,p_source_id in number default hr_api.g_number

318: Procedure upd
319: (p_effective_date in date
320: ,p_grossup_balances_id in number
321: ,p_object_version_number in out nocopy number
322: ,p_source_id in number default hr_api.g_number
323: ,p_source_type in varchar2 default hr_api.g_varchar2
324: ,p_balance_type_name in varchar2 default hr_api.g_varchar2
325: ,p_balance_type_id in number default hr_api.g_number
326: ,p_exclusion_rule_id in number default hr_api.g_number

Line 323: ,p_source_type in varchar2 default hr_api.g_varchar2

319: (p_effective_date in date
320: ,p_grossup_balances_id in number
321: ,p_object_version_number in out nocopy number
322: ,p_source_id in number default hr_api.g_number
323: ,p_source_type in varchar2 default hr_api.g_varchar2
324: ,p_balance_type_name in varchar2 default hr_api.g_varchar2
325: ,p_balance_type_id in number default hr_api.g_number
326: ,p_exclusion_rule_id in number default hr_api.g_number
327: ) is

Line 324: ,p_balance_type_name in varchar2 default hr_api.g_varchar2

320: ,p_grossup_balances_id in number
321: ,p_object_version_number in out nocopy number
322: ,p_source_id in number default hr_api.g_number
323: ,p_source_type in varchar2 default hr_api.g_varchar2
324: ,p_balance_type_name in varchar2 default hr_api.g_varchar2
325: ,p_balance_type_id in number default hr_api.g_number
326: ,p_exclusion_rule_id in number default hr_api.g_number
327: ) is
328: --

Line 325: ,p_balance_type_id in number default hr_api.g_number

321: ,p_object_version_number in out nocopy number
322: ,p_source_id in number default hr_api.g_number
323: ,p_source_type in varchar2 default hr_api.g_varchar2
324: ,p_balance_type_name in varchar2 default hr_api.g_varchar2
325: ,p_balance_type_id in number default hr_api.g_number
326: ,p_exclusion_rule_id in number default hr_api.g_number
327: ) is
328: --
329: l_rec pay_sgb_shd.g_rec_type;

Line 326: ,p_exclusion_rule_id in number default hr_api.g_number

322: ,p_source_id in number default hr_api.g_number
323: ,p_source_type in varchar2 default hr_api.g_varchar2
324: ,p_balance_type_name in varchar2 default hr_api.g_varchar2
325: ,p_balance_type_id in number default hr_api.g_number
326: ,p_exclusion_rule_id in number default hr_api.g_number
327: ) is
328: --
329: l_rec pay_sgb_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'upd';