DBA Data[Home] [Help]

APPS.FF_FFN_INS dependencies on FF_FFN_SHD

Line 124: (p_rec in out nocopy ff_ffn_shd.g_rec_type

120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure insert_dml
124: (p_rec in out nocopy ff_ffn_shd.g_rec_type
125: ) is
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --

Line 133: ff_ffn_shd.g_api_dml := true; -- Set the api dml status

129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: ff_ffn_shd.g_api_dml := true; -- Set the api dml status
134: --
135: -- Insert the row into: ff_functions
136: --
137: insert into ff_functions

Line 162: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

158: ,p_rec.description
159: ,p_rec.object_version_number
160: );
161: --
162: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then

Line 168: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
169: ff_ffn_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated

Line 169: ff_ffn_shd.constraint_error

165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
169: ff_ffn_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

Line 173: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

169: ff_ffn_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
174: ff_ffn_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated

Line 174: ff_ffn_shd.constraint_error

170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
174: ff_ffn_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

Line 178: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

174: ff_ffn_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
179: ff_ffn_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

Line 179: ff_ffn_shd.constraint_error

175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
179: ff_ffn_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;

Line 182: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

178: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
179: ff_ffn_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;
184: End insert_dml;
185: --
186: -- ----------------------------------------------------------------------------

Line 224: (p_rec in out nocopy ff_ffn_shd.g_rec_type

220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure pre_insert
224: (p_rec in out nocopy ff_ffn_shd.g_rec_type
225: ) is
226: --
227: Cursor C_Sel1 is select ff_functions_s.nextval from sys.dual;
228: --

Line 312: ,p_rec in ff_ffn_shd.g_rec_type

308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure post_insert
311: (p_effective_date in date
312: ,p_rec in ff_ffn_shd.g_rec_type
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'post_insert';
316: --

Line 359: ,p_rec in out nocopy ff_ffn_shd.g_rec_type

355: -- |---------------------------------< ins >----------------------------------|
356: -- ----------------------------------------------------------------------------
357: Procedure ins
358: (p_effective_date in date
359: ,p_rec in out nocopy ff_ffn_shd.g_rec_type
360: ) is
361: --
362: l_proc varchar2(72) := g_package||'ins';
363: --

Line 415: l_rec ff_ffn_shd.g_rec_type;

411: ,p_function_id out nocopy number
412: ,p_object_version_number out nocopy number
413: ) is
414: --
415: l_rec ff_ffn_shd.g_rec_type;
416: l_proc varchar2(72) := g_package||'ins';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);

Line 425: ff_ffn_shd.convert_args

421: -- Call conversion function to turn arguments into the
422: -- p_rec structure.
423: --
424: l_rec :=
425: ff_ffn_shd.convert_args
426: (null
427: ,p_business_group_id
428: ,p_legislation_code
429: ,p_class