Change from using a PKG to a Table to get Values

From: <jjosull_at_yahoo.com>
Date: 24 Jun 2003 02:21:10 -0700
Message-ID: <efaf064.0306240121.5ea6790e_at_posting.google.com>

Change from using a PKG to a Table to get Values [Quoted] Trying to Change

I have a variable period_open_flag declared as boolean.

Currently, a pkg utility.pkg(get_period) function gets called and assigns 4 values to the period_open_flag variable.

This variable is then used in the calculation of different end date's etc through out the rest of the code.

Like so..

period_open_flag := int_utility_pkg.get_period(pd_end_date, dte_stamp, fi_month, fi_year);

I have to change the way this pgm works by not using the int_utility_pkg.get_period any more & using a table int_periods table instead..

Table Def:

int_periods
period Varchar2
period_start_date Date
period_end_date Date
creation_date Date

Is there any way i can use the table instead of the pkg & function w/o having to change the rest of the code??

I tried creating a cursor called period_open_flag with the above table, and getting the values i need w/o huge changes

IF anybody has any pointers that'dbe great, if i havent been detailed enough i can provide more details.

Many Thanks For any help Received on Tue Jun 24 2003 - 11:21:10 CEST