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_RXI_I_WRAP_ASSET_BAL dependencies on IGI_IAC_ASSET_REP_ITF

Line 909: INSERT INTO igi_iac_asset_rep_itf (

905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
908:
909: INSERT INTO igi_iac_asset_rep_itf (
910: request_id,
911: company_name,
912: book_type_code,
913: period,

Line 1417: INSERT INTO igi_iac_asset_rep_itf (

1413: IF l_parent_id IS NOT NULL THEN
1414: l_parent_no := l_asset_number;
1415: END IF;
1416:
1417: INSERT INTO igi_iac_asset_rep_itf (
1418: request_id,
1419: company_name,
1420: book_type_code,
1421: period,

Line 1810: INSERT INTO igi_iac_asset_rep_itf (

1806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
1809:
1810: INSERT INTO igi_iac_asset_rep_itf (
1811: request_id,
1812: company_name,
1813: book_type_code,
1814: period,

Line 2298: INSERT INTO igi_iac_asset_rep_itf (

2294: IF l_parent_id IS NOT NULL THEN
2295: l_parent_no := l_asset_number;
2296: END IF;
2297:
2298: INSERT INTO igi_iac_asset_rep_itf (
2299: request_id,
2300: company_name,
2301: book_type_code,
2302: period,

Line 2696: INSERT INTO igi_iac_asset_rep_itf (

2692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2693: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2695:
2696: INSERT INTO igi_iac_asset_rep_itf (
2697: request_id,
2698: company_name,
2699: book_type_code,
2700: period,

Line 3195: INSERT INTO igi_iac_asset_rep_itf (

3191: IF l_parent_id IS NOT NULL THEN
3192: l_parent_no := l_asset_number;
3193: END IF;
3194:
3195: INSERT INTO igi_iac_asset_rep_itf (
3196: request_id,
3197: company_name,
3198: book_type_code,
3199: period,

Line 3593: INSERT INTO igi_iac_asset_rep_itf (

3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3592:
3593: INSERT INTO igi_iac_asset_rep_itf (
3594: request_id,
3595: company_name,
3596: book_type_code,
3597: period,

Line 4092: INSERT INTO igi_iac_asset_rep_itf (

4088: IF l_parent_id IS NOT NULL THEN
4089: l_parent_no := l_asset_number;
4090: END IF;
4091:
4092: INSERT INTO igi_iac_asset_rep_itf (
4093: request_id,
4094: company_name,
4095: book_type_code,
4096: period,

Line 4202: DELETE FROM igi_iac_asset_rep_itf

4198: BEGIN
4199: l_path := g_path||'Delete_Zero_Rows';
4200: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting rows with all zero values');
4201: IF p_reptShrtName IN ('RXIGIIAK','RXIGIIAD') THEN
4202: DELETE FROM igi_iac_asset_rep_itf
4203: WHERE book_type_code = p_bookType
4204: AND request_id = p_request_id
4205: AND reval_cost = 0
4206: AND deprn_period = 0

Line 4212: DELETE FROM igi_iac_asset_rep_itf

4208: AND deprn_resv = 0
4209: AND deprn_backlog = 0
4210: AND deprn_total = 0;
4211: ELSIF p_reptShrtName IN ('RXIGIIAM','RXIGIIAO') THEN
4212: DELETE FROM igi_iac_asset_rep_itf
4213: WHERE book_type_code = p_bookType
4214: AND request_id = p_request_id
4215: AND reval_cost = 0
4216: AND oper_exp = 0

Line 4220: DELETE FROM igi_iac_asset_rep_itf

4216: AND oper_exp = 0
4217: AND oper_exp_backlog = 0
4218: AND oper_exp_net = 0;
4219: ELSIF p_reptShrtName IN ('RXIGIIAL','RXIGIIAR') THEN
4220: DELETE FROM igi_iac_asset_rep_itf
4221: WHERE book_type_code = p_bookType
4222: AND request_id = p_request_id
4223: AND reval_cost = 0
4224: AND reval_resv_cost = 0

Line 4229: DELETE FROM igi_iac_asset_rep_itf

4225: AND reval_resv_blog = 0
4226: AND reval_resv_gen_fund = 0
4227: AND reval_resv_net = 0;
4228: ELSIF p_reptShrtName IN ('RXIGIIAJ','RXIGIIAB') THEN
4229: DELETE FROM igi_iac_asset_rep_itf
4230: WHERE book_type_code = p_bookType
4231: AND request_id = p_request_id
4232: AND reval_cost = 0
4233: AND reval_reserve = 0