DBA Data[Home] [Help]

APPS.PAY_PBF_INS dependencies on PAY_PBF_SHD

Line 80: (p_rec in out nocopy pay_pbf_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_pbf_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: pay_pbf_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from pay_balance_feeds_f t
92: where t.balance_feed_id = p_rec.balance_feed_id
93: and t.effective_start_date =
94: pay_pbf_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 pay_balance_feeds_f.created_by%TYPE;

Line 152: pay_pbf_shd.g_api_dml := true; -- Set the api dml status

148: l_last_updated_by := fnd_global.user_id;
149: l_last_update_login := fnd_global.login_id;
150: End If;
151: --
152: pay_pbf_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pay_balance_feeds_f
155: --
156: insert into pay_balance_feeds_f

Line 191: pay_pbf_shd.g_api_dml := false; -- Unset the api dml status

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

Line 197: pay_pbf_shd.g_api_dml := false; -- Unset the api dml status

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

Line 198: pay_pbf_shd.constraint_error

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

Line 202: pay_pbf_shd.g_api_dml := false; -- Unset the api dml status

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

Line 203: pay_pbf_shd.constraint_error

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

Line 206: pay_pbf_shd.g_api_dml := false; -- Unset the api dml status

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

Line 262: (p_rec in out nocopy pay_pbf_shd.g_rec_type

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

Line 325: (p_rec in out nocopy pay_pbf_shd.g_rec_type

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

Line 417: (p_rec in pay_pbf_shd.g_rec_type

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

Line 517: ,p_rec in pay_pbf_shd.g_rec_type

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

Line 561: ,p_rec in out nocopy pay_pbf_shd.g_rec_type

557: -- ----------------------------------------------------------------------------
558: Procedure ins
559: (p_effective_date in date
560: ,p_initial_feed in boolean
561: ,p_rec in out nocopy pay_pbf_shd.g_rec_type
562: ,p_exist_run_result_warning out nocopy boolean
563: ) is
564: --
565: l_proc varchar2(72) := g_package||'ins';

Line 667: l_rec pay_pbf_shd.g_rec_type;

663: ,p_effective_end_date out nocopy date
664: ,p_exist_run_result_warning out nocopy boolean
665: ) is
666: --
667: l_rec pay_pbf_shd.g_rec_type;
668: l_proc varchar2(72) := g_package||'ins';
669: l_exist_run_result_warning boolean;
670: --
671: Begin

Line 678: pay_pbf_shd.convert_args

674: -- Call conversion function to turn arguments into the
675: -- p_rec structure.
676: --
677: l_rec :=
678: pay_pbf_shd.convert_args
679: (null
680: ,null
681: ,null
682: ,p_business_group_id