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.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on PER_NL_ABSENCE_CHANGES

Line 6: -- rows from table PER_NL_ABSENCE_CHANGES

2: /* $Header: pernldsr.pkb 120.1.12000000.2 2007/02/28 11:08:45 spendhar noship $ */
3: --
4: -- Description
5: -- Calls to different procedures, will Insert, Update or Delete
6: -- rows from table PER_NL_ABSENCE_CHANGES
7: --
8: -- Call to the local function will return absence category.
9: --
10: -- columns legislation_code, absence_attandnce_id, date_changed,

Line 12: -- PER_NL_ABSENCE_CHANGES are mandatory.

8: -- Call to the local function will return absence category.
9: --
10: -- columns legislation_code, absence_attandnce_id, date_changed,
11: -- update_type, reported_indicator and person_id in table
12: -- PER_NL_ABSENCE_CHANGES are mandatory.
13: --
14: -- Declare local function
15: --
16: FUNCTION absence_category(p_absence_attendance_id IN number) return varchar2;

Line 40: -- Row is inserted into PER_NL_ABSENCE_CHANGES when the

36: --
37: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
38: --
39: --
40: -- Row is inserted into PER_NL_ABSENCE_CHANGES when the
41: -- absence category is "'S'ickness"
42: --
43: If absence_category(p_absence_attendance_id) = 'S' then
44: insert into per_nl_absence_changes

Line 44: insert into per_nl_absence_changes

40: -- Row is inserted into PER_NL_ABSENCE_CHANGES when the
41: -- absence category is "'S'ickness"
42: --
43: If absence_category(p_absence_attendance_id) = 'S' then
44: insert into per_nl_absence_changes
45: (absence_attendance_id
46: ,date_changed
47: ,update_type
48: ,reported_indicator

Line 103: -- Row is inserted into PER_NL_ABSENCE_CHANGES when the

99: --
100: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
101: --
102: --
103: -- Row is inserted into PER_NL_ABSENCE_CHANGES when the
104: -- absence category is "'S'ickness"
105: --
106: If absence_category(p_absence_attendance_id) = 'S' then
107: open cur_per_abs_chags;

Line 121: -- PER_NL_ABSENCE_CHANGES is 'END'

117: then
118: --
119: -- when there are any changes to DATE_END or
120: -- DATE_PROJECTED_END, update type in
121: -- PER_NL_ABSENCE_CHANGES is 'END'
122: --
123: v_update_type := 'END';
124: --
125: elsif (nvl(p_date_start,hr_general.start_of_time) <>

Line 139: -- PER_NL_ABSENCE_CHANGES is 'UPDATE'

135: ) then
136: --
137: -- when there are any changes to DATE_START,
138: -- DATE_PROJECTED_START or ABS_INFORMATION1 update type in
139: -- PER_NL_ABSENCE_CHANGES is 'UPDATE'
140: --
141: v_update_type := 'UPDATE';
142: --
143: end if;

Line 148: -- then insert row into PER_NL_ABSENCE_CHANGES

144: --
145: close cur_per_abs_chags;
146: --
147: -- when there is change to v_update_type
148: -- then insert row into PER_NL_ABSENCE_CHANGES
149: --
150: if v_update_type is not null then
151: insert into per_nl_absence_changes
152: (absence_attendance_id

Line 151: insert into per_nl_absence_changes

147: -- when there is change to v_update_type
148: -- then insert row into PER_NL_ABSENCE_CHANGES
149: --
150: if v_update_type is not null then
151: insert into per_nl_absence_changes
152: (absence_attendance_id
153: ,date_changed
154: ,update_type
155: ,reported_indicator

Line 224: -- Insert data into table PER_NL_ABSENCE_CHANGES only

220: open cur_per_abs_chags;
221: fetch cur_per_abs_chags into l_rec;
222: close cur_per_abs_chags;
223: --
224: -- Insert data into table PER_NL_ABSENCE_CHANGES only
225: -- only when absence category is "'S'ickness".
226: --
227: If absence_category(p_absence_attendance_id) = 'S' then
228: insert into per_nl_absence_changes

Line 228: insert into per_nl_absence_changes

224: -- Insert data into table PER_NL_ABSENCE_CHANGES only
225: -- only when absence category is "'S'ickness".
226: --
227: If absence_category(p_absence_attendance_id) = 'S' then
228: insert into per_nl_absence_changes
229: (absence_attendance_id
230: ,date_changed
231: ,update_type
232: ,reported_indicator

Line 253: procedure purge_per_nl_absence_changes

249: --
250: END IF;
251: END delete_person_absence_changes;
252: --
253: procedure purge_per_nl_absence_changes
254: (p_errbuf OUT nocopy varchar2
255: ,p_retcode OUT nocopy varchar2
256: ,p_effective_date IN varchar2
257: ,p_business_group_id IN number) is

Line 263: DELETE from per_nl_absence_changes pnac

259: v_effective_date date := fnd_date.string_to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
260: --
261: begin
262: --
263: DELETE from per_nl_absence_changes pnac
264: WHERE months_between(trunc(v_effective_date), pnac.date_changed) > 12
265: AND person_id in ( SELECT person_id
266: FROM per_all_people_f
267: WHERE business_group_id = p_business_group_id);

Line 269: end purge_per_nl_absence_changes;

265: AND person_id in ( SELECT person_id
266: FROM per_all_people_f
267: WHERE business_group_id = p_business_group_id);
268: --
269: end purge_per_nl_absence_changes;
270: --
271: procedure update_reported_absence_chgs
272: (p_effective_date IN date
273: ,p_prev_rep_chg IN varchar2

Line 309: update per_nl_absence_changes pnac

305: begin
306: --
307: for rec_upd in cur_upd
308: loop
309: update per_nl_absence_changes pnac
310: set pnac.reported_indicator = 'Y'
311: WHERE pnac.person_id = rec_upd.person_id
312: AND nvl(p_effective_date,pnac.sickness_start_date )
313: BETWEEN rec_upd.effective_start_date AND rec_upd.effective_end_date