APPS.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_MASS_REVALUATION_RULES

Line 203: g_char := 'Deleting fa_mass_revaluation_rules table';

199: ------------------------------------------------------------
200: g_step := 'DELETE_RULES';
201:
202: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
203: g_char := 'Deleting fa_mass_revaluation_rules table';
204: fnd_file.put_line (FND_FILE.LOG, g_char);
205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, g_char);
206: END IF;
207:

Line 208: DELETE FROM fa_mass_revaluation_rules

204: fnd_file.put_line (FND_FILE.LOG, g_char);
205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, g_char);
206: END IF;
207:
208: DELETE FROM fa_mass_revaluation_rules
209: Where mass_reval_id = p_mass_reval_id;
210:
211: ------------------------------------------------------------
212: -- Gives commit to delete transaction to release rollback --

Line 777: -- Creates a row in FA_MASS_REVALUATION_RULES that later --

773:
774: ------------------------------------------------------------
775: -- Procedure: create_revaluation_rule --
776: -- --
777: -- Creates a row in FA_MASS_REVALUATION_RULES that later --
778: -- will be the input to the Mass Revaluation Process. --
779: ------------------------------------------------------------
780: PROCEDURE create_revaluation_rule (p_mass_reval_id IN NUMBER
781: , p_asset_id IN NUMBER

Line 791: g_char := 'values inserted into fa_mass_revaluation_rules:';

787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
788: g_char := 'Procedure create_revaluation_rule(+)';
789: fnd_file.put_line (FND_FILE.LOG, g_char);
790: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, g_char);
791: g_char := 'values inserted into fa_mass_revaluation_rules:';
792: fnd_file.put_line (FND_FILE.LOG, g_char);
793: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, g_char);
794: g_char := 'asset id:'||to_char(p_asset_id)||
795: ' override_defaults_flag:'||'No'||

Line 813: INSERT INTO fa_mass_revaluation_rules

809: fnd_file.put_line (FND_FILE.LOG, g_char);
810: END IF;
811: END IF;
812:
813: INSERT INTO fa_mass_revaluation_rules
814: (mass_reval_id
815: , category_id
816: , asset_id
817: , reval_percent

Line 988: -- Insert a row in fa_mass_revaluation_rules for every asset--

984: , adjustable_assets_rec.cost
985: , adjustable_assets_rec.revaluation_start_date);
986:
987: --------------------------------------------------------------
988: -- Insert a row in fa_mass_revaluation_rules for every asset--
989: -- that can be inflation adjusted --
990: --------------------------------------------------------------
991:
992: create_revaluation_rule (p_mass_reval_id