APPS.HR_AMD_UPD dependencies on HR_API

Line 64: -- Update the hr_api_modules Row

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
67: set
68: module_name = p_rec.module_name,

Line 66: update hr_api_modules

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
67: set
68: module_name = p_rec.module_name,
69: module_package = p_rec.module_package,
70: data_within_business_group = p_rec.data_within_business_group

Line 78: When hr_api.check_integrity_violated Then

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

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

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
86: hr_amd_shd.constraint_error

Line 83: When hr_api.parent_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
86: hr_amd_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 87: (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
91: hr_amd_shd.constraint_error

Line 88: When hr_api.unique_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
91: hr_amd_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 92: (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;
96: End update_dml;

Line 239: If (p_rec.api_module_type = hr_api.g_varchar2) then

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

Line 243: If (p_rec.module_name = hr_api.g_varchar2) then

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;
246: End If;
247: If (p_rec.data_within_business_group = hr_api.g_varchar2) then

Line 247: If (p_rec.data_within_business_group = hr_api.g_varchar2) then

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;
250: End If;
251: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 251: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

Line 255: If (p_rec.module_package = hr_api.g_varchar2) then

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;
258: End If;
259: --

Line 315: p_module_name in varchar2 default hr_api.g_varchar2,

311: -- ----------------------------------------------------------------------------
312: Procedure upd
313: (
314: p_api_module_id in number,
315: p_module_name in varchar2 default hr_api.g_varchar2,
316: p_module_package in varchar2 default hr_api.g_varchar2,
317: p_data_within_business_group in varchar2 default hr_api.g_varchar2,
318: p_effective_date in date
319: ) is

Line 316: p_module_package in varchar2 default hr_api.g_varchar2,

312: Procedure upd
313: (
314: p_api_module_id in number,
315: p_module_name in varchar2 default hr_api.g_varchar2,
316: p_module_package in varchar2 default hr_api.g_varchar2,
317: p_data_within_business_group in varchar2 default hr_api.g_varchar2,
318: p_effective_date in date
319: ) is
320: --

Line 317: p_data_within_business_group in varchar2 default hr_api.g_varchar2,

313: (
314: p_api_module_id in number,
315: p_module_name in varchar2 default hr_api.g_varchar2,
316: p_module_package in varchar2 default hr_api.g_varchar2,
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;

Line 334: hr_api.g_varchar2,

330: l_rec :=
331: hr_amd_shd.convert_args
332: (
333: p_api_module_id,
334: hr_api.g_varchar2,
335: p_module_name,
336: p_data_within_business_group,
337: hr_api.g_varchar2,
338: p_module_package

Line 337: hr_api.g_varchar2,

333: p_api_module_id,
334: hr_api.g_varchar2,
335: p_module_name,
336: p_data_within_business_group,
337: hr_api.g_varchar2,
338: p_module_package
339: );
340: --
341: -- Having converted the arguments into the