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_CRITERIA_RATE_DEFN_API dependencies on PQH_CRITERIA_RATE_DEFN

Line 1: Package Body PQH_CRITERIA_RATE_DEFN_API as

1: Package Body PQH_CRITERIA_RATE_DEFN_API as
2: /* $Header: pqcrdapi.pkb 120.2 2005/07/13 04:52:24 srenukun noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqcrdapi.pkb 120.2 2005/07/13 04:52:24 srenukun noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PQH_CRITERIA_RATE_DEFN_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_criteria_rate_defn >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 73: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;

69: -- Declare cursors and local variables
70: --
71: l_in_out_parameter number;
72: l_effective_date date;
73: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
74: l_object_version_number pqh_criteria_rate_defn.object_version_number%type;
75: --
76: l_proc varchar2(72) := g_package||'create_criteria_rate_defn';
77: begin

Line 74: l_object_version_number pqh_criteria_rate_defn.object_version_number%type;

70: --
71: l_in_out_parameter number;
72: l_effective_date date;
73: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
74: l_object_version_number pqh_criteria_rate_defn.object_version_number%type;
75: --
76: l_proc varchar2(72) := g_package||'create_criteria_rate_defn';
77: begin
78: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 97: pqh_criteria_rate_defn_bk1.create_criteria_rate_defn_b

93: --
94: -- Call Before Process User Hook
95: --
96: begin
97: pqh_criteria_rate_defn_bk1.create_criteria_rate_defn_b
98: (p_effective_date => l_effective_date
99: ,p_business_group_id => p_business_group_id
100: ,p_short_name => p_short_name
101: ,p_uom => p_uom

Line 150: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'

146: );
147: exception
148: when hr_api.cannot_find_prog_unit then
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
151: ,p_hook_type => 'BP'
152: );
153: end;
154: --

Line 227: pqh_criteria_rate_defn_bk1.create_criteria_rate_defn_a

223: --
224: -- Call After Process User Hook
225: --
226: begin
227: pqh_criteria_rate_defn_bk1.create_criteria_rate_defn_a
228: (p_effective_date => l_effective_date
229: ,p_business_group_id => p_business_group_id
230: ,p_criteria_rate_defn_id => l_criteria_rate_defn_id
231: ,p_short_name => p_short_name

Line 281: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'

277: ,p_object_version_number => l_object_version_number );
278: exception
279: when hr_api.cannot_find_prog_unit then
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
282: ,p_hook_type => 'AP'
283: );
284: end;
285: --

Line 393: l_object_version_number pqh_criteria_rate_defn.object_version_number%TYPE;

389: -- Declare cursors and local variables
390: --
391: l_in_out_parameter number;
392: l_effective_date date;
393: l_object_version_number pqh_criteria_rate_defn.object_version_number%TYPE;
394: l_proc varchar2(72) := g_package||'update_criteria_rate_defn';
395: begin
396: hr_utility.set_location('Entering:'|| l_proc, 10);
397: --

Line 416: pqh_criteria_rate_defn_bk2.update_criteria_rate_defn_b

412: --
413: -- Call Before Process User Hook
414: --
415: begin
416: pqh_criteria_rate_defn_bk2.update_criteria_rate_defn_b
417: (p_effective_date => l_effective_date
418: ,p_business_group_id => p_business_group_id
419: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
420: ,p_short_name => p_short_name

Line 471: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'

467: );
468: exception
469: when hr_api.cannot_find_prog_unit then
470: hr_api.cannot_find_prog_unit_error
471: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
472: ,p_hook_type => 'BP'
473: );
474: end;
475: --

Line 548: pqh_criteria_rate_defn_bk2.update_criteria_rate_defn_a

544: --
545: -- Call After Process User Hook
546: --
547: begin
548: pqh_criteria_rate_defn_bk2.update_criteria_rate_defn_a
549: (p_effective_date => l_effective_date
550: ,p_business_group_id => p_business_group_id
551: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
552: ,p_short_name => p_short_name

Line 602: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'

598: ,p_object_version_number => l_object_version_number );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
603: ,p_hook_type => 'AP'
604: );
605: end;
606: --

Line 664: l_object_version_number pqh_criteria_rate_defn.object_version_number%type;

660: -- Declare cursors and local variables
661: --
662: l_in_out_parameter number;
663: l_effective_date date;
664: l_object_version_number pqh_criteria_rate_defn.object_version_number%type;
665: --
666: l_proc varchar2(72) := g_package||'delete_criteria_rate_defn';
667: begin
668: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 688: pqh_criteria_rate_defn_bk3.delete_criteria_rate_defn_b

684: --
685: -- Call Before Process User Hook
686: --
687: begin
688: pqh_criteria_rate_defn_bk3.delete_criteria_rate_defn_b
689: (p_effective_date => l_effective_date
690: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
691: ,p_object_version_number => l_object_version_number
692: );

Line 696: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'

692: );
693: exception
694: when hr_api.cannot_find_prog_unit then
695: hr_api.cannot_find_prog_unit_error
696: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
697: ,p_hook_type => 'BP'
698: );
699: end;
700: --

Line 721: pqh_criteria_rate_defn_bk3.delete_criteria_rate_defn_a

717: --
718: -- Call After Process User Hook
719: --
720: begin
721: pqh_criteria_rate_defn_bk3.delete_criteria_rate_defn_a
722: (p_effective_date => l_effective_date
723: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
724: ,p_object_version_number => l_object_version_number );
725: exception

Line 728: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'

724: ,p_object_version_number => l_object_version_number );
725: exception
726: when hr_api.cannot_find_prog_unit then
727: hr_api.cannot_find_prog_unit_error
728: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
729: ,p_hook_type => 'AP'
730: );
731: end;
732: --

Line 770: end PQH_CRITERIA_RATE_DEFN_API;

766: raise;
767: end delete_criteria_rate_defn;
768: --
769: --
770: end PQH_CRITERIA_RATE_DEFN_API;