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_STA_INS dependencies on PAY_STA_SHD

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

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

68: t.creation_date
69: from pay_us_emp_state_tax_rules_f t
70: where t.emp_state_tax_rule_id = p_rec.emp_state_tax_rule_id
71: and t.effective_start_date =
72: pay_sta_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_us_emp_state_tax_rules_f.created_by%TYPE;

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

Line 324: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

320: p_rec.sta_information29,
321: p_rec.sta_information30
322: );
323: --
324: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
325: hr_utility.set_location(' Leaving:'||l_proc, 15);
326: --
327: Exception
328: When hr_api.check_integrity_violated Then

Line 330: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

326: --
327: Exception
328: When hr_api.check_integrity_violated Then
329: -- A check constraint has been violated
330: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
331: pay_sta_shd.constraint_error
332: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
333: When hr_api.unique_integrity_violated Then
334: -- Unique integrity has been violated

Line 331: pay_sta_shd.constraint_error

327: Exception
328: When hr_api.check_integrity_violated Then
329: -- A check constraint has been violated
330: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
331: pay_sta_shd.constraint_error
332: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
333: When hr_api.unique_integrity_violated Then
334: -- Unique integrity has been violated
335: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

Line 335: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

331: pay_sta_shd.constraint_error
332: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
333: When hr_api.unique_integrity_violated Then
334: -- Unique integrity has been violated
335: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
336: pay_sta_shd.constraint_error
337: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
338: When Others Then
339: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

Line 336: pay_sta_shd.constraint_error

332: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
333: When hr_api.unique_integrity_violated Then
334: -- Unique integrity has been violated
335: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
336: pay_sta_shd.constraint_error
337: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
338: When Others Then
339: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
340: Raise;

Line 339: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

335: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
336: pay_sta_shd.constraint_error
337: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
338: When Others Then
339: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
340: Raise;
341: End dt_insert_dml;
342: --
343: -- ----------------------------------------------------------------------------

Line 347: (p_rec in out nocopy pay_sta_shd.g_rec_type,

343: -- ----------------------------------------------------------------------------
344: -- |------------------------------< insert_dml >------------------------------|
345: -- ----------------------------------------------------------------------------
346: Procedure insert_dml
347: (p_rec in out nocopy pay_sta_shd.g_rec_type,
348: p_effective_date in date,
349: p_datetrack_mode in varchar2,
350: p_validation_start_date in date,
351: p_validation_end_date in date) is

Line 407: (p_rec in out nocopy pay_sta_shd.g_rec_type,

403: --
404: -- {End Of Comments}
405: -- ----------------------------------------------------------------------------
406: Procedure pre_insert
407: (p_rec in out nocopy pay_sta_shd.g_rec_type,
408: p_effective_date in date,
409: p_datetrack_mode in varchar2,
410: p_validation_start_date in date,
411: p_validation_end_date in date) is

Line 464: (p_rec in pay_sta_shd.g_rec_type,

460: --
461: -- {End Of Comments}
462: -- ----------------------------------------------------------------------------
463: Procedure post_insert
464: (p_rec in pay_sta_shd.g_rec_type,
465: p_effective_date in date,
466: p_datetrack_mode in varchar2,
467: p_validation_start_date in date,
468: p_validation_end_date in date) is

Line 572: p_rec in pay_sta_shd.g_rec_type,

568: -- ----------------------------------------------------------------------------
569: Procedure ins_lck
570: (p_effective_date in date,
571: p_datetrack_mode in varchar2,
572: p_rec in pay_sta_shd.g_rec_type,
573: p_validation_start_date out nocopy date,
574: p_validation_end_date out nocopy date) is
575: --
576: l_proc varchar2(72) := g_package||'ins_lck';

Line 613: p_rec in out nocopy pay_sta_shd.g_rec_type,

609: -- |---------------------------------< ins >----------------------------------|
610: -- ----------------------------------------------------------------------------
611: Procedure ins
612: (
613: p_rec in out nocopy pay_sta_shd.g_rec_type,
614: p_effective_date in date
615: ) is
616: --
617: l_proc varchar2(72) := g_package||'ins';

Line 767: l_rec pay_sta_shd.g_rec_type;

763: p_sta_information29 in varchar2 default null,
764: p_sta_information30 in varchar2 default null
765: ) is
766: --
767: l_rec pay_sta_shd.g_rec_type;
768: l_proc varchar2(72) := g_package||'ins';
769: --
770: Begin
771: hr_utility.set_location('Entering:'||l_proc, 5);

Line 777: pay_sta_shd.convert_args

773: -- Call conversion function to turn arguments into the
774: -- p_rec structure.
775: --
776: l_rec :=
777: pay_sta_shd.convert_args
778: (
779: null,
780: null,
781: null,