APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 113: p_adj_hist IN igi_iac_adjustments_history%ROWTYPE)

109: END debug_adj_asset;
110:
111: FUNCTION Calculate_New_Balances( p_asset_iac_adj_info IN OUT NOCOPY igi_iac_types.iac_adj_hist_asset_info,
112: P_asset_balance IN OUT NOCOPY igi_iac_asset_balances%ROWTYPE,
113: p_adj_hist IN igi_iac_adjustments_history%ROWTYPE)
114: RETURN boolean IS
115:
116: CURSOR c_period_num_for_catchup IS
117: SELECT period_num_for_catchup

Line 477: p_adj_hist igi_iac_adjustments_history%ROWTYPE,

473:
474: FUNCTION Do_Expensed_Adj
475: (p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,
476: P_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,
477: p_adj_hist igi_iac_adjustments_history%ROWTYPE,
478: p_event_id number) --R12 uptake
479: RETURN BOOLEAN
480: IS
481:

Line 544: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

540: l_asset_balance_mvmt igi_iac_asset_balances%ROWTYPE;
541: l_curr_asset_balance igi_iac_asset_balances%ROWTYPE;
542: l_det_balances igi_iac_det_balances%ROWTYPE;
543: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
544: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
545: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
546: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
547: l_category_id fa_additions.asset_category_id%TYPE;
548: l_asset_units fa_additions.current_units%TYPE;

Line 545: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

541: l_curr_asset_balance igi_iac_asset_balances%ROWTYPE;
542: l_det_balances igi_iac_det_balances%ROWTYPE;
543: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
544: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
545: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
546: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
547: l_category_id fa_additions.asset_category_id%TYPE;
548: l_asset_units fa_additions.current_units%TYPE;
549: l_distribution_units fa_distribution_history.units_assigned%TYPE;

Line 546: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

542: l_det_balances igi_iac_det_balances%ROWTYPE;
543: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
544: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
545: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
546: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
547: l_category_id fa_additions.asset_category_id%TYPE;
548: l_asset_units fa_additions.current_units%TYPE;
549: l_distribution_units fa_distribution_history.units_assigned%TYPE;
550: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

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

1398:
1399: /* Create accounting entries for non zero values*/
1400: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1401: p_full_path => l_path_name,
1402: p_string => ' Creating accounting entries in igi_iac_adjustments');
1403: IF l_current_db.deprn_reserve <> 0 THEN
1404: l_rowid := NULL ;
1405: igi_iac_adjustments_pkg.insert_row(
1406: X_rowid => l_rowid ,

Line 1405: igi_iac_adjustments_pkg.insert_row(

1401: p_full_path => l_path_name,
1402: p_string => ' Creating accounting entries in igi_iac_adjustments');
1403: IF l_current_db.deprn_reserve <> 0 THEN
1404: l_rowid := NULL ;
1405: igi_iac_adjustments_pkg.insert_row(
1406: X_rowid => l_rowid ,
1407: X_adjustment_id => l_adjustment_id ,
1408: X_book_type_code => l_det_balances.book_type_code ,
1409: X_code_combination_id => l_deprn_exp_ccid,

Line 1426: igi_iac_adjustments_pkg.insert_row(

1422: X_event_id => p_event_id
1423: ) ;
1424:
1425: l_rowid := NULL ;
1426: igi_iac_adjustments_pkg.insert_row(
1427: X_rowid => l_rowid ,
1428: X_adjustment_id => l_adjustment_id ,
1429: X_book_type_code => l_det_balances.book_type_code ,
1430: X_code_combination_id => l_deprn_rsv_ccid,

Line 1449: igi_iac_adjustments_pkg.insert_row(

1445: END IF;
1446:
1447: IF l_current_db.reval_reserve_gen_fund <> 0 THEN
1448: l_rowid := NULL ;
1449: igi_iac_adjustments_pkg.insert_row(
1450: X_rowid => l_rowid ,
1451: X_adjustment_id => l_adjustment_id ,
1452: X_book_type_code => l_det_balances.book_type_code ,
1453: X_code_combination_id => l_revl_rsv_ccid,

Line 1470: igi_iac_adjustments_pkg.insert_row(

1466: X_event_id => p_event_id
1467: ) ;
1468:
1469: l_rowid := NULL ;
1470: igi_iac_adjustments_pkg.insert_row(
1471: X_rowid => l_rowid ,
1472: X_adjustment_id => l_adjustment_id ,
1473: X_book_type_code => l_det_balances.book_type_code ,
1474: X_code_combination_id => l_gen_fund_ccid,

Line 1493: igi_iac_adjustments_pkg.insert_row(

1489: END IF;
1490:
1491: IF l_current_db.reval_reserve_backlog <> 0 THEN
1492: l_rowid := NULL;
1493: igi_iac_adjustments_pkg.insert_row(
1494: X_rowid => l_rowid ,
1495: X_adjustment_id => l_adjustment_id ,
1496: X_book_type_code => l_det_balances.book_type_code ,
1497: X_code_combination_id => l_blog_rsv_ccid,

Line 1515: igi_iac_adjustments_pkg.insert_row(

1511: ) ;
1512:
1513:
1514: l_rowid := NULL;
1515: igi_iac_adjustments_pkg.insert_row(
1516: X_rowid => l_rowid ,
1517: X_adjustment_id => l_adjustment_id ,
1518: X_book_type_code => l_det_balances.book_type_code ,
1519: X_code_combination_id => l_revl_rsv_ccid,

Line 1539: igi_iac_adjustments_pkg.insert_row(

1535: END IF;
1536:
1537: IF l_current_db.operating_acct_backlog <> 0 THEN
1538: l_rowid := NULL;
1539: igi_iac_adjustments_pkg.insert_row(
1540: X_rowid => l_rowid ,
1541: X_adjustment_id => l_adjustment_id ,
1542: X_book_type_code => l_det_balances.book_type_code ,
1543: X_code_combination_id => l_blog_rsv_ccid,

Line 1560: igi_iac_adjustments_pkg.insert_row(

1556: X_event_id => p_event_id
1557: ) ;
1558:
1559: l_rowid := NULL;
1560: igi_iac_adjustments_pkg.insert_row(
1561: X_rowid => l_rowid ,
1562: X_adjustment_id => l_adjustment_id ,
1563: X_book_type_code => l_det_balances.book_type_code ,
1564: X_code_combination_id => l_op_exp_ccid,