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_FFP_INS dependencies on FF_FFP_INS

Line 1: Package Body ff_ffp_ins as

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

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ff_ffp_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_ffp_ins.g_function_id_i := p_function_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ff_ffp_ins.g_function_id_i := p_function_id;
29: ff_ffp_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_ffp_ins.g_sequence_number_i := p_sequence_number;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ff_ffp_ins.g_function_id_i := p_function_id;
29: ff_ffp_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 187: ff_ffp_ins.g_function_id_i

183: Cursor C_Sel2 is
184: Select null
185: from ff_function_parameters
186: where function_id =
187: ff_ffp_ins.g_function_id_i
188: or sequence_number =
189: ff_ffp_ins.g_sequence_number_i;
190: --
191: l_proc varchar2(72) := g_package||'pre_insert';

Line 189: ff_ffp_ins.g_sequence_number_i;

185: from ff_function_parameters
186: where function_id =
187: ff_ffp_ins.g_function_id_i
188: or sequence_number =
189: ff_ffp_ins.g_sequence_number_i;
190: --
191: l_proc varchar2(72) := g_package||'pre_insert';
192: l_exists varchar2(1);
193: --

Line 197: If (ff_ffp_ins.g_function_id_i is not null or

193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: If (ff_ffp_ins.g_function_id_i is not null or
198: ff_ffp_ins.g_sequence_number_i is not null) Then
199: --
200: -- Verify registered primary key values not already in use
201: --

Line 198: ff_ffp_ins.g_sequence_number_i is not null) Then

194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: If (ff_ffp_ins.g_function_id_i is not null or
198: ff_ffp_ins.g_sequence_number_i is not null) Then
199: --
200: -- Verify registered primary key values not already in use
201: --
202: Open C_Sel2;

Line 218: ff_ffp_ins.g_function_id_i;

214: --
215: -- Use registered key values and clear globals
216: --
217: p_rec.function_id :=
218: ff_ffp_ins.g_function_id_i;
219: ff_ffp_ins.g_function_id_i := null;
220: p_rec.sequence_number :=
221: ff_ffp_ins.g_sequence_number_i;
222: ff_ffp_ins.g_sequence_number_i := null;

Line 219: ff_ffp_ins.g_function_id_i := null;

215: -- Use registered key values and clear globals
216: --
217: p_rec.function_id :=
218: ff_ffp_ins.g_function_id_i;
219: ff_ffp_ins.g_function_id_i := null;
220: p_rec.sequence_number :=
221: ff_ffp_ins.g_sequence_number_i;
222: ff_ffp_ins.g_sequence_number_i := null;
223: Else

Line 221: ff_ffp_ins.g_sequence_number_i;

217: p_rec.function_id :=
218: ff_ffp_ins.g_function_id_i;
219: ff_ffp_ins.g_function_id_i := null;
220: p_rec.sequence_number :=
221: ff_ffp_ins.g_sequence_number_i;
222: ff_ffp_ins.g_sequence_number_i := null;
223: Else
224: --
225: -- No registerd key values, so select the next sequence number

Line 222: ff_ffp_ins.g_sequence_number_i := null;

218: ff_ffp_ins.g_function_id_i;
219: ff_ffp_ins.g_function_id_i := null;
220: p_rec.sequence_number :=
221: ff_ffp_ins.g_sequence_number_i;
222: ff_ffp_ins.g_sequence_number_i := null;
223: Else
224: --
225: -- No registerd key values, so select the next sequence number
226: --

Line 339: ff_ffp_ins.pre_insert(p_rec);

335: hr_multi_message.end_validation_set;
336: --
337: -- Call the supporting pre-insert operation
338: --
339: ff_ffp_ins.pre_insert(p_rec);
340: --
341: -- Insert the row
342: --
343: ff_ffp_ins.insert_dml(p_rec);

Line 343: ff_ffp_ins.insert_dml(p_rec);

339: ff_ffp_ins.pre_insert(p_rec);
340: --
341: -- Insert the row
342: --
343: ff_ffp_ins.insert_dml(p_rec);
344: --
345: -- Call the supporting post-insert operation
346: --
347: ff_ffp_ins.post_insert

Line 347: ff_ffp_ins.post_insert

343: ff_ffp_ins.insert_dml(p_rec);
344: --
345: -- Call the supporting post-insert operation
346: --
347: ff_ffp_ins.post_insert
348: (p_effective_date
349: ,p_rec
350: );
351: --

Line 397: ff_ffp_ins.ins

393: --
394: -- Having converted the arguments into the ff_ffp_rec
395: -- plsql record structure we call the corresponding record business process.
396: --
397: ff_ffp_ins.ins
398: (p_effective_date
399: ,l_rec
400: );
401: --

Line 411: end ff_ffp_ins;

407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: End ins;
410: --
411: end ff_ffp_ins;