eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SA_HIJRAH_FUNCTIONS dependencies on HR_SA_HIJRAH_FUNCTIONS

Line 1: package body hr_sa_hijrah_functions as

1: package body hr_sa_hijrah_functions as
2: /* $Header: pesahjdt.pkb 120.0.12010000.2 2008/08/06 09:37:10 ubhat ship $ */
3:
4: function hijrah_to_gregorian
5: (p_input_date in varchar2)

Line 31: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);

27: -- hr_utility.trace_on(null,'SADTCNV');
28: hr_utility.set_location('In side hijrah_to_gregorian',1);
29: hr_utility.set_location('p_input_date '|| p_input_date,1);
30: if p_input_date is not null then
31: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
32: /*l_hij_year := to_number(substr(l_input_date,1,4)) - 1;
33: l_hij_month := to_number(substr(l_input_date,6,2)) - 1;
34: l_hij_day := to_number(substr(l_input_date,9,2)) ;*/
35: l_hij_year := to_number(substr(l_input_date,1,4)) ;

Line 159: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);

155: l_new_greg_date date;
156: l_new_hij_date varchar2(10);
157: l_input_date varchar2(10);
158: begin
159: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
160: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
161: l_new_greg_date := l_greg_date + p_num;
162: l_new_hij_date := hr_sa_hijrah_functions.gregorian_to_hijrah(l_new_greg_date);
163: return (l_new_hij_date);

Line 160: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');

156: l_new_hij_date varchar2(10);
157: l_input_date varchar2(10);
158: begin
159: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
160: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
161: l_new_greg_date := l_greg_date + p_num;
162: l_new_hij_date := hr_sa_hijrah_functions.gregorian_to_hijrah(l_new_greg_date);
163: return (l_new_hij_date);
164: end add_days;

Line 162: l_new_hij_date := hr_sa_hijrah_functions.gregorian_to_hijrah(l_new_greg_date);

158: begin
159: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
160: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
161: l_new_greg_date := l_greg_date + p_num;
162: l_new_hij_date := hr_sa_hijrah_functions.gregorian_to_hijrah(l_new_greg_date);
163: return (l_new_hij_date);
164: end add_days;
165:
166: function days_between

Line 176: hr_sa_hijrah_functions.validate_date(p_high_date,l_high_date);

172: l_diff number;
173: l_high_date varchar2(10);
174: l_low_date varchar2(10);
175: begin
176: hr_sa_hijrah_functions.validate_date(p_high_date,l_high_date);
177: hr_sa_hijrah_functions.validate_date(p_low_date,l_low_date);
178: l_high_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_high_date),'YYYY/MM/DD');
179: l_low_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_low_date),'YYYY/MM/DD');
180: l_diff := l_high_greg_date - l_low_greg_date;

Line 177: hr_sa_hijrah_functions.validate_date(p_low_date,l_low_date);

173: l_high_date varchar2(10);
174: l_low_date varchar2(10);
175: begin
176: hr_sa_hijrah_functions.validate_date(p_high_date,l_high_date);
177: hr_sa_hijrah_functions.validate_date(p_low_date,l_low_date);
178: l_high_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_high_date),'YYYY/MM/DD');
179: l_low_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_low_date),'YYYY/MM/DD');
180: l_diff := l_high_greg_date - l_low_greg_date;
181: return(l_diff);

Line 178: l_high_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_high_date),'YYYY/MM/DD');

174: l_low_date varchar2(10);
175: begin
176: hr_sa_hijrah_functions.validate_date(p_high_date,l_high_date);
177: hr_sa_hijrah_functions.validate_date(p_low_date,l_low_date);
178: l_high_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_high_date),'YYYY/MM/DD');
179: l_low_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_low_date),'YYYY/MM/DD');
180: l_diff := l_high_greg_date - l_low_greg_date;
181: return(l_diff);
182: end days_between;

Line 179: l_low_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_low_date),'YYYY/MM/DD');

175: begin
176: hr_sa_hijrah_functions.validate_date(p_high_date,l_high_date);
177: hr_sa_hijrah_functions.validate_date(p_low_date,l_low_date);
178: l_high_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_high_date),'YYYY/MM/DD');
179: l_low_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_low_date),'YYYY/MM/DD');
180: l_diff := l_high_greg_date - l_low_greg_date;
181: return(l_diff);
182: end days_between;
183:

Line 191: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);

187: l_day varchar2(30);
188: l_greg_date date;
189: l_input_date varchar2(10);
190: begin
191: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
192: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
193: select ltrim(rtrim(to_char(l_greg_date,'D')))
194: into l_day
195: from dual;

Line 192: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');

188: l_greg_date date;
189: l_input_date varchar2(10);
190: begin
191: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
192: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
193: select ltrim(rtrim(to_char(l_greg_date,'D')))
194: into l_day
195: from dual;
196: return(hr_general.decode_lookup('SA_HIJRAH_DAYS',l_day));

Line 206: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);

202: l_month number;
203: l_greg_date date;
204: l_input_date varchar2(10);
205: begin
206: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
207: l_month := to_number(substr(l_input_date,6,2));
208: return(hr_general.decode_lookup('SA_HIJRAH_MONTHS',l_month));
209: end get_month;
210:

Line 218: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);

214: l_day varchar2(10);
215: l_greg_date date;
216: l_input_date varchar2(10);
217: begin
218: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
219: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
220: select ltrim(rtrim(to_char(l_greg_date,'D')))
221: into l_day
222: from dual;

Line 219: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');

215: l_greg_date date;
216: l_input_date varchar2(10);
217: begin
218: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
219: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
220: select ltrim(rtrim(to_char(l_greg_date,'D')))
221: into l_day
222: from dual;
223: return(l_day);

Line 232: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);

228: return number as
229: l_first_date varchar2(10);
230: l_input_date varchar2(10);
231: begin
232: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
233: l_first_date := substr(l_input_date,1,4)||'/01/01';
234: return(days_between(l_input_date,l_first_date));
235: end get_yearday;
236:

Line 359: end hr_sa_hijrah_functions;

355: end if;
356:
357: end validate_date;
358:
359: end hr_sa_hijrah_functions;