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.FF_FFN_DEL dependencies on FF_FFN_SHD

Line 86: (p_rec in ff_ffn_shd.g_rec_type

82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in ff_ffn_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --

Line 94: ff_ffn_shd.g_api_dml := true; -- Set the api dml status

90: --
91: Begin
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: --
94: ff_ffn_shd.g_api_dml := true; -- Set the api dml status
95: --
96: -- Delete the ff_functions row.
97: --
98: delete from ff_functions

Line 101: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

97: --
98: delete from ff_functions
99: where function_id = p_rec.function_id;
100: --
101: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception

Line 108: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

104: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
109: ff_ffn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

Line 109: ff_ffn_shd.constraint_error

105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
109: ff_ffn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;

Line 112: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status

108: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
109: ff_ffn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End delete_dml;
115: --
116: -- ----------------------------------------------------------------------------

Line 148: Procedure pre_delete(p_rec in ff_ffn_shd.g_rec_type) is

144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in ff_ffn_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin

Line 190: Procedure post_delete(p_rec in ff_ffn_shd.g_rec_type) is

186: -- Internal Row Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- -----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in ff_ffn_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin

Line 207: => ff_ffn_shd.g_old_rec.business_group_id

203: ff_ffn_rkd.after_delete
204: (p_function_id
205: => p_rec.function_id
206: ,p_business_group_id_o
207: => ff_ffn_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => ff_ffn_shd.g_old_rec.legislation_code
210: ,p_class_o
211: => ff_ffn_shd.g_old_rec.class

Line 209: => ff_ffn_shd.g_old_rec.legislation_code

205: => p_rec.function_id
206: ,p_business_group_id_o
207: => ff_ffn_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => ff_ffn_shd.g_old_rec.legislation_code
210: ,p_class_o
211: => ff_ffn_shd.g_old_rec.class
212: ,p_name_o
213: => ff_ffn_shd.g_old_rec.name

Line 211: => ff_ffn_shd.g_old_rec.class

207: => ff_ffn_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => ff_ffn_shd.g_old_rec.legislation_code
210: ,p_class_o
211: => ff_ffn_shd.g_old_rec.class
212: ,p_name_o
213: => ff_ffn_shd.g_old_rec.name
214: ,p_alias_name_o
215: => ff_ffn_shd.g_old_rec.alias_name

Line 213: => ff_ffn_shd.g_old_rec.name

209: => ff_ffn_shd.g_old_rec.legislation_code
210: ,p_class_o
211: => ff_ffn_shd.g_old_rec.class
212: ,p_name_o
213: => ff_ffn_shd.g_old_rec.name
214: ,p_alias_name_o
215: => ff_ffn_shd.g_old_rec.alias_name
216: ,p_data_type_o
217: => ff_ffn_shd.g_old_rec.data_type

Line 215: => ff_ffn_shd.g_old_rec.alias_name

211: => ff_ffn_shd.g_old_rec.class
212: ,p_name_o
213: => ff_ffn_shd.g_old_rec.name
214: ,p_alias_name_o
215: => ff_ffn_shd.g_old_rec.alias_name
216: ,p_data_type_o
217: => ff_ffn_shd.g_old_rec.data_type
218: ,p_definition_o
219: => ff_ffn_shd.g_old_rec.definition

Line 217: => ff_ffn_shd.g_old_rec.data_type

213: => ff_ffn_shd.g_old_rec.name
214: ,p_alias_name_o
215: => ff_ffn_shd.g_old_rec.alias_name
216: ,p_data_type_o
217: => ff_ffn_shd.g_old_rec.data_type
218: ,p_definition_o
219: => ff_ffn_shd.g_old_rec.definition
220: ,p_description_o
221: => ff_ffn_shd.g_old_rec.description

Line 219: => ff_ffn_shd.g_old_rec.definition

215: => ff_ffn_shd.g_old_rec.alias_name
216: ,p_data_type_o
217: => ff_ffn_shd.g_old_rec.data_type
218: ,p_definition_o
219: => ff_ffn_shd.g_old_rec.definition
220: ,p_description_o
221: => ff_ffn_shd.g_old_rec.description
222: ,p_object_version_number_o
223: => ff_ffn_shd.g_old_rec.object_version_number

Line 221: => ff_ffn_shd.g_old_rec.description

217: => ff_ffn_shd.g_old_rec.data_type
218: ,p_definition_o
219: => ff_ffn_shd.g_old_rec.definition
220: ,p_description_o
221: => ff_ffn_shd.g_old_rec.description
222: ,p_object_version_number_o
223: => ff_ffn_shd.g_old_rec.object_version_number
224: );
225: --

Line 223: => ff_ffn_shd.g_old_rec.object_version_number

219: => ff_ffn_shd.g_old_rec.definition
220: ,p_description_o
221: => ff_ffn_shd.g_old_rec.description
222: ,p_object_version_number_o
223: => ff_ffn_shd.g_old_rec.object_version_number
224: );
225: --
226: exception
227: --

Line 243: (p_rec in ff_ffn_shd.g_rec_type

239: -- ----------------------------------------------------------------------------
240: -- |---------------------------------< del >----------------------------------|
241: -- ----------------------------------------------------------------------------
242: Procedure del
243: (p_rec in ff_ffn_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'del';
247: l_object_version_number ff_functions.object_version_number%type;

Line 288: ff_ffn_shd.lck

284: End Loop;
285: --
286: -- We must lock the row which we need to delete.
287: --
288: ff_ffn_shd.lck
289: (p_rec.function_id
290: ,p_rec.object_version_number
291: );
292: --

Line 325: l_rec ff_ffn_shd.g_rec_type;

321: (p_function_id in number
322: ,p_object_version_number in number
323: ) is
324: --
325: l_rec ff_ffn_shd.g_rec_type;
326: l_proc varchar2(72) := g_package||'del';
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);