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.PAY_EVENT_VALUE_CHANGES_API dependencies on PAY_EVENT_VALUE_CHANGES_F

Line 39: l_event_value_change_id pay_event_value_changes_f.event_value_change_id%TYPE;

35: l_counter number; --misc number
36: --
37: -- Declare OUT variables
38: --
39: l_event_value_change_id pay_event_value_changes_f.event_value_change_id%TYPE;
40: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;
41: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;
42: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;
43:

Line 40: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;

36: --
37: -- Declare OUT variables
38: --
39: l_event_value_change_id pay_event_value_changes_f.event_value_change_id%TYPE;
40: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;
41: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;
42: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;
43:
44: begin

Line 41: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;

37: -- Declare OUT variables
38: --
39: l_event_value_change_id pay_event_value_changes_f.event_value_change_id%TYPE;
40: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;
41: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;
42: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;
43:
44: begin
45: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 42: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;

38: --
39: l_event_value_change_id pay_event_value_changes_f.event_value_change_id%TYPE;
40: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;
41: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;
42: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;
43:
44: begin
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --

Line 97: from pay_event_value_changes_f

93: -- eg we are inserting a second qualifier.
94: --------------------------------------------------------
95: select count(*)
96: into l_counter
97: from pay_event_value_changes_f
98: where p_effective_date between effective_start_date and effective_end_date
99: and p_datetracked_event_id = datetracked_event_id
100: and default_event = 'Y';
101:

Line 248: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;

244: l_effective_date date;
245: --
246: -- Declare OUT variables
247: --
248: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;
249: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;
250: --
251: -- Declare IN OUT variable
252: --

Line 249: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;

245: --
246: -- Declare OUT variables
247: --
248: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;
249: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;
250: --
251: -- Declare IN OUT variable
252: --
253: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;

Line 253: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;

249: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;
250: --
251: -- Declare IN OUT variable
252: --
253: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;
254: --
255: begin
256: hr_utility.set_location('Entering:'|| l_proc, 10);
257: --

Line 418: l_effective_start_date pay_event_value_changes_f.effective_start_date%type;

414: l_effective_date date;
415: --
416: -- Declare OUT variables
417: --
418: l_effective_start_date pay_event_value_changes_f.effective_start_date%type;
419: l_effective_end_date pay_event_value_changes_f.effective_end_date%type;
420: l_validation_start_date date;
421: l_validation_end_date date;
422: l_object_version_number pay_event_value_changes_f.object_version_number%type;

Line 419: l_effective_end_date pay_event_value_changes_f.effective_end_date%type;

415: --
416: -- Declare OUT variables
417: --
418: l_effective_start_date pay_event_value_changes_f.effective_start_date%type;
419: l_effective_end_date pay_event_value_changes_f.effective_end_date%type;
420: l_validation_start_date date;
421: l_validation_end_date date;
422: l_object_version_number pay_event_value_changes_f.object_version_number%type;
423: --

Line 422: l_object_version_number pay_event_value_changes_f.object_version_number%type;

418: l_effective_start_date pay_event_value_changes_f.effective_start_date%type;
419: l_effective_end_date pay_event_value_changes_f.effective_end_date%type;
420: l_validation_start_date date;
421: l_validation_end_date date;
422: l_object_version_number pay_event_value_changes_f.object_version_number%type;
423: --
424: begin
425: hr_utility.set_location('Entering:'|| l_proc, 5);
426: --