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_JP_YEA_BAL_ADJ_PKG dependencies on FND_DATE

Line 34: and fnd_date.canonical_to_date(p_effective_date)

30: cursor c_pay_formula is
31: select fnd_number.canonical_to_number(prl_information4)
32: from pay_all_payrolls_f
33: where payroll_id = fnd_number.canonical_to_number(p_payroll_id)
34: and fnd_date.canonical_to_date(p_effective_date)
35: between effective_start_date and effective_end_date;
36: --
37: cursor c_formula is
38: select fft.formula_name

Line 41: and fnd_date.canonical_to_date(p_effective_date)

37: cursor c_formula is
38: select fft.formula_name
39: from ff_formulas_f ff, ff_formulas_f_tl fft
40: where ff.formula_id = nvl(l_pay_formula_id, l_org_formula_id)
41: and fnd_date.canonical_to_date(p_effective_date)
42: between ff.effective_start_date and ff.effective_end_date
43: and fft.formula_id = ff.formula_id
44: and fft.language = userenv('LANG');
45: --

Line 130: l_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);

126: end if;
127: --
128: elsif l_inputs(i).datatype = 'DATE' and l_inputs(i).name = 'DATE_EARNED' then
129: --
130: l_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
131: --
132: end if;
133: --
134: end if;

Line 197: g_date_value(1) := fnd_date.canonical_to_date(l_outputs(i).value);

193: --
194: elsif l_outputs(i).datatype = 'DATE' then
195: --
196: if l_outputs(i).name = 'L_DATE1' then
197: g_date_value(1) := fnd_date.canonical_to_date(l_outputs(i).value);
198: elsif l_outputs(i).name = 'L_DATE2' then
199: g_date_value(2) := fnd_date.canonical_to_date(l_outputs(i).value);
200: elsif l_outputs(i).name = 'L_DATE3' then
201: g_date_value(3) := fnd_date.canonical_to_date(l_outputs(i).value);

Line 199: g_date_value(2) := fnd_date.canonical_to_date(l_outputs(i).value);

195: --
196: if l_outputs(i).name = 'L_DATE1' then
197: g_date_value(1) := fnd_date.canonical_to_date(l_outputs(i).value);
198: elsif l_outputs(i).name = 'L_DATE2' then
199: g_date_value(2) := fnd_date.canonical_to_date(l_outputs(i).value);
200: elsif l_outputs(i).name = 'L_DATE3' then
201: g_date_value(3) := fnd_date.canonical_to_date(l_outputs(i).value);
202: elsif l_outputs(i).name = 'L_DATE4' then
203: g_date_value(4) := fnd_date.canonical_to_date(l_outputs(i).value);

Line 201: g_date_value(3) := fnd_date.canonical_to_date(l_outputs(i).value);

197: g_date_value(1) := fnd_date.canonical_to_date(l_outputs(i).value);
198: elsif l_outputs(i).name = 'L_DATE2' then
199: g_date_value(2) := fnd_date.canonical_to_date(l_outputs(i).value);
200: elsif l_outputs(i).name = 'L_DATE3' then
201: g_date_value(3) := fnd_date.canonical_to_date(l_outputs(i).value);
202: elsif l_outputs(i).name = 'L_DATE4' then
203: g_date_value(4) := fnd_date.canonical_to_date(l_outputs(i).value);
204: elsif l_outputs(i).name = 'L_DATE5' then
205: g_date_value(5) := fnd_date.canonical_to_date(l_outputs(i).value);

Line 203: g_date_value(4) := fnd_date.canonical_to_date(l_outputs(i).value);

199: g_date_value(2) := fnd_date.canonical_to_date(l_outputs(i).value);
200: elsif l_outputs(i).name = 'L_DATE3' then
201: g_date_value(3) := fnd_date.canonical_to_date(l_outputs(i).value);
202: elsif l_outputs(i).name = 'L_DATE4' then
203: g_date_value(4) := fnd_date.canonical_to_date(l_outputs(i).value);
204: elsif l_outputs(i).name = 'L_DATE5' then
205: g_date_value(5) := fnd_date.canonical_to_date(l_outputs(i).value);
206: elsif l_outputs(i).name = 'L_DATE6' then
207: g_date_value(6) := fnd_date.canonical_to_date(l_outputs(i).value);

Line 205: g_date_value(5) := fnd_date.canonical_to_date(l_outputs(i).value);

