883: lv_procedure_name VARCHAR2(40) := 'Get_Account_Balance_Side';
884: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
885: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
886:
887: lv_balance_side_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
888: lv_balance_side_meaning FND_LOOKUP_VALUES.MEANING%TYPE;
889:
890: --Cursor for getting 'Balance Side' and 'Account Type' based on account
891: CURSOR balance_side_cur
884: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
885: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
886:
887: lv_balance_side_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
888: lv_balance_side_meaning FND_LOOKUP_VALUES.MEANING%TYPE;
889:
890: --Cursor for getting 'Balance Side' and 'Account Type' based on account
891: CURSOR balance_side_cur
892: IS
945: --Get the Chinese characters of Debit and Credit
946: BEGIN
947: SELECT MEANING
948: INTO lv_balance_side_meaning
949: FROM FND_LOOKUP_VALUES
950: WHERE LOOKUP_TYPE = 'JA_CN_DEBIT_CREDIT'
951: AND LOOKUP_CODE = lv_balance_side_code
952: AND LANGUAGE = USERENV('LANG');
953: EXCEPTION
1652:
1653: ln_row_count NUMBER := 0;
1654: ld_start_date DATE;
1655: ld_end_date DATE;
1656: lv_balance_side FND_LOOKUP_VALUES.MEANING%TYPE;
1657: lv_functional_currency fnd_currencies_vl.NAME%TYPE;
1658:
1659: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
1660: lr_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;