DBA Data[Home] [Help]

APPS.HR_CAU_UPD dependencies on HR_CAU_SHD

Line 54: Procedure update_dml(p_rec in out nocopy hr_cau_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 nocopy hr_cau_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: hr_cau_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_cau_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the hr_calendar_usages Row
68: --
69: update hr_calendar_usages

Line 76: hr_cau_shd.g_api_dml := false; -- Unset the api dml status

72: end_date = p_rec.end_date,
73: object_version_number = p_rec.object_version_number
74: where calendar_usage_id = p_rec.calendar_usage_id;
75: --
76: hr_cau_shd.g_api_dml := false; -- Unset the api dml status
77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: Exception

Line 83: hr_cau_shd.g_api_dml := false; -- Unset the api dml status

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

Line 84: hr_cau_shd.constraint_error

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

Line 88: hr_cau_shd.g_api_dml := false; -- Unset the api dml status

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

Line 89: hr_cau_shd.constraint_error

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

Line 93: hr_cau_shd.g_api_dml := false; -- Unset the api dml status

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

Line 94: hr_cau_shd.constraint_error

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

Line 97: hr_cau_shd.g_api_dml := false; -- Unset the api dml status

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

Line 133: Procedure pre_update(p_rec in hr_cau_shd.g_rec_type) is

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

Line 175: Procedure post_update(p_rec in hr_cau_shd.g_rec_type) is

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

Line 229: Procedure convert_defs(p_rec in out nocopy hr_cau_shd.g_rec_type) is

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

Line 244: hr_cau_shd.g_old_rec.calendar_id;

240: -- is being used then we must set to the 'current' argument value.
241: --
242: If (p_rec.calendar_id = hr_api.g_number) then
243: p_rec.calendar_id :=
244: hr_cau_shd.g_old_rec.calendar_id;
245: End If;
246: If (p_rec.primary_key_value = hr_api.g_number) then
247: p_rec.primary_key_value :=
248: hr_cau_shd.g_old_rec.primary_key_value;

Line 248: hr_cau_shd.g_old_rec.primary_key_value;

244: hr_cau_shd.g_old_rec.calendar_id;
245: End If;
246: If (p_rec.primary_key_value = hr_api.g_number) then
247: p_rec.primary_key_value :=
248: hr_cau_shd.g_old_rec.primary_key_value;
249: End If;
250: If (p_rec.purpose_usage_id = hr_api.g_number) then
251: p_rec.purpose_usage_id :=
252: hr_cau_shd.g_old_rec.purpose_usage_id;

Line 252: hr_cau_shd.g_old_rec.purpose_usage_id;

248: hr_cau_shd.g_old_rec.primary_key_value;
249: End If;
250: If (p_rec.purpose_usage_id = hr_api.g_number) then
251: p_rec.purpose_usage_id :=
252: hr_cau_shd.g_old_rec.purpose_usage_id;
253: End If;
254: If (p_rec.start_date = hr_api.g_date) then
255: p_rec.start_date :=
256: hr_cau_shd.g_old_rec.start_date;

Line 256: hr_cau_shd.g_old_rec.start_date;

252: hr_cau_shd.g_old_rec.purpose_usage_id;
253: End If;
254: If (p_rec.start_date = hr_api.g_date) then
255: p_rec.start_date :=
256: hr_cau_shd.g_old_rec.start_date;
257: End If;
258: If (p_rec.end_date = hr_api.g_date) then
259: p_rec.end_date :=
260: hr_cau_shd.g_old_rec.end_date;

Line 260: hr_cau_shd.g_old_rec.end_date;

256: hr_cau_shd.g_old_rec.start_date;
257: End If;
258: If (p_rec.end_date = hr_api.g_date) then
259: p_rec.end_date :=
260: hr_cau_shd.g_old_rec.end_date;
261: End If;
262:
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 273: p_rec in out nocopy hr_cau_shd.g_rec_type,

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

Line 293: hr_cau_shd.lck

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

Line 348: l_rec hr_cau_shd.g_rec_type;

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

Line 358: hr_cau_shd.convert_args

354: -- Call conversion function to turn arguments into the
355: -- l_rec structure.
356: --
357: l_rec :=
358: hr_cau_shd.convert_args
359: (
360: hr_api.g_number,
361: p_calendar_usage_id,
362: hr_api.g_number,