APPS.SSPWSMED_PKG dependencies on SSP_MEDICALS

Line 39: select ssp_medicals_s.nextval

35: */
36:
37: PROCEDURE get_medical_sequence (p_medical_id in out number) is
38: cursor c1 is
39: select ssp_medicals_s.nextval
40: from sys.dual;
41: BEGIN
42: open c1;
43: fetch c1 into p_medical_id;

Line 54: from ssp_medicals h

50: p_maternity_id in number,
51: p_medical_id in number) is
52: cursor c1 is
53: select h.rowid
54: from ssp_medicals h
55: where h.maternity_id = p_maternity_id
56: and h.medical_id <> p_medical_id
57: and upper(h.evidence_source) = p_evidence_source
58: and h.evidence_date = p_evidence_date;

Line 79: from ssp_medicals h

75: p_absence_attendance_id in number,
76: p_medical_id in number) is
77: cursor c1 is
78: select h.evidence_source, h.evidence_date
79: from ssp_medicals h
80: where h.absence_attendance_id = p_absence_attendance_id
81: and h.medical_id <> p_medical_id
82: and upper(h.evidence_source) = p_evidence_source
83: and h.evidence_date = p_evidence_date;

Line 98: update ssp_medicals

94: END check_unique_abs_evidence;
95:
96: PROCEDURE upd_prev_sick_evid (p_absence_attendance_id in number) is
97: BEGIN
98: update ssp_medicals
99: set evidence_status='SUPERCEDED'
100: where absence_attendance_id = p_absence_attendance_id
101: and evidence_status = 'CURRENT';
102: END upd_prev_sick_evid;

Line 106: update ssp_medicals

102: END upd_prev_sick_evid;
103:
104: PROCEDURE upd_prev_mat_evid (p_maternity_id in number) is
105: BEGIN
106: update ssp_medicals
107: set evidence_status='SUPERCEDED'
108: where maternity_id = p_maternity_id
109: and evidence_status = 'CURRENT';
110: END upd_prev_mat_evid;