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 213: l_opert_cert_hdr gmo_opert_cert_header%ROWTYPE;

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

Line 533: FROM gmo_opert_cert_header

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