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_CCI_INS dependencies on OTA_CCI_INS

Line 1: Package Body ota_cci_ins as

1: Package Body ota_cci_ins as
2: /* $Header: otccirhi.pkb 120.1 2005/07/21 15:07 estreacy noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_cci_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: ota_cci_ins.g_category_usage_id_i := p_category_usage_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ota_cci_ins.g_category_usage_id_i := p_category_usage_id;
29: ota_cci_ins.g_certification_id_i := p_certification_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: ota_cci_ins.g_certification_id_i := p_certification_id;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ota_cci_ins.g_category_usage_id_i := p_category_usage_id;
29: ota_cci_ins.g_certification_id_i := p_certification_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 223: ota_cci_ins.g_category_usage_id_i

219: Cursor C_Sel2 is
220: Select null
221: from ota_cert_cat_inclusions
222: where category_usage_id =
223: ota_cci_ins.g_category_usage_id_i
224: or certification_id =
225: ota_cci_ins.g_certification_id_i;
226: */
227: --

Line 225: ota_cci_ins.g_certification_id_i;

221: from ota_cert_cat_inclusions
222: where category_usage_id =
223: ota_cci_ins.g_category_usage_id_i
224: or certification_id =
225: ota_cci_ins.g_certification_id_i;
226: */
227: --
228: l_proc varchar2(72) := g_package||'pre_insert';
229: l_exists varchar2(1);

Line 235: If (ota_cci_ins.g_category_usage_id_i is not null or

231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: /*
235: If (ota_cci_ins.g_category_usage_id_i is not null or
236: ota_cci_ins.g_certification_id_i is not null) Then
237: --
238: -- Verify registered primary key values not already in use
239: --

Line 236: ota_cci_ins.g_certification_id_i is not null) Then

232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: /*
235: If (ota_cci_ins.g_category_usage_id_i is not null or
236: ota_cci_ins.g_certification_id_i is not null) Then
237: --
238: -- Verify registered primary key values not already in use
239: --
240: Open C_Sel2;

Line 257: ota_cci_ins.g_category_usage_id_i;

253: */
254: -- Use registered key values and clear globals
255: --
256: p_rec.category_usage_id :=
257: ota_cci_ins.g_category_usage_id_i;
258: ota_cci_ins.g_category_usage_id_i := null;
259: p_rec.certification_id :=
260: ota_cci_ins.g_certification_id_i;
261: ota_cci_ins.g_certification_id_i := null;

Line 258: ota_cci_ins.g_category_usage_id_i := null;

254: -- Use registered key values and clear globals
255: --
256: p_rec.category_usage_id :=
257: ota_cci_ins.g_category_usage_id_i;
258: ota_cci_ins.g_category_usage_id_i := null;
259: p_rec.certification_id :=
260: ota_cci_ins.g_certification_id_i;
261: ota_cci_ins.g_certification_id_i := null;
262: /*

Line 260: ota_cci_ins.g_certification_id_i;

256: p_rec.category_usage_id :=
257: ota_cci_ins.g_category_usage_id_i;
258: ota_cci_ins.g_category_usage_id_i := null;
259: p_rec.certification_id :=
260: ota_cci_ins.g_certification_id_i;
261: ota_cci_ins.g_certification_id_i := null;
262: /*
263: Else
264: --

Line 261: ota_cci_ins.g_certification_id_i := null;

257: ota_cci_ins.g_category_usage_id_i;
258: ota_cci_ins.g_category_usage_id_i := null;
259: p_rec.certification_id :=
260: ota_cci_ins.g_certification_id_i;
261: ota_cci_ins.g_certification_id_i := null;
262: /*
263: Else
264: --
265: -- No registerd key values, so select the next sequence number

Line 412: ota_cci_ins.set_base_key_value(p_category_usage_id => l_category_usage_id

408:
409: l_certification_id := p_rec.certification_id;
410: l_category_usage_id := p_rec.category_usage_id;
411:
412: ota_cci_ins.set_base_key_value(p_category_usage_id => l_category_usage_id
413: ,p_certification_id => l_certification_id);
414: --
415: -- Call the supporting insert validate operations
416: --

Line 429: ota_cci_ins.pre_insert(p_rec);

425: hr_multi_message.end_validation_set;
426: --
427: -- Call the supporting pre-insert operation
428: --
429: ota_cci_ins.pre_insert(p_rec);
430: --
431: -- Insert the row
432: --
433: ota_cci_ins.insert_dml(p_rec);

Line 433: ota_cci_ins.insert_dml(p_rec);

429: ota_cci_ins.pre_insert(p_rec);
430: --
431: -- Insert the row
432: --
433: ota_cci_ins.insert_dml(p_rec);
434: --
435: -- Call the supporting post-insert operation
436: --
437: ota_cci_ins.post_insert

Line 437: ota_cci_ins.post_insert

433: ota_cci_ins.insert_dml(p_rec);
434: --
435: -- Call the supporting post-insert operation
436: --
437: ota_cci_ins.post_insert
438: (p_effective_date
439: ,p_rec
440: );
441: --

Line 527: ota_cci_ins.ins

523: --
524: -- Having converted the arguments into the ota_cci_rec
525: -- plsql record structure we call the corresponding record business process.
526: --
527: ota_cci_ins.ins
528: (p_effective_date
529: ,l_rec
530: );
531: --

Line 542: end ota_cci_ins;

538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: End ins;
541: --
542: end ota_cci_ins;