[Home] [Help]
292:
293: -- -------------------------------------------------------------------
294: -- PROCEDURE PURGE_FACTS_TRANSACTIONS
295: -- -------------------------------------------------------------------
296: -- Purges all FACTS transactions from the FV_FACTS_TEMP table for
297: -- the passed Treasaury Symbol.
298: -- ------------------------------------------------------------------
299:
300: Procedure PURGE_FACTS_TRANSACTIONS
299:
300: Procedure PURGE_FACTS_TRANSACTIONS
301: IS
302: BEGIN
303: DELETE FROM FV_FACTS_TEMP
304: Where treasury_symbol_id = v_treasury_symbol_id
305: And fct_int_record_category = 'TRIAL_BALANCE';
306: Commit ;
307:
527: -- This procedure selets all the transactions that needs to be
528: -- analyzed for reporting in the FACTS Trial Balance report. After getting the
529: -- list of trasnactions that needs to be reported, it applies all the
530: -- FACTS attributes for the account number and perform further
531: -- processing for Legislative Indicator. It populates the table FV_FACTS_TEMP
532: -- for using in the Trial balance report
533: -- ------------------------------------------------------------------
534: PROCEDURE PROCESS_TBAL_TRANSACTIONS
535: IS
608: vl_seg_prompt VARCHAR2(25) ;
609: vl_seg_value_set_name VARCHAR2(40) ;
610: vl_disbursements_flag VARCHAR2(1);
611: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
612: v_excptn_cat fv_facts_temp.fct_int_record_category%TYPE;
613: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
614: v_fyr_segment_name VARCHAR2(20) ;
615: --v_financing_acct VARCHAR2(1);
616: P_refer2 VARCHAR2(80);
977:
978: /* Bug 2464961
979: Modified the select statement to select gjl.entered_dr , gjl.entered_cr
980: Seperately. these two column values would be stored in the
981: table fv_facts_temp in AMOUNT1 and AMOUNT2 columns respectively */
982:
983: -- Bug 2512646 START
984:
985: Begin
2076:
2077: -- -------------------------------------------------------------------
2078: -- PROCEDURE CREATE_TBAL_RECORD
2079: -- -------------------------------------------------------------------
2080: -- Inserts a new record into FV_FACTS_TEMP table with the current
2081: -- values from the global variables with record category TRIAL_BALANCE
2082: -- ------------------------------------------------------------------
2083: PROCEDURE CREATE_TBAL_RECORD
2084: IS
2093: i.e. amount1 and amount2 for v_amount_dr and v_amount_cr respectively*/
2094:
2095: /* Bug No : 2494754 */
2096:
2097: INSERT INTO FV_FACTS_TEMP
2098: (TBAL_ACCT_NUM ,
2099: TBAL_FUND_VALUE ,
2100: COHORT ,
2101: BEGIN_END ,