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_CUS_INS dependencies on OTA_CUS_INS

Line 1: Package Body ota_cus_ins as

1: Package Body ota_cus_ins as
2: /* $Header: otcusrhi.pkb 120.0 2005/06/24 07:53 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_cus_ins.g_chat_id_i := p_chat_id;
31: ota_cus_ins.g_person_id_i := p_person_id;
32: ota_cus_ins.g_contact_id_i := p_contact_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 31: ota_cus_ins.g_person_id_i := p_person_id;

27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_cus_ins.g_chat_id_i := p_chat_id;
31: ota_cus_ins.g_person_id_i := p_person_id;
32: ota_cus_ins.g_contact_id_i := p_contact_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;

Line 32: ota_cus_ins.g_contact_id_i := p_contact_id;

28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_cus_ins.g_chat_id_i := p_chat_id;
31: ota_cus_ins.g_person_id_i := p_person_id;
32: ota_cus_ins.g_contact_id_i := p_contact_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --

Line 183: -- ota_cus_ins.g_chat_id_i

179: -- Cursor C_Sel2 is
180: -- Select null
181: -- from ota_chat_users
182: -- where chat_id =
183: -- ota_cus_ins.g_chat_id_i
184: -- or person_id =
185: -- ota_cus_ins.g_person_id_i
186: -- or contact_id =
187: -- ota_cus_ins.g_contact_id_i;

Line 185: -- ota_cus_ins.g_person_id_i

181: -- from ota_chat_users
182: -- where chat_id =
183: -- ota_cus_ins.g_chat_id_i
184: -- or person_id =
185: -- ota_cus_ins.g_person_id_i
186: -- or contact_id =
187: -- ota_cus_ins.g_contact_id_i;
188: --
189: l_proc varchar2(72) := g_package||'pre_insert';

Line 187: -- ota_cus_ins.g_contact_id_i;

183: -- ota_cus_ins.g_chat_id_i
184: -- or person_id =
185: -- ota_cus_ins.g_person_id_i
186: -- or contact_id =
187: -- ota_cus_ins.g_contact_id_i;
188: --
189: l_proc varchar2(72) := g_package||'pre_insert';
190: -- l_exists varchar2(1);
191: --

Line 195: -- If (ota_cus_ins.g_chat_id_i is not null or

191: --
192: Begin
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: -- If (ota_cus_ins.g_chat_id_i is not null or
196: -- ota_cus_ins.g_person_id_i is not null or
197: -- ota_cus_ins.g_contact_id_i is not null) Then
198: --
199: -- Verify registered primary key values not already in use

Line 196: -- ota_cus_ins.g_person_id_i is not null or

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

Line 197: -- ota_cus_ins.g_contact_id_i is not null) Then

193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: -- If (ota_cus_ins.g_chat_id_i is not null or
196: -- ota_cus_ins.g_person_id_i is not null or
197: -- ota_cus_ins.g_contact_id_i is not null) Then
198: --
199: -- Verify registered primary key values not already in use
200: --
201: -- Open C_Sel2;

Line 217: -- ota_cus_ins.g_chat_id_i;

213: --
214: -- Use registered key values and clear globals
215: --
216: -- p_rec.chat_id :=
217: -- ota_cus_ins.g_chat_id_i;
218: -- ota_cus_ins.g_chat_id_i := null;
219: -- p_rec.person_id :=
220: -- ota_cus_ins.g_person_id_i;
221: -- ota_cus_ins.g_person_id_i := null;

Line 218: -- ota_cus_ins.g_chat_id_i := null;

214: -- Use registered key values and clear globals
215: --
216: -- p_rec.chat_id :=
217: -- ota_cus_ins.g_chat_id_i;
218: -- ota_cus_ins.g_chat_id_i := null;
219: -- p_rec.person_id :=
220: -- ota_cus_ins.g_person_id_i;
221: -- ota_cus_ins.g_person_id_i := null;
222: -- p_rec.contact_id :=

Line 220: -- ota_cus_ins.g_person_id_i;

216: -- p_rec.chat_id :=
217: -- ota_cus_ins.g_chat_id_i;
218: -- ota_cus_ins.g_chat_id_i := null;
219: -- p_rec.person_id :=
220: -- ota_cus_ins.g_person_id_i;
221: -- ota_cus_ins.g_person_id_i := null;
222: -- p_rec.contact_id :=
223: -- ota_cus_ins.g_contact_id_i;
224: -- ota_cus_ins.g_contact_id_i := null;

Line 221: -- ota_cus_ins.g_person_id_i := null;

217: -- ota_cus_ins.g_chat_id_i;
218: -- ota_cus_ins.g_chat_id_i := null;
219: -- p_rec.person_id :=
220: -- ota_cus_ins.g_person_id_i;
221: -- ota_cus_ins.g_person_id_i := null;
222: -- p_rec.contact_id :=
223: -- ota_cus_ins.g_contact_id_i;
224: -- ota_cus_ins.g_contact_id_i := null;
225: -- Else

Line 223: -- ota_cus_ins.g_contact_id_i;

219: -- p_rec.person_id :=
220: -- ota_cus_ins.g_person_id_i;
221: -- ota_cus_ins.g_person_id_i := null;
222: -- p_rec.contact_id :=
223: -- ota_cus_ins.g_contact_id_i;
224: -- ota_cus_ins.g_contact_id_i := null;
225: -- Else
226: --
227: -- No registerd key values, so select the next sequence number

Line 224: -- ota_cus_ins.g_contact_id_i := null;

220: -- ota_cus_ins.g_person_id_i;
221: -- ota_cus_ins.g_person_id_i := null;
222: -- p_rec.contact_id :=
223: -- ota_cus_ins.g_contact_id_i;
224: -- ota_cus_ins.g_contact_id_i := null;
225: -- Else
226: --
227: -- No registerd key values, so select the next sequence number
228: --

Line 334: ota_cus_ins.set_base_key_value(l_chat_id, l_person_id, l_contact_id);

330: l_chat_id := p_rec.chat_id;
331: l_person_id := p_rec.person_id;
332: l_contact_id := p_rec.contact_id;
333:
334: ota_cus_ins.set_base_key_value(l_chat_id, l_person_id, l_contact_id);
335:
336: ota_cus_bus.insert_validate
337: (p_effective_date
338: ,l_chat_id

Line 349: ota_cus_ins.pre_insert(p_rec);

345: hr_multi_message.end_validation_set;
346: --
347: -- Call the supporting pre-insert operation
348: --
349: ota_cus_ins.pre_insert(p_rec);
350: --
351: -- Insert the row
352: --
353: ota_cus_ins.insert_dml(p_rec);

Line 353: ota_cus_ins.insert_dml(p_rec);

349: ota_cus_ins.pre_insert(p_rec);
350: --
351: -- Insert the row
352: --
353: ota_cus_ins.insert_dml(p_rec);
354: --
355: -- Call the supporting post-insert operation
356: --
357: ota_cus_ins.post_insert

Line 357: ota_cus_ins.post_insert

353: ota_cus_ins.insert_dml(p_rec);
354: --
355: -- Call the supporting post-insert operation
356: --
357: ota_cus_ins.post_insert
358: (p_effective_date
359: ,p_rec
360: );
361: --

Line 403: ota_cus_ins.ins

399: --
400: -- Having converted the arguments into the ota_cus_rec
401: -- plsql record structure we call the corresponding record business process.
402: --
403: ota_cus_ins.ins
404: (p_effective_date
405: ,l_rec
406: );
407: --

Line 419: end ota_cus_ins;

415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: End ins;
418: --
419: end ota_cus_ins;