136: l_account_value VARCHAR2(30);
137: l_bfy_value VARCHAR2(30);
138: l_fund_category fv_fund_parameters.fund_category%TYPE;
139: l_fund_time_frame fv_fund_parameters.fund_time_frame%TYPE;
140: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
141: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
142: l_fund_expired_status VARCHAR2(30);
143: l_unreserv_dist_rec po_bc_distributions%ROWTYPE;
144: l_unreserv_data_exists BOOLEAN := FALSE;
137: l_bfy_value VARCHAR2(30);
138: l_fund_category fv_fund_parameters.fund_category%TYPE;
139: l_fund_time_frame fv_fund_parameters.fund_time_frame%TYPE;
140: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
141: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
142: l_fund_expired_status VARCHAR2(30);
143: l_unreserv_dist_rec po_bc_distributions%ROWTYPE;
144: l_unreserv_data_exists BOOLEAN := FALSE;
145: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
141: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
142: l_fund_expired_status VARCHAR2(30);
143: l_unreserv_dist_rec po_bc_distributions%ROWTYPE;
144: l_unreserv_data_exists BOOLEAN := FALSE;
145: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
146: l_sign NUMBER;
147:
148: BEGIN
149: l_procedure_name := g_path_name || l_procedure_name;
431: l_bfy_value VARCHAR2(30);
432: l_index NUMBER;
433: l_conversion_rate NUMBER;
434: l_sign NUMBER;
435: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;
437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;
438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;
439: l_old_event_type po_bc_distributions.event_type_code%TYPE;
436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;
437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;
438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;
439: l_old_event_type po_bc_distributions.event_type_code%TYPE;
440: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
441: l_pya_data_exists BOOLEAN := FALSE;
442:
443: BEGIN
444: l_procedure_name := g_path_name || l_procedure_name;