DBA Data[Home] [Help]

APPS.IGI_IAC_RETIREMENT dependencies on IGI_IAC_DET_BALANCES_PKG

Line 973: igi_iac_det_balances_pkg.insert_row(

969:
970: debug( g_state_level,l_path_name,'start insert det bal');
971: l_rowid := NULL ;
972:
973: igi_iac_det_balances_pkg.insert_row(
974: X_rowid => l_rowid ,
975: X_adjustment_id => l_retirement_adjustment_id ,
976: X_asset_id => P_Asset_Id ,
977: X_distribution_id => l_detail_balances.distribution_id ,

Line 1078: igi_iac_det_balances_pkg.insert_row(

1074: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);
1075: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn_ytd,P_Book_Type_Code);
1076: END IF;
1077:
1078: igi_iac_det_balances_pkg.insert_row(
1079: X_rowid => l_rowid ,
1080: X_adjustment_id => l_retirement_adjustment_id ,
1081: X_asset_id => P_Asset_Id,
1082: X_distribution_id => l_detail_balances.distribution_id ,

Line 1500: igi_iac_det_balances_pkg.insert_row(

1496:
1497: l_rowid := NULL ;
1498:
1499:
1500: igi_iac_det_balances_pkg.insert_row(
1501: X_rowid => l_rowid ,
1502: X_adjustment_id => l_retirement_adjustment_id ,
1503: X_asset_id => P_Asset_Id ,
1504: X_distribution_id => l_detail_balances.distribution_id ,

Line 1576: igi_iac_det_balances_pkg.insert_row(

1572: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
1573:
1574: debug( g_state_level,l_path_name,'Inactive distributions');
1575: l_rowid := NULL ;
1576: igi_iac_det_balances_pkg.insert_row(
1577: X_rowid => l_rowid ,
1578: X_adjustment_id => l_retirement_adjustment_id ,
1579: X_asset_id => P_Asset_Id,
1580: X_distribution_id => l_detail_balances.distribution_id ,

Line 1797: igi_iac_det_balances_pkg.insert_row(

1793:
1794: l_rowid := NULL ;
1795:
1796:
1797: igi_iac_det_balances_pkg.insert_row(
1798: X_rowid => l_rowid ,
1799: X_adjustment_id => l_retirement_adjustment_id ,
1800: X_asset_id => P_Asset_Id ,
1801: X_distribution_id => l_detail_balances.distribution_id ,

Line 1874: igi_iac_det_balances_pkg.insert_row(

1870: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
1871:
1872: debug( g_state_level,l_path_name,'Inactive distributions');
1873: l_rowid := NULL ;
1874: igi_iac_det_balances_pkg.insert_row(
1875: X_rowid => l_rowid ,
1876: X_adjustment_id => l_retirement_adjustment_id ,
1877: X_asset_id => P_Asset_Id,
1878: X_distribution_id => l_detail_balances.distribution_id ,

Line 2665: igi_iac_det_balances_pkg.insert_row(

2661: END IF;
2662:
2663: l_rowid := NULL ;
2664:
2665: igi_iac_det_balances_pkg.insert_row(
2666: X_rowid => l_rowid ,
2667: X_adjustment_id => l_retirement_adjustment_id ,
2668: X_asset_id => P_Asset_Id ,
2669: X_distribution_id => l_detail_balances.distribution_id ,

Line 2935: igi_iac_det_balances_pkg.insert_row(

2931:
2932:
2933:
2934: l_rowid := NULL ;
2935: igi_iac_det_balances_pkg.insert_row(
2936: X_rowid => l_rowid ,
2937: X_adjustment_id => l_retirement_adjustment_id ,
2938: X_asset_id => P_Asset_Id ,
2939: X_distribution_id => l_new_fa_dist.distribution_id,

Line 3032: igi_iac_det_balances_pkg.insert_row(

3028:
3029: l_asset_units_count := l_asset_units_count + l_units_per_dist.units_assigned ;
3030:
3031: l_rowid := NULL ;
3032: igi_iac_det_balances_pkg.insert_row(
3033: X_rowid => l_rowid ,
3034: X_adjustment_id => l_retirement_adjustment_id ,
3035: X_asset_id => P_Asset_Id,
3036: X_distribution_id => l_detail_balances.distribution_id ,

Line 3100: igi_iac_det_balances_pkg.insert_row(

3096: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
3097: END IF;
3098:
3099: l_rowid:=NULL ;
3100: igi_iac_det_balances_pkg.insert_row(
3101: X_rowid => l_rowid ,
3102: X_adjustment_id => l_retirement_adjustment_id ,
3103: X_asset_id => P_Asset_Id,
3104: X_distribution_id => l_detail_balances.distribution_id ,

Line 3574: igi_iac_det_balances_pkg.insert_row(

3570:
3571: l_detail_balances.net_book_value := l_detail_balances.adjustment_cost - l_detail_balances.deprn_reserve -l_detail_balances.deprn_reserve_backlog ;
3572:
3573: l_rowid := NULL ;
3574: igi_iac_det_balances_pkg.insert_row(
3575: X_rowid => l_rowid ,
3576: X_adjustment_id => l_retirement_adjustment_id ,
3577: X_asset_id => P_Asset_Id ,
3578: X_distribution_id => l_detail_balances.distribution_id,

Line 3646: igi_iac_det_balances_pkg.insert_row(

3642:
3643: ELSE -- not impacted by retiretment -- active distribution
3644:
3645: l_rowid := NULL ;
3646: igi_iac_det_balances_pkg.insert_row(
3647: X_rowid => l_rowid ,
3648: X_adjustment_id => l_retirement_adjustment_id ,
3649: X_asset_id => P_Asset_Id ,
3650: X_distribution_id => l_detail_balances.distribution_id ,

Line 3699: igi_iac_det_balances_pkg.insert_row(

3695: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
3696:
3697: debug( g_state_level,l_path_name,'Inactive distributions');
3698: l_rowid := NULL ;
3699: igi_iac_det_balances_pkg.insert_row(
3700: X_rowid => l_rowid ,
3701: X_adjustment_id => l_retirement_adjustment_id ,
3702: X_asset_id => P_Asset_Id,
3703: X_distribution_id => l_detail_balances.distribution_id ,

Line 3967: igi_iac_det_balances_pkg.insert_row(

3963:
3964: l_detail_balances.net_book_value := l_detail_balances.adjustment_cost - l_detail_balances.deprn_reserve -l_detail_balances.deprn_reserve_backlog ;
3965:
3966: l_rowid := NULL ;
3967: igi_iac_det_balances_pkg.insert_row(
3968: X_rowid => l_rowid ,
3969: X_adjustment_id => l_retirement_adjustment_id ,
3970: X_asset_id => P_Asset_Id ,
3971: X_distribution_id => l_detail_balances.distribution_id,

Line 4040: igi_iac_det_balances_pkg.insert_row(

4036: x_mode => 'R');
4037: ELSE -- not impacted by retiretment -- active distribution
4038:
4039: l_rowid := NULL ;
4040: igi_iac_det_balances_pkg.insert_row(
4041: X_rowid => l_rowid ,
4042: X_adjustment_id => l_retirement_adjustment_id ,
4043: X_asset_id => P_Asset_Id ,
4044: X_distribution_id => l_detail_balances.distribution_id ,

Line 4093: igi_iac_det_balances_pkg.insert_row(

4089: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
4090:
4091: debug( g_state_level,l_path_name,'Inactive distributions');
4092: l_rowid := NULL ;
4093: igi_iac_det_balances_pkg.insert_row(
4094: X_rowid => l_rowid ,
4095: X_adjustment_id => l_retirement_adjustment_id ,
4096: X_asset_id => P_Asset_Id,
4097: X_distribution_id => l_detail_balances.distribution_id ,