DBA Data[Home] [Help]

APPS.PER_CHECKLIST_ITEMS_API dependencies on PER_CHECKLIST_ITEMS

Line 1: Package Body per_checklist_items_api as

1: Package Body per_checklist_items_api as
2: /* $Header: pechkapi.pkb 115.12 2002/12/10 15:06:28 pkakar noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' per_checklist_items_api.';

2: /* $Header: pechkapi.pkb 115.12 2002/12/10 15:06:28 pkakar noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' per_checklist_items_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_checklist_items >----------------------|
10: -- ----------------------------------------------------------------------------

Line 59: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;

55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
60: l_proc varchar2(72) := g_package||'create_checklist_items';
61: l_object_version_number per_checklist_items.object_version_number%TYPE;
62: -- l_language_code hr_locations_all_tl.language%TYPE;
63: --

Line 61: l_object_version_number per_checklist_items.object_version_number%TYPE;

57: -- Declare cursors and local variables
58: --
59: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
60: l_proc varchar2(72) := g_package||'create_checklist_items';
61: l_object_version_number per_checklist_items.object_version_number%TYPE;
62: -- l_language_code hr_locations_all_tl.language%TYPE;
63: --
64: begin
65: --

Line 80: per_checklist_items_bk1.create_checklist_items_b

76: begin
77: --
78: -- Start of API User Hook for the before hook of create_checklist_items
79: --
80: per_checklist_items_bk1.create_checklist_items_b
81: (
82: p_effective_date => TRUNC(p_effective_date)
83: ,p_person_id => p_person_id
84: ,p_item_code => p_item_code

Line 181: per_checklist_items_bk1.create_checklist_items_a

177: begin
178: --
179: -- Start of API User Hook for the after hook of create_checklist_items
180: --
181: per_checklist_items_bk1.create_checklist_items_a
182: (
183: p_effective_date => TRUNC(p_effective_date)
184: ,p_person_id => p_person_id
185: ,p_item_code => p_item_code

Line 331: l_object_version_number per_checklist_items.object_version_number%TYPE;

327: --
328: -- Declare cursors and local variables
329: --
330: l_proc varchar2(72) := g_package||'update_checklist_items';
331: l_object_version_number per_checklist_items.object_version_number%TYPE;
332: l_temp_object_version_number per_checklist_items.object_version_number%TYPE;
333: --
334: begin
335: --

Line 332: l_temp_object_version_number per_checklist_items.object_version_number%TYPE;

328: -- Declare cursors and local variables
329: --
330: l_proc varchar2(72) := g_package||'update_checklist_items';
331: l_object_version_number per_checklist_items.object_version_number%TYPE;
332: l_temp_object_version_number per_checklist_items.object_version_number%TYPE;
333: --
334: begin
335: --
336: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 353: per_checklist_items_bk2.update_checklist_items_b

349: begin
350: --
351: -- Start of API User Hook for the before hook of update_checklist_items
352: --
353: per_checklist_items_bk2.update_checklist_items_b
354: (
355: p_effective_date => TRUNC(p_effective_date)
356: ,p_checklist_item_id => p_checklist_item_id
357: ,p_person_id => p_person_id

Line 455: per_checklist_items_bk2.update_checklist_items_a

451: begin
452: --
453: -- Start of API User Hook for the after hook of update_checklist_items
454: --
455: per_checklist_items_bk2.update_checklist_items_a
456: (
457: p_effective_date => TRUNC(p_effective_date)
458: ,p_checklist_item_id => p_checklist_item_id
459: ,p_person_id => p_person_id

Line 582: per_checklist_items_bk3.delete_checklist_items_b

578: begin
579: --
580: -- Start of API User Hook for the before hook of delete_checklist_items
581: --
582: per_checklist_items_bk3.delete_checklist_items_b
583: (
584: p_checklist_item_id => p_checklist_item_id
585: ,p_object_version_number => p_object_version_number
586: );

Line 608: per_checklist_items_bk3.delete_checklist_items_a

604: begin
605: --
606: -- Start of API User Hook for the after hook of delete_checklist_items
607: --
608: per_checklist_items_bk3.delete_checklist_items_a
609: (
610: p_checklist_item_id => p_checklist_item_id
611: ,p_object_version_number => p_object_version_number
612: );

Line 816: per_checklist_items_api.create_checklist_items

812: -- insert the data
813: --
814: hr_utility.set_location(l_proc, 50);
815: --
816: per_checklist_items_api.create_checklist_items
817: (p_validate => FALSE
818: ,p_effective_date => TRUNC(p_effective_date)
819: ,p_person_id => l_chk_rec.person_id
820: ,p_item_code => l_chk_rec.item_code

Line 877: per_checklist_items_api.update_checklist_items

873: -- update the data
874: --
875: hr_utility.set_location(l_proc, 90);
876: --
877: per_checklist_items_api.update_checklist_items
878: (p_validate => FALSE
879: ,p_effective_date => TRUNC(p_effective_date)
880: ,p_checklist_item_id => l_chk_rec.checklist_item_id
881: ,p_person_id => l_chk_rec.person_id

Line 953: end per_checklist_items_api;

949: raise;
950: --
951: end cre_or_upd_checklist_items;
952: --
953: end per_checklist_items_api;