APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 90: p_adj_hist IN igi_iac_adjustments_history%ROWTYPE)

86: END debug_adj_asset;
87:
88: FUNCTION Calculate_New_Balances( p_asset_iac_adj_info IN OUT NOCOPY igi_iac_types.iac_adj_hist_asset_info,
89: P_asset_balance IN OUT NOCOPY igi_iac_asset_balances%ROWTYPE,
90: p_adj_hist IN igi_iac_adjustments_history%ROWTYPE)
91: RETURN boolean IS
92:
93: CURSOR c_period_num_for_catchup IS
94: SELECT period_num_for_catchup

Line 448: p_adj_hist igi_iac_adjustments_history%ROWTYPE,

444:
445: FUNCTION Do_Expensed_Adj
446: (p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,
447: P_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,
448: p_adj_hist igi_iac_adjustments_history%ROWTYPE,
449: p_event_id number) --R12 uptake
450: RETURN BOOLEAN
451: IS
452:

Line 515: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

511: l_asset_balance_mvmt igi_iac_asset_balances%ROWTYPE;
512: l_curr_asset_balance igi_iac_asset_balances%ROWTYPE;
513: l_det_balances igi_iac_det_balances%ROWTYPE;
514: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
515: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
516: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
517: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
518: l_category_id fa_additions.asset_category_id%TYPE;
519: l_asset_units fa_additions.current_units%TYPE;

Line 516: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

512: l_curr_asset_balance igi_iac_asset_balances%ROWTYPE;
513: l_det_balances igi_iac_det_balances%ROWTYPE;
514: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
515: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
516: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
517: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
518: l_category_id fa_additions.asset_category_id%TYPE;
519: l_asset_units fa_additions.current_units%TYPE;
520: l_distribution_units fa_distribution_history.units_assigned%TYPE;

Line 517: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

513: l_det_balances igi_iac_det_balances%ROWTYPE;
514: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
515: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
516: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
517: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
518: l_category_id fa_additions.asset_category_id%TYPE;
519: l_asset_units fa_additions.current_units%TYPE;
520: l_distribution_units fa_distribution_history.units_assigned%TYPE;
521: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

Line 1351: p_string => ' Creating accounting entries in igi_iac_adjustments');

1347:
1348: /* Create accounting entries for non zero values*/
1349: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1350: p_full_path => l_path_name,
1351: p_string => ' Creating accounting entries in igi_iac_adjustments');
1352: IF l_current_db.deprn_reserve <> 0 THEN
1353: l_rowid := NULL ;
1354: igi_iac_adjustments_pkg.insert_row(
1355: X_rowid => l_rowid ,

Line 1354: igi_iac_adjustments_pkg.insert_row(

1350: p_full_path => l_path_name,
1351: p_string => ' Creating accounting entries in igi_iac_adjustments');
1352: IF l_current_db.deprn_reserve <> 0 THEN
1353: l_rowid := NULL ;
1354: igi_iac_adjustments_pkg.insert_row(
1355: X_rowid => l_rowid ,
1356: X_adjustment_id => l_adjustment_id ,
1357: X_book_type_code => l_det_balances.book_type_code ,
1358: X_code_combination_id => l_deprn_exp_ccid,

Line 1375: igi_iac_adjustments_pkg.insert_row(

1371: X_event_id => p_event_id
1372: ) ;
1373:
1374: l_rowid := NULL ;
1375: igi_iac_adjustments_pkg.insert_row(
1376: X_rowid => l_rowid ,
1377: X_adjustment_id => l_adjustment_id ,
1378: X_book_type_code => l_det_balances.book_type_code ,
1379: X_code_combination_id => l_deprn_rsv_ccid,

Line 1398: igi_iac_adjustments_pkg.insert_row(

1394: END IF;
1395:
1396: IF l_current_db.reval_reserve_gen_fund <> 0 THEN
1397: l_rowid := NULL ;
1398: igi_iac_adjustments_pkg.insert_row(
1399: X_rowid => l_rowid ,
1400: X_adjustment_id => l_adjustment_id ,
1401: X_book_type_code => l_det_balances.book_type_code ,
1402: X_code_combination_id => l_revl_rsv_ccid,

Line 1419: igi_iac_adjustments_pkg.insert_row(

1415: X_event_id => p_event_id
1416: ) ;
1417:
1418: l_rowid := NULL ;
1419: igi_iac_adjustments_pkg.insert_row(
1420: X_rowid => l_rowid ,
1421: X_adjustment_id => l_adjustment_id ,
1422: X_book_type_code => l_det_balances.book_type_code ,
1423: X_code_combination_id => l_gen_fund_ccid,

Line 1442: igi_iac_adjustments_pkg.insert_row(

1438: END IF;
1439:
1440: IF l_current_db.reval_reserve_backlog <> 0 THEN
1441: l_rowid := NULL;
1442: igi_iac_adjustments_pkg.insert_row(
1443: X_rowid => l_rowid ,
1444: X_adjustment_id => l_adjustment_id ,
1445: X_book_type_code => l_det_balances.book_type_code ,
1446: X_code_combination_id => l_blog_rsv_ccid,

Line 1464: igi_iac_adjustments_pkg.insert_row(

1460: ) ;
1461:
1462:
1463: l_rowid := NULL;
1464: igi_iac_adjustments_pkg.insert_row(
1465: X_rowid => l_rowid ,
1466: X_adjustment_id => l_adjustment_id ,
1467: X_book_type_code => l_det_balances.book_type_code ,
1468: X_code_combination_id => l_revl_rsv_ccid,

Line 1488: igi_iac_adjustments_pkg.insert_row(

1484: END IF;
1485:
1486: IF l_current_db.operating_acct_backlog <> 0 THEN
1487: l_rowid := NULL;
1488: igi_iac_adjustments_pkg.insert_row(
1489: X_rowid => l_rowid ,
1490: X_adjustment_id => l_adjustment_id ,
1491: X_book_type_code => l_det_balances.book_type_code ,
1492: X_code_combination_id => l_blog_rsv_ccid,

Line 1509: igi_iac_adjustments_pkg.insert_row(

1505: X_event_id => p_event_id
1506: ) ;
1507:
1508: l_rowid := NULL;
1509: igi_iac_adjustments_pkg.insert_row(
1510: X_rowid => l_rowid ,
1511: X_adjustment_id => l_adjustment_id ,
1512: X_book_type_code => l_det_balances.book_type_code ,
1513: X_code_combination_id => l_op_exp_ccid,