139: x_current_hour out NOCOPY varchar2,
140: x_current_minute out NOCOPY varchar2) is
141: begin
142:
143: x_current_date_time := fnd_date.date_to_charDT(SYSDATE);
144:
145: x_current_date := fnd_date.date_to_chardate(SYSDATE);
146:
147: select to_char(SYSDATE, 'HH24')
141: begin
142:
143: x_current_date_time := fnd_date.date_to_charDT(SYSDATE);
144:
145: x_current_date := fnd_date.date_to_chardate(SYSDATE);
146:
147: select to_char(SYSDATE, 'HH24')
148: into x_current_hour
149: from dual;