Is there any default calendar which I can use on my form and report

Advertisement

Hi All,
Is there any default calendar which I can use on date field on my form and report.
just by change its property like double click on date field and property calendar = yes
or any other way.
thanks
mohan

Advertisement

hi
create a functions something like this.i hope it helps u.
function call_calender ( f_dtm_set in date default sysdate ) return date is
l_dtm  date;
l_list paramlist := get_parameter_list ( 'CALL_CALENDER' );
begin
if
  not id_null ( l_list )
then
  destroy_parameter_list ( l_list );
end if;
if
  trunc ( f_dtm_set ) != trunc ( sysdate ) --> if you call the calendar function with a date, the calendar will change to that date
then
  l_list := create_parameter_list ( 'CALL_CALENDER' );
  add_parameter ( l_list, 'DTM_SET', text_parameter, to_char ( f_dtm_set, 'dd/mm/yyyy' ) );
end if;
copy ( null, 'global.calender_date' ); --> create a null global
call_form ( 'form_name', no_hide, no_replace, no_query_only, l_list );
if
  not id_null ( l_list )
then
  destroy_parameter_list ( l_list );
end if;
if
  name_in ( 'global.calender_date' ) is not null  --> if the global is not null, give the choosen item back
then
  l_dtm := to_date ( name_in ( 'global.calender_date' ), 'dd/mm/yyyy' );
end if;
erase ( 'global.calender_date' );
return ( l_dtm );
end;sarah

November 30, -0001

Is there any default calendar which I can use on my form and report

Hi All, Is there any default calendar which I can use on date field on my form and report. just by change its property like double click on date field and property calendar = yes or any other way. thanks mohanhi create a functions something like this

ARE THERE ANY WAYS BY WHICH I CAN FIND THE Appln Servlet Container Memory

ARE THERE ANY WAYS BY WHICH I CAN FIND THE Appln Servlet Container Memory .You can check out Tomcat memory usage using Tomcat Manger and clicking server status. It gives the information like this Free memory: 489.80 MB Total memory: 508.12 MB Max mem

Is there any patch available so i can use it in Oracle 9i Standard Edition

Incremental Backup and Recovery Parallel DML Parallel Query Export/import Transportable Tablespace these features are supported by Oracle 9i Enterprise Edition but not in Oracle 9i Standard Edition is there any patch available so i can use it in Orac

I have started getting spammed on multiple Apple products (iPhone and iPad) with FaceTime calls since the recent IOS update.  Is there any feature or sedtting I can use locally to restrict incoming calls to FaceTime without going to the carrier?

I have started getting spammed on multiple Apple products (iPhone and iPad) with FaceTime calls since the recent IOS update.  Is there any feature or setting I can use locally to restrict incoming calls to a FaceTime account without going to the carr

Can i start oracle forms and reports 11g services in linux with opmnctl ?

Hi: I am so confused with weblogic and forms 11g that i don't know nothing at all looll :) Someone told me that to start oracle forms i need to this [[email protected] ~]$./startManagedWebLogic.sh WLS_FORMS This scripts asks for a password and that's annoyi

Is there any tools with which I can ope back-up to analyse it?

hi, is there any tools of microsoft  with which I can open a back-up to analyse it ? johan h.davidHi, àopen a back-up to analyse it I'm a little confused with the description. If you mean that want to see files and folders which had been backed up. W

Transparent table which i can use instead of this structure :::RMCP2

Hi Buddies, I have to use some fields into this structure RMCP2 - I/O Table: Sales and Operations Planning . But this is a structure, do we have any transparent table which i can use instead of this structure? Regards, vijayHi Vijay, Plz use SQL trac

Is there a software in which I can hook up my iPhone 4s to my computer and send and receive text messages and calls (via headset) through my computer?

Is there a software in which I can hook up my iPhone 4s to my computer and send and receive text messages and calls (via headset) through my computer? Whether it's free or cost money, can someone please give me a name of a program or software that al

Is there a way in which i can check if my Iphone 4 is factory unlocked before upgrading

Is there a way in which i can check if my Iphone 4 is factory unlocked before upgrading i have bought it outside of usa and its unlocked till now....will it lock if i upgrade i just wana get official word from apple that my iphone is factory unlocked

My computer has become much slower and may have been infected.  Is there any course of action I can take in solving this problem?

my computer has become much slower and may have been infected.  Is there any course of action I can take in solving this problem?If this started happening without your having made any changes and without a warning of low disk space, then it's likely

Hi, I dropped my I Phone 4 and shattered the front glass. I have an extended warranty on my phone. Is there any place in Singapore I can take the phone and get a replacement???You suggestion highly appreciated

Hey, I dropped my Iphone 4 and the front glass got shattered. I am covered under the extended warranty. Is there any place in Singapore I can take my phone for repair? Has anyone got it repaired for free??Please let me know how to go about with it. Y

Are there any free TV channels that can be received on the Apple TV?

Are there any free TV channels that can be received on the Apple TV?No, it's not a TV tuner.  It's primarily marketed as a rental vehicle for iTunes store movies/purchases and for playback of compatible (see specs) media from iTunes. Some subscriptio

Primarily using the ipad air as an art portfolio but photos i upload in order get rearranged. other than changing the date they were shot, is there any solution to this? can they be reorganized in iphoto on the ipad?

primarily using the ipad air as an art portfolio but photos i upload in order get rearranged. other than changing the date they were shot, is there any solution to this? can they be reorganized in iphoto on the ipad?You are welcome. Sorting and organ

Is there any way to have a COMPLETE list of all samples and loops ( Logic 8

I'm sure it's been posted previously, but anyway, I'm looking to buy new Apple Loops libraries and I have faced the fact , that many of the sounds and loops produced by third parties manufacturers have been already included in Logic installation disc

Hi I am searching for a app which i can use to protect games or other apps from my childs. not to protect all only a few

hi im searchingg for an app which i can use to protect games or other apps from my childs. not to protect all only a fewSorry, but you will not find any such app.  The iOS itself is set up such that 3rd parth apps can have almost no interaction with

Is there an ipad app where I can write notes in meetings and convert it to text

is there an ipad app where I can take handwritten business notes and convert it to text?Can't any word processor do this? I use Pages as my word processor. I could just write down notes there or dictate them. Then come back later to fill in the detai

Is there any way to get the query used in discoverer from backend??

Hi All, I am new to dicoverer. Is there any way to get the query used in discoverer from backend?? Thanks, SachinHi, you can view the SQL from within the discoverer menu: in desktop: View-> SQL Inspector in Plus: Tools-> Show SQL The SQL in the DB t

HT4994 HAI CAN YOU TELL ME WHICH SIM IS USED IN THIS IMEI **** AND WHICH COUNTRY

HAI CAN YOU TELL ME WHICH SIM IS USED IN THIS IMEI **** AND WHICH COUNTRY <Edited By Host>No. Sorry, no one here can help you. The only reliable way to determine this info is to call AppleCare.Read other 2 answers

What is the latest Sun One webserver with SP #, which we can use it  in pro

What is the latest Sun One webserver with SP #, which we can use it in production environment. thanks siva6.1 Service pack 5 is our latest release. you can get this software from http://www.sun.com/webserver hope this helpsRead other 2 answers

From which table can I display PGI (material and quantity)for a spesific cu

Dear gurus, From which table can I display PGI (material and quantity)for a spesific customer order? Thanks in advanceHI PGI and material quantity can be available in MSEG table for this enter the sales order number in KDAUF or* MAT_KDAUF* fields in