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 265: FROM fa_mass_revaluations rr

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

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

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

Line 878: UPDATE fa_mass_revaluations

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