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_RATE_ELEMENT_RELATIONS_API dependencies on PQH_RATE_ELEMENT_RELATIONS

Line 1: Package Body PQH_RATE_ELEMENT_RELATIONS_API as

1: Package Body PQH_RATE_ELEMENT_RELATIONS_API as
2: /* $Header: pqrerapi.pkb 120.0 2005/10/06 14:53:06 srajakum noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrerapi.pkb 120.0 2005/10/06 14:53:06 srajakum noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_RATE_ELEMENT_RELATIONS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------------------------------|
10: -- ----------------------------------------------------------------------------

Line 29: l_rate_element_relation_id PQH_RATE_ELEMENT_RELATIONS.rate_element_relation_id%TYPE;

25: --
26: -- Declare cursors and local variables
27: --
28: l_effective_date date;
29: l_rate_element_relation_id PQH_RATE_ELEMENT_RELATIONS.rate_element_relation_id%TYPE;
30: l_object_version_number PQH_RATE_ELEMENT_RELATIONS.object_version_number%TYPE;
31: l_proc varchar2(72) := g_package||'create_rate_element_relation';
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 30: l_object_version_number PQH_RATE_ELEMENT_RELATIONS.object_version_number%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_effective_date date;
29: l_rate_element_relation_id PQH_RATE_ELEMENT_RELATIONS.rate_element_relation_id%TYPE;
30: l_object_version_number PQH_RATE_ELEMENT_RELATIONS.object_version_number%TYPE;
31: l_proc varchar2(72) := g_package||'create_rate_element_relation';
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --

Line 68: PQH_RATE_ELEMENT_RELATIONS_BK1.create_rate_element_relation_b

64: )
65:
66: */
67:
68: PQH_RATE_ELEMENT_RELATIONS_BK1.create_rate_element_relation_b
69: (p_effective_date => l_effective_date
70: ,p_criteria_rate_element_id => p_criteria_rate_element_id
71: ,p_relation_type_cd => p_relation_type_cd
72: ,p_rel_element_type_id => p_rel_element_type_id

Line 125: PQH_RATE_ELEMENT_RELATIONS_BK1.create_rate_element_relation_a

121: */
122:
123:
124: begin
125: PQH_RATE_ELEMENT_RELATIONS_BK1.create_rate_element_relation_a
126: (
127: p_effective_date => l_effective_date
128: ,p_criteria_rate_element_id => p_criteria_rate_element_id
129: ,p_relation_type_cd => p_relation_type_cd

Line 213: l_object_version_number PQH_RATE_ELEMENT_RELATIONS.object_version_number%TYPE;

209: -- Declare cursors and local variables
210: --
211: l_effective_date date;
212: l_proc varchar2(72) := g_package||'update_rate_element_relation';
213: l_object_version_number PQH_RATE_ELEMENT_RELATIONS.object_version_number%TYPE;
214: begin
215: hr_utility.set_location('Entering:'|| l_proc, 10);
216: --
217: -- Issue a savepoint

Line 251: PQH_RATE_ELEMENT_RELATIONS_BK2.update_rate_element_relation_b

247: );
248: */
249:
250: begin
251: PQH_RATE_ELEMENT_RELATIONS_BK2.update_rate_element_relation_b
252: (
253: p_effective_date => l_effective_date
254: ,p_criteria_rate_element_id => p_criteria_rate_element_id
255: ,p_relation_type_cd => p_relation_type_cd

Line 295: PQH_RATE_ELEMENT_RELATIONS_BK2.update_rate_element_relation_a

291: --
292: -- Call After Process User Hook
293: --
294: begin
295: PQH_RATE_ELEMENT_RELATIONS_BK2.update_rate_element_relation_a
296: (
297: p_effective_date => l_effective_date
298: ,p_criteria_rate_element_id => p_criteria_rate_element_id
299: ,p_relation_type_cd => p_relation_type_cd

Line 391: PQH_RATE_ELEMENT_RELATIONS_BK3.delete_rate_element_relation_b

387: --
388: -- Call Before Process User Hook
389: --
390: begin
391: PQH_RATE_ELEMENT_RELATIONS_BK3.delete_rate_element_relation_b
392: ( p_effective_date => l_effective_date
393: ,p_rate_element_relation_id => p_rate_element_relation_id
394: ,p_object_version_number => p_object_version_number
395: );

Line 423: PQH_RATE_ELEMENT_RELATIONS_BK3.delete_rate_element_relation_a

419: --
420: -- Call After Process User Hook
421: --
422: begin
423: PQH_RATE_ELEMENT_RELATIONS_BK3.delete_rate_element_relation_a
424: (p_effective_date => l_effective_date
425: ,p_rate_element_relation_id => p_rate_element_relation_id
426: ,p_object_version_number => p_object_version_number
427: );

Line 473: end PQH_RATE_ELEMENT_RELATIONS_API;

469: raise;
470: end delete_rate_element_relation;
471: --
472: --
473: end PQH_RATE_ELEMENT_RELATIONS_API;