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_CAL_INS dependencies on PAY_CAL_SHD

Line 80: (p_rec in out nocopy pay_cal_shd.g_rec_type

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

90: t.creation_date
91: from pay_cost_allocations_f t
92: where t.cost_allocation_id = p_rec.cost_allocation_id
93: and t.effective_start_date =
94: pay_cal_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_cost_allocations_f.created_by%TYPE;

Line 154: pay_cal_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_cal_shd.g_api_dml := true; -- Set the api dml status
155: --
156: -- Insert the row into: pay_cost_allocations_f
157: --
158: insert into pay_cost_allocations_f

Line 198: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

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

Line 204: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

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

Line 205: pay_cal_shd.constraint_error

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

Line 209: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

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

Line 210: pay_cal_shd.constraint_error

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

Line 213: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

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

Line 221: (p_rec in out nocopy pay_cal_shd.g_rec_type

217: -- ----------------------------------------------------------------------------
218: -- |------------------------------< insert_dml >------------------------------|
219: -- ----------------------------------------------------------------------------
220: Procedure insert_dml
221: (p_rec in out nocopy pay_cal_shd.g_rec_type
222: ,p_effective_date in date
223: ,p_datetrack_mode in varchar2
224: ,p_validation_start_date in date
225: ,p_validation_end_date in date

Line 284: (p_rec in out nocopy pay_cal_shd.g_rec_type

280: --
281: -- {End Of Comments}
282: -- ----------------------------------------------------------------------------
283: Procedure pre_insert
284: (p_rec in out nocopy pay_cal_shd.g_rec_type
285: ,p_effective_date in date
286: ,p_datetrack_mode in varchar2
287: ,p_validation_start_date in date
288: ,p_validation_end_date in date

Line 377: (p_rec in pay_cal_shd.g_rec_type

373: -- {End Of Comments}
374: -- ----------------------------------------------------------------------------
375: -- ----------------------------------------------------------------------------
376: Procedure post_insert
377: (p_rec in pay_cal_shd.g_rec_type
378: ,p_effective_date in date
379: ,p_datetrack_mode in varchar2
380: ,p_validation_start_date in date
381: ,p_validation_end_date in date

Line 475: ,p_rec in pay_cal_shd.g_rec_type

471: -- ----------------------------------------------------------------------------
472: Procedure ins_lck
473: (p_effective_date in date
474: ,p_datetrack_mode in varchar2
475: ,p_rec in pay_cal_shd.g_rec_type
476: ,p_validation_start_date out nocopy date
477: ,p_validation_end_date out nocopy date
478: ) is
479: --

Line 515: ,p_rec in out nocopy pay_cal_shd.g_rec_type

511: -- |---------------------------------< ins >----------------------------------|
512: -- ----------------------------------------------------------------------------
513: Procedure ins
514: (p_effective_date in date
515: ,p_rec in out nocopy pay_cal_shd.g_rec_type
516: ) is
517: --
518: l_proc varchar2(72) := g_package||'ins';
519: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 604: l_rec pay_cal_shd.g_rec_type;

600: ,p_effective_start_date out nocopy date
601: ,p_effective_end_date out nocopy date
602: ) is
603: --
604: l_rec pay_cal_shd.g_rec_type;
605: l_proc varchar2(72) := g_package||'ins';
606: --
607: Begin
608: hr_utility.set_location('Entering:'||l_proc, 5);

Line 614: pay_cal_shd.convert_args

610: -- Call conversion function to turn arguments into the
611: -- p_rec structure.
612: --
613: l_rec :=
614: pay_cal_shd.convert_args
615: (null
616: ,null
617: ,null
618: ,p_business_group_id