APPS.PAY_SIV_UPD dependencies on HR_API

Line 91: When hr_api.check_integrity_violated Then

87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
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

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

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
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 95: When hr_api.parent_integrity_violated Then

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
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then

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

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
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 99: When hr_api.unique_integrity_violated Then

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
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then

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

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;
106: --

Line 248: If (p_rec.element_type_id = hr_api.g_number) then

244: -- p_rec plsql record structure
245: -- to see if a system default is being used. If a system default
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

Line 252: If (p_rec.display_sequence = hr_api.g_number) then

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;
255: End If;
256: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then

Line 256: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then

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;
259: End If;
260: If (p_rec.hot_default_flag = hr_api.g_varchar2) then

Line 260: If (p_rec.hot_default_flag = hr_api.g_varchar2) then

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;
263: End If;
264: If (p_rec.mandatory_flag = hr_api.g_varchar2) then

Line 264: If (p_rec.mandatory_flag = hr_api.g_varchar2) then

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;
267: End If;
268: If (p_rec.name = hr_api.g_varchar2) then

Line 268: If (p_rec.name = hr_api.g_varchar2) then

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;
271: End If;
272: If (p_rec.uom = hr_api.g_varchar2) then

Line 272: If (p_rec.uom = hr_api.g_varchar2) then

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;
275: End If;
276: If (p_rec.lookup_type = hr_api.g_varchar2) then

Line 276: If (p_rec.lookup_type = hr_api.g_varchar2) then

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;
279: End If;
280: If (p_rec.default_value = hr_api.g_varchar2) then

Line 280: If (p_rec.default_value = hr_api.g_varchar2) then

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;
283: End If;
284: If (p_rec.max_value = hr_api.g_varchar2) then

Line 284: If (p_rec.max_value = hr_api.g_varchar2) then

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;
287: End If;
288: If (p_rec.min_value = hr_api.g_varchar2) then

Line 288: If (p_rec.min_value = hr_api.g_varchar2) then

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;
291: End If;
292: If (p_rec.warning_or_error = hr_api.g_varchar2) then

Line 292: If (p_rec.warning_or_error = hr_api.g_varchar2) then

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;
295: End If;
296: If (p_rec.default_value_column = hr_api.g_varchar2) then

Line 296: If (p_rec.default_value_column = hr_api.g_varchar2) then

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;
299: End If;
300: If (p_rec.exclusion_rule_id = hr_api.g_number) then

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

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;
303: End If;
304: If (p_rec.formula_id = hr_api.g_number) then

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

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;
307: End If;
308: If (p_rec.input_validation_formula = hr_api.g_varchar2) then

Line 308: If (p_rec.input_validation_formula = hr_api.g_varchar2) then

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;
311: End If;
312:

Line 368: p_element_type_id in number default hr_api.g_number,

