APPS.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_MASS_REVALUATION_RULES

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

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

Line 206: DELETE FROM fa_mass_revaluation_rules

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

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

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

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

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

Line 811: INSERT INTO fa_mass_revaluation_rules

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

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

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