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 118: ,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)); --FORMS60

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

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

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

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

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

Line 2116: nvl(l_eff_end,hr_general.end_of_time)

2112: p_HRW_ID,
2113: p_PTP_ID,
2114: substr(p_ORA_MSG,1,119),
2115: nvl(l_eff_start,sysdate),
2116: nvl(l_eff_end,hr_general.end_of_time)
2117: ,l_Person_ID /* ER230 */
2118: ,l_Payroll_ID /* ER230 */
2119: );
2120: END IF;

Line 2158: nvl(l_eff_end,hr_general.end_of_time)

2154: NULL,
2155: NULL,
2156: l_error,
2157: nvl(l_eff_start,sysdate),
2158: nvl(l_eff_end,hr_general.end_of_time)
2159: );
2160:
2161: END SET_TIMECARD_ERROR;
2162:

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

2289:
2290: FUNCTION get_week_day(p_date in Date ) RETURN varchar2 IS
2291:
2292: cursor weekday_cur(c_date Date) is
2293: select DECODE (MOD (trunc(p_date)-trunc(hr_general.START_OF_TIME),7),
2294: 0,'SAT',
2295: 1,'SUN',
2296: 2,'MON',
2297: 3,'TUE',

Line 2386: AND date_to=hr_general.end_of_time

2382: IS
2383: SELECT 'Y'
2384: FROM hxc_time_building_blocks
2385: WHERE resource_id = p_person_id
2386: AND date_to=hr_general.end_of_time
2387: AND ROWNUM<2;
2388:
2389: l_dummy VARCHAR2 (1);
2390: BEGIN