APPS.PER_CTK_INS dependencies on PER_CTK_INS

Line 1: Package Body per_ctk_ins as

1: Package Body per_ctk_ins as
2: /* $Header: pectkrhi.pkb 120.7 2006/09/11 20:45:03 sturlapa noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_ctk_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 26: per_ctk_ins.g_task_in_checklist_id_i := p_task_in_checklist_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_ctk_ins.g_task_in_checklist_id_i := p_task_in_checklist_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 281: per_ctk_ins.g_task_in_checklist_id_i;

277: Cursor C_Sel2 is
278: Select null
279: from per_tasks_in_checklist
280: where task_in_checklist_id =
281: per_ctk_ins.g_task_in_checklist_id_i;
282: --
283: cursor c_elig_prfl_dates(cur_p_elig_prfl_id number) is
284: select
285: effective_start_date

Line 312: If (per_ctk_ins.g_task_in_checklist_id_i is not null) Then

308: --
309: Begin
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: If (per_ctk_ins.g_task_in_checklist_id_i is not null) Then
313: --
314: -- Verify registered primary key values not already in use
315: --
316: Open C_Sel2;

Line 332: per_ctk_ins.g_task_in_checklist_id_i;

328: --
329: -- Use registered key values and clear globals
330: --
331: p_rec.task_in_checklist_id :=
332: per_ctk_ins.g_task_in_checklist_id_i;
333: per_ctk_ins.g_task_in_checklist_id_i := null;
334: Else
335: --
336: -- No registerd key values, so select the next sequence number

Line 333: per_ctk_ins.g_task_in_checklist_id_i := null;

329: -- Use registered key values and clear globals
330: --
331: p_rec.task_in_checklist_id :=
332: per_ctk_ins.g_task_in_checklist_id_i;
333: per_ctk_ins.g_task_in_checklist_id_i := null;
334: Else
335: --
336: -- No registerd key values, so select the next sequence number
337: --

Line 602: per_ctk_ins.pre_insert(p_rec

598: hr_multi_message.end_validation_set;
599: --
600: -- Call the supporting pre-insert operation
601: --
602: per_ctk_ins.pre_insert(p_rec
603: ,p_effective_date);
604: --
605: -- Insert the row
606: --

Line 607: per_ctk_ins.insert_dml(p_rec);

603: ,p_effective_date);
604: --
605: -- Insert the row
606: --
607: per_ctk_ins.insert_dml(p_rec);
608: --
609: -- Call the supporting post-insert operation
610: --
611: per_ctk_ins.post_insert

Line 611: per_ctk_ins.post_insert

607: per_ctk_ins.insert_dml(p_rec);
608: --
609: -- Call the supporting post-insert operation
610: --
611: per_ctk_ins.post_insert
612: (p_effective_date
613: ,p_rec
614: );
615: --

Line 755: per_ctk_ins.ins

751: --
752: -- Having converted the arguments into the per_ctk_rec
753: -- plsql record structure we call the corresponding record business process.
754: --
755: per_ctk_ins.ins
756: (p_effective_date
757: ,l_rec
758: );
759: --

Line 769: end per_ctk_ins;

765: --
766: hr_utility.set_location(' Leaving:'||l_proc, 10);
767: End ins;
768: --
769: end per_ctk_ins;