eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_TRANSFERS_PKG dependencies on IGI_IAC_COMMON_UTILS

Line 413: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

409:
410: l_path := g_path||'find_ccid';
411:
412: -- For reval reserve get the ccid into p_reval_ccid
413: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
414: p_asset_id,
415: p_dist_id,
416: 'REVAL_RESERVE_ACCT',
417: p_transaction_header_id,

Line 423: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

419: p_reval_ccid);
420:
421:
422: -- For general fund get the ccid into p_gen_fund_ccid
423: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
424: p_asset_id,
425: p_dist_id,
426: 'GENERAL_FUND_ACCT',
427: p_transaction_header_id,

Line 432: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

428: 'TRANSFER',
429: p_Gen_fund_ccid);
430:
431: -- For backlog deprn reserve get the ccid into p_backlog_ccid
432: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
433: p_asset_id,
434: p_dist_id,
435: 'BACKLOG_DEPRN_RSV_ACCT',
436: p_transaction_header_id,

Line 441: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

437: 'TRANSFER',
438: p_backlog_ccid);
439:
440: -- For deprn reserve get the ccid into p_deprn_ccid
441: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
442: p_asset_id,
443: p_dist_id,
444: 'DEPRN_RESERVE_ACCT',
445: p_transaction_header_id,

Line 450: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

446: 'TRANSFER',
447: p_deprn_ccid);
448:
449: -- For asset cost get the ccid into p_cost_ccid
450: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
451: p_asset_id,
452: p_dist_id,
453: 'ASSET_COST_ACCT',
454: p_transaction_header_id,

Line 459: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

455: 'TRANSFER',
456: p_cost_ccid);
457:
458: -- For operating expense get the ccid into p_op_expense_ccid
459: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
460: p_asset_id,
461: p_dist_id,
462: 'OPERATING_EXPENSE_ACCT',
463: p_transaction_header_id,

Line 468: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

464: 'TRANSFER',
465: p_op_expense_ccid);
466:
467: -- get the account info for the DEPRN_EXPENSE_ACCT
468: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
469: p_asset_id,
470: p_dist_id,
471: 'DEPRN_EXPENSE_ACCT',
472: p_transaction_header_id,

