APPS.GMO_OPER_CERT_PUB dependencies on GMO_OPERT_CERT_HEADER

Line 25: l_opert_cert_hdr gmo_opert_cert_header%ROWTYPE;

21: l_api_name CONSTANT VARCHAR2 (30) := 'check_certification';
22: l_return_status VARCHAR2 (1);
23: l_employ_id NUMBER ;
24: l_user_id NUMBER ;
25: l_opert_cert_hdr gmo_opert_cert_header%ROWTYPE;
26: l_cert_comp_tbl l_cert_comp_tbl_typ;
27: l_org_id NUMBER ;
28: l_object_id NUMBER ;
29: l_object_type NUMBER ;

Line 44: FROM gmo_opert_cert_header

40: CURSOR cur_get_oper_cert (v_org_id IN NUMBER,
41: v_object_id IN NUMBER,
42: v_object_type IN NUMBER ) IS
43: SELECT *
44: FROM gmo_opert_cert_header
45: WHERE organization_id = v_org_id
46: AND object_id = v_object_id
47: AND object_type = v_object_type;
48:

Line 216: l_opert_cert_hdr gmo_opert_cert_header%ROWTYPE;

212: l_api_name CONSTANT VARCHAR2 (30) := 'required_certification';
213: l_return_status VARCHAR2 (1);
214: l_employ_id NUMBER ;
215: l_user_id NUMBER ;
216: l_opert_cert_hdr gmo_opert_cert_header%ROWTYPE;
217: l_cert_comp_tbl l_cert_comp_tbl_typ;
218: l_org_id NUMBER ;
219: l_object_id NUMBER ;
220: l_object_type NUMBER ;

Line 536: FROM gmo_opert_cert_header

532: RAISE fnd_api.g_exc_error;
533: END IF;
534: -- dbms_output.put_line('l_op_cert_id '||l_operator_certificate_id);
535: SELECT organization_id into l_org_id
536: FROM gmo_opert_cert_header
537: Where header_id = l_header_id ;
538:
539: IF l_operator_certificate_id IS NOT NULL THEN
540: GMO_OPER_CERT_PUB.required_Certification(p_user_id =>l_user_id