[Home] [Help]
353: -- Submit the RXi Report
354: BEGIN
355: SELECT count(*)
356: INTO l_count
357: FROM FV_FACTS_TRX_TEMP;
358:
359: IF l_count >0 THEN
360:
361: l_req_id :=
739: -- PROCEDURE JOURNAL_PROCESS
740: -- -------------------------------------------------------------------
741: -- Journal_Process procedure is called from the Main procedure.
742: -- Its primary purpose is to derive values to populate
743: -- 'FV_FACTS_TRX_TEMP' table from the rows derived from INVOICES,
744: -- PAYMENTS etc. It uses dynamimic SQL to dynamically set
745: -- the select statement for the cursor.
746: -- It uses the argument 'p_jrnl_type' to find whether the journal
747: -- type is Invoice or payment, etc. The valid journal type values
4174: -- --------------------------------------------------------------------
4175: -- PROCEDURE POPULATE_TABLE
4176: -- --------------------------------------------------------------------
4177: -- This procedure gets called from procedure Journal_Process.
4178: -- Its main purpose is to insert records in FV_FACTS_TRX_TEMP table.
4179: -- --------------------------------------------------------------------
4180: PROCEDURE populate_table
4181: ( p_treasury_symbol_id NUMBER ,
4182: p_set_of_books_id NUMBER ,
4231: l_module_name VARCHAR2(200);
4232: BEGIN
4233: l_module_name := g_module_name || 'populate_table';
4234: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' POPULATING FV_FACTS_TRX_TEMP TABLE ...');
4236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' TREASURY SYMBOL ID :'||P_TREASURY_SYMBOL_ID||'''');
4237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' SET OF BOOKS ID :'||P_SET_OF_BOOKS_ID||'''');
4238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CCID :'||P_CODE_COMBINATION_ID||'''');
4239: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' FUND VALUE :'||P_FUND_VALUE||'''');
4284: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' SLA ENTITY ID :'||P_SLA_ENTITY_ID);
4285:
4286: END IF;
4287:
4288: INSERT INTO fv_facts_trx_temp
4289: (treasury_symbol_id ,
4290: set_of_books_id ,
4291: code_combination_id ,
4292: fund_value ,
4388: p_sla_hdr_creation_date,
4389: p_sla_entity_id );
4390:
4391: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4392: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' POPULATED FV_FACTS_TRX_TEMP TABLE ...');
4393: END IF;
4394: EXCEPTION
4395: WHEN OTHERS THEN
4396: g_error_code := SQLCODE ;
4718: END load_facts_attributes ;
4719: -- -------------------------------------------------------------------
4720: -- PROCEDURE PURGE_FACTS_TRANSACTIONS
4721: -- -------------------------------------------------------------------
4722: -- Purges all FACTS transactions from the FV_FACTS_TRX_TEMP table for
4723: -- the passed Treasaury Symbol.
4724: -- ------------------------------------------------------------------
4725: PROCEDURE purge_facts_transactionS
4726: IS
4726: IS
4727: l_module_name VARCHAR2(200);
4728: BEGIN
4729: l_module_name := g_module_name || 'purge_facts_transactionS';
4730: DELETE FROM fv_facts_trx_temp;
4731: COMMIT ;
4732: EXCEPTION
4733: -- Exception Processing
4734: WHEN NO_DATA_FOUND THEN