DBA Data[Home] [Help]

APPS.HR_PAB_UPD dependencies on HR_PAB_SHD

Line 54: Procedure update_dml(p_rec in out hr_pab_shd.g_rec_type) is

50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out hr_pab_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: hr_pab_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: hr_pab_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the hr_pattern_bits Row
68: --
69: update hr_pattern_bits

Line 79: hr_pab_shd.g_api_dml := false; -- Unset the api dml status

75: base_time_unit = p_rec.base_time_unit,
76: object_version_number = p_rec.object_version_number
77: where pattern_bit_id = p_rec.pattern_bit_id;
78: --
79: hr_pab_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception

Line 86: hr_pab_shd.g_api_dml := false; -- Unset the api dml status

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

Line 87: hr_pab_shd.constraint_error

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

Line 91: hr_pab_shd.g_api_dml := false; -- Unset the api dml status

87: hr_pab_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: hr_pab_shd.g_api_dml := false; -- Unset the api dml status
92: hr_pab_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated

Line 92: hr_pab_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: hr_pab_shd.g_api_dml := false; -- Unset the api dml status
92: hr_pab_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_pab_shd.g_api_dml := false; -- Unset the api dml status

Line 96: hr_pab_shd.g_api_dml := false; -- Unset the api dml status

92: hr_pab_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_pab_shd.g_api_dml := false; -- Unset the api dml status
97: hr_pab_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: hr_pab_shd.g_api_dml := false; -- Unset the api dml status

Line 97: hr_pab_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_pab_shd.g_api_dml := false; -- Unset the api dml status
97: hr_pab_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: hr_pab_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;

Line 100: hr_pab_shd.g_api_dml := false; -- Unset the api dml status

96: hr_pab_shd.g_api_dml := false; -- Unset the api dml status
97: hr_pab_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: hr_pab_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End update_dml;
103: --
104: -- ----------------------------------------------------------------------------

Line 136: Procedure pre_update(p_rec in hr_pab_shd.g_rec_type) is

132: -- Internal Table Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update(p_rec in hr_pab_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin

Line 178: Procedure post_update(p_rec in hr_pab_shd.g_rec_type) is

174: -- Internal Table Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update(p_rec in hr_pab_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin

Line 232: Procedure convert_defs(p_rec in out hr_pab_shd.g_rec_type) is

228: -- Internal Table Handler Use Only.
229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure convert_defs(p_rec in out hr_pab_shd.g_rec_type) is
233: --
234: l_proc varchar2(72) := g_package||'convert_defs';
235: --
236: Begin

Line 247: hr_pab_shd.g_old_rec.pattern_bit_code;

243: -- is being used then we must set to the 'current' argument value.
244: --
245: If (p_rec.pattern_bit_code = hr_api.g_varchar2) then
246: p_rec.pattern_bit_code :=
247: hr_pab_shd.g_old_rec.pattern_bit_code;
248: End If;
249: If (p_rec.bit_meaning = hr_api.g_varchar2) then
250: p_rec.bit_meaning :=
251: hr_pab_shd.g_old_rec.bit_meaning;

Line 251: hr_pab_shd.g_old_rec.bit_meaning;

247: hr_pab_shd.g_old_rec.pattern_bit_code;
248: End If;
249: If (p_rec.bit_meaning = hr_api.g_varchar2) then
250: p_rec.bit_meaning :=
251: hr_pab_shd.g_old_rec.bit_meaning;
252: End If;
253: If (p_rec.time_unit_multiplier = hr_api.g_number) then
254: p_rec.time_unit_multiplier :=
255: hr_pab_shd.g_old_rec.time_unit_multiplier;

Line 255: hr_pab_shd.g_old_rec.time_unit_multiplier;

251: hr_pab_shd.g_old_rec.bit_meaning;
252: End If;
253: If (p_rec.time_unit_multiplier = hr_api.g_number) then
254: p_rec.time_unit_multiplier :=
255: hr_pab_shd.g_old_rec.time_unit_multiplier;
256: End If;
257: If (p_rec.base_time_unit = hr_api.g_varchar2) then
258: p_rec.base_time_unit :=
259: hr_pab_shd.g_old_rec.base_time_unit;

Line 259: hr_pab_shd.g_old_rec.base_time_unit;

255: hr_pab_shd.g_old_rec.time_unit_multiplier;
256: End If;
257: If (p_rec.base_time_unit = hr_api.g_varchar2) then
258: p_rec.base_time_unit :=
259: hr_pab_shd.g_old_rec.base_time_unit;
260: End If;
261:
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 272: p_rec in out hr_pab_shd.g_rec_type,

268: -- |---------------------------------< upd >----------------------------------|
269: -- ----------------------------------------------------------------------------
270: Procedure upd
271: (
272: p_rec in out hr_pab_shd.g_rec_type,
273: p_validate in boolean default false
274: ) is
275: --
276: l_proc varchar2(72) := g_package||'upd';

Line 292: hr_pab_shd.lck

288: End If;
289: --
290: -- We must lock the row which we need to update.
291: --
292: hr_pab_shd.lck
293: (
294: p_rec.pattern_bit_id,
295: p_rec.object_version_number
296: );

Line 349: l_rec hr_pab_shd.g_rec_type;

345: p_object_version_number in out number,
346: p_validate in boolean default false
347: ) is
348: --
349: l_rec hr_pab_shd.g_rec_type;
350: l_proc varchar2(72) := g_package||'upd';
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);

Line 359: hr_pab_shd.convert_args

355: -- Call conversion function to turn arguments into the
356: -- l_rec structure.
357: --
358: l_rec :=
359: hr_pab_shd.convert_args
360: (
361: p_pattern_bit_id,
362: p_pattern_bit_code,
363: p_bit_meaning,