[Home] [Help]
75: || in the TBH call igs_fi_credits_pkg.insert_row.
76: || shtatiko 30-APR-2003 Enh# 2831569, Added check for Manage Accounts
77: || System Option. If its value is NULL then this will
78: || error out. If its value is OTHER then it tries
79: || to create a credit but doesn't update Standard
80: || or Holds Balance for the person in context.
81: || vchappid 19-May-2003 Build Bug# 2831572, Financial Accounting Enhancements
82: || New Parameters - Attendance Type, Attendance Mode, Residency Status Code
83: || added in procedure create_credit
115: l_pkg_name CONSTANT VARCHAR2(30) := 'IGS_FI_CREDIT_PVT';
116: l_api_version CONSTANT NUMBER := 2.1;
117: l_api_name CONSTANT VARCHAR2(30) := 'create_credit';
118: l_credit CONSTANT VARCHAR2(10) := 'CREDIT';
119: l_standard CONSTANT igs_fi_balance_rules.balance_name%TYPE := 'STANDARD';
120: l_hold CONSTANT igs_fi_balance_rules.balance_name%TYPE := 'HOLDS';
121: l_v_action_active CONSTANT VARCHAR2(10) := 'ACTIVE';
122:
123: l_b_return_status BOOLEAN;
504: END IF;
505:
506: -- After the records have been created in the credits and the credit activities table, then
507: -- the update balances process should be called for picking up the balances records in the credits
508: -- table for Holds and Standard Balance.
509:
510: --Firstly, Standard Balance updation.
511:
512: l_v_message_name :=NULL;
506: -- After the records have been created in the credits and the credit activities table, then
507: -- the update balances process should be called for picking up the balances records in the credits
508: -- table for Holds and Standard Balance.
509:
510: --Firstly, Standard Balance updation.
511:
512: l_v_message_name :=NULL;
513:
514: --Updation of balances table SHOULD NOT happen for Deposit Transactions.
515: -- And also if Manage Accounts is OTHER
516: IF (l_v_credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT'))
517: AND l_v_manage_accounts <> 'OTHER' THEN
518: igs_fi_prc_balances.update_balances( p_party_id => p_credit_rec.p_party_id,
519: p_balance_type => l_standard,
520: p_balance_date => TRUNC(l_d_transaction_date),
521: p_amount => ((-1)*l_n_amount),
522: p_source => l_credit,
523: p_source_id => l_n_credit_id,