APPS.HXT_BATCH_PROCESS dependencies on FND_DATE

Line 1341: type = '||p_lookup_type||' date = '||fnd_date.date_to_chardate(p_date_active));

1337: if g_debug then
1338: hr_utility.set_location('convert_lookup',10);
1339: end if;
1340: HXT_UTIL.DEBUG('convert_lookup - code = '||p_lookup_code||'
1341: type = '||p_lookup_type||' date = '||fnd_date.date_to_chardate(p_date_active));
1342:
1343:
1344: -- Bug 8888777
1345: -- Need to do a conversion only if IV expected is in Display format.

Line 1403: type = '||'NAME_TRANSLATIONS'||' date = '||fnd_date.date_to_chardate(p_date_active));

1399: if g_debug then
1400: hr_utility.set_location('get_lookup_code',10);
1401: end if;
1402: HXT_UTIL.DEBUG('get_lookup_ code for meaning = '||p_meaning||'
1403: type = '||'NAME_TRANSLATIONS'||' date = '||fnd_date.date_to_chardate(p_date_active));
1404: if g_debug then
1405: hr_utility.trace('p_meaning :'||p_meaning);
1406: end if;
1407: IF p_meaning IS NOT NULL THEN

Line 1727: HXT_UTIL.DEBUG('Getting input values for element '||to_char(p_values_rec.element_type_id)||' date '||fnd_date.date_to_chardate(p_values_rec.date_worked)); --FORMS60 --HXT115

1723: CLOSE get_input_values;
1724: END IF;
1725:
1726: -- Get input values details for this element
1727: HXT_UTIL.DEBUG('Getting input values for element '||to_char(p_values_rec.element_type_id)||' date '||fnd_date.date_to_chardate(p_values_rec.date_worked)); --FORMS60 --HXT115
1728:
1729: -- Bug 12993528
1730: -- Replaced the pay_paywsqee_pkg call with our own new procedure.
1731: -- Added new params otl_sequence for each of the 15 input values.

Line 2019: pbl_value(i) := fnd_date.date_to_canonical(p_values_rec.date_worked);

2015: if g_debug then
2016: hr_utility.set_location('dtl_to_BEE',150);
2017: end if;
2018: -- pbl_value(i) := to_char(p_values_rec.date_worked,'DD-MON-YYYY');
2019: pbl_value(i) := fnd_date.date_to_canonical(p_values_rec.date_worked);
2020: lv_pbl_flag := 'Y';
2021: if g_debug then
2022: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));
2023: end if;

Line 2582: SELECT fnd_date.date_to_chardate(end_date) end_date --SIR149 --FORMS60

2578: , p_ref_num IN VARCHAR2
2579: , p_process_mode IN VARCHAR2
2580: , p_pay_retcode IN OUT NOCOPY NUMBER) IS
2581: CURSOR cur_sess_date IS
2582: SELECT fnd_date.date_to_chardate(end_date) end_date --SIR149 --FORMS60
2583: FROM per_time_periods
2584: WHERE time_period_id = g_time_period_id;
2585: l_req_id NUMBER;
2586: l_errbuf VARCHAR2(80);

Line 2604: l_session_date := fnd_date.date_to_chardate(SYSDATE); --SIR149 --FORMS60

2600: l_process_mode := p_process_mode;
2601: -- Get session date
2602: --begin SPR C166
2603: IF g_time_period_id IS NULL THEN
2604: l_session_date := fnd_date.date_to_chardate(SYSDATE); --SIR149 --FORMS60
2605: ELSE
2606: OPEN cur_sess_date;
2607: FETCH cur_sess_date INTO l_session_date;
2608: CLOSE cur_sess_date;