SQL doing here
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL doing here

  1. #1
    Join Date
    Aug 2000
    Posts
    68

    SQL doing here

    period_open_flag := int_utility_pkg.get_period(period_end_date, date_stamp, fiscal_month, fiscal_year);

    Can i just ask someone to tell me exactly what is happening above?

    W/o having to look at the int_utility_pkg, do u think this looks correct?

    the period _open_flag is getting the values of the period_end_date,date_stamp,fiscal_month, fiscal_year asssigned to it via the int_utility_pkg??


    Many Thanks
    Carpe Diem

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    My guess:

    "int_utility_pkg" - is a package

    "get_period" - is a function within the above package that takes the
    parameters period_end_date, date_stamp, fiscal_month, fiscal_year
    and outputs a VALUE (possible an accounting period).

    This single value is being assigned to the variable "period_open_flag"

    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width