[Home] [Help]
793:
794: Q4_REC Q4%ROWTYPE;
795:
796: ----------------------------------------------------------------------------------------------
797: -- NOTE: Q5 will process revaluations from XTR_REVALUATION_DETAILS.
798: -- There is no amount_type column in the XTR_REVALUATION_DETAILS table.
799: -- In the JEA setup, the amount type of 'UNREAL' and 'REAL' is intended
800: -- to allow the user to post unrealized/realized gains/losses to different
801: -- GL accounts. In addition, any unrealized gains/losses will be flagged
794: Q4_REC Q4%ROWTYPE;
795:
796: ----------------------------------------------------------------------------------------------
797: -- NOTE: Q5 will process revaluations from XTR_REVALUATION_DETAILS.
798: -- There is no amount_type column in the XTR_REVALUATION_DETAILS table.
799: -- In the JEA setup, the amount type of 'UNREAL' and 'REAL' is intended
800: -- to allow the user to post unrealized/realized gains/losses to different
801: -- GL accounts. In addition, any unrealized gains/losses will be flagged
802: -- as requiring a reversal entry in the subsequent period when transferring
801: -- GL accounts. In addition, any unrealized gains/losses will be flagged
802: -- as requiring a reversal entry in the subsequent period when transferring
803: -- XTR journals to the GL interface table.
804: -- Instead, there are separate columns for REALIZED_PL and UNREALIZED_PL
805: -- amounts in the XTR_REVALUATION_DETAILS table. If the row is for a realized
806: -- profit/loss, then there will be an amount in the REALIZED_PL column, etc.
807: ----------------------------------------------------------------------------------------------
808: Cursor Q5 is
809: Select
956: ,jea.action_code action_code
957: ,jea.date_type date_type
958: from xtr_gain_loss_dnm dnm,
959: xtr_journal_entry_actions jea,
960: xtr_revaluation_details rd,
961: xtr_bank_accounts ba,
962: xtr_bank_balances bb
963: where dnm.batch_id = in_batch_id
964: and jea.company_code = in_company -- JEA
1105: -- Find any upgrade reval details
1106: -----------------------------------
1107: cursor UPGRADE_REVAL is
1108: select b.upgrade_batch
1109: from XTR_REVALUATION_DETAILS a,
1110: XTR_BATCHES b
1111: where a.company_code = in_company
1112: and a.batch_id = b.batch_id
1113: and nvl(b.upgrade_batch,'N') = 'Y';