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_SIV_UPD dependencies on PAY_SIV_SHD

Line 51: Procedure update_dml(p_rec in out nocopy pay_siv_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure update_dml(p_rec in out nocopy pay_siv_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin

Line 93: pay_siv_shd.constraint_error

89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: pay_siv_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pay_siv_shd.constraint_error

Line 97: pay_siv_shd.constraint_error

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

Line 101: pay_siv_shd.constraint_error

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

Line 139: Procedure pre_update(p_rec in pay_siv_shd.g_rec_type) is

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

Line 181: Procedure post_update(p_rec in pay_siv_shd.g_rec_type) is

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

Line 235: Procedure convert_defs(p_rec in out nocopy pay_siv_shd.g_rec_type) is

231: -- Internal Row Handler Use Only.
232: --
233: -- {End Of Comments}
234: -- ----------------------------------------------------------------------------
235: Procedure convert_defs(p_rec in out nocopy pay_siv_shd.g_rec_type) is
236: --
237: l_proc varchar2(72) := g_package||'convert_defs';
238: --
239: Begin

Line 250: pay_siv_shd.g_old_rec.element_type_id;

246: -- is being used then we must set to the 'current' argument value.
247: --
248: If (p_rec.element_type_id = hr_api.g_number) then
249: p_rec.element_type_id :=
250: pay_siv_shd.g_old_rec.element_type_id;
251: End If;
252: If (p_rec.display_sequence = hr_api.g_number) then
253: p_rec.display_sequence :=
254: pay_siv_shd.g_old_rec.display_sequence;

Line 254: pay_siv_shd.g_old_rec.display_sequence;

250: pay_siv_shd.g_old_rec.element_type_id;
251: End If;
252: If (p_rec.display_sequence = hr_api.g_number) then
253: p_rec.display_sequence :=
254: pay_siv_shd.g_old_rec.display_sequence;
255: End If;
256: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then
257: p_rec.generate_db_items_flag :=
258: pay_siv_shd.g_old_rec.generate_db_items_flag;

Line 258: pay_siv_shd.g_old_rec.generate_db_items_flag;

254: pay_siv_shd.g_old_rec.display_sequence;
255: End If;
256: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then
257: p_rec.generate_db_items_flag :=
258: pay_siv_shd.g_old_rec.generate_db_items_flag;
259: End If;
260: If (p_rec.hot_default_flag = hr_api.g_varchar2) then
261: p_rec.hot_default_flag :=
262: pay_siv_shd.g_old_rec.hot_default_flag;

Line 262: pay_siv_shd.g_old_rec.hot_default_flag;

258: pay_siv_shd.g_old_rec.generate_db_items_flag;
259: End If;
260: If (p_rec.hot_default_flag = hr_api.g_varchar2) then
261: p_rec.hot_default_flag :=
262: pay_siv_shd.g_old_rec.hot_default_flag;
263: End If;
264: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
265: p_rec.mandatory_flag :=
266: pay_siv_shd.g_old_rec.mandatory_flag;

Line 266: pay_siv_shd.g_old_rec.mandatory_flag;

262: pay_siv_shd.g_old_rec.hot_default_flag;
263: End If;
264: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
265: p_rec.mandatory_flag :=
266: pay_siv_shd.g_old_rec.mandatory_flag;
267: End If;
268: If (p_rec.name = hr_api.g_varchar2) then
269: p_rec.name :=
270: pay_siv_shd.g_old_rec.name;

Line 270: pay_siv_shd.g_old_rec.name;

266: pay_siv_shd.g_old_rec.mandatory_flag;
267: End If;
268: If (p_rec.name = hr_api.g_varchar2) then
269: p_rec.name :=
270: pay_siv_shd.g_old_rec.name;
271: End If;
272: If (p_rec.uom = hr_api.g_varchar2) then
273: p_rec.uom :=
274: pay_siv_shd.g_old_rec.uom;

Line 274: pay_siv_shd.g_old_rec.uom;

270: pay_siv_shd.g_old_rec.name;
271: End If;
272: If (p_rec.uom = hr_api.g_varchar2) then
273: p_rec.uom :=
274: pay_siv_shd.g_old_rec.uom;
275: End If;
276: If (p_rec.lookup_type = hr_api.g_varchar2) then
277: p_rec.lookup_type :=
278: pay_siv_shd.g_old_rec.lookup_type;

Line 278: pay_siv_shd.g_old_rec.lookup_type;

274: pay_siv_shd.g_old_rec.uom;
275: End If;
276: If (p_rec.lookup_type = hr_api.g_varchar2) then
277: p_rec.lookup_type :=
278: pay_siv_shd.g_old_rec.lookup_type;
279: End If;
280: If (p_rec.default_value = hr_api.g_varchar2) then
281: p_rec.default_value :=
282: pay_siv_shd.g_old_rec.default_value;

Line 282: pay_siv_shd.g_old_rec.default_value;

278: pay_siv_shd.g_old_rec.lookup_type;
279: End If;
280: If (p_rec.default_value = hr_api.g_varchar2) then
281: p_rec.default_value :=
282: pay_siv_shd.g_old_rec.default_value;
283: End If;
284: If (p_rec.max_value = hr_api.g_varchar2) then
285: p_rec.max_value :=
286: pay_siv_shd.g_old_rec.max_value;

Line 286: pay_siv_shd.g_old_rec.max_value;

282: pay_siv_shd.g_old_rec.default_value;
283: End If;
284: If (p_rec.max_value = hr_api.g_varchar2) then
285: p_rec.max_value :=
286: pay_siv_shd.g_old_rec.max_value;
287: End If;
288: If (p_rec.min_value = hr_api.g_varchar2) then
289: p_rec.min_value :=
290: pay_siv_shd.g_old_rec.min_value;

Line 290: pay_siv_shd.g_old_rec.min_value;

286: pay_siv_shd.g_old_rec.max_value;
287: End If;
288: If (p_rec.min_value = hr_api.g_varchar2) then
289: p_rec.min_value :=
290: pay_siv_shd.g_old_rec.min_value;
291: End If;
292: If (p_rec.warning_or_error = hr_api.g_varchar2) then
293: p_rec.warning_or_error :=
294: pay_siv_shd.g_old_rec.warning_or_error;

Line 294: pay_siv_shd.g_old_rec.warning_or_error;

290: pay_siv_shd.g_old_rec.min_value;
291: End If;
292: If (p_rec.warning_or_error = hr_api.g_varchar2) then
293: p_rec.warning_or_error :=
294: pay_siv_shd.g_old_rec.warning_or_error;
295: End If;
296: If (p_rec.default_value_column = hr_api.g_varchar2) then
297: p_rec.default_value_column :=
298: pay_siv_shd.g_old_rec.default_value_column;

Line 298: pay_siv_shd.g_old_rec.default_value_column;

294: pay_siv_shd.g_old_rec.warning_or_error;
295: End If;
296: If (p_rec.default_value_column = hr_api.g_varchar2) then
297: p_rec.default_value_column :=
298: pay_siv_shd.g_old_rec.default_value_column;
299: End If;
300: If (p_rec.exclusion_rule_id = hr_api.g_number) then
301: p_rec.exclusion_rule_id :=
302: pay_siv_shd.g_old_rec.exclusion_rule_id;

Line 302: pay_siv_shd.g_old_rec.exclusion_rule_id;

298: pay_siv_shd.g_old_rec.default_value_column;
299: End If;
300: If (p_rec.exclusion_rule_id = hr_api.g_number) then
301: p_rec.exclusion_rule_id :=
302: pay_siv_shd.g_old_rec.exclusion_rule_id;
303: End If;
304: If (p_rec.formula_id = hr_api.g_number) then
305: p_rec.formula_id :=
306: pay_siv_shd.g_old_rec.formula_id;

Line 306: pay_siv_shd.g_old_rec.formula_id;

302: pay_siv_shd.g_old_rec.exclusion_rule_id;
303: End If;
304: If (p_rec.formula_id = hr_api.g_number) then
305: p_rec.formula_id :=
306: pay_siv_shd.g_old_rec.formula_id;
307: End If;
308: If (p_rec.input_validation_formula = hr_api.g_varchar2) then
309: p_rec.input_validation_formula :=
310: pay_siv_shd.g_old_rec.input_validation_formula;

Line 310: pay_siv_shd.g_old_rec.input_validation_formula;

306: pay_siv_shd.g_old_rec.formula_id;
307: End If;
308: If (p_rec.input_validation_formula = hr_api.g_varchar2) then
309: p_rec.input_validation_formula :=
310: pay_siv_shd.g_old_rec.input_validation_formula;
311: End If;
312:
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 323: ,p_rec in out nocopy pay_siv_shd.g_rec_type

319: -- |---------------------------------< upd >----------------------------------|
320: -- ----------------------------------------------------------------------------
321: Procedure upd
322: (p_effective_date in date
323: ,p_rec in out nocopy pay_siv_shd.g_rec_type
324: ) is
325: --
326: l_proc varchar2(72) := g_package||'upd';
327: --

Line 333: pay_siv_shd.lck

329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: -- We must lock the row which we need to update.
332: --
333: pay_siv_shd.lck
334: (
335: p_rec.input_value_id,
336: p_rec.object_version_number
337: );

Line 387: l_rec pay_siv_shd.g_rec_type;

383: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
384: p_object_version_number in out nocopy number
385: ) is
386: --
387: l_rec pay_siv_shd.g_rec_type;
388: l_proc varchar2(72) := g_package||'upd';
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);

Line 397: pay_siv_shd.convert_args

393: -- Call conversion function to turn arguments into the
394: -- l_rec structure.
395: --
396: l_rec :=
397: pay_siv_shd.convert_args
398: (
399: p_input_value_id,
400: p_element_type_id,
401: p_display_sequence,