APPS.IGI_IMP_IAC_TRANSFER_PKG dependencies on IGI_IMP_IAC_INTERFACE

Line 31: UPDATE igi_imp_iac_interface_ctrl ct

27: )
28: IS
29: BEGIN
30:
31: UPDATE igi_imp_iac_interface_ctrl ct
32: SET ct.transfer_status = p_status
33: WHERE ct.book_type_code = p_book_type_code
34: AND ct.category_id = p_category_id ;
35:

Line 51: FROM igi_imp_iac_interface ii

47: RETURN BOOLEAN AS
48: CURSOR C_Assets
49: IS
50: SELECT *
51: FROM igi_imp_iac_interface ii
52: WHERE ii.book_type_code = p_book_type_code
53: AND ii.category_id = p_Category_id
54: AND ii.transferred_flag = 'N'
55: AND nvl(ii.valid_flag,'N') = 'N';

Line 369: UPDATE igi_imp_iac_interface

365: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
366: p_full_path => g_path||'Validate_Assets',
367: p_string => 'Asset has valid values. Setting Valid_Flag to Y');
368:
369: UPDATE igi_imp_iac_interface
370: SET deprn_exp_mhca = l_deprn_exp_mhca,
371: general_fund_per_mhca = arec.deprn_exp_mhca - arec.deprn_exp_hist,
372: operating_account_mhca = (arec.operating_account_cost - arec.operating_account_backlog),
373: nbv_mhca = arec.cost_mhca - arec.accum_deprn_mhca - arec.backlog_mhca,

Line 532: UPDATE igi_imp_iac_interface

528: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
529: p_full_path => g_path||'Validate_Assets',
530: p_string => 'Asset has valid values. Setting Valid_Flag to Y');
531:
532: UPDATE igi_imp_iac_interface
533: SET deprn_exp_mhca = l_deprn_exp_mhca,
534: general_fund_per_mhca = arec.deprn_exp_mhca - arec.deprn_exp_hist,
535: operating_account_mhca = (arec.operating_account_cost - arec.operating_account_backlog),
536: nbv_mhca = arec.cost_mhca - arec.accum_deprn_mhca - arec.backlog_mhca,

Line 646: UPDATE igi_imp_iac_interface

642: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
643: p_full_path => g_path||'Validate_Assets',
644: p_string => 'Asset has valid values. Setting Valid_Flag to Y');
645:
646: UPDATE igi_imp_iac_interface
647: SET deprn_exp_mhca = arec.deprn_exp_hist,
648: operating_account_mhca = (arec.operating_account_cost - arec.operating_account_backlog),
649: nbv_mhca = arec.nbv_hist,
650: valid_flag = 'Y'

Line 1836: FROM igi_imp_iac_interface_ctrl ic

1832: p_event_id number) --R12 uptake
1833: IS
1834: CURSOR c_ctrl IS
1835: SELECT *
1836: FROM igi_imp_iac_interface_ctrl ic
1837: WHERE ic.book_type_code = p_book_type_code
1838: AND ic.category_id = p_Category_id ;
1839:
1840: CURSOR c_assets IS

Line 1842: FROM igi_imp_iac_interface ii

1838: AND ic.category_id = p_Category_id ;
1839:
1840: CURSOR c_assets IS
1841: SELECT *
1842: FROM igi_imp_iac_interface ii
1843: WHERE ii.book_type_code = p_book_type_code
1844: AND ii.category_id = p_Category_id
1845: AND ii.transferred_flag = 'N'
1846: AND ii.valid_flag = 'Y'; --Fix for Bug 5137813

Line 1864: from igi_imp_iac_interface_py_add

1860: AND rownum = 1 ;
1861:
1862: Cursor c_get_reval_factor( cp_book VARCHAR2,cp_asset_id number) is
1863: select current_reval_factor,cummulative_reval_factor
1864: from igi_imp_iac_interface_py_add
1865: where book_type_code = cp_book
1866: and asset_id =cp_asset_id;
1867:
1868:

Line 2728: UPDATE igi_imp_iac_interface --Fix for Bug 5137813

2724: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2725: p_full_path => g_path||'transfer_data',
2726: p_string => '>>Processed Asset ID : '|| arec.asset_id ) ;
2727:
2728: UPDATE igi_imp_iac_interface --Fix for Bug 5137813
2729: SET transferred_flag = 'Y'
2730: WHERE book_type_code = arec.book_type_code
2731: AND asset_id = arec.asset_id;
2732: