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_PPR_INS dependencies on PAY_PPR_SHD

Line 80: (p_rec in out nocopy pay_ppr_shd.g_rec_type

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

90: t.creation_date
91: from pay_status_processing_rules_f t
92: where t.status_processing_rule_id = p_rec.status_processing_rule_id
93: and t.effective_start_date =
94: pay_ppr_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_status_processing_rules_f.created_by%TYPE;

Line 154: pay_ppr_shd.g_api_dml := true; -- Set the api dml status

150: Else
151: p_rec.object_version_number := 1; -- Initialise the object version
152: End If;
153: --
154: pay_ppr_shd.g_api_dml := true; -- Set the api dml status
155: --
156: -- Insert the row into: pay_status_processing_rules_f
157: --
158: insert into pay_status_processing_rules_f

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

193: ,l_last_updated_by
194: ,l_last_update_login
195: );
196: --
197: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
198: hr_utility.set_location(' Leaving:'||l_proc, 15);
199: --
200: Exception
201: When hr_api.check_integrity_violated Then

Line 203: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 204: pay_ppr_shd.constraint_error

200: Exception
201: When hr_api.check_integrity_violated Then
202: -- A check constraint has been violated
203: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
204: pay_ppr_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status

Line 208: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status

204: pay_ppr_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
209: pay_ppr_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status

Line 209: pay_ppr_shd.constraint_error

205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
209: pay_ppr_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
213: Raise;

Line 212: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status

208: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
209: pay_ppr_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
213: Raise;
214: End dt_insert_dml;
215: --
216: -- ----------------------------------------------------------------------------

Line 268: (p_rec in out nocopy pay_ppr_shd.g_rec_type

264: -- ----------------------------------------------------------------------------
265: -- |------------------------------< insert_dml >------------------------------|
266: -- ----------------------------------------------------------------------------
267: Procedure insert_dml
268: (p_rec in out nocopy pay_ppr_shd.g_rec_type
269: ,p_effective_date in date
270: ,p_datetrack_mode in varchar2
271: ,p_validation_start_date in date
272: ,p_validation_end_date in date

Line 331: (p_rec in out nocopy pay_ppr_shd.g_rec_type

327: --
328: -- {End Of Comments}
329: -- ----------------------------------------------------------------------------
330: Procedure pre_insert
331: (p_rec in out nocopy pay_ppr_shd.g_rec_type
332: ,p_effective_date in date
333: ,p_datetrack_mode in varchar2
334: ,p_validation_start_date in date
335: ,p_validation_end_date in date

Line 435: (p_rec in pay_ppr_shd.g_rec_type

431: --
432: -- {End Of Comments}
433: -- ----------------------------------------------------------------------------
434: Procedure post_insert
435: (p_rec in pay_ppr_shd.g_rec_type
436: ,p_effective_date in date
437: ,p_datetrack_mode in varchar2
438: ,p_validation_start_date in date
439: ,p_validation_end_date in date

Line 526: ,p_rec in pay_ppr_shd.g_rec_type

522: -- ----------------------------------------------------------------------------
523: Procedure ins_lck
524: (p_effective_date in date
525: ,p_datetrack_mode in varchar2
526: ,p_rec in pay_ppr_shd.g_rec_type
527: ,p_validation_start_date out nocopy date
528: ,p_validation_end_date out nocopy date
529: ) is
530: --

Line 566: ,p_rec in out nocopy pay_ppr_shd.g_rec_type

562: -- |---------------------------------< ins >----------------------------------|
563: -- ----------------------------------------------------------------------------
564: Procedure ins
565: (p_effective_date in date
566: ,p_rec in out nocopy pay_ppr_shd.g_rec_type
567: ,p_formula_mismatch_warning out nocopy boolean
568: ) is
569: --
570: l_proc varchar2(72) := g_package||'ins';

Line 682: l_rec pay_ppr_shd.g_rec_type;

678: ,p_comment_id out nocopy number
679: ,p_formula_mismatch_warning out nocopy boolean
680: ) is
681: --
682: l_rec pay_ppr_shd.g_rec_type;
683: l_proc varchar2(72) := g_package||'ins';
684: l_formula_mismatch_warning boolean;
685: --
686: Begin

Line 693: pay_ppr_shd.convert_args

689: -- Call conversion function to turn arguments into the
690: -- p_rec structure.
691: --
692: l_rec :=
693: pay_ppr_shd.convert_args
694: (null
695: ,null
696: ,null
697: ,p_business_group_id