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 258: pay_cft_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 265: pay_cft_shd.constraint_error

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

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

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

Line 270: pay_cft_shd.constraint_error

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

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

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

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

277: -- ----------------------------------------------------------------------------
278: -- |------------------------------< insert_dml >------------------------------|
279: -- ----------------------------------------------------------------------------
280: Procedure insert_dml
281: (p_rec in out nocopy pay_cft_shd.g_rec_type,
282: p_effective_date in date,
283: p_datetrack_mode in varchar2,
284: p_validation_start_date in date,
285: p_validation_end_date in date) is

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

337: --
338: -- {End Of Comments}
339: -- ----------------------------------------------------------------------------
340: Procedure pre_insert
341: (p_rec in out nocopy pay_cft_shd.g_rec_type,
342: p_effective_date in date,
343: p_datetrack_mode in varchar2,
344: p_validation_start_date in date,
345: p_validation_end_date in date) is

Line 398: (p_rec in pay_cft_shd.g_rec_type,

394: --
395: -- {End Of Comments}
396: -- ----------------------------------------------------------------------------
397: Procedure post_insert
398: (p_rec in pay_cft_shd.g_rec_type,
399: p_effective_date in date,
400: p_datetrack_mode in varchar2,
401: p_validation_start_date in date,
402: p_validation_end_date in date) is

Line 532: p_rec in pay_cft_shd.g_rec_type,

528: -- ----------------------------------------------------------------------------
529: Procedure ins_lck
530: (p_effective_date in date,
531: p_datetrack_mode in varchar2,
532: p_rec in pay_cft_shd.g_rec_type,
533: p_validation_start_date out nocopy date,
534: p_validation_end_date out nocopy date) is
535: --
536: l_proc varchar2(72) := g_package||'ins_lck';

Line 573: p_rec in out nocopy pay_cft_shd.g_rec_type,

569: -- |---------------------------------< ins >----------------------------------|
570: -- ----------------------------------------------------------------------------
571: Procedure ins
572: (
573: p_rec in out nocopy pay_cft_shd.g_rec_type,
574: p_effective_date in date
575: ) is
576: --
577: l_proc varchar2(72) := g_package||'ins';

Line 698: l_rec pay_cft_shd.g_rec_type;

694: p_fed_lsf_amount in number default null,
695: p_effective_date in date
696: ) is
697: --
698: l_rec pay_cft_shd.g_rec_type;
699: l_proc varchar2(72) := g_package||'ins';
700: l_effective_date date;
701: --
702: cursor c1(asg_id number) is

Line 736: pay_cft_shd.convert_args

732: */
733: l_effective_date := p_effective_date;
734:
735: l_rec :=
736: pay_cft_shd.convert_args
737: (
738: null,
739: null,
740: null,