APPS.PQH_FR_VALIDATIONS_API dependencies on PQH_FR_VALIDATIONS

Line 1: Package Body PQH_FR_VALIDATIONS_API as

1: Package Body PQH_FR_VALIDATIONS_API as
2: /* $Header: pqvldapi.pkb 115.3 2002/12/05 00:30:53 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqvldapi.pkb 115.3 2002/12/05 00:30:53 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_FR_VALIDATIONS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< Insert_Validation >------------------------|
10: -- ----------------------------------------------------------------------------

Line 38: l_object_Version_Number PQH_FR_VALIDATIONS.OBJECT_VERSION_NUMBER%TYPE;

34: -- Declare cursors and local variables
35: --
36:
37: l_proc varchar2(72) := g_package||'Insert_Validation';
38: l_object_Version_Number PQH_FR_VALIDATIONS.OBJECT_VERSION_NUMBER%TYPE;
39: L_Effective_Date Date;
40: l_validation_id PQH_FR_VALIDATIONS.VALIDATION_ID%TYPE;
41:
42:

Line 40: l_validation_id PQH_FR_VALIDATIONS.VALIDATION_ID%TYPE;

36:
37: l_proc varchar2(72) := g_package||'Insert_Validation';
38: l_object_Version_Number PQH_FR_VALIDATIONS.OBJECT_VERSION_NUMBER%TYPE;
39: L_Effective_Date Date;
40: l_validation_id PQH_FR_VALIDATIONS.VALIDATION_ID%TYPE;
41:
42:
43: begin
44: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 57: PQH_FR_VALIDATIONS_BK1.Insert_Validation_b

53: --
54: -- Call Before Process User Hook
55: --
56: begin
57: PQH_FR_VALIDATIONS_BK1.Insert_Validation_b
58: (p_effective_date => l_effective_date
59: ,p_pension_fund_type_code => p_pension_fund_type_code
60: ,p_pension_fund_id => p_pension_fund_id
61: ,p_business_group_id => p_business_group_id

Line 81: (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'

77:
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'
82: ,p_hook_type => 'BP'
83: );
84: end;
85: --

Line 117: PQH_FR_VALIDATIONS_BK1.Insert_Validation_a

113: --
114: -- Call After Process User Hook
115: --
116: begin
117: PQH_FR_VALIDATIONS_BK1.Insert_Validation_a
118: (
119: p_effective_date => l_effective_date
120: ,p_pension_fund_type_code => p_pension_fund_type_code
121: ,p_pension_fund_id => p_pension_fund_id

Line 141: (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'

137:
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'
142: ,p_hook_type => 'AP'
143: );
144: end;
145: --

Line 217: l_object_Version_Number PQH_FR_VALIDATIONS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

213: ,p_percent_of_salary in number
214: ) Is
215:
216: l_proc varchar2(72) := g_package||'Update_Validation';
217: l_object_Version_Number PQH_FR_VALIDATIONS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
218: L_Effective_Date Date;
219:
220: Begin
221: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 235: PQH_FR_VALIDATIONS_BK2.Update_Validation_b

231: -- Call Before Process User Hook
232: --
233: begin
234:
235: PQH_FR_VALIDATIONS_BK2.Update_Validation_b
236: (
237: p_effective_date => l_effective_date
238: ,p_validation_id => p_validation_id
239: ,p_object_version_number => l_object_version_number

Line 295: PQH_FR_VALIDATIONS_BK2.Update_Validation_a

291: -- Call After Process User Hook
292: --
293: begin
294:
295: PQH_FR_VALIDATIONS_BK2.Update_Validation_a
296: (
297: p_effective_date => l_effective_date
298: ,p_validation_id => p_validation_id
299: ,p_object_version_number => l_object_version_number

Line 388: PQH_FR_VALIDATIONS_BK3.Delete_Validation_b

384: --
385: -- Call Before Process User Hook
386: --
387: begin
388: PQH_FR_VALIDATIONS_BK3.Delete_Validation_b
389: (
390: p_validation_id => p_validation_id
391: ,p_object_version_number => p_object_version_number
392: );

Line 412: PQH_FR_VALIDATIONS_BK3.Delete_Validation_a

408: -- Call After Process User Hook
409: --
410: begin
411:
412: PQH_FR_VALIDATIONS_BK3.Delete_Validation_a
413: (
414: p_validation_id => p_validation_id
415: ,p_object_version_number => p_object_version_number
416: );

Line 456: end PQH_FR_VALIDATIONS_API;

452: hr_utility.set_location(' Leaving:'||l_proc, 90);
453: raise;
454: end delete_Validation;
455:
456: end PQH_FR_VALIDATIONS_API;