eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CPT_INS dependencies on PAY_CPT_SHD

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

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_cpt_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_cpt_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from pay_ca_emp_prov_tax_info_f t
70: where t.emp_province_tax_inf_id = p_rec.emp_province_tax_inf_id
71: and t.effective_start_date =
72: pay_cpt_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_prov_tax_info_f.created_by%TYPE;

Line 129: pay_cpt_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_cpt_shd.g_api_dml := true; -- Set the api dml status
130: --
131: -- Insert the row into: pay_ca_emp_prov_tax_info_f
132: --
133: insert into pay_ca_emp_prov_tax_info_f

Line 276: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

272: l_last_update_login,
273: p_rec.ppip_exempt_flag
274: );
275: --
276: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
277: hr_utility.set_location(' Leaving:'||l_proc, 15);
278: --
279: Exception
280: When hr_api.check_integrity_violated Then

Line 282: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

278: --
279: Exception
280: When hr_api.check_integrity_violated Then
281: -- A check constraint has been violated
282: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
283: pay_cpt_shd.constraint_error
284: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
285: When hr_api.unique_integrity_violated Then
286: -- Unique integrity has been violated

Line 283: pay_cpt_shd.constraint_error

279: Exception
280: When hr_api.check_integrity_violated Then
281: -- A check constraint has been violated
282: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
283: pay_cpt_shd.constraint_error
284: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
285: When hr_api.unique_integrity_violated Then
286: -- Unique integrity has been violated
287: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

Line 287: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

283: pay_cpt_shd.constraint_error
284: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
285: When hr_api.unique_integrity_violated Then
286: -- Unique integrity has been violated
287: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
288: pay_cpt_shd.constraint_error
289: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
290: When Others Then
291: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

Line 288: pay_cpt_shd.constraint_error

284: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
285: When hr_api.unique_integrity_violated Then
286: -- Unique integrity has been violated
287: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
288: pay_cpt_shd.constraint_error
289: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
290: When Others Then
291: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
292: Raise;

Line 291: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

287: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
288: pay_cpt_shd.constraint_error
289: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
290: When Others Then
291: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
292: Raise;
293: End dt_insert_dml;
294: --
295: -- ----------------------------------------------------------------------------

Line 299: (p_rec in out nocopy pay_cpt_shd.g_rec_type,

295: -- ----------------------------------------------------------------------------
296: -- |------------------------------< insert_dml >------------------------------|
297: -- ----------------------------------------------------------------------------
298: Procedure insert_dml
299: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
300: p_effective_date in date,
301: p_datetrack_mode in varchar2,
302: p_validation_start_date in date,
303: p_validation_end_date in date) is

Line 359: (p_rec in out nocopy pay_cpt_shd.g_rec_type,

355: --
356: -- {End Of Comments}
357: -- ----------------------------------------------------------------------------
358: Procedure pre_insert
359: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
360: p_effective_date in date,
361: p_datetrack_mode in varchar2,
362: p_validation_start_date in date,
363: p_validation_end_date in date) is

Line 416: (p_rec in pay_cpt_shd.g_rec_type,

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

Line 559: p_rec in pay_cpt_shd.g_rec_type,

555: -- ----------------------------------------------------------------------------
556: Procedure ins_lck
557: (p_effective_date in date,
558: p_datetrack_mode in varchar2,
559: p_rec in pay_cpt_shd.g_rec_type,
560: p_validation_start_date out nocopy date,
561: p_validation_end_date out nocopy date) is
562: --
563: l_proc varchar2(72) := g_package||'ins_lck';

Line 600: p_rec in out nocopy pay_cpt_shd.g_rec_type,

596: -- |---------------------------------< ins >----------------------------------|
597: -- ----------------------------------------------------------------------------
598: Procedure ins
599: (
600: p_rec in out nocopy pay_cpt_shd.g_rec_type,
601: p_effective_date in date
602: ) is
603: --
604: l_proc varchar2(72) := g_package||'ins';

Line 732: l_rec pay_cpt_shd.g_rec_type;

728: p_effective_date in date,
729: p_ppip_exempt_flag in varchar2 default null
730: ) is
731: --
732: l_rec pay_cpt_shd.g_rec_type;
733: l_proc varchar2(72) := g_package||'ins';
734: l_effective_date date;
735: cursor c1(asg_id number) is
736: select max(effective_start_date)

Line 767: pay_cpt_shd.convert_args

763: */
764: l_effective_date := p_effective_date;
765:
766: l_rec :=
767: pay_cpt_shd.convert_args
768: (
769: null,
770: null,
771: null,