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.FA_SORP_UPG_PKG dependencies on FA_SORP_UPG_IMPREVAL

Line 1814: FUNCTION fa_sorp_upg_impreval_mc_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1810: ROLLBACK;
1811: RETURN FALSE;
1812: END fa_sorp_upg_cagf_fn;
1813:
1814: FUNCTION fa_sorp_upg_impreval_mc_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1815: RETURN BOOLEAN
1816: IS
1817: v_impairment_id NUMBER;
1818: v_mass_reval_id NUMBER;

Line 1938: FROM fa_sorp_upg_impreval

1934: CURSOR c_final_imp_asset_cur
1935: IS
1936: SELECT ID, impairment_id, imp_description, imp_class_type,
1937: imp_amount, book_type_code
1938: FROM fa_sorp_upg_impreval
1939: WHERE transaction_type = 'Impairment' AND id_type = 'A';
1940:
1941: v_final_imp_asset_cur c_final_imp_asset_cur%ROWTYPE;
1942:

Line 1947: FROM fa_sorp_upg_impreval

1943: CURSOR c_final_imp_cash_cur
1944: IS
1945: SELECT ID, impairment_id, imp_description, imp_class_type,
1946: imp_amount, book_type_code
1947: FROM fa_sorp_upg_impreval
1948: WHERE transaction_type = 'Impairment' AND id_type = 'C';
1949:
1950: v_final_imp_cash_cur c_final_imp_cash_cur%ROWTYPE;
1951:

Line 1955: FROM fa_sorp_upg_impreval

1951:
1952: CURSOR c_final_reval_asset_cur
1953: IS
1954: SELECT mass_reval_id, ID, reval_reason, book_type_code
1955: FROM fa_sorp_upg_impreval
1956: WHERE transaction_type = 'Revaluation' AND asset_category_id IS NULL;
1957:
1958: v_final_reval_asset_cur c_final_reval_asset_cur%ROWTYPE;
1959:

Line 1964: FROM fa_sorp_upg_impreval

1960: CURSOR c_final_reval_cat_cur
1961: IS
1962: SELECT mass_reval_id, asset_category_id category_id, reval_reason,
1963: book_type_code
1964: FROM fa_sorp_upg_impreval
1965: WHERE transaction_type = 'Revaluation' AND ID IS NULL;
1966:
1967: v_final_reval_cat_cur c_final_reval_cat_cur%ROWTYPE;
1968:

Line 1987: from fa_sorp_upg_impreval;

1983: reval_reason,
1984: book_type_code,
1985: report_mode,
1986: id_type
1987: from fa_sorp_upg_impreval;
1988:
1989: v_srp_upg_impreval_hist_cur c_srp_upg_impreval_hist_cur%rowtype;
1990:
1991: l_request_id number;

Line 1999: DELETE FROM fa_sorp_upg_impreval;

1995: l_general_fund_amount number;
1996: l_counter number;
1997:
1998: BEGIN
1999: DELETE FROM fa_sorp_upg_impreval;
2000:
2001: COMMIT;
2002:
2003: l_request_id := fnd_global.conc_request_id;

Line 2005: p_from := 'fa_sorp_upg_impreval';

2001: COMMIT;
2002:
2003: l_request_id := fnd_global.conc_request_id;
2004:
2005: p_from := 'fa_sorp_upg_impreval';
2006: p_where := ' and 1=1';
2007:
2008: P_REQUEST_WHERE := ' AND REQUEST_ID <> '||l_request_id;
2009:

Line 2013: from fa_sorp_upg_impreval_hist

2009:
2010:
2011:
2012: select count(1) into v_final_cnt
2013: from fa_sorp_upg_impreval_hist
2014: where book_type_code = p_book
2015: and report_mode = p_mode;
2016:
2017: IF v_final_cnt = 0 then

Line 2034: INSERT INTO fa_sorp_upg_impreval