364: Procedure upd
365: (
366: p_effective_date in date,
367: p_input_value_id in number,
368: p_element_type_id in number default hr_api.g_number,
369: p_display_sequence in number default hr_api.g_number,
370: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,

Line 369: p_display_sequence in number default hr_api.g_number,

365: (
366: p_effective_date in date,
367: p_input_value_id in number,
368: p_element_type_id in number default hr_api.g_number,
369: p_display_sequence in number default hr_api.g_number,
370: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
373: p_name in varchar2 default hr_api.g_varchar2,

Line 370: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,

366: p_effective_date in date,
367: p_input_value_id in number,
368: p_element_type_id in number default hr_api.g_number,
369: p_display_sequence in number default hr_api.g_number,
370: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
373: p_name in varchar2 default hr_api.g_varchar2,
374: p_uom in varchar2 default hr_api.g_varchar2,

Line 371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,

367: p_input_value_id in number,
368: p_element_type_id in number default hr_api.g_number,
369: p_display_sequence in number default hr_api.g_number,
370: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
373: p_name in varchar2 default hr_api.g_varchar2,
374: p_uom in varchar2 default hr_api.g_varchar2,
375: p_lookup_type in varchar2 default hr_api.g_varchar2,

Line 372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,

368: p_element_type_id in number default hr_api.g_number,
369: p_display_sequence in number default hr_api.g_number,
370: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
373: p_name in varchar2 default hr_api.g_varchar2,
374: p_uom in varchar2 default hr_api.g_varchar2,
375: p_lookup_type in varchar2 default hr_api.g_varchar2,
376: p_default_value in varchar2 default hr_api.g_varchar2,

Line 373: p_name in varchar2 default hr_api.g_varchar2,

369: p_display_sequence in number default hr_api.g_number,
370: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
373: p_name in varchar2 default hr_api.g_varchar2,
374: p_uom in varchar2 default hr_api.g_varchar2,
375: p_lookup_type in varchar2 default hr_api.g_varchar2,
376: p_default_value in varchar2 default hr_api.g_varchar2,
377: p_max_value in varchar2 default hr_api.g_varchar2,

Line 374: p_uom in varchar2 default hr_api.g_varchar2,

370: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
373: p_name in varchar2 default hr_api.g_varchar2,
374: p_uom in varchar2 default hr_api.g_varchar2,
375: p_lookup_type in varchar2 default hr_api.g_varchar2,
376: p_default_value in varchar2 default hr_api.g_varchar2,
377: p_max_value in varchar2 default hr_api.g_varchar2,
378: p_min_value in varchar2 default hr_api.g_varchar2,

Line 375: p_lookup_type in varchar2 default hr_api.g_varchar2,

371: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
373: p_name in varchar2 default hr_api.g_varchar2,
374: p_uom in varchar2 default hr_api.g_varchar2,
375: p_lookup_type in varchar2 default hr_api.g_varchar2,
376: p_default_value in varchar2 default hr_api.g_varchar2,
377: p_max_value in varchar2 default hr_api.g_varchar2,
378: p_min_value in varchar2 default hr_api.g_varchar2,
379: p_warning_or_error in varchar2 default hr_api.g_varchar2,

Line 376: p_default_value in varchar2 default hr_api.g_varchar2,

372: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
373: p_name in varchar2 default hr_api.g_varchar2,
374: p_uom in varchar2 default hr_api.g_varchar2,
375: p_lookup_type in varchar2 default hr_api.g_varchar2,
376: p_default_value in varchar2 default hr_api.g_varchar2,
377: p_max_value in varchar2 default hr_api.g_varchar2,
378: p_min_value in varchar2 default hr_api.g_varchar2,
379: p_warning_or_error in varchar2 default hr_api.g_varchar2,
380: p_default_value_column in varchar2 default hr_api.g_varchar2,

Line 377: p_max_value in varchar2 default hr_api.g_varchar2,

373: p_name in varchar2 default hr_api.g_varchar2,
374: p_uom in varchar2 default hr_api.g_varchar2,
375: p_lookup_type in varchar2 default hr_api.g_varchar2,
376: p_default_value in varchar2 default hr_api.g_varchar2,
377: p_max_value in varchar2 default hr_api.g_varchar2,
378: p_min_value in varchar2 default hr_api.g_varchar2,
379: p_warning_or_error in varchar2 default hr_api.g_varchar2,
380: p_default_value_column in varchar2 default hr_api.g_varchar2,
381: p_exclusion_rule_id in number default hr_api.g_number,

Line 378: p_min_value in varchar2 default hr_api.g_varchar2,

374: p_uom in varchar2 default hr_api.g_varchar2,
375: p_lookup_type in varchar2 default hr_api.g_varchar2,
376: p_default_value in varchar2 default hr_api.g_varchar2,
377: p_max_value in varchar2 default hr_api.g_varchar2,
378: p_min_value in varchar2 default hr_api.g_varchar2,
379: p_warning_or_error in varchar2 default hr_api.g_varchar2,
380: p_default_value_column in varchar2 default hr_api.g_varchar2,
381: p_exclusion_rule_id in number default hr_api.g_number,
382: p_formula_id in number default hr_api.g_number,

Line 379: p_warning_or_error in varchar2 default hr_api.g_varchar2,

375: p_lookup_type in varchar2 default hr_api.g_varchar2,
376: p_default_value in varchar2 default hr_api.g_varchar2,
377: p_max_value in varchar2 default hr_api.g_varchar2,
378: p_min_value in varchar2 default hr_api.g_varchar2,
379: p_warning_or_error in varchar2 default hr_api.g_varchar2,
380: p_default_value_column in varchar2 default hr_api.g_varchar2,
381: p_exclusion_rule_id in number default hr_api.g_number,
382: p_formula_id in number default hr_api.g_number,
383: p_input_validation_formula in varchar2 default hr_api.g_varchar2,

Line 380: p_default_value_column in varchar2 default hr_api.g_varchar2,

376: p_default_value in varchar2 default hr_api.g_varchar2,
377: p_max_value in varchar2 default hr_api.g_varchar2,
378: p_min_value in varchar2 default hr_api.g_varchar2,
379: p_warning_or_error in varchar2 default hr_api.g_varchar2,
380: p_default_value_column in varchar2 default hr_api.g_varchar2,
381: p_exclusion_rule_id in number default hr_api.g_number,
382: p_formula_id in number default hr_api.g_number,
383: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
384: p_object_version_number in out nocopy number

Line 381: p_exclusion_rule_id in number default hr_api.g_number,

377: p_max_value in varchar2 default hr_api.g_varchar2,
378: p_min_value in varchar2 default hr_api.g_varchar2,
379: p_warning_or_error in varchar2 default hr_api.g_varchar2,
380: p_default_value_column in varchar2 default hr_api.g_varchar2,
381: p_exclusion_rule_id in number default hr_api.g_number,
382: p_formula_id in number default hr_api.g_number,
383: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
384: p_object_version_number in out nocopy number
385: ) is

Line 382: p_formula_id in number default hr_api.g_number,

378: p_min_value in varchar2 default hr_api.g_varchar2,
379: p_warning_or_error in varchar2 default hr_api.g_varchar2,
380: p_default_value_column in varchar2 default hr_api.g_varchar2,
381: p_exclusion_rule_id in number default hr_api.g_number,
382: p_formula_id in number default hr_api.g_number,
383: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
384: p_object_version_number in out nocopy number
385: ) is
386: --

Line 383: p_input_validation_formula in varchar2 default hr_api.g_varchar2,

379: p_warning_or_error in varchar2 default hr_api.g_varchar2,
380: p_default_value_column in varchar2 default hr_api.g_varchar2,
381: p_exclusion_rule_id in number default hr_api.g_number,
382: p_formula_id in number default hr_api.g_number,
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;