APPS.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_MASS_REVALUATIONS

Line 68: g_reval_fully_rsvd_flag FA_MASS_REVALUATIONS.DEFAULT_REVAL_FULLY_RSVD_FLAG%TYPE;

64: g_char VARCHAR2 (200);
65: g_revalue_cip_assets_flag VARCHAR2(1);
66: --Bug3466346
67: -- g_reval_fully_rsvd_flag VARCHAR2(1);
68: g_reval_fully_rsvd_flag FA_MASS_REVALUATIONS.DEFAULT_REVAL_FULLY_RSVD_FLAG%TYPE;
69: g_life_extension_factor FA_MASS_REVALUATIONS.DEFAULT_LIFE_EXTENSION_FACTOR%TYPE;
70: g_life_extension_ceiling FA_MASS_REVALUATIONS.DEFAULT_LIFE_EXTENSION_CEILING%TYPE;
71:
72: g_period_open_date DATE;

Line 69: g_life_extension_factor FA_MASS_REVALUATIONS.DEFAULT_LIFE_EXTENSION_FACTOR%TYPE;

65: g_revalue_cip_assets_flag VARCHAR2(1);
66: --Bug3466346
67: -- g_reval_fully_rsvd_flag VARCHAR2(1);
68: g_reval_fully_rsvd_flag FA_MASS_REVALUATIONS.DEFAULT_REVAL_FULLY_RSVD_FLAG%TYPE;
69: g_life_extension_factor FA_MASS_REVALUATIONS.DEFAULT_LIFE_EXTENSION_FACTOR%TYPE;
70: g_life_extension_ceiling FA_MASS_REVALUATIONS.DEFAULT_LIFE_EXTENSION_CEILING%TYPE;
71:
72: g_period_open_date DATE;
73: TOO_MANY_COSTS EXCEPTION;

Line 70: g_life_extension_ceiling FA_MASS_REVALUATIONS.DEFAULT_LIFE_EXTENSION_CEILING%TYPE;

66: --Bug3466346
67: -- g_reval_fully_rsvd_flag VARCHAR2(1);
68: g_reval_fully_rsvd_flag FA_MASS_REVALUATIONS.DEFAULT_REVAL_FULLY_RSVD_FLAG%TYPE;
69: g_life_extension_factor FA_MASS_REVALUATIONS.DEFAULT_LIFE_EXTENSION_FACTOR%TYPE;
70: g_life_extension_ceiling FA_MASS_REVALUATIONS.DEFAULT_LIFE_EXTENSION_CEILING%TYPE;
71:
72: g_period_open_date DATE;
73: TOO_MANY_COSTS EXCEPTION;
74:

Line 267: FROM fa_mass_revaluations rr

263: g_revalue_cip_assets_flag,
264: g_reval_fully_rsvd_flag,
265: g_life_extension_factor,
266: g_life_extension_ceiling
267: FROM fa_mass_revaluations rr
268: WHERE rr.mass_reval_id = p_mass_reval_id;
269: EXCEPTION WHEN OTHERS THEN
270: g_char := 'Error: Mass Revaluation Id : '||to_char(p_mass_reval_id)||SQLERRM;
271: fnd_file.put_line (FND_FILE.LOG, g_char);

Line 855: -- It also updates fa_mass_revaluations table to indicate --

851: -- Procedure: update_control_tables --
852: -- --
853: -- Update depreciation book to indicate that was revalued --
854: -- in the current period. --
855: -- It also updates fa_mass_revaluations table to indicate --
856: -- in wich period revaluation has been run. --
857: ------------------------------------------------------------
858: PROCEDURE update_control_tables (p_mass_reval_id IN NUMBER) IS
859:

Line 880: UPDATE fa_mass_revaluations

876: WHERE book_type_code = p_book_type_code;
877:
878: -- Update commented to fix bug 1013530
879: /*
880: UPDATE fa_mass_revaluations
881: SET global_attribute1 = g_current_period_counter1
882: WHERE mass_reval_id = p_mass_reval_id;
883: */
884: