The following lines contain the word 'select', 'insert', 'update' or 'delete':
igs_fi_credits_pkg.insert_row,and p_d_gl_date,gl_posted_date,posting_control_id to the call
to igs_fi_crd_activities_pkg.insert_row. Modified the logic of validation of currency_cd
and calculation of exchange_rate as exchange has been made mandatory if currency passed is
other than local currency specified in System Options Form. If currency is passed is same
as the one that is specified in System Options form, exchange rate is non-mandatory
and even if it is passed with some value, it will be ignored and has been considered as 1.
vvutukur 07-Oct-2002 Enh#2562745.1)Added two validations to error out NOCOPY of credits api a)if this procedure
is called while holds conversion process is running b)if no active balance rule
exists for HOLDS.2)Added code to call Update_balances procedure to update/create
Holds balance in igs_fi_balances table real time whenever a credit gets created
(just like STANDARD balance real time updation).
smvk 16-Sep-2002 Removed the parameter p_subaccount_id as a part of Bug # 2564643
Removed the local paramter l_psa.
smadathi 03-Jul-2002 Bug 2443082. Modified update_balances procedure call. Modified to pass transaction date
instead of system date.
vchappid 13-Jun-2002 Bug#2411529, Incorrectly used message name has been modified
SYKRISHN 19-APR-2002 Bug 2324088 - Introduced Desc Flex Field Validations.
vvutukur 27-02-2002 placed call to igs_fi_gen_007.validate_person instead of calling local function
validate_person.for bug:2238362
jbegum 12-Feb-2001 As part of Enh bug # 2201081
Added call to IGS_FI_GEN_005.validate_psa and IGS_FI_PARTY_SA_PKG.insert_row
sykrishn 4-FEB-2002 Added the new IN parameters p_awd_yr_cal_type,p_awd_yr_ci_sequence_number,p_fee_cal_type,p_fee_ci_sequence_number
These parameters are mandatory when the Credit Class is Of Internal or External Financial Aid
Changes realted to credit source- refer DLD - sfcr020
Validations for Fee Period - LCI relation
IGS_LOOKUPS -check for credit source
vvutukur 31-Jan-2002 Added new parameter p_invoice_id and logic,if accounting method is ACCRUAL,
the default clearing account defined for the Adjustment Credit type gets
overridden by the revenue account of the charge being adjusted.
sarakshi 18-dec-2001 Removed the parameters p_source_date,p_fee_type,p_credit_type_id from
the call to procedure Update_Balances and added parameter p_source_id
as a part of Enh. bug:2124001
sarakshi 8-oct-2001 Replaced procedure igs_fi_prc_balances.calculate_balances with
igs_fi_prc_balances.update_balances also removed balance_flag parameter
from call to insert row of credits table.bug no:2030448
msrinivi 13 Aug,2001 Call to build process to populate rev/rec ccid/code before
inserting intoigs_fi_activities table
********************************************************************************************** */
l_credit_number igs_fi_credits_all.credit_number%TYPE;