APPS.OTA_COI_INS dependencies on OTA_COI_INS

Line 1: Package Body ota_coi_ins as

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

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_coi_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_coi_ins.g_chat_id_i := p_chat_id;

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

Line 31: ota_coi_ins.g_object_id_i := p_object_id;

27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_coi_ins.g_chat_id_i := p_chat_id;
31: ota_coi_ins.g_object_id_i := p_object_id;
32: ota_coi_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_coi_ins.g_object_type_i := p_object_type;

28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_coi_ins.g_chat_id_i := p_chat_id;
31: ota_coi_ins.g_object_id_i := p_object_id;
32: ota_coi_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 185: -- ota_coi_ins.g_chat_id_i

181: -- Cursor C_Sel2 is
182: -- Select null
183: -- from ota_chat_obj_inclusions
184: -- where chat_id =
185: -- ota_coi_ins.g_chat_id_i
186: -- or object_id =
187: -- ota_coi_ins.g_object_id_i
188: -- or object_type =
189: -- ota_coi_ins.g_object_type_i;

Line 187: -- ota_coi_ins.g_object_id_i

183: -- from ota_chat_obj_inclusions
184: -- where chat_id =
185: -- ota_coi_ins.g_chat_id_i
186: -- or object_id =
187: -- ota_coi_ins.g_object_id_i
188: -- or object_type =
189: -- ota_coi_ins.g_object_type_i;
190: --
191: l_proc varchar2(72) := g_package||'pre_insert';

Line 189: -- ota_coi_ins.g_object_type_i;

185: -- ota_coi_ins.g_chat_id_i
186: -- or object_id =
187: -- ota_coi_ins.g_object_id_i
188: -- or object_type =
189: -- ota_coi_ins.g_object_type_i;
190: --
191: l_proc varchar2(72) := g_package||'pre_insert';
192: --l_exists varchar2(1);
193: --

Line 296: ota_coi_ins.set_base_key_value(l_chat_id,l_object_id,l_object_type);

292: -- p_rec.chat_id := null;
293: -- p_rec.object_id := null;
294: -- p_rec.object_type := null;
295:
296: ota_coi_ins.set_base_key_value(l_chat_id,l_object_id,l_object_type);
297: --
298: -- Call the supporting insert validate operations
299: --
300: ota_coi_bus.insert_validate

Line 313: ota_coi_ins.pre_insert(p_rec);

309: hr_multi_message.end_validation_set;
310: --
311: -- Call the supporting pre-insert operation
312: --
313: ota_coi_ins.pre_insert(p_rec);
314: --
315: -- Insert the row
316: --
317: ota_coi_ins.insert_dml(p_rec);

Line 317: ota_coi_ins.insert_dml(p_rec);

313: ota_coi_ins.pre_insert(p_rec);
314: --
315: -- Insert the row
316: --
317: ota_coi_ins.insert_dml(p_rec);
318: --
319: -- Call the supporting post-insert operation
320: --
321: ota_coi_ins.post_insert

Line 321: ota_coi_ins.post_insert

317: ota_coi_ins.insert_dml(p_rec);
318: --
319: -- Call the supporting post-insert operation
320: --
321: ota_coi_ins.post_insert
322: (p_effective_date
323: ,p_rec
324: );
325: --

Line 369: ota_coi_ins.ins

365: --
366: -- Having converted the arguments into the ota_coi_rec
367: -- plsql record structure we call the corresponding record business process.
368: --
369: ota_coi_ins.ins
370: (p_effective_date
371: ,l_rec
372: );
373: --

Line 385: end ota_coi_ins;

381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 10);
383: End ins;
384: --
385: end ota_coi_ins;