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_FCU_INS dependencies on FF_FCU_INS

Line 1: Package Body ff_fcu_ins as

1: Package Body ff_fcu_ins as
2: /* $Header: fffcurhi.pkb 120.1 2005/10/05 01:51 adkumar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ff_fcu_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ff_fcu_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 28: ff_fcu_ins.g_function_id_i := p_function_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ff_fcu_ins.g_function_id_i := p_function_id;
29: ff_fcu_ins.g_sequence_number_i := p_sequence_number;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: ff_fcu_ins.g_sequence_number_i := p_sequence_number;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ff_fcu_ins.g_function_id_i := p_function_id;
29: ff_fcu_ins.g_sequence_number_i := p_sequence_number;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 181: ff_fcu_ins.g_function_id_i

177: Cursor C_Sel2 is
178: Select null
179: from ff_function_context_usages
180: where function_id =
181: ff_fcu_ins.g_function_id_i
182: or sequence_number =
183: ff_fcu_ins.g_sequence_number_i;
184: --
185: l_proc varchar2(72) := g_package||'pre_insert';

Line 183: ff_fcu_ins.g_sequence_number_i;

179: from ff_function_context_usages
180: where function_id =
181: ff_fcu_ins.g_function_id_i
182: or sequence_number =
183: ff_fcu_ins.g_sequence_number_i;
184: --
185: l_proc varchar2(72) := g_package||'pre_insert';
186: l_exists varchar2(1);
187: --

Line 191: If (ff_fcu_ins.g_function_id_i is not null and

187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: If (ff_fcu_ins.g_function_id_i is not null and
192: ff_fcu_ins.g_sequence_number_i is not null) Then
193: --
194: -- Verify registered primary key values not already in use
195: --

Line 192: ff_fcu_ins.g_sequence_number_i is not null) Then

188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: If (ff_fcu_ins.g_function_id_i is not null and
192: ff_fcu_ins.g_sequence_number_i is not null) Then
193: --
194: -- Verify registered primary key values not already in use
195: --
196: Open C_Sel2;

Line 212: ff_fcu_ins.g_function_id_i;

208: --
209: -- Use registered key values and clear globals
210: --
211: p_rec.function_id :=
212: ff_fcu_ins.g_function_id_i;
213: ff_fcu_ins.g_function_id_i := null;
214: p_rec.sequence_number :=
215: ff_fcu_ins.g_sequence_number_i;
216: ff_fcu_ins.g_sequence_number_i := null;

Line 213: ff_fcu_ins.g_function_id_i := null;

209: -- Use registered key values and clear globals
210: --
211: p_rec.function_id :=
212: ff_fcu_ins.g_function_id_i;
213: ff_fcu_ins.g_function_id_i := null;
214: p_rec.sequence_number :=
215: ff_fcu_ins.g_sequence_number_i;
216: ff_fcu_ins.g_sequence_number_i := null;
217: Else

Line 215: ff_fcu_ins.g_sequence_number_i;

211: p_rec.function_id :=
212: ff_fcu_ins.g_function_id_i;
213: ff_fcu_ins.g_function_id_i := null;
214: p_rec.sequence_number :=
215: ff_fcu_ins.g_sequence_number_i;
216: ff_fcu_ins.g_sequence_number_i := null;
217: Else
218: --
219: -- No registerd key values, so select the next sequence number

Line 216: ff_fcu_ins.g_sequence_number_i := null;

212: ff_fcu_ins.g_function_id_i;
213: ff_fcu_ins.g_function_id_i := null;
214: p_rec.sequence_number :=
215: ff_fcu_ins.g_sequence_number_i;
216: ff_fcu_ins.g_sequence_number_i := null;
217: Else
218: --
219: -- No registerd key values, so select the next sequence number
220: --

Line 317: ff_fcu_ins.pre_insert(p_rec);

313: hr_multi_message.end_validation_set;
314: --
315: -- Call the supporting pre-insert operation
316: --
317: ff_fcu_ins.pre_insert(p_rec);
318: --
319: -- Insert the row
320: --
321: ff_fcu_ins.insert_dml(p_rec);

Line 321: ff_fcu_ins.insert_dml(p_rec);

317: ff_fcu_ins.pre_insert(p_rec);
318: --
319: -- Insert the row
320: --
321: ff_fcu_ins.insert_dml(p_rec);
322: --
323: -- Call the supporting post-insert operation
324: --
325: ff_fcu_ins.post_insert

Line 325: ff_fcu_ins.post_insert

321: ff_fcu_ins.insert_dml(p_rec);
322: --
323: -- Call the supporting post-insert operation
324: --
325: ff_fcu_ins.post_insert
326: (p_rec
327: );
328: --
329: -- Call to raise any errors on multi-message list

Line 366: ff_fcu_ins.ins

362: --
363: -- Having converted the arguments into the ff_fcu_rec
364: -- plsql record structure we call the corresponding record business process.
365: --
366: ff_fcu_ins.ins
367: (l_rec
368: );
369: --
370: -- As the primary key argument(s)

Line 380: end ff_fcu_ins;

376: --
377: hr_utility.set_location(' Leaving:'||l_proc, 10);
378: End ins;
379: --
380: end ff_fcu_ins;