DBA Data[Home] [Help]

APPS.HR_AMD_UPD dependencies on HR_AMD_SHD

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

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

Line 62: hr_amd_shd.g_api_dml := true; -- Set the api dml status

58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: --
62: hr_amd_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Update the hr_api_modules Row
65: --
66: update hr_api_modules

Line 73: hr_amd_shd.g_api_dml := false; -- Unset the api dml status

69: module_package = p_rec.module_package,
70: data_within_business_group = p_rec.data_within_business_group
71: where api_module_id = p_rec.api_module_id;
72: --
73: hr_amd_shd.g_api_dml := false; -- Unset the api dml status
74: --
75: hr_utility.set_location(' Leaving:'||l_proc, 10);
76: --
77: Exception

Line 80: hr_amd_shd.g_api_dml := false; -- Unset the api dml status

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

Line 81: hr_amd_shd.constraint_error

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

Line 85: hr_amd_shd.g_api_dml := false; -- Unset the api dml status

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

Line 86: hr_amd_shd.constraint_error

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

Line 90: hr_amd_shd.g_api_dml := false; -- Unset the api dml status

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

Line 91: hr_amd_shd.constraint_error

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

Line 94: hr_amd_shd.g_api_dml := false; -- Unset the api dml status

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

Line 130: Procedure pre_update(p_rec in hr_amd_shd.g_rec_type) is

126: -- Internal Row Handler Use Only.
127: --
128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130: Procedure pre_update(p_rec in hr_amd_shd.g_rec_type) is
131: --
132: l_proc varchar2(72) := g_package||'pre_update';
133: --
134: Begin

Line 172: Procedure post_update(p_rec in hr_amd_shd.g_rec_type) is

168: -- Internal Row Handler Use Only.
169: --
170: -- {End Of Comments}
171: -- ----------------------------------------------------------------------------
172: Procedure post_update(p_rec in hr_amd_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'post_update';
175: --
176: Begin

Line 226: Procedure convert_defs(p_rec in out nocopy hr_amd_shd.g_rec_type) is

222: -- Internal Row Handler Use Only.
223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure convert_defs(p_rec in out nocopy hr_amd_shd.g_rec_type) is
227: --
228: l_proc varchar2(72) := g_package||'convert_defs';
229: --
230: Begin

Line 241: hr_amd_shd.g_old_rec.api_module_type;

237: -- is being used then we must set to the 'current' argument value.
238: --
239: If (p_rec.api_module_type = hr_api.g_varchar2) then
240: p_rec.api_module_type :=
241: hr_amd_shd.g_old_rec.api_module_type;
242: End If;
243: If (p_rec.module_name = hr_api.g_varchar2) then
244: p_rec.module_name :=
245: hr_amd_shd.g_old_rec.module_name;

Line 245: hr_amd_shd.g_old_rec.module_name;

241: hr_amd_shd.g_old_rec.api_module_type;
242: End If;
243: If (p_rec.module_name = hr_api.g_varchar2) then
244: p_rec.module_name :=
245: hr_amd_shd.g_old_rec.module_name;
246: End If;
247: If (p_rec.data_within_business_group = hr_api.g_varchar2) then
248: p_rec.data_within_business_group :=
249: hr_amd_shd.g_old_rec.data_within_business_group;

Line 249: hr_amd_shd.g_old_rec.data_within_business_group;

245: hr_amd_shd.g_old_rec.module_name;
246: End If;
247: If (p_rec.data_within_business_group = hr_api.g_varchar2) then
248: p_rec.data_within_business_group :=
249: hr_amd_shd.g_old_rec.data_within_business_group;
250: End If;
251: If (p_rec.legislation_code = hr_api.g_varchar2) then
252: p_rec.legislation_code :=
253: hr_amd_shd.g_old_rec.legislation_code;

Line 253: hr_amd_shd.g_old_rec.legislation_code;

249: hr_amd_shd.g_old_rec.data_within_business_group;
250: End If;
251: If (p_rec.legislation_code = hr_api.g_varchar2) then
252: p_rec.legislation_code :=
253: hr_amd_shd.g_old_rec.legislation_code;
254: End If;
255: If (p_rec.module_package = hr_api.g_varchar2) then
256: p_rec.module_package :=
257: hr_amd_shd.g_old_rec.module_package;

Line 257: hr_amd_shd.g_old_rec.module_package;

253: hr_amd_shd.g_old_rec.legislation_code;
254: End If;
255: If (p_rec.module_package = hr_api.g_varchar2) then
256: p_rec.module_package :=
257: hr_amd_shd.g_old_rec.module_package;
258: End If;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: --

Line 269: p_rec in out nocopy hr_amd_shd.g_rec_type,

265: -- |---------------------------------< upd >----------------------------------|
266: -- ----------------------------------------------------------------------------
267: Procedure upd
268: (
269: p_rec in out nocopy hr_amd_shd.g_rec_type,
270: p_effective_date in date
271: ) is
272: --
273: l_proc varchar2(72) := g_package||'upd';

Line 280: hr_amd_shd.lck

276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: -- We must lock the row which we need to update.
279: --
280: hr_amd_shd.lck
281: (
282: p_rec.api_module_id
283: );
284: --

Line 321: l_rec hr_amd_shd.g_rec_type;

317: p_data_within_business_group in varchar2 default hr_api.g_varchar2,
318: p_effective_date in date
319: ) is
320: --
321: l_rec hr_amd_shd.g_rec_type;
322: l_proc varchar2(72) := g_package||'upd';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);

Line 331: hr_amd_shd.convert_args

327: -- Call conversion function to turn arguments into the
328: -- l_rec structure.
329: --
330: l_rec :=
331: hr_amd_shd.convert_args
332: (
333: p_api_module_id,
334: hr_api.g_varchar2,
335: p_module_name,