APPS.HR_AHC_INS dependencies on HR_API

Line 63: -- Insert the row into: hr_api_hook_calls

59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: hr_ahc_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_hook_calls
64: --
65: insert into hr_api_hook_calls
66: ( api_hook_call_id,
67: api_hook_id,

Line 65: insert into hr_api_hook_calls

61: hr_ahc_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_hook_calls
64: --
65: insert into hr_api_hook_calls
66: ( api_hook_call_id,
67: api_hook_id,
68: api_hook_call_type,
69: legislation_code,

Line 102: When hr_api.check_integrity_violated Then

98: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
99: --
100: hr_utility.set_location(' Leaving:'||l_proc, 10);
101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.parent_integrity_violated Then
108: -- Parent integrity has been violated
109: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
110: hr_ahc_shd.constraint_error

Line 107: When hr_api.parent_integrity_violated Then

103: -- A check constraint has been violated
104: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.parent_integrity_violated Then
108: -- Parent integrity has been violated
109: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
110: hr_ahc_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

107: When hr_api.parent_integrity_violated Then
108: -- Parent integrity has been violated
109: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
110: hr_ahc_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
115: hr_ahc_shd.constraint_error

Line 112: When hr_api.unique_integrity_violated Then

108: -- Parent integrity has been violated
109: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
110: hr_ahc_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
115: hr_ahc_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

112: When hr_api.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
115: hr_ahc_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When Others Then
118: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
119: Raise;
120: End insert_dml;

Line 163: Cursor C_Sel1 is select hr_api_hook_calls_s.nextval from sys.dual;

159: Procedure pre_insert(p_rec in out nocopy hr_ahc_shd.g_rec_type) is
160: --
161: l_proc varchar2(72) := g_package||'pre_insert';
162: --
163: Cursor C_Sel1 is select hr_api_hook_calls_s.nextval from sys.dual;
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --