1372: END IF;
1373:
1374:
1375: --
1376: -- Create rows in igi_iac_det_balances
1377: --
1378:
1379: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1380: p_full_path => g_path||'prorate_for_det_balances',
1484: p_full_path => g_path||'prorate_for_det_balances',
1485: p_string => 'Creating Detail Balances record ....');
1486:
1487:
1488: igi_iac_det_balances_pkg.insert_row (
1489: x_rowid => l_out_rowid ,
1490: x_adjustment_id => p_adj_id ,
1491: x_asset_id => p_asset_id ,
1492: x_distribution_id => l_all_dist.distribution_id ,
1574: p_event_id number )
1575: RETURN BOOLEAN IS
1576: CURSOR c_dists IS
1577: SELECT *
1578: FROM igi_iac_det_balances db
1579: WHERE db.book_type_Code = p_book_type_code
1580: AND db.asset_id = p_asset_id
1581: AND db.adjustment_id = p_adj_id
1582: AND db.active_flag is NULL;
2506: );
2507:
2508: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2509: p_full_path => g_path||'transfer_data',
2510: p_string => ' Creating rows in igi_iac_det_balances for closed period...');
2511: -- Create rows in igi_iac_det_balances for closed period
2512: --
2513: IF ( NOT ( Prorate_for_Det_Balances (
2514: p_book_type_code => l_corporate_book ,
2507:
2508: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2509: p_full_path => g_path||'transfer_data',
2510: p_string => ' Creating rows in igi_iac_det_balances for closed period...');
2511: -- Create rows in igi_iac_det_balances for closed period
2512: --
2513: IF ( NOT ( Prorate_for_Det_Balances (
2514: p_book_type_code => l_corporate_book ,
2515: p_category_id => p_category_id ,
2546:
2547:
2548: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2549: p_full_path => g_path||'transfer_data',
2550: p_string => ' Creating rows in igi_iac_det_balances ...');
2551: -- Create rows in igi_iac_det_balances
2552: --
2553: IF ( NOT ( Prorate_for_Det_Balances (
2554: p_book_type_code => l_corporate_book ,
2547:
2548: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2549: p_full_path => g_path||'transfer_data',
2550: p_string => ' Creating rows in igi_iac_det_balances ...');
2551: -- Create rows in igi_iac_det_balances
2552: --
2553: IF ( NOT ( Prorate_for_Det_Balances (
2554: p_book_type_code => l_corporate_book ,
2555: p_category_id => p_category_id ,