1285:
1286: --
1287: -- Round the values
1288: --
1289: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_adjustment_cost ,
1290: p_book_type_code )) THEN
1291: null;
1292: END IF;
1293: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_net_book_value ,
1289: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_adjustment_cost ,
1290: p_book_type_code )) THEN
1291: null;
1292: END IF;
1293: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_net_book_value ,
1294: p_book_type_code )) THEN
1295: null;
1296: END IF;
1297: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_cost ,
1293: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_net_book_value ,
1294: p_book_type_code )) THEN
1295: null;
1296: END IF;
1297: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_cost ,
1298: p_book_type_code )) THEN
1299: null;
1300: END IF;
1301: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_backlog ,
1297: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_cost ,
1298: p_book_type_code )) THEN
1299: null;
1300: END IF;
1301: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_backlog ,
1302: p_book_type_code )) THEN
1303: null;
1304: END IF;
1305: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_gen_fund ,
1301: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_backlog ,
1302: p_book_type_code )) THEN
1303: null;
1304: END IF;
1305: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_gen_fund ,
1306: p_book_type_code )) THEN
1307: null;
1308: END IF;
1309: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_net ,
1305: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_gen_fund ,
1306: p_book_type_code )) THEN
1307: null;
1308: END IF;
1309: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_net ,
1310: p_book_type_code )) THEN
1311: null;
1312: END IF;
1313: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_cost ,
1309: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_reval_reserve_net ,
1310: p_book_type_code )) THEN
1311: null;
1312: END IF;
1313: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_cost ,
1314: p_book_type_code )) THEN
1315: null;
1316: END IF;
1317: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_backlog ,
1313: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_cost ,
1314: p_book_type_code )) THEN
1315: null;
1316: END IF;
1317: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_backlog ,
1318: p_book_type_code )) THEN
1319: null;
1320: END IF;
1321: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_net ,
1317: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_backlog ,
1318: p_book_type_code )) THEN
1319: null;
1320: END IF;
1321: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_net ,
1322: p_book_type_code )) THEN
1323: null;
1324: END IF;
1325: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_ytd ,
1321: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_net ,
1322: p_book_type_code )) THEN
1323: null;
1324: END IF;
1325: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_ytd ,
1326: p_book_type_code )) THEN
1327: null;
1328: END IF;
1329: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_period ,
1325: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_operating_acct_ytd ,
1326: p_book_type_code )) THEN
1327: null;
1328: END IF;
1329: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_period ,
1330: p_book_type_code )) THEN
1331: null;
1332: END IF;
1333: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_ytd ,
1329: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_period ,
1330: p_book_type_code )) THEN
1331: null;
1332: END IF;
1333: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_ytd ,
1334: p_book_type_code )) THEN
1335: null;
1336: END IF;
1337: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_reserve ,
1333: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_ytd ,
1334: p_book_type_code )) THEN
1335: null;
1336: END IF;
1337: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_reserve ,
1338: p_book_type_code )) THEN
1339: null;
1340: END IF;
1341: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_reserve_backlog ,
1337: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_reserve ,
1338: p_book_type_code )) THEN
1339: null;
1340: END IF;
1341: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_reserve_backlog ,
1342: p_book_type_code )) THEN
1343: null;
1344: END IF;
1345: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_general_fund_per ,
1341: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_deprn_reserve_backlog ,
1342: p_book_type_code )) THEN
1343: null;
1344: END IF;
1345: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_general_fund_per ,
1346: p_book_type_code )) THEN
1347: null;
1348: END IF;
1349: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_general_fund_acc ,
1345: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_general_fund_per ,
1346: p_book_type_code )) THEN
1347: null;
1348: END IF;
1349: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_general_fund_acc ,
1350: p_book_type_code )) THEN
1351: null;
1352: END IF;
1353: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_op_ac_cost ,
1349: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_general_fund_acc ,
1350: p_book_type_code )) THEN
1351: null;
1352: END IF;
1353: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_op_ac_cost ,
1354: p_book_type_code )) THEN
1355: null;
1356: END IF;
1357: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_op_ac_backlog ,
1353: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_op_ac_cost ,
1354: p_book_type_code )) THEN
1355: null;
1356: END IF;
1357: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_op_ac_backlog ,
1358: p_book_type_code )) THEN
1359: null;
1360: END IF;
1361: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_hist_deprn_amount ,
1357: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_op_ac_backlog ,
1358: p_book_type_code )) THEN
1359: null;
1360: END IF;
1361: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_hist_deprn_amount ,
1362: p_book_type_code )) THEN
1363: null;
1364: END IF;
1365: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_hist_deprn_ytd ,
1361: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_hist_deprn_amount ,
1362: p_book_type_code )) THEN
1363: null;
1364: END IF;
1365: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_hist_deprn_ytd ,
1366: p_book_type_code )) THEN
1367: null;
1368: END IF;
1369: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_hist_deprn_reserve ,
1365: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_hist_deprn_ytd ,
1366: p_book_type_code )) THEN
1367: null;
1368: END IF;
1369: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_det_hist_deprn_reserve ,
1370: p_book_type_code )) THEN
1371: null;
1372: END IF;
1373:
1615: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1616: p_full_path => g_path||'create_adjustments',
1617: p_string => 'Getting GL Info for book ...');
1618:
1619: IF ( NOT ( Igi_Iac_Common_Utils.Get_Book_GL_Info ( p_book_type_code ,
1620: l_set_of_books_Id ,
1621: l_coa_id ,
1622: l_currency ,
1623: l_precision ))) THEN
1764: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1765: p_full_path => g_path||'create_adjustments',
1766: p_string => 'Getting CCID ...') ;
1767:
1768: IF ( NOT ( Igi_Iac_Common_Utils.Get_Account_CCID (
1769: p_book_type_code ,
1770: p_asset_id ,
1771: drec.distribution_id ,
1772: l_account_Type ,
2102: p_full_path => g_path||'transfer_data',
2103: p_string => 'Fetching period Info for counter : '|| l_period_counter );
2104: -- Fetch period Info for the counter
2105: --
2106: IF ( NOT( Igi_Iac_Common_Utils.Get_Period_Info_For_Counter (
2107: l_corporate_book ,
2108: l_period_Counter ,
2109: l_prd_rec
2110: ))) THEN
2125: p_string => 'Fetching period Info for closed period , counter : '|| (l_period_counter-1) );
2126:
2127: -- Fetch period Info for the closed period counter
2128: --
2129: IF ( NOT( Igi_Iac_Common_Utils.Get_Period_Info_For_Counter (
2130: l_corporate_book ,
2131: l_period_Counter-1 ,
2132: l_prev_prd_rec
2133: ))) THEN
2409:
2410: --
2411: -- Round Values
2412: --
2413: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_net_book_value ,
2414: l_corporate_book )) THEN
2415: null;
2416: END IF;
2417: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_adjusted_cost ,
2413: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_net_book_value ,
2414: l_corporate_book )) THEN
2415: null;
2416: END IF;
2417: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_adjusted_cost ,
2418: l_corporate_book )) THEN
2419: null;
2420: END IF;
2421: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_operating_acct ,
2417: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_adjusted_cost ,
2418: l_corporate_book )) THEN
2419: null;
2420: END IF;
2421: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_operating_acct ,
2422: l_corporate_book )) THEN
2423: null;
2424: END IF;
2425: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_reval_reserve ,
2421: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_operating_acct ,
2422: l_corporate_book )) THEN
2423: null;
2424: END IF;
2425: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_reval_reserve ,
2426: l_corporate_book )) THEN
2427: null;
2428: END IF;
2429: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_deprn_amount ,
2425: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_reval_reserve ,
2426: l_corporate_book )) THEN
2427: null;
2428: END IF;
2429: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_deprn_amount ,
2430: l_corporate_book )) THEN
2431: null;
2432: END IF;
2433: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_ytd_deprn ,
2429: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_deprn_amount ,
2430: l_corporate_book )) THEN
2431: null;
2432: END IF;
2433: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_ytd_deprn ,
2434: l_corporate_book )) THEN
2435: null;
2436: END IF;
2437: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_deprn_reserve ,
2433: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_ytd_deprn ,
2434: l_corporate_book )) THEN
2435: null;
2436: END IF;
2437: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_deprn_reserve ,
2438: l_corporate_book )) THEN
2439: null;
2440: END IF;
2441: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_backlog_deprn_reserve ,
2437: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_deprn_reserve ,
2438: l_corporate_book )) THEN
2439: null;
2440: END IF;
2441: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_backlog_deprn_reserve ,
2442: l_corporate_book )) THEN
2443: null;
2444: END IF;
2445: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_general_fund ,
2441: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_backlog_deprn_reserve ,
2442: l_corporate_book )) THEN
2443: null;
2444: END IF;
2445: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_general_fund ,
2446: l_corporate_book )) THEN
2447: null;
2448: END IF;
2449: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_hist_deprn_amount ,
2445: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_general_fund ,
2446: l_corporate_book )) THEN
2447: null;
2448: END IF;
2449: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_hist_deprn_amount ,
2450: l_corporate_book )) THEN
2451: null;
2452: END IF;
2453: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_hist_deprn_ytd ,
2449: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_hist_deprn_amount ,
2450: l_corporate_book )) THEN
2451: null;
2452: END IF;
2453: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_hist_deprn_ytd ,
2454: l_corporate_book )) THEN
2455: null;
2456: END IF;
2457: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_hist_deprn_reserve ,
2453: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_hist_deprn_ytd ,
2454: l_corporate_book )) THEN
2455: null;
2456: END IF;
2457: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_hist_deprn_reserve ,
2458: l_corporate_book )) THEN
2459: null;
2460: END IF;
2461: