Calender Object - very urgent [message #85537] |
Wed, 07 July 2004 01:29  |
K.Sateeshkumar
Messages: 16 Registered: March 2004
|
Junior Member |
|
|
Hai Gurus!
How to attach a calender object to a date field in both forms/reports 6i,is there any built-in package available.if available how to use the built-in in both forms & reports. if not is there any procedure to create a calender object and attach to it a date field.
pl help me!
Thanking you,
K.Sateeshkumar
|
|
|
Re: Calender Object - very urgent [message #85541 is a reply to message #85537] |
Wed, 07 July 2004 02:13  |
 |
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
hi buddy,
there was a good discussion went on this topic.
plz check the site
http://www.experts-exchange.com/Databases/Oracle/Tools_Development/Q_20955024.html
after downloading the required pll
1.Copy or make the Calendar Object Group a subclass.
2.Attach the PL/SQL library CALENDAR.PLL.
3.Create a Key-Listval trigger.
4.Call Date_LOV.Get_Date.
date_lov.get_date(display_date,return_item, window_x_pos,window_y_pos, window_title, ok_label,cancel_label, highlight, autoconfirm,autoskip );
ex:
date_lov.get_date(sysdate,'emp.hiredate',200,80,'Joining Date','OK','Cancel',TRUE,FALSE,FALSE);
by
vamsi
|
|
|