201: g_date_value(3) := fnd_date.canonical_to_date(l_outputs(i).value);
202: elsif l_outputs(i).name = 'L_DATE4' then
203: g_date_value(4) := fnd_date.canonical_to_date(l_outputs(i).value);
204: elsif l_outputs(i).name = 'L_DATE5' then
205: g_date_value(5) := fnd_date.canonical_to_date(l_outputs(i).value);
206: elsif l_outputs(i).name = 'L_DATE6' then
207: g_date_value(6) := fnd_date.canonical_to_date(l_outputs(i).value);
208: elsif l_outputs(i).name = 'L_DATE7' then
209: g_date_value(7) := fnd_date.canonical_to_date(l_outputs(i).value);

Line 207: g_date_value(6) := fnd_date.canonical_to_date(l_outputs(i).value);

203: g_date_value(4) := fnd_date.canonical_to_date(l_outputs(i).value);
204: elsif l_outputs(i).name = 'L_DATE5' then
205: g_date_value(5) := fnd_date.canonical_to_date(l_outputs(i).value);
206: elsif l_outputs(i).name = 'L_DATE6' then
207: g_date_value(6) := fnd_date.canonical_to_date(l_outputs(i).value);
208: elsif l_outputs(i).name = 'L_DATE7' then
209: g_date_value(7) := fnd_date.canonical_to_date(l_outputs(i).value);
210: elsif l_outputs(i).name = 'L_DATE8' then
211: g_date_value(8) := fnd_date.canonical_to_date(l_outputs(i).value);

Line 209: g_date_value(7) := fnd_date.canonical_to_date(l_outputs(i).value);

205: g_date_value(5) := fnd_date.canonical_to_date(l_outputs(i).value);
206: elsif l_outputs(i).name = 'L_DATE6' then
207: g_date_value(6) := fnd_date.canonical_to_date(l_outputs(i).value);
208: elsif l_outputs(i).name = 'L_DATE7' then
209: g_date_value(7) := fnd_date.canonical_to_date(l_outputs(i).value);
210: elsif l_outputs(i).name = 'L_DATE8' then
211: g_date_value(8) := fnd_date.canonical_to_date(l_outputs(i).value);
212: elsif l_outputs(i).name = 'L_DATE9' then
213: g_date_value(9) := fnd_date.canonical_to_date(l_outputs(i).value);

Line 211: g_date_value(8) := fnd_date.canonical_to_date(l_outputs(i).value);

207: g_date_value(6) := fnd_date.canonical_to_date(l_outputs(i).value);
208: elsif l_outputs(i).name = 'L_DATE7' then
209: g_date_value(7) := fnd_date.canonical_to_date(l_outputs(i).value);
210: elsif l_outputs(i).name = 'L_DATE8' then
211: g_date_value(8) := fnd_date.canonical_to_date(l_outputs(i).value);
212: elsif l_outputs(i).name = 'L_DATE9' then
213: g_date_value(9) := fnd_date.canonical_to_date(l_outputs(i).value);
214: elsif l_outputs(i).name = 'L_DATE10' then
215: g_date_value(10) := fnd_date.canonical_to_date(l_outputs(i).value);

Line 213: g_date_value(9) := fnd_date.canonical_to_date(l_outputs(i).value);

209: g_date_value(7) := fnd_date.canonical_to_date(l_outputs(i).value);
210: elsif l_outputs(i).name = 'L_DATE8' then
211: g_date_value(8) := fnd_date.canonical_to_date(l_outputs(i).value);
212: elsif l_outputs(i).name = 'L_DATE9' then
213: g_date_value(9) := fnd_date.canonical_to_date(l_outputs(i).value);
214: elsif l_outputs(i).name = 'L_DATE10' then
215: g_date_value(10) := fnd_date.canonical_to_date(l_outputs(i).value);
216: end if;
217: --

Line 215: g_date_value(10) := fnd_date.canonical_to_date(l_outputs(i).value);

211: g_date_value(8) := fnd_date.canonical_to_date(l_outputs(i).value);
212: elsif l_outputs(i).name = 'L_DATE9' then
213: g_date_value(9) := fnd_date.canonical_to_date(l_outputs(i).value);
214: elsif l_outputs(i).name = 'L_DATE10' then
215: g_date_value(10) := fnd_date.canonical_to_date(l_outputs(i).value);
216: end if;
217: --
218: end if;
219: --