Line 692: IF IGI_IAC_COMMON_UTILS.Iac_round(l_asset_rec.dep_expense_catchup,

688: l_asset_rec.dep_expense_catchup := l_asset_rec.dep_expense_catchup*(p_transfer_units/p_asset_units);
689:
690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Additional IAC Expense :'||l_expense_diff);
691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No of Catch up periods :'||(p_curr_prd_cntr-p_tfr_prd_cntr));
692: IF IGI_IAC_COMMON_UTILS.Iac_round(l_asset_rec.dep_expense_catchup,
693: p_book_type_code) THEN
694: NULL;
695: END IF;
696:

Line 711: IF IGI_IAC_COMMON_UTILS.Iac_round(l_asset_rec.op_expense_catchup,

707: END IF;
708: CLOSE c_op_expense_amt;
709:
710: l_asset_rec.op_expense_catchup := l_asset_rec.op_expense_catchup*(p_transfer_units/p_asset_units);
711: IF IGI_IAC_COMMON_UTILS.Iac_round(l_asset_rec.op_expense_catchup,
712: p_asset_hdr_rec.book_type_code) THEN
713: NULL;
714: END IF;
715: END IF;

Line 736: IF IGI_IAC_COMMON_UTILS.Iac_round(l_iac_fa_dep_rec.dep_expense_catchup,

732:
733: -- calculate the historic depreciation catchup amount
734: l_iac_fa_dep_rec.dep_expense_catchup := l_historic_deprn_expense*(p_curr_prd_cntr - p_tfr_prd_cntr);
735: l_iac_fa_dep_rec.dep_expense_catchup := l_iac_fa_dep_rec.dep_expense_catchup*(p_transfer_units/p_asset_units);
736: IF IGI_IAC_COMMON_UTILS.Iac_round(l_iac_fa_dep_rec.dep_expense_catchup,
737: p_book_type_code) THEN
738: NULL;
739: END IF;
740:

Line 1176: IF NOT igi_iac_common_utils.is_iac_book(p_asset_hdr_rec.book_type_code) THEN

1172: RAISE e_iac_not_enabled;
1173: END IF;
1174:
1175: -- Check If Book is an IAC book
1176: IF NOT igi_iac_common_utils.is_iac_book(p_asset_hdr_rec.book_type_code) THEN
1177: RAISE e_not_iac_book;
1178: END IF;
1179:
1180: -- check if the asset has been revalued atleast once

Line 1181: IF NOT igi_iac_common_utils.is_asset_proc(p_asset_hdr_rec.book_type_code,

1177: RAISE e_not_iac_book;
1178: END IF;
1179:
1180: -- check if the asset has been revalued atleast once
1181: IF NOT igi_iac_common_utils.is_asset_proc(p_asset_hdr_rec.book_type_code,
1182: p_asset_hdr_rec.asset_id)
1183: THEN
1184: RAISE e_asset_not_revalued;
1185: END IF;

Line 1189: IF NOT igi_iac_common_utils.get_book_GL_info(p_asset_hdr_rec.book_type_code,

1185: END IF;
1186:
1187: -- get the GL set of books id if p_asset_hdr_rec.set_of_books_id is null
1188: IF p_asset_hdr_rec.set_of_books_id is NULL THEN
1189: IF NOT igi_iac_common_utils.get_book_GL_info(p_asset_hdr_rec.book_type_code,
1190: l_sob_id,
1191: l_coa_id,
1192: l_currency,
1193: l_precision)

Line 1201: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_asset_hdr_rec.book_type_code,

1197: END IF;
1198:
1199: -- populate igi_iac_fa_deprn table with asset detials if no rows exist for that
1200: -- asset
1201: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_asset_hdr_rec.book_type_code,
1202: 'TRANSFER') THEN
1203: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'*** Error in Synchronizing Depreciation Data ***');
1204: RETURN FALSE;
1205: END IF;

Line 1208: IF igi_iac_common_utils.get_latest_transaction (p_asset_hdr_rec.book_type_code,

1204: RETURN FALSE;
1205: END IF;
1206:
1207: --Fetch the latest transaction = prev trans if latest is revaluation-preview or obsolete
1208: IF igi_iac_common_utils.get_latest_transaction (p_asset_hdr_rec.book_type_code,
1209: p_asset_hdr_rec.asset_id,
1210: l_transaction_type_code,
1211: l_transaction_header_id,
1212: l_mass_reference_id,

Line 1233: IF igi_iac_common_utils.get_open_period_info(p_asset_hdr_rec.book_type_code,

1229: END IF; */
1230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Prev adj: '||l_prev_adjustment_id||' Current: '||l_adjustment_id);
1231:
1232: -- Get the current open period counter
1233: IF igi_iac_common_utils.get_open_period_info(p_asset_hdr_rec.book_type_code,
1234: l_prd_rec)
1235: THEN
1236: l_current_period_counter:=l_prd_rec.period_counter;
1237: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||l_current_period_counter);

Line 1242: IF IGI_IAC_COMMON_UTILS.Is_Asset_Adjustment_Done(p_asset_hdr_rec.book_type_code,

1238: END IF;
1239:
1240: -- Check whether adjustments exist in the open period
1241: -- If Adjustments exists then stop the Transfer
1242: IF IGI_IAC_COMMON_UTILS.Is_Asset_Adjustment_Done(p_asset_hdr_rec.book_type_code,
1243: p_asset_hdr_rec.asset_id) THEN
1244:
1245: FA_SRVR_MSG.Add_Message(
1246: Calling_FN => 'IGI_IAC_TRANSFERS_PKG.Do_Transfer' ,

Line 1256: IF igi_iac_common_utils.get_period_info_for_date(p_asset_hdr_rec.book_type_code,

1252:
1253: -- check if this is a prior period transfer
1254: g_prior_period := FALSE;
1255: -- get the period counter for the transfer date period
1256: IF igi_iac_common_utils.get_period_info_for_date(p_asset_hdr_rec.book_type_code,
1257: p_trans_rec.transaction_date_entered,
1258: l_prd_rec_prior)
1259: THEN
1260: l_prior_period_counter:=l_prd_rec_prior.period_counter;

Line 1520: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,

1516:
1517: -- prepare distribution data for igi_iac_det_balances
1518: -- igi_iac_fa_deprn and igi_iac_adjustments
1519: -- Rounding All amounts
1520: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,
1521: p_asset_hdr_rec.book_type_code) THEN
1522: null;
1523: END IF;
1524: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund,

Line 1524: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund,

1520: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,
1521: p_asset_hdr_rec.book_type_code) THEN
1522: null;
1523: END IF;
1524: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund,
1525: p_asset_hdr_rec.book_type_code) THEN
1526: null;
1527: END IF;
1528: IF IGI_IAC_COMMON_UTILS.Iac_round(l_backlog_deprn_reserve,

Line 1528: IF IGI_IAC_COMMON_UTILS.Iac_round(l_backlog_deprn_reserve,

1524: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund,
1525: p_asset_hdr_rec.book_type_code) THEN
1526: null;
1527: END IF;
1528: IF IGI_IAC_COMMON_UTILS.Iac_round(l_backlog_deprn_reserve,
1529: p_asset_hdr_rec.book_type_code) THEN
1530: null;
1531: END IF;
1532: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_reserve,

Line 1532: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_reserve,

1528: IF IGI_IAC_COMMON_UTILS.Iac_round(l_backlog_deprn_reserve,
1529: p_asset_hdr_rec.book_type_code) THEN
1530: null;
1531: END IF;
1532: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_reserve,
1533: p_asset_hdr_rec.book_type_code) THEN
1534: null;
1535: END IF;
1536: IF IGI_IAC_COMMON_UTILS.Iac_round(l_adjusted_cost,

Line 1536: IF IGI_IAC_COMMON_UTILS.Iac_round(l_adjusted_cost,

1532: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_reserve,
1533: p_asset_hdr_rec.book_type_code) THEN
1534: null;
1535: END IF;
1536: IF IGI_IAC_COMMON_UTILS.Iac_round(l_adjusted_cost,
1537: p_asset_hdr_rec.book_type_code) THEN
1538: null;
1539: END IF;
1540: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct,

Line 1540: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct,

1536: IF IGI_IAC_COMMON_UTILS.Iac_round(l_adjusted_cost,
1537: p_asset_hdr_rec.book_type_code) THEN
1538: null;
1539: END IF;
1540: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct,
1541: p_asset_hdr_rec.book_type_code) THEN
1542: null;
1543: END IF;
1544: IF IGI_IAC_COMMON_UTILS.Iac_round(l_net_book_value,

Line 1544: IF IGI_IAC_COMMON_UTILS.Iac_round(l_net_book_value,

1540: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct,
1541: p_asset_hdr_rec.book_type_code) THEN
1542: null;
1543: END IF;
1544: IF IGI_IAC_COMMON_UTILS.Iac_round(l_net_book_value,
1545: p_asset_hdr_rec.book_type_code) THEN
1546: null;
1547: END IF;
1548: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_per,

Line 1548: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_per,

1544: IF IGI_IAC_COMMON_UTILS.Iac_round(l_net_book_value,
1545: p_asset_hdr_rec.book_type_code) THEN
1546: null;
1547: END IF;
1548: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_per,
1549: p_asset_hdr_rec.book_type_code) THEN
1550: null;
1551: END IF;
1552: IF IGI_IAC_COMMON_UTILS.Iac_round(l_ytd_deprn,

Line 1552: IF IGI_IAC_COMMON_UTILS.Iac_round(l_ytd_deprn,

1548: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_per,
1549: p_asset_hdr_rec.book_type_code) THEN
1550: null;
1551: END IF;
1552: IF IGI_IAC_COMMON_UTILS.Iac_round(l_ytd_deprn,
1553: p_asset_hdr_rec.book_type_code) THEN
1554: null;
1555: END IF;
1556: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct_ytd,

Line 1556: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct_ytd,

1552: IF IGI_IAC_COMMON_UTILS.Iac_round(l_ytd_deprn,
1553: p_asset_hdr_rec.book_type_code) THEN
1554: null;
1555: END IF;
1556: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct_ytd,
1557: p_asset_hdr_rec.book_type_code) THEN
1558: null;
1559: END IF;
1560: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve_backlog,

Line 1560: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve_backlog,

1556: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct_ytd,
1557: p_asset_hdr_rec.book_type_code) THEN
1558: null;
1559: END IF;
1560: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve_backlog,
1561: p_asset_hdr_rec.book_type_code) THEN
1562: null;
1563: END IF;
1564: IF IGI_IAC_COMMON_UTILS.Iac_round(l_operating_acct_backlog,

Line 1564: IF IGI_IAC_COMMON_UTILS.Iac_round(l_operating_acct_backlog,

1560: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve_backlog,
1561: p_asset_hdr_rec.book_type_code) THEN
1562: null;
1563: END IF;
1564: IF IGI_IAC_COMMON_UTILS.Iac_round(l_operating_acct_backlog,
1565: p_asset_hdr_rec.book_type_code) THEN
1566: null;
1567: END IF;
1568: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund_per,

Line 1568: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund_per,

1564: IF IGI_IAC_COMMON_UTILS.Iac_round(l_operating_acct_backlog,
1565: p_asset_hdr_rec.book_type_code) THEN
1566: null;
1567: END IF;
1568: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund_per,
1569: p_asset_hdr_rec.book_type_code) THEN
1570: null;
1571: END IF;
1572: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_period,

Line 1572: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_period,

1568: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund_per,
1569: p_asset_hdr_rec.book_type_code) THEN
1570: null;
1571: END IF;
1572: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_period,
1573: p_asset_hdr_rec.book_type_code) THEN
1574: null;
1575: END IF;
1576: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_reserve,

Line 1576: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_reserve,

1572: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_period,
1573: p_asset_hdr_rec.book_type_code) THEN
1574: null;
1575: END IF;
1576: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_reserve,
1577: p_asset_hdr_rec.book_type_code) THEN
1578: null;
1579: END IF;
1580: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_ytd,

