APPS.HXT_BATCH_PROCESS dependencies on FND_DATE

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

853: if g_debug then
854: hr_utility.set_location('convert_lookup',10);
855: end if;
856: HXT_UTIL.DEBUG('convert_lookup - code = '||p_lookup_code||'
857: type = '||p_lookup_type||' date = '||fnd_date.date_to_chardate(p_date_active));
858: IF p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL THEN
859: if g_debug then
860: hr_utility.set_location('convert_lookup',20);
861: end if;

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

908: if g_debug then
909: hr_utility.set_location('get_lookup_code',10);
910: end if;
911: HXT_UTIL.DEBUG('get_lookup_ code for meaning = '||p_meaning||'
912: type = '||'NAME_TRANSLATIONS'||' date = '||fnd_date.date_to_chardate(p_date_active));
913: if g_debug then
914: hr_utility.trace('p_meaning :'||p_meaning);
915: end if;
916: IF p_meaning IS NOT NULL THEN

Line 1033: 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

1029: hxt_value(i).name := null;
1030: hxt_value(i).lookup := null;
1031: END LOOP;
1032: -- Get input values details for this element
1033: 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
1034: pay_paywsqee_pkg.GET_INPUT_VALUE_DETAILS(p_values_rec.element_type_id,
1035: p_values_rec.date_worked,
1036: hxt_value(1).sequence,
1037: hxt_value(2).sequence,

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

1243: if g_debug then
1244: hr_utility.set_location('dtl_to_BEE',150);
1245: end if;
1246: -- pbl_value(i) := to_char(p_values_rec.date_worked,'DD-MON-YYYY');
1247: pbl_value(i) := fnd_date.date_to_canonical(p_values_rec.date_worked);
1248: lv_pbl_flag := 'Y';
1249: if g_debug then
1250: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));
1251: end if;

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

1516: , p_ref_num IN VARCHAR2
1517: , p_process_mode IN VARCHAR2
1518: , p_pay_retcode IN OUT NOCOPY NUMBER) IS
1519: CURSOR cur_sess_date IS
1520: SELECT fnd_date.date_to_chardate(end_date) end_date --SIR149 --FORMS60
1521: FROM per_time_periods
1522: WHERE time_period_id = g_time_period_id;
1523: l_req_id NUMBER;
1524: l_errbuf VARCHAR2(80);

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

1538: l_process_mode := p_process_mode;
1539: -- Get session date
1540: --begin SPR C166
1541: IF g_time_period_id IS NULL THEN
1542: l_session_date := fnd_date.date_to_chardate(SYSDATE); --SIR149 --FORMS60
1543: ELSE
1544: OPEN cur_sess_date;
1545: FETCH cur_sess_date INTO l_session_date;
1546: CLOSE cur_sess_date;