APPS.GMO_OPER_CERT_PUB dependencies on GMO_OPERT_CERT_DETAIL

Line 18: TYPE l_cert_comp_tbl_typ IS TABLE OF gmo_opert_cert_detail%ROWTYPE

14: ,x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER
15:
16: IS
17:
18: TYPE l_cert_comp_tbl_typ IS TABLE OF gmo_opert_cert_detail%ROWTYPE
19: INDEX BY BINARY_INTEGER;
20:
21: l_api_name CONSTANT VARCHAR2 (30) := 'check_certification';
22: l_return_status VARCHAR2 (1);

Line 52: FROM gmo_opert_cert_detail

48:
49: CURSOR cur_get_compet_dtl (v_header_id IN NUMBER
50: ) IS
51: SELECT *
52: FROM gmo_opert_cert_detail
53: WHERE header_id = v_header_id ;
54:
55: CURSOR cur_get_org (v_org_id number) IS
56:

Line 128: FROM gmo_opert_cert_detail

124:
125: -- now based on the HRMS make a call to the api and chek for competency.
126: --dbms_output.put_line('for cert');
127: SELECT COUNT(*) into l_cert_count
128: FROM gmo_opert_cert_detail
129: WHERE header_id = l_opert_cert_hdr.header_id
130: AND qualification_type = 1 -- 1 is certification
131: AND FROM_DATE <= l_eff_date
132: AND nvl(TO_DATE, sysdate) >= l_eff_date

Line 145: FROM gmo_opert_cert_detail ocd

141: RAISE no_certificate;
142: END IF;
143:
144: SELECT COUNT(*) into l_comp_count
145: FROM gmo_opert_cert_detail ocd
146: WHERE ocd.header_id = l_opert_cert_hdr.header_id
147: AND ocd.qualification_type = 2 -- 2 is competence
148: AND FROM_DATE <= l_eff_date
149: AND nvl(TO_DATE, sysdate) >= l_eff_date

Line 209: TYPE l_cert_comp_tbl_typ IS TABLE OF gmo_opert_cert_detail%ROWTYPE

205: ,x_return_status OUT NOCOPY VARCHAR2)
206:
207: IS
208:
209: TYPE l_cert_comp_tbl_typ IS TABLE OF gmo_opert_cert_detail%ROWTYPE
210: INDEX BY BINARY_INTEGER;
211:
212: l_api_name CONSTANT VARCHAR2 (30) := 'required_certification';
213: l_return_status VARCHAR2 (1);

Line 248: FROM gmo_opert_cert_detail ocd

244:
245: CURSOR get_req_competence (v_header_id NUMBER,v_employ_id NUMBER, v_business_id NUMBER, v_date DATE) IS
246:
247: SELECT ocd.Qualification_id , ocd.Qualification_type, ocd.PROFICIENCY_LEVEL_ID
248: FROM gmo_opert_cert_detail ocd
249: WHERE header_id = v_header_id
250: AND qualification_type = 1 -- 1 is certification
251: AND FROM_DATE <= v_date
252: AND nvl(TO_DATE,sysdate) >= v_date

Line 263: FROM gmo_opert_cert_detail ocd

259:
260:
261: UNION
262: SELECT ocd.Qualification_id , ocd.Qualification_type, ocd.PROFICIENCY_LEVEL_ID
263: FROM gmo_opert_cert_detail ocd
264: WHERE ocd.header_id = v_header_id
265: AND ocd.qualification_type = 2 -- 2 is competence
266: AND FROM_DATE <= v_date
267: AND nvl(TO_DATE,sysdate) >= v_date