Line 1580: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_ytd,

1576: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_reserve,
1577: p_asset_hdr_rec.book_type_code) THEN
1578: null;
1579: END IF;
1580: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_ytd,
1581: p_asset_hdr_rec.book_type_code) THEN
1582: null;
1583: END IF;
1584:

Line 1587: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_expense,

1583: END IF;
1584:
1585: IF g_prior_period THEN
1586: -- do currency rounding for the catchup amounts
1587: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_expense,
1588: p_asset_hdr_rec.book_type_code) THEN
1589: NULL;
1590: END IF;
1591: IF IGI_IAC_COMMON_UTILS.Iac_round(l_dist_op_exp,

Line 1591: IF IGI_IAC_COMMON_UTILS.Iac_round(l_dist_op_exp,

1587: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_expense,
1588: p_asset_hdr_rec.book_type_code) THEN
1589: NULL;
1590: END IF;
1591: IF IGI_IAC_COMMON_UTILS.Iac_round(l_dist_op_exp,
1592: p_asset_hdr_rec.book_type_code) THEN
1593: NULL;
1594: END IF;
1595: END IF; -- prior period

Line 2015: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_asset_hdr_rec.book_type_code,

2011: IF (l_all_dist.distribution_id = l_old_dist) THEN
2012: -- old distribution
2013: -- get ccid
2014: -- get the ccod for interco ar
2015: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_asset_hdr_rec.book_type_code,
2016: p_asset_hdr_rec.asset_id,
2017: l_all_dist.distribution_id,
2018: 'INTERCO_AR_ACCT',
2019: p_trans_rec.transaction_header_id,

Line 2042: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_asset_hdr_rec.book_type_code,

2038: );
2039: ELSIF (l_all_dist.distribution_id = l_impacted_dist) THEN
2040: -- new distribution
2041: -- get the ccod for interco ap
2042: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_asset_hdr_rec.book_type_code,
2043: p_asset_hdr_rec.asset_id,
2044: l_all_dist.distribution_id,
2045: 'INTERCO_AP_ACCT',
2046: p_trans_rec.transaction_header_id,

Line 2588: IF (IGI_IAC_COMMON_UTILS.get_period_info_for_date(p_book_type_code,

2584: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);
2585:
2586:
2587: /*Check If it is Prior Period Transfer*/
2588: IF (IGI_IAC_COMMON_UTILS.get_period_info_for_date(p_book_type_code,
2589: l_trans_headers.transaction_date_entered,
2590: l_prd_rec_prior)) THEN
2591: l_prior_period_counter:=l_prd_rec_prior.period_counter;
2592: END IF;