APPS.HR_AHK_INS dependencies on HR_API

Line 63: -- Insert the row into: hr_api_hooks

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

Line 65: insert into hr_api_hooks

61: hr_ahk_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_hooks
64: --
65: insert into hr_api_hooks
66: ( api_hook_id,
67: api_module_id,
68: api_hook_type,
69: hook_package,

Line 92: When hr_api.check_integrity_violated Then

88: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
95: hr_ahk_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 97: When hr_api.parent_integrity_violated Then

93: -- A check constraint has been violated
94: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
95: hr_ahk_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
100: hr_ahk_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
100: hr_ahk_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahk_shd.constraint_error

Line 102: When hr_api.unique_integrity_violated Then

98: -- Parent integrity has been violated
99: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
100: hr_ahk_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahk_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.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahk_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;
110: End insert_dml;

Line 153: Cursor C_Sel1 is select hr_api_hooks_s.nextval from sys.dual;

149: Procedure pre_insert(p_rec in out nocopy hr_ahk_shd.g_rec_type) is
150: --
151: l_proc varchar2(72) := g_package||'pre_insert';
152: --
153: Cursor C_Sel1 is select hr_api_hooks_s.nextval from sys.dual;
154: --
155: Begin
156: hr_utility.set_location('Entering:'||l_proc, 5);
157: --