DBA Data[Home] [Help]

APPS.PAY_JP_LTAX_EFILE_PKG dependencies on FND_DATE

Line 210: g_parameter.effective_date_from := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_FROM'));

206: select effective_date
207: into g_parameter.effective_date
208: from fnd_sessions
209: where session_id = userenv('sessionid');
210: g_parameter.effective_date_from := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_FROM'));
211: g_parameter.effective_date_to := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_TO'));
212: g_parameter.organization_id := fnd_number.canonical_to_number(pay_jp_mag_utility_pkg.get_parameter('ORGANIZATION_ID'));
213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));

Line 211: g_parameter.effective_date_to := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_TO'));

207: into g_parameter.effective_date
208: from fnd_sessions
209: where session_id = userenv('sessionid');
210: g_parameter.effective_date_from := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_FROM'));
211: g_parameter.effective_date_to := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_TO'));
212: g_parameter.organization_id := fnd_number.canonical_to_number(pay_jp_mag_utility_pkg.get_parameter('ORGANIZATION_ID'));
213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));

Line 214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));

210: g_parameter.effective_date_from := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_FROM'));
211: g_parameter.effective_date_to := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_TO'));
212: g_parameter.organization_id := fnd_number.canonical_to_number(pay_jp_mag_utility_pkg.get_parameter('ORGANIZATION_ID'));
213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));

Line 215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));

211: g_parameter.effective_date_to := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_TO'));
212: g_parameter.organization_id := fnd_number.canonical_to_number(pay_jp_mag_utility_pkg.get_parameter('ORGANIZATION_ID'));
213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));
219: hr_utility.set_location(l_proc, 20);

Line 216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));

212: g_parameter.organization_id := fnd_number.canonical_to_number(pay_jp_mag_utility_pkg.get_parameter('ORGANIZATION_ID'));
213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));
219: hr_utility.set_location(l_proc, 20);
220: --