DBA Data[Home] [Help]

APPS.IGS_FI_CREDITS_API_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 102

                         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;