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.OTA_FOI_INS dependencies on OTA_FOI_INS

Line 1: Package Body ota_foi_ins as

1: Package Body ota_foi_ins as
2: /* $Header: otfoirhi.pkb 120.3 2005/08/12 02:45 pchandra noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_foi_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 30: ota_foi_ins.g_forum_id_i := p_forum_id;

26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_foi_ins.g_forum_id_i := p_forum_id;
31: ota_foi_ins.g_object_id_i := p_object_id;
32: ota_foi_ins.g_object_type_i := p_object_type;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 31: ota_foi_ins.g_object_id_i := p_object_id;

27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_foi_ins.g_forum_id_i := p_forum_id;
31: ota_foi_ins.g_object_id_i := p_object_id;
32: ota_foi_ins.g_object_type_i := p_object_type;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;

Line 32: ota_foi_ins.g_object_type_i := p_object_type;

28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_foi_ins.g_forum_id_i := p_forum_id;
31: ota_foi_ins.g_object_id_i := p_object_id;
32: ota_foi_ins.g_object_type_i := p_object_type;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --

Line 186: ota_foi_ins.g_forum_id_i

182: Cursor C_Sel2 is
183: Select null
184: from ota_frm_obj_inclusions
185: where forum_id =
186: ota_foi_ins.g_forum_id_i
187: or object_id =
188: ota_foi_ins.g_object_id_i
189: or object_type =
190: ota_foi_ins.g_object_type_i;

Line 188: ota_foi_ins.g_object_id_i

184: from ota_frm_obj_inclusions
185: where forum_id =
186: ota_foi_ins.g_forum_id_i
187: or object_id =
188: ota_foi_ins.g_object_id_i
189: or object_type =
190: ota_foi_ins.g_object_type_i;
191: --
192: */

Line 190: ota_foi_ins.g_object_type_i;

186: ota_foi_ins.g_forum_id_i
187: or object_id =
188: ota_foi_ins.g_object_id_i
189: or object_type =
190: ota_foi_ins.g_object_type_i;
191: --
192: */
193: l_proc varchar2(72) := g_package||'pre_insert';
194: l_exists varchar2(1);

Line 200: If (ota_foi_ins.g_forum_id_i is not null or

196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: /*
200: If (ota_foi_ins.g_forum_id_i is not null or
201: ota_foi_ins.g_object_id_i is not null or
202: ota_foi_ins.g_object_type_i is not null) Then
203: --
204: -- Verify registered primary key values not already in use

Line 201: ota_foi_ins.g_object_id_i is not null or

197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: /*
200: If (ota_foi_ins.g_forum_id_i is not null or
201: ota_foi_ins.g_object_id_i is not null or
202: ota_foi_ins.g_object_type_i is not null) Then
203: --
204: -- Verify registered primary key values not already in use
205: --

Line 202: ota_foi_ins.g_object_type_i is not null) Then

198: --
199: /*
200: If (ota_foi_ins.g_forum_id_i is not null or
201: ota_foi_ins.g_object_id_i is not null or
202: ota_foi_ins.g_object_type_i is not null) Then
203: --
204: -- Verify registered primary key values not already in use
205: --
206: Open C_Sel2;

Line 222: ota_foi_ins.g_forum_id_i;

218: --
219: -- Use registered key values and clear globals
220: --
221: p_rec.forum_id :=
222: ota_foi_ins.g_forum_id_i;
223: ota_foi_ins.g_forum_id_i := null;
224: p_rec.object_id :=
225: ota_foi_ins.g_object_id_i;
226: ota_foi_ins.g_object_id_i := null;

Line 223: ota_foi_ins.g_forum_id_i := null;

219: -- Use registered key values and clear globals
220: --
221: p_rec.forum_id :=
222: ota_foi_ins.g_forum_id_i;
223: ota_foi_ins.g_forum_id_i := null;
224: p_rec.object_id :=
225: ota_foi_ins.g_object_id_i;
226: ota_foi_ins.g_object_id_i := null;
227: p_rec.object_type :=

Line 225: ota_foi_ins.g_object_id_i;

221: p_rec.forum_id :=
222: ota_foi_ins.g_forum_id_i;
223: ota_foi_ins.g_forum_id_i := null;
224: p_rec.object_id :=
225: ota_foi_ins.g_object_id_i;
226: ota_foi_ins.g_object_id_i := null;
227: p_rec.object_type :=
228: ota_foi_ins.g_object_type_i;
229: ota_foi_ins.g_object_type_i := null;

Line 226: ota_foi_ins.g_object_id_i := null;

222: ota_foi_ins.g_forum_id_i;
223: ota_foi_ins.g_forum_id_i := null;
224: p_rec.object_id :=
225: ota_foi_ins.g_object_id_i;
226: ota_foi_ins.g_object_id_i := null;
227: p_rec.object_type :=
228: ota_foi_ins.g_object_type_i;
229: ota_foi_ins.g_object_type_i := null;
230: Else

Line 228: ota_foi_ins.g_object_type_i;

224: p_rec.object_id :=
225: ota_foi_ins.g_object_id_i;
226: ota_foi_ins.g_object_id_i := null;
227: p_rec.object_type :=
228: ota_foi_ins.g_object_type_i;
229: ota_foi_ins.g_object_type_i := null;
230: Else
231: --
232: -- No registerd key values, so select the next sequence number

Line 229: ota_foi_ins.g_object_type_i := null;

225: ota_foi_ins.g_object_id_i;
226: ota_foi_ins.g_object_id_i := null;
227: p_rec.object_type :=
228: ota_foi_ins.g_object_type_i;
229: ota_foi_ins.g_object_type_i := null;
230: Else
231: --
232: -- No registerd key values, so select the next sequence number
233: --

Line 345: ota_foi_ins.set_base_key_value( p_forum_id => l_forum_id

341: /*p_rec.forum_id := null;
342: p_rec.object_id := null;
343: p_rec.object_type := null;*/
344:
345: ota_foi_ins.set_base_key_value( p_forum_id => l_forum_id
346: ,p_object_id => l_object_id
347: ,p_object_type => l_object_type
348: );
349:

Line 366: ota_foi_ins.pre_insert(p_rec);

362: hr_multi_message.end_validation_set;
363: --
364: -- Call the supporting pre-insert operation
365: --
366: ota_foi_ins.pre_insert(p_rec);
367: --
368: -- Insert the row
369: --
370: ota_foi_ins.insert_dml(p_rec);

Line 370: ota_foi_ins.insert_dml(p_rec);

366: ota_foi_ins.pre_insert(p_rec);
367: --
368: -- Insert the row
369: --
370: ota_foi_ins.insert_dml(p_rec);
371: --
372: -- Call the supporting post-insert operation
373: --
374: ota_foi_ins.post_insert

Line 374: ota_foi_ins.post_insert

370: ota_foi_ins.insert_dml(p_rec);
371: --
372: -- Call the supporting post-insert operation
373: --
374: ota_foi_ins.post_insert
375: (p_effective_date
376: ,p_rec
377: );
378: --

Line 428: ota_foi_ins.ins

424: --
425: -- Having converted the arguments into the ota_foi_rec
426: -- plsql record structure we call the corresponding record business process.
427: --
428: ota_foi_ins.ins
429: (p_effective_date
430: ,l_rec
431: );
432: --

Line 445: end ota_foi_ins;

441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 10);
443: End ins;
444: --
445: end ota_foi_ins;