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 125: FROM gmo_opert_cert_detail

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

Line 142: FROM gmo_opert_cert_detail ocd

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

Line 206: TYPE l_cert_comp_tbl_typ IS TABLE OF gmo_opert_cert_detail%ROWTYPE

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

Line 245: FROM gmo_opert_cert_detail ocd

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

Line 260: FROM gmo_opert_cert_detail ocd

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