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 PAY_SGB_SHD

Line 55: (p_rec in out nocopy pay_sgb_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_sgb_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 89: pay_sgb_shd.constraint_error

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));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --

Line 94: 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));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --

Line 99: 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));
101: When Others Then
102: --
103: Raise;

Line 139: (p_rec in pay_sgb_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure pre_update
139: (p_rec in pay_sgb_shd.g_rec_type
140: ) is
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --

Line 182: Procedure post_update (p_rec in pay_sgb_shd.g_rec_type ) is

178: -- Internal Row Handler Use Only.
179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure post_update (p_rec in pay_sgb_shd.g_rec_type ) is
183: --
184: l_proc varchar2(72) := g_package||'post_update';
185: --
186: Begin

Line 236: (p_rec in out nocopy pay_sgb_shd.g_rec_type

232: --
233: -- {End Of Comments}
234: -- ----------------------------------------------------------------------------
235: Procedure convert_defs
236: (p_rec in out nocopy pay_sgb_shd.g_rec_type
237: ) is
238: --
239: Begin
240: --

Line 248: pay_sgb_shd.g_old_rec.source_id;

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
251: p_rec.source_type :=
252: pay_sgb_shd.g_old_rec.source_type;

Line 252: pay_sgb_shd.g_old_rec.source_type;

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
255: p_rec.balance_type_name :=
256: pay_sgb_shd.g_old_rec.balance_type_name;

Line 256: pay_sgb_shd.g_old_rec.balance_type_name;

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
259: p_rec.balance_type_id :=
260: pay_sgb_shd.g_old_rec.balance_type_id;

Line 260: pay_sgb_shd.g_old_rec.balance_type_id;

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
263: p_rec.exclusion_rule_id :=
264: pay_sgb_shd.g_old_rec.exclusion_rule_id;

Line 264: pay_sgb_shd.g_old_rec.exclusion_rule_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: --
267: End convert_defs;
268: --

Line 274: ,p_rec in out nocopy pay_sgb_shd.g_rec_type

270: -- |---------------------------------< upd >----------------------------------|
271: -- ----------------------------------------------------------------------------
272: Procedure upd
273: (p_effective_date in date
274: ,p_rec in out nocopy pay_sgb_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'upd';
278: --

Line 284: pay_sgb_shd.lck

280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- We must lock the row which we need to update.
283: --
284: pay_sgb_shd.lck
285: (p_rec.grossup_balances_id
286: ,p_rec.object_version_number
287: );
288: --

Line 329: l_rec pay_sgb_shd.g_rec_type;

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';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);

Line 339: pay_sgb_shd.convert_args

335: -- Call conversion function to turn arguments into the
336: -- l_rec structure.
337: --
338: l_rec :=
339: pay_sgb_shd.convert_args
340: (p_grossup_balances_id
341: ,p_source_id
342: ,p_source_type
343: ,p_balance_type_name