DBA Data[Home] [Help]

APPS.PQH_FR_VALIDATION_EVENTS_API dependencies on PQH_FR_VALIDATION_EVENTS

Line 1: Package Body PQH_FR_VALIDATION_EVENTS_API as

1: Package Body PQH_FR_VALIDATION_EVENTS_API as
2: /* $Header: pqvleapi.pkb 115.2 2002/12/05 00:31:10 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqvleapi.pkb 115.2 2002/12/05 00:31:10 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_FR_VALIDATION_EVENTS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< Insert_Validation_event >---------------------|
10: -- ----------------------------------------------------------------------------

Line 27: l_object_Version_Number PQH_FR_VALIDATION_EVENTS.OBJECT_VERSION_NUMBER%TYPE;

23: -- Declare cursors and local variables
24: --
25:
26: l_proc varchar2(72) := g_package||'Insert_Validation_event';
27: l_object_Version_Number PQH_FR_VALIDATION_EVENTS.OBJECT_VERSION_NUMBER%TYPE;
28: L_Effective_Date Date;
29: l_validation_event_id PQH_FR_VALIDATION_EVENTS.VALIDATION_EVENT_ID%TYPE;
30:
31:

Line 29: l_validation_event_id PQH_FR_VALIDATION_EVENTS.VALIDATION_EVENT_ID%TYPE;

25:
26: l_proc varchar2(72) := g_package||'Insert_Validation_event';
27: l_object_Version_Number PQH_FR_VALIDATION_EVENTS.OBJECT_VERSION_NUMBER%TYPE;
28: L_Effective_Date Date;
29: l_validation_event_id PQH_FR_VALIDATION_EVENTS.VALIDATION_EVENT_ID%TYPE;
30:
31:
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 46: PQH_FR_VALIDATION_EVENTS_BK1.Insert_Validation_event_b

42: --
43: -- Call Before Process User Hook
44: --
45: begin
46: PQH_FR_VALIDATION_EVENTS_BK1.Insert_Validation_event_b
47: (p_effective_date => l_effective_date
48: ,p_validation_id => p_validation_id
49: ,p_event_type => p_event_type
50: ,p_event_code => p_event_code

Line 59: (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'

55:
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'
60: ,p_hook_type => 'BP');
61: end;
62: --
63: -- Validation in addition to Row Handlers

Line 82: PQH_FR_VALIDATION_EVENTS_BK1.Insert_Validation_event_a

78: --
79: -- Call After Process User Hook
80: --
81: begin
82: PQH_FR_VALIDATION_EVENTS_BK1.Insert_Validation_event_a
83: (p_effective_date => l_effective_date
84: ,p_validation_id => p_validation_id
85: ,p_event_type => p_event_type
86: ,p_event_code => p_event_code

Line 94: (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'

90:
91: exception
92: when hr_api.cannot_find_prog_unit then
93: hr_api.cannot_find_prog_unit_error
94: (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'
95: ,p_hook_type => 'AP'
96: );
97: end;
98: --

Line 158: l_object_Version_Number PQH_FR_VALIDATION_EVENTS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

154: ,p_end_date in date default hr_api.g_date
155: ,p_comments in varchar2 default hr_api.g_varchar2) Is
156:
157: l_proc varchar2(72) := g_package||'Update_Validation_event';
158: l_object_Version_Number PQH_FR_VALIDATION_EVENTS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
159: L_Effective_Date Date;
160:
161: Begin
162: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 176: PQH_FR_VALIDATION_EVENTS_BK2.Update_Validation_event_b

172: -- Call Before Process User Hook
173: --
174: begin
175:
176: PQH_FR_VALIDATION_EVENTS_BK2.Update_Validation_event_b
177: (p_effective_date => l_effective_date
178: ,p_validation_event_id => p_validation_event_id
179: ,p_object_version_number => p_object_version_number
180: ,p_validation_id => p_validation_id

Line 212: PQH_FR_VALIDATION_EVENTS_BK2.Update_Validation_event_a

208: -- Call After Process User Hook
209: --
210: begin
211:
212: PQH_FR_VALIDATION_EVENTS_BK2.Update_Validation_event_a
213: (p_effective_date => l_effective_date
214: ,p_validation_event_id => p_validation_event_id
215: ,p_object_version_number => l_object_version_number
216: ,p_validation_id => p_validation_id

Line 292: PQH_FR_VALIDATION_EVENTS_BK3.Delete_Validation_event_b

288: --
289: -- Call Before Process User Hook
290: --
291: begin
292: PQH_FR_VALIDATION_EVENTS_BK3.Delete_Validation_event_b
293: (p_validation_event_id => p_validation_event_id
294: ,p_object_version_number => p_object_version_number
295: );
296: exception

Line 314: PQH_FR_VALIDATION_EVENTS_BK3.Delete_Validation_event_a

310: -- Call After Process User Hook
311: --
312: begin
313:
314: PQH_FR_VALIDATION_EVENTS_BK3.Delete_Validation_event_a
315: (p_validation_event_id => p_validation_event_id
316: ,p_object_version_number => p_object_version_number
317: );
318:

Line 357: end PQH_FR_VALIDATION_EVENTS_API;

353: hr_utility.set_location(' Leaving:'||l_proc, 90);
354: raise;
355: end delete_Validation_event;
356:
357: end PQH_FR_VALIDATION_EVENTS_API;