DBA Data[Home] [Help]

APPS.FF_FGL_INS dependencies on FF_FGL_SHD

Line 80: (p_rec in out nocopy ff_fgl_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ff_fgl_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date

Line 94: ff_fgl_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from ff_globals_f t
92: where t.global_id = p_rec.global_id
93: and t.effective_start_date =
94: ff_fgl_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by ff_globals_f.created_by%TYPE;

Line 154: ff_fgl_shd.g_api_dml := true; -- Set the api dml status

150: Else
151: p_rec.object_version_number := 1; -- Initialise the object version
152: End If;
153: --
154: ff_fgl_shd.g_api_dml := true; -- Set the api dml status
155: --
156: -- Insert the row into: ff_globals_f
157: --
158: insert into ff_globals_f

Line 193: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

189: ,l_last_updated_by
190: ,l_last_update_login
191: );
192: --
193: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
194: hr_utility.set_location(' Leaving:'||l_proc, 15);
195: --
196: Exception
197: When hr_api.check_integrity_violated Then

Line 199: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

195: --
196: Exception
197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
199: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
200: ff_fgl_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated

Line 200: ff_fgl_shd.constraint_error

196: Exception
197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
199: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
200: ff_fgl_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

Line 204: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

200: ff_fgl_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
205: ff_fgl_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

Line 205: ff_fgl_shd.constraint_error

201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
205: ff_fgl_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
209: Raise;

Line 208: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

204: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
205: ff_fgl_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
209: Raise;
210: End dt_insert_dml;
211: --
212: -- ----------------------------------------------------------------------------

Line 264: (p_rec in out nocopy ff_fgl_shd.g_rec_type

260: -- ----------------------------------------------------------------------------
261: -- |------------------------------< insert_dml >------------------------------|
262: -- ----------------------------------------------------------------------------
263: Procedure insert_dml
264: (p_rec in out nocopy ff_fgl_shd.g_rec_type
265: ,p_effective_date in date
266: ,p_datetrack_mode in varchar2
267: ,p_validation_start_date in date
268: ,p_validation_end_date in date

Line 327: (p_rec in out nocopy ff_fgl_shd.g_rec_type

323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure pre_insert
327: (p_rec in out nocopy ff_fgl_shd.g_rec_type
328: ,p_effective_date in date
329: ,p_datetrack_mode in varchar2
330: ,p_validation_start_date in date
331: ,p_validation_end_date in date

Line 419: (p_rec in ff_fgl_shd.g_rec_type

415: --
416: -- {End Of Comments}
417: -- ----------------------------------------------------------------------------
418: Procedure post_insert
419: (p_rec in ff_fgl_shd.g_rec_type
420: ,p_effective_date in date
421: ,p_datetrack_mode in varchar2
422: ,p_validation_start_date in date
423: ,p_validation_end_date in date

Line 519: ,p_rec in ff_fgl_shd.g_rec_type

515: -- ----------------------------------------------------------------------------
516: Procedure ins_lck
517: (p_effective_date in date
518: ,p_datetrack_mode in varchar2
519: ,p_rec in ff_fgl_shd.g_rec_type
520: ,p_validation_start_date out nocopy date
521: ,p_validation_end_date out nocopy date
522: ) is
523: --

Line 559: ,p_rec in out nocopy ff_fgl_shd.g_rec_type

555: -- |---------------------------------< ins >----------------------------------|
556: -- ----------------------------------------------------------------------------
557: Procedure ins
558: (p_effective_date in date
559: ,p_rec in out nocopy ff_fgl_shd.g_rec_type
560: ) is
561: --
562: l_proc varchar2(72) := g_package||'ins';
563: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 646: l_rec ff_fgl_shd.g_rec_type;

642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
644: ) is
645: --
646: l_rec ff_fgl_shd.g_rec_type;
647: l_proc varchar2(72) := g_package||'ins';
648: --
649: Begin
650: hr_utility.set_location('Entering:'||l_proc, 5);

Line 656: ff_fgl_shd.convert_args

652: -- Call conversion function to turn arguments into the
653: -- p_rec structure.
654: --
655: l_rec :=
656: ff_fgl_shd.convert_args
657: (null
658: ,null
659: ,null
660: ,p_business_group_id