APPS.HR_AMD_INS dependencies on HR_API

Line 63: -- Insert the row into: hr_api_modules

59: --
60: --
61: hr_amd_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_modules
64: --
65: insert into hr_api_modules
66: ( api_module_id,
67: api_module_type,

Line 65: insert into hr_api_modules

61: hr_amd_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_modules
64: --
65: insert into hr_api_modules
66: ( api_module_id,
67: api_module_type,
68: module_name,
69: data_within_business_group,

Line 86: When hr_api.check_integrity_violated Then

82: hr_amd_shd.g_api_dml := false; -- Unset the api dml status
83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: hr_amd_shd.g_api_dml := false; -- Unset the api dml status
89: hr_amd_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 91: When hr_api.parent_integrity_violated Then

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

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

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

Line 96: When hr_api.unique_integrity_violated Then

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

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

96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: hr_amd_shd.g_api_dml := false; -- Unset the api dml status
99: hr_amd_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: hr_amd_shd.g_api_dml := false; -- Unset the api dml status
103: Raise;
104: End insert_dml;

Line 147: Cursor C_Sel1 is select hr_api_modules_s.nextval from sys.dual;

143: Procedure pre_insert(p_rec in out nocopy hr_amd_shd.g_rec_type) is
144: --
145: l_proc varchar2(72) := g_package||'pre_insert';
146: --
147: Cursor C_Sel1 is select hr_api_modules_s.nextval from sys.dual;
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --