APPS.HXT_UTIL dependencies on HR_GENERAL

Line 99: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)

95: nvl(l_CREATED_BY,-1),
96: p_TYPE, p_PPB_id, p_TIM_id, p_HRW_ID, p_PTP_ID,
97: substr(p_ORA_MSG,1,119)
98: ,nvl(p_EFFECTIVE_START_DATE,sysdate)
99: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)
100: ,l_Person_ID
101: ,l_Payroll_ID
102: ); --FORMS60
103:

Line 120: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)); --FORMS60

116: FND_MESSAGE.GET||' '||nls_initcap(substr(p_error_msg,1,100)),
117: sysdate, 'ERROR', 999, 'NEW', 999, 999, 999, 999,
118: l_error
119: ,nvl(p_EFFECTIVE_START_DATE,sysdate)
120: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)); --FORMS60
121: FND_MESSAGE.CLEAR;
122: END;
123: END gen_error;
124: --

Line 197: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)

193: nvl(l_CREATED_BY,-1),
194: p_TYPE, p_TIM_id, p_HRW_ID, p_PTP_ID,
195: substr(p_ORA_MSG,1,119)
196: ,nvl(p_EFFECTIVE_START_DATE,sysdate)
197: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)
198: ,l_Person_ID
199: ,l_Payroll_ID
200: );
201: EXCEPTION

Line 216: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time));

212: FND_MESSAGE.GET||' '||nls_initcap(substr(p_error_msg,1,100)),
213: sysdate, 'ERROR', 999, 'NEW', 999, 999, 999,
214: l_error
215: ,nvl(p_EFFECTIVE_START_DATE,sysdate)
216: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time));
217: FND_MESSAGE.CLEAR;
218: END;
219: END gen_error;
220: --

Line 2197: nvl(l_eff_end,hr_general.end_of_time)

2193: p_HRW_ID,
2194: p_PTP_ID,
2195: substr(p_ORA_MSG,1,119),
2196: nvl(l_eff_start,sysdate),
2197: nvl(l_eff_end,hr_general.end_of_time)
2198: ,l_Person_ID /* ER230 */
2199: ,l_Payroll_ID /* ER230 */
2200: );
2201:

Line 2240: nvl(l_eff_end,hr_general.end_of_time)

2236: NULL,
2237: NULL,
2238: l_error,
2239: nvl(l_eff_start,sysdate),
2240: nvl(l_eff_end,hr_general.end_of_time)
2241: );
2242:
2243: END SET_TIMECARD_ERROR;
2244:

Line 2375: select DECODE (MOD (trunc(p_date)-trunc(hr_general.START_OF_TIME),7),

2371:
2372: FUNCTION get_week_day(p_date in Date ) RETURN varchar2 IS
2373:
2374: cursor weekday_cur(c_date Date) is
2375: select DECODE (MOD (trunc(p_date)-trunc(hr_general.START_OF_TIME),7),
2376: 0,'SAT',
2377: 1,'SUN',
2378: 2,'MON',
2379: 3,'TUE',

Line 2576: AND date_to=hr_general.end_of_time

2572: IS
2573: SELECT 'Y'
2574: FROM hxc_time_building_blocks
2575: WHERE resource_id = p_person_id
2576: AND date_to=hr_general.end_of_time
2577: AND ROWNUM<2;
2578:
2579: l_dummy VARCHAR2 (1);
2580: BEGIN