[Home] [Help]
12: PROCEDURE
13: FADPTX_INSERT
14:
15: DESCRIPTION
16: This procedure insert the data to interim table:FA_DEPRN_TAX_REP_ITF.
17: ===========================================================================*/
18:
19: procedure fadptx_insert (
20: errbuf out nocopy varchar2,
461: and ffvs.flex_value_set_name = 'Vision FA State'
462: and ffvt.language = 'US'
463: and flex_value between p_state_from and p_state_to
464: and ffv.flex_value not in (select distinct state
465: from fa_deprn_Tax_rep_itf
466: where request_id = p_request_id)
467: and ffv.flex_value in (select fdta.code
468: from fa_deprn_tax_entities fdte,
469: fa_deprn_tax_Authorities fdta
2262: /* bug 2082460 */
2263: h_adddec_description := substrb(h_adddec_description,1,30);
2264: h_all_description := substrb(h_all_description,1,30);
2265:
2266: /* Insert end date's data to FA_DEPRN_TAX_REP_ITF */
2267:
2268: IF (g_print_debug) THEN
2269: fa_rx_util_pkg.debug ('fadptx_insert: ' || 'h_state_flag :'||h_state_flag);
2270: END IF;
2269: fa_rx_util_pkg.debug ('fadptx_insert: ' || 'h_state_flag :'||h_state_flag);
2270: END IF;
2271:
2272: -- bug#2629893
2273: -- For FA_DEPRN_TAX_REP_ITF, insert and update date for state ranages.
2274: -- For FA_DEPRN_TAX_REP_NBVS, insert and update date for all states.
2275:
2276: --Start for 9935602
2277:
2304: END IF;
2305:
2306: --End for 9935602
2307:
2308: Insert into FA_DEPRN_TAX_REP_ITF (
2309: REQUEST_ID,
2310: YEAR,
2311: ASSET_ID,
2312: ASSET_NUMBER,
2607: END IF;
2608:
2609: --End for 9935602
2610:
2611: INSERT INTO FA_DEPRN_TAX_REP_ITF(
2612: request_id,
2613: year,
2614: book_type_code,
2615: state,
2693: p_id_flex_num => cat_flex_struct,
2694: p_qualifier => h_tax_asset_type_segment,
2695: p_data => TO_CHAR(l_tax_type_cntr));
2696:
2697: Insert into FA_DEPRN_TAX_REP_ITF (
2698: REQUEST_ID,
2699: YEAR,
2700: ASSET_ID,
2701: ASSET_NUMBER,
2787: h_login_id,
2788: NULL,
2789: NULL
2790: FROM dual
2791: WHERE NOT EXISTS (SELECT 1 FROM fa_deprn_tax_rep_itf
2792: WHERE request_id=h_request_id
2793: and year=h_year
2794: and state=state_code_v(l_local_cntr)
2795: and tax_asset_type=TO_CHAR(l_tax_type_cntr));