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.PQH_FR_VALIDATION_PERIODS_API dependencies on PQH_FR_VALIDATION_PERIODS

Line 1: Package Body PQH_FR_VALIDATION_PERIODS_API as

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

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

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

Line 33: l_object_Version_Number PQH_FR_VALIDATION_PERIODS.OBJECT_VERSION_NUMBER%TYPE;

29: -- Declare cursors and local variables
30: --
31:
32: l_proc varchar2(72) := g_package||'Insert_Validation_Period';
33: l_object_Version_Number PQH_FR_VALIDATION_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
34: L_Effective_Date Date;
35: l_validation_period_id PQH_FR_VALIDATION_PERIODS.VALIDATION_PERIOD_ID%TYPE;
36:
37:

Line 35: l_validation_period_id PQH_FR_VALIDATION_PERIODS.VALIDATION_PERIOD_ID%TYPE;

31:
32: l_proc varchar2(72) := g_package||'Insert_Validation_Period';
33: l_object_Version_Number PQH_FR_VALIDATION_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
34: L_Effective_Date Date;
35: l_validation_period_id PQH_FR_VALIDATION_PERIODS.VALIDATION_PERIOD_ID%TYPE;
36:
37:
38: begin
39: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 52: PQH_FR_VALIDATION_PERIODS_BK1.Insert_Validation_Period_b

48: --
49: -- Call Before Process User Hook
50: --
51: begin
52: PQH_FR_VALIDATION_PERIODS_BK1.Insert_Validation_Period_b
53: (p_effective_date => l_effective_date
54: ,p_validation_id => p_validation_id
55: ,p_start_date => p_start_date
56: ,p_end_date => p_end_date

Line 72: (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'

68:
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'
73: ,p_hook_type => 'BP'
74: );
75: end;
76: --

Line 103: PQH_FR_VALIDATION_PERIODS_BK1.Insert_Validation_Period_a

99: --
100: -- Call After Process User Hook
101: --
102: begin
103: PQH_FR_VALIDATION_PERIODS_BK1.Insert_Validation_Period_a
104: (p_effective_date => l_effective_date
105: ,p_validation_id => p_validation_id
106: ,p_start_date => p_start_date
107: ,p_end_date => p_end_date

Line 121: (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'

117:
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'
122: ,p_hook_type => 'AP'
123: );
124: end;
125: --

Line 191: l_object_Version_Number PQH_FR_VALIDATION_PERIODS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

187: ,p_comments in varchar2 default hr_api.g_varchar2
188: ,p_validation_status in varchar2 default hr_api.g_varchar2) Is
189:
190: l_proc varchar2(72) := g_package||'Update_Validation_Period';
191: l_object_Version_Number PQH_FR_VALIDATION_PERIODS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
192: L_Effective_Date Date;
193:
194: Begin
195: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 209: PQH_FR_VALIDATION_PERIODS_BK2.Update_Validation_Period_b

205: -- Call Before Process User Hook
206: --
207: begin
208:
209: PQH_FR_VALIDATION_PERIODS_BK2.Update_Validation_Period_b
210: (p_effective_date => l_effective_date
211: ,p_validation_period_id => p_validation_period_id
212: ,p_object_version_number => p_object_version_number
213: ,p_validation_id => p_validation_id

Line 258: PQH_FR_VALIDATION_PERIODS_BK2.Update_Validation_Period_a

254: -- Call After Process User Hook
255: --
256: begin
257:
258: PQH_FR_VALIDATION_PERIODS_BK2.Update_Validation_Period_a
259: (p_effective_date => l_effective_date
260: ,p_validation_period_id => p_validation_period_id
261: ,p_object_version_number => l_object_version_number
262: ,p_validation_id => p_validation_id

Line 343: PQH_FR_VALIDATION_PERIODS_BK3.Delete_Validation_Period_b

339: --
340: -- Call Before Process User Hook
341: --
342: begin
343: PQH_FR_VALIDATION_PERIODS_BK3.Delete_Validation_Period_b
344: (p_validation_period_id => p_validation_period_id
345: ,p_object_version_number => p_object_version_number
346: );
347: exception

Line 366: PQH_FR_VALIDATION_PERIODS_BK3.Delete_Validation_Period_a

362: -- Call After Process User Hook
363: --
364: begin
365:
366: PQH_FR_VALIDATION_PERIODS_BK3.Delete_Validation_Period_a
367: (
368: p_validation_period_id => p_validation_period_id
369: ,p_object_version_number => p_object_version_number
370: );

Line 410: end PQH_FR_VALIDATION_PERIODS_API;

406: hr_utility.set_location(' Leaving:'||l_proc, 90);
407: raise;
408: end delete_Validation_period;
409:
410: end PQH_FR_VALIDATION_PERIODS_API;