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.BEN_PRC_SHD dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 39: If (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_DT6') Then

35: --
36: Begin
37: hr_utility.set_location('Entering:'||l_proc, 5);
38: --
39: If (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_DT6') Then
40: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('STEP','5');
43: fnd_message.raise_error;

Line 44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then

40: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('STEP','5');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.set_token('PROCEDURE', l_proc);
47: fnd_message.set_token('STEP','10');
48: fnd_message.raise_error;

Line 49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then

45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.set_token('PROCEDURE', l_proc);
47: fnd_message.set_token('STEP','10');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.set_token('PROCEDURE', l_proc);
52: fnd_message.set_token('STEP','15');
53: fnd_message.raise_error;

Line 54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then

50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.set_token('PROCEDURE', l_proc);
52: fnd_message.set_token('STEP','15');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('STEP','20');
58: fnd_message.raise_error;

Line 157: from ben_prtt_reimbmt_rqst_f

153: ttl_rqst_amt ,
154: aprvd_for_pymt_amt ,
155: null,
156: exp_incurd_dt
157: from ben_prtt_reimbmt_rqst_f
158: where prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
159: and p_effective_date
160: between effective_start_date and effective_end_date;
161: --

Line 230: from ben_prtt_reimbmt_rqst_f t

226: l_parent_key_value1 number;
227: --
228: Cursor C_Sel1 Is
229: select t.pl_id
230: from ben_prtt_reimbmt_rqst_f t
231: where t.prtt_reimbmt_rqst_id = p_base_key_value
232: and p_effective_date
233: between t.effective_start_date and t.effective_end_date;
234: --

Line 252: p_base_table_name => 'ben_prtt_reimbmt_rqst_f',

248: -- Call the corresponding datetrack api
249: --
250: dt_api.find_dt_del_modes
251: (p_effective_date => p_effective_date,
252: p_base_table_name => 'ben_prtt_reimbmt_rqst_f',
253: p_base_key_column => 'prtt_reimbmt_rqst_id',
254: p_base_key_value => p_base_key_value,
255: p_parent_table_name1 => 'ben_pl_f',
256: p_parent_key_column1 => 'pl_id',

Line 286: p_base_table_name => 'ben_prtt_reimbmt_rqst_f',

282: -- Call the corresponding datetrack api
283: --
284: dt_api.find_dt_upd_modes
285: (p_effective_date => p_effective_date,
286: p_base_table_name => 'ben_prtt_reimbmt_rqst_f',
287: p_base_key_column => 'prtt_reimbmt_rqst_id',
288: p_base_key_value => p_base_key_value,
289: p_correction => p_correction,
290: p_update => p_update,

Line 319: (p_base_table_name => 'ben_prtt_reimbmt_rqst_f',

315: -- version number.
316: --
317: l_object_version_number :=
318: dt_api.get_object_version_number
319: (p_base_table_name => 'ben_prtt_reimbmt_rqst_f',
320: p_base_key_column => 'prtt_reimbmt_rqst_id',
321: p_base_key_value => p_base_key_value);
322: --
323: hr_utility.set_location(l_proc, 10);

Line 329: update ben_prtt_reimbmt_rqst_f t

325: --
326: -- Update the specified datetrack row setting the effective
327: -- end date to the specified new effective end date.
328: --
329: update ben_prtt_reimbmt_rqst_f t
330: set t.effective_end_date = p_new_effective_end_date,
331: t.object_version_number = l_object_version_number
332: where t.prtt_reimbmt_rqst_id = p_base_key_value
333: and p_effective_date

Line 442: from ben_prtt_reimbmt_rqst_f

438: ttl_rqst_amt ,
439: aprvd_for_pymt_amt ,
440: null ,
441: exp_incurd_dt
442: from ben_prtt_reimbmt_rqst_f
443: where prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
444: and p_effective_date
445: between effective_start_date and effective_end_date
446: for update nowait;

Line 503: p_base_table_name => 'ben_prtt_reimbmt_rqst_f',

499: --
500: dt_api.validate_dt_mode
501: (p_effective_date => p_effective_date,
502: p_datetrack_mode => p_datetrack_mode,
503: p_base_table_name => 'ben_prtt_reimbmt_rqst_f',
504: p_base_key_column => 'prtt_reimbmt_rqst_id',
505: p_base_key_value => p_prtt_reimbmt_rqst_id,
506: p_parent_table_name1 => 'ben_pl_f',
507: p_parent_key_column1 => 'pl_id',

Line 540: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');

536: -- The object is locked therefore we need to supply a meaningful
537: -- error message.
538: --
539: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
540: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');
541: fnd_message.raise_error;
542: When l_object_invalid then
543: --
544: -- The object doesn't exist or is invalid

Line 547: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');

543: --
544: -- The object doesn't exist or is invalid
545: --
546: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
547: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');
548: fnd_message.raise_error;
549: End lck;
550: --
551: -- ----------------------------------------------------------------------------