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_MATRIX_RATES_API dependencies on PQH_RATE_MATRIX_RATES_F

Line 33: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;

29: --
30: -- Declare cursors and local variables
31: --
32: l_effective_date date;
33: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
34: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
35: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
36: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
37: l_proc varchar2(72) := g_package||'create_rate_matrix_rate';

Line 34: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;

30: -- Declare cursors and local variables
31: --
32: l_effective_date date;
33: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
34: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
35: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
36: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
37: l_proc varchar2(72) := g_package||'create_rate_matrix_rate';
38: --

Line 35: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;

31: --
32: l_effective_date date;
33: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
34: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
35: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
36: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
37: l_proc varchar2(72) := g_package||'create_rate_matrix_rate';
38: --
39: begin

Line 36: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;

32: l_effective_date date;
33: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
34: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
35: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
36: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
37: l_proc varchar2(72) := g_package||'create_rate_matrix_rate';
38: --
39: begin
40: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 206: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;

202: --
203: -- Declare cursors and local variables
204: --
205: l_effective_date date;
206: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
207: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
208: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
209: l_proc varchar2(72) := g_package||'update_rate_matrix_rate';
210: begin

Line 207: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;

203: -- Declare cursors and local variables
204: --
205: l_effective_date date;
206: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
207: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
208: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
209: l_proc varchar2(72) := g_package||'update_rate_matrix_rate';
210: begin
211: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 208: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;

204: --
205: l_effective_date date;
206: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
207: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
208: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
209: l_proc varchar2(72) := g_package||'update_rate_matrix_rate';
210: begin
211: hr_utility.set_location('Entering:'|| l_proc, 10);
212: --

Line 370: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;

366: --
367: -- Declare cursors and local variables
368: --
369: l_effective_date date;
370: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
371: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
372: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
373: l_proc varchar2(72) := g_package||'delete_rate_matrix_rate';
374: begin

Line 371: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;

367: -- Declare cursors and local variables
368: --
369: l_effective_date date;
370: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
371: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
372: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
373: l_proc varchar2(72) := g_package||'delete_rate_matrix_rate';
374: begin
375: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 372: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;

368: --
369: l_effective_date date;
370: l_object_version_number pqh_rate_matrix_rates_f.object_version_number%type;
371: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
372: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
373: l_proc varchar2(72) := g_package||'delete_rate_matrix_rate';
374: begin
375: hr_utility.set_location('Entering:'|| l_proc, 10);
376: --