APPS.PER_GB_ABSENCE_EVIDENCE_SWI dependencies on SSP_MEDICALS

Line 100: select 1 from ssp_medicals

96: l_error_text varchar2(2000);
97: l_sqlerrm varchar2(2000);
98:
99: cursor chk_evidence_status(p_abs_attd_id number, p_evid_date date) is
100: select 1 from ssp_medicals
101: where absence_attendance_id = p_abs_attd_id
102: and evidence_date > p_evid_date;
103:
104: l_recs number :=0;

Line 140: update ssp_medicals

136: l_evidence_status :='CURRENT';
137: end if;
138: close chk_evidence_status;
139:
140: update ssp_medicals
141: set evidence_status='SUPERCEDED'
142: where absence_attendance_id = p_absence_attendance_id
143: and evidence_status = 'CURRENT'
144: and evidence_date < p_evidence_date;

Line 148: insert into ssp_medicals

144: and evidence_date < p_evidence_date;
145:
146: -- IF l_populate_sickness_dates THEN
147:
148: insert into ssp_medicals
149: (MEDICAL_ID,
150: OBJECT_VERSION_NUMBER,
151: EVIDENCE_DATE,
152: EVIDENCE_SOURCE,

Line 190: (p_medical_id, -- ssp_medicals_s.nextval,

186: LAST_UPDATED_BY,
187: LAST_UPDATE_DATE,
188: LAST_UPDATE_LOGIN)
189: values
190: (p_medical_id, -- ssp_medicals_s.nextval,
191: p_object_version_number,
192: trunc(p_evidence_date),
193: p_evidence_source,
194: p_absence_attendance_id,

Line 349: cursor c_ssp_medicals is

345: l_error_text varchar2(2000);
346: l_sqlerrm varchar2(2000);
347: l_date_start Date;
348:
349: cursor c_ssp_medicals is
350: select * from ssp_medicals
351: where medical_id = p_medical_id;
352:
353: ssp_rec c_ssp_medicals%rowtype;

Line 350: select * from ssp_medicals

346: l_sqlerrm varchar2(2000);
347: l_date_start Date;
348:
349: cursor c_ssp_medicals is
350: select * from ssp_medicals
351: where medical_id = p_medical_id;
352:
353: ssp_rec c_ssp_medicals%rowtype;
354:

Line 353: ssp_rec c_ssp_medicals%rowtype;

349: cursor c_ssp_medicals is
350: select * from ssp_medicals
351: where medical_id = p_medical_id;
352:
353: ssp_rec c_ssp_medicals%rowtype;
354:
355: Begin
356: hr_utility.set_location(' Entering:' || l_proc,10);
357: --

Line 375: open c_ssp_medicals;

371: hr_api.constant_to_boolean
372: (p_constant_value => p_validate);
373:
374: hr_utility.set_location(' Stage:' || l_proc,12);
375: open c_ssp_medicals;
376: fetch c_ssp_medicals into ssp_rec;
377:
378: if c_ssp_medicals%found then
379: hr_utility.set_location(' Stage:' || l_proc,13);

Line 376: fetch c_ssp_medicals into ssp_rec;

372: (p_constant_value => p_validate);
373:
374: hr_utility.set_location(' Stage:' || l_proc,12);
375: open c_ssp_medicals;
376: fetch c_ssp_medicals into ssp_rec;
377:
378: if c_ssp_medicals%found then
379: hr_utility.set_location(' Stage:' || l_proc,13);
380: if p_evidence_source <> hr_api.g_varchar2 then

Line 378: if c_ssp_medicals%found then

374: hr_utility.set_location(' Stage:' || l_proc,12);
375: open c_ssp_medicals;
376: fetch c_ssp_medicals into ssp_rec;
377:
378: if c_ssp_medicals%found then
379: hr_utility.set_location(' Stage:' || l_proc,13);
380: if p_evidence_source <> hr_api.g_varchar2 then
381: ssp_rec.evidence_source := p_evidence_source;
382: end if;

Line 465: close c_ssp_medicals;

461: if p_attribute20 <> hr_api.g_varchar2 then
462: ssp_rec.attribute20 := p_attribute20;
463: end if;
464: end if;
465: close c_ssp_medicals;
466:
467:
468: open c_is_gb_leg;
469: fetch c_is_gb_leg into l_absence_attendance_type_id, l_business_group_id;

Line 479: update ssp_medicals set

475:
476: -- IF l_populate_sickness_dates THEN
477: hr_utility.set_location(' Stage:' || l_proc,15);
478:
479: update ssp_medicals set
480: evidence_source = ssp_rec.evidence_source
481: ,evidence_date = ssp_rec.evidence_date
482: ,evidence_details = ssp_rec.evidence_details
483: ,evidence_received_date = ssp_rec.evidence_received_date

Line 598: delete from ssp_medicals where medical_id = p_medical_id;

594: hr_api.constant_to_boolean
595: (p_constant_value => p_validate);
596: --
597: if not(l_validate) then
598: delete from ssp_medicals where medical_id = p_medical_id;
599: end if;
600: --
601: -- Call API
602: --