DBA Data[Home] [Help]

APPS.PAY_CFT_INS dependencies on PAY_CFT_SHD

Line 58: (p_rec in out nocopy pay_cft_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_cft_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is

Line 72: pay_cft_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from pay_ca_emp_fed_tax_info_f t
70: where t.emp_fed_tax_inf_id = p_rec.emp_fed_tax_inf_id
71: and t.effective_start_date =
72: pay_cft_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by pay_ca_emp_fed_tax_info_f.created_by%TYPE;

Line 129: pay_cft_shd.g_api_dml := true; -- Set the api dml status

125: l_last_updated_by := fnd_global.user_id;
126: l_last_update_login := fnd_global.login_id;
127: End If;
128: --
129: pay_cft_shd.g_api_dml := true; -- Set the api dml status
130: --
131: -- Insert the row into: pay_ca_emp_fed_tax_info_f
132: --
133: insert into pay_ca_emp_fed_tax_info_f

Line 262: pay_cft_shd.g_api_dml := false; -- Unset the api dml status

258: l_last_updated_by,
259: l_last_update_login
260: );
261: --
262: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
263: hr_utility.set_location(' Leaving:'||l_proc, 15);
264: --
265: Exception
266: When hr_api.check_integrity_violated Then

Line 268: pay_cft_shd.g_api_dml := false; -- Unset the api dml status

264: --
265: Exception
266: When hr_api.check_integrity_violated Then
267: -- A check constraint has been violated
268: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
269: pay_cft_shd.constraint_error
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated

Line 269: pay_cft_shd.constraint_error

265: Exception
266: When hr_api.check_integrity_violated Then
267: -- A check constraint has been violated
268: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
269: pay_cft_shd.constraint_error
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated
273: pay_cft_shd.g_api_dml := false; -- Unset the api dml status

Line 273: pay_cft_shd.g_api_dml := false; -- Unset the api dml status

269: pay_cft_shd.constraint_error
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated
273: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
274: pay_cft_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When Others Then
277: pay_cft_shd.g_api_dml := false; -- Unset the api dml status

Line 274: pay_cft_shd.constraint_error

270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated
273: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
274: pay_cft_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When Others Then
277: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
278: Raise;

Line 277: pay_cft_shd.g_api_dml := false; -- Unset the api dml status

273: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
274: pay_cft_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When Others Then
277: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
278: Raise;
279: End dt_insert_dml;
280: --
281: -- ----------------------------------------------------------------------------

Line 285: (p_rec in out nocopy pay_cft_shd.g_rec_type,

281: -- ----------------------------------------------------------------------------
282: -- |------------------------------< insert_dml >------------------------------|
283: -- ----------------------------------------------------------------------------
284: Procedure insert_dml
285: (p_rec in out nocopy pay_cft_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is

Line 345: (p_rec in out nocopy pay_cft_shd.g_rec_type,

341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure pre_insert
345: (p_rec in out nocopy pay_cft_shd.g_rec_type,
346: p_effective_date in date,
347: p_datetrack_mode in varchar2,
348: p_validation_start_date in date,
349: p_validation_end_date in date) is

Line 402: (p_rec in pay_cft_shd.g_rec_type,

398: --
399: -- {End Of Comments}
400: -- ----------------------------------------------------------------------------
401: Procedure post_insert
402: (p_rec in pay_cft_shd.g_rec_type,
403: p_effective_date in date,
404: p_datetrack_mode in varchar2,
405: p_validation_start_date in date,
406: p_validation_end_date in date) is

Line 538: p_rec in pay_cft_shd.g_rec_type,

534: -- ----------------------------------------------------------------------------
535: Procedure ins_lck
536: (p_effective_date in date,
537: p_datetrack_mode in varchar2,
538: p_rec in pay_cft_shd.g_rec_type,
539: p_validation_start_date out nocopy date,
540: p_validation_end_date out nocopy date) is
541: --
542: l_proc varchar2(72) := g_package||'ins_lck';

Line 579: p_rec in out nocopy pay_cft_shd.g_rec_type,

575: -- |---------------------------------< ins >----------------------------------|
576: -- ----------------------------------------------------------------------------
577: Procedure ins
578: (
579: p_rec in out nocopy pay_cft_shd.g_rec_type,
580: p_effective_date in date
581: ) is
582: --
583: l_proc varchar2(72) := g_package||'ins';

Line 706: l_rec pay_cft_shd.g_rec_type;

702: p_cpp_revocation_date in date, --For Bug Number 13258136
703: p_effective_date in date
704: ) is
705: --
706: l_rec pay_cft_shd.g_rec_type;
707: l_proc varchar2(72) := g_package||'ins';
708: l_effective_date date;
709: --
710: cursor c1(asg_id number) is

Line 744: pay_cft_shd.convert_args

740: */
741: l_effective_date := p_effective_date;
742:
743: l_rec :=
744: pay_cft_shd.convert_args
745: (
746: null,
747: null,
748: null,