2030:
2031: FETCH c_imp_itf_asset_cur
2032: INTO v_imp_itf_asset_cur;
2033:
2034: INSERT INTO fa_sorp_upg_impreval
2035: (transaction_type,
2036: ID,
2037: NAME,
2038: description,

Line 2084: INSERT INTO fa_sorp_upg_impreval

2080:
2081: FETCH c_imp_itf_cash_cur
2082: INTO v_imp_itf_cash_cur;
2083:
2084: INSERT INTO fa_sorp_upg_impreval
2085: (transaction_type,
2086: ID,
2087: NAME,
2088: description,

Line 2133: INSERT INTO fa_sorp_upg_impreval

2129: INTO v_reval_asset_cur;
2130:
2131: EXIT WHEN c_reval_asset_cur%NOTFOUND;
2132:
2133: INSERT INTO fa_sorp_upg_impreval
2134: (transaction_type,
2135: ID,
2136: NAME,
2137: description,

Line 2160: INSERT INTO fa_sorp_upg_impreval

2156: INTO v_reval_cat_cur;
2157:
2158: EXIT WHEN c_reval_cat_cur%NOTFOUND;
2159:
2160: INSERT INTO fa_sorp_upg_impreval
2161: (transaction_type,
2162: asset_category_id,
2163: category_name, mass_reval_id,
2164: reval_percent, reval_reason,

Line 2302: INSERT INTO fa_sorp_upg_impreval_hist

2298: loop
2299: fetch c_srp_upg_impreval_hist_cur into v_srp_upg_impreval_hist_cur;
2300: exit when c_srp_upg_impreval_hist_cur%notfound;
2301:
2302: INSERT INTO fa_sorp_upg_impreval_hist
2303: (transaction_type ,
2304: id,
2305: name,
2306: description,

Line 2344: p_from := 'fa_sorp_upg_impreval_hist';

2340: end loop;
2341: close c_srp_upg_impreval_hist_cur;
2342: END IF;
2343: ELSE -- v_final_cnt = 0
2344: p_from := 'fa_sorp_upg_impreval_hist';
2345: p_where := ' and book_type_code = '||''''||p_book||''''||' and report_mode ='||''''||p_mode||'''';
2346: END IF;
2347:
2348:

Line 2356: END fa_sorp_upg_impreval_mc_fn;

2352: WHEN OTHERS
2353: THEN
2354: ROLLBACK;
2355: RETURN FALSE;
2356: END fa_sorp_upg_impreval_mc_fn;
2357:
2358: FUNCTION fa_sorp_upg_impreval_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
2359: RETURN BOOLEAN
2360: IS

Line 2358: FUNCTION fa_sorp_upg_impreval_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

2354: ROLLBACK;
2355: RETURN FALSE;
2356: END fa_sorp_upg_impreval_mc_fn;
2357:
2358: FUNCTION fa_sorp_upg_impreval_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
2359: RETURN BOOLEAN
2360: IS
2361: v_impairment_id NUMBER;
2362: v_mass_reval_id NUMBER;

Line 2484: FROM fa_sorp_upg_impreval

2480: CURSOR c_final_imp_asset_cur
2481: IS
2482: SELECT ID, impairment_id, imp_description, imp_class_type,
2483: imp_amount, book_type_code
2484: FROM fa_sorp_upg_impreval
2485: WHERE transaction_type = 'Impairment' AND id_type = 'A';
2486:
2487: v_final_imp_asset_cur c_final_imp_asset_cur%ROWTYPE;
2488:

Line 2493: FROM fa_sorp_upg_impreval

2489: CURSOR c_final_imp_cash_cur
2490: IS
2491: SELECT ID, impairment_id, imp_description, imp_class_type,
2492: imp_amount, book_type_code
2493: FROM fa_sorp_upg_impreval
2494: WHERE transaction_type = 'Impairment' AND id_type = 'C';
2495:
2496: v_final_imp_cash_cur c_final_imp_cash_cur%ROWTYPE;
2497:

Line 2501: FROM fa_sorp_upg_impreval

2497:
2498: CURSOR c_final_reval_asset_cur
2499: IS
2500: SELECT mass_reval_id, ID, reval_reason, book_type_code
2501: FROM fa_sorp_upg_impreval
2502: WHERE transaction_type = 'Revaluation' AND asset_category_id IS NULL;
2503:
2504: v_final_reval_asset_cur c_final_reval_asset_cur%ROWTYPE;
2505:

Line 2510: FROM fa_sorp_upg_impreval

2506: CURSOR c_final_reval_cat_cur
2507: IS
2508: SELECT mass_reval_id, asset_category_id category_id, reval_reason,
2509: book_type_code
2510: FROM fa_sorp_upg_impreval
2511: WHERE transaction_type = 'Revaluation' AND ID IS NULL;
2512:
2513: v_final_reval_cat_cur c_final_reval_cat_cur%ROWTYPE;
2514:

Line 2533: from fa_sorp_upg_impreval;

2529: reval_reason,
2530: book_type_code,
2531: report_mode,
2532: id_type
2533: from fa_sorp_upg_impreval;
2534:
2535: v_srp_upg_impreval_hist_cur c_srp_upg_impreval_hist_cur%rowtype;
2536:
2537: l_request_id number;

Line 2548: DELETE FROM fa_sorp_upg_impreval;

2544: BEGIN
2545:
2546: if not fa_sorp_upg_mc_flag(p_book) then
2547:
2548: DELETE FROM fa_sorp_upg_impreval;
2549:
2550: COMMIT;
2551:
2552: l_request_id := fnd_global.conc_request_id;

Line 2554: p_from := 'fa_sorp_upg_impreval';

2550: COMMIT;
2551:
2552: l_request_id := fnd_global.conc_request_id;
2553:
2554: p_from := 'fa_sorp_upg_impreval';
2555: p_where := ' and 1=1';
2556:
2557: P_REQUEST_WHERE := ' AND REQUEST_ID <> '||l_request_id;
2558:

Line 2562: from fa_sorp_upg_impreval_hist

2558:
2559:
2560:
2561: select count(1) into v_final_cnt
2562: from fa_sorp_upg_impreval_hist
2563: where book_type_code = p_book
2564: and report_mode = p_mode;
2565:
2566: IF v_final_cnt = 0 then

Line 2583: INSERT INTO fa_sorp_upg_impreval

2579:
2580: FETCH c_imp_itf_asset_cur
2581: INTO v_imp_itf_asset_cur;
2582:
2583: INSERT INTO fa_sorp_upg_impreval
2584: (transaction_type,
2585: ID,
2586: NAME,
2587: description,

Line 2633: INSERT INTO fa_sorp_upg_impreval

2629:
2630: FETCH c_imp_itf_cash_cur
2631: INTO v_imp_itf_cash_cur;
2632:
2633: INSERT INTO fa_sorp_upg_impreval
2634: (transaction_type,
2635: ID,
2636: NAME,
2637: description,

Line 2682: INSERT INTO fa_sorp_upg_impreval

2678: INTO v_reval_asset_cur;
2679:
2680: EXIT WHEN c_reval_asset_cur%NOTFOUND;
2681:
2682: INSERT INTO fa_sorp_upg_impreval
2683: (transaction_type,
2684: ID,
2685: NAME,
2686: description,

Line 2709: INSERT INTO fa_sorp_upg_impreval

2705: INTO v_reval_cat_cur;
2706:
2707: EXIT WHEN c_reval_cat_cur%NOTFOUND;
2708:
2709: INSERT INTO fa_sorp_upg_impreval
2710: (transaction_type,
2711: asset_category_id,
2712: category_name, mass_reval_id,
2713: reval_percent, reval_reason,

Line 2849: INSERT INTO fa_sorp_upg_impreval_hist

2845: loop
2846: fetch c_srp_upg_impreval_hist_cur into v_srp_upg_impreval_hist_cur;
2847: exit when c_srp_upg_impreval_hist_cur%notfound;
2848:
2849: INSERT INTO fa_sorp_upg_impreval_hist
2850: (transaction_type ,
2851: id,
2852: name,
2853: description,

Line 2891: p_from := 'fa_sorp_upg_impreval_hist';

2887: end loop;
2888: close c_srp_upg_impreval_hist_cur;
2889: END IF;
2890: ELSE -- v_final_cnt = 0
2891: p_from := 'fa_sorp_upg_impreval_hist';
2892: p_where := ' and book_type_code = '||''''||p_book||''''||' and report_mode ='||''''||p_mode||'''';
2893: END IF;
2894:
2895:

Line 2901: v_boolean := fa_sorp_upg_impreval_mc_fn(p_book,p_mode);

2897: RETURN TRUE;
2898:
2899: else
2900:
2901: v_boolean := fa_sorp_upg_impreval_mc_fn(p_book,p_mode);
2902: IF V_BOOLEAN THEN
2903: RETURN TRUE;
2904: ELSE
2905: RETURN FALSE;

Line 2915: END fa_sorp_upg_impreval_fn;

2911: WHEN OTHERS
2912: THEN
2913: ROLLBACK;
2914: RETURN FALSE;
2915: END fa_sorp_upg_impreval_fn;
2916:
2917:
2918: END fa_sorp_upg_pkg;