APPS.OKC_REP_QA_CHECK_PVT dependencies on OKC_BUS_DOC_TYPES_TL

Line 567: l_contract_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

563: l_api_version CONSTANT NUMBER := 1;
564: l_api_name CONSTANT VARCHAR2(30) := 'validate_E_Signature';
565: l_index PLS_INTEGER := 0;
566: l_valid_E_sign_flag VARCHAR2(1);
567: l_contract_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
568:
569: CURSOR contract_type_csr IS
570: SELECT signature_workflow_name
571: FROM okc_bus_doc_types_b

Line 857: l_contract_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

853: l_api_version CONSTANT NUMBER := 1;
854: l_api_name CONSTANT VARCHAR2(30) := 'validate_contract_type';
855: l_index PLS_INTEGER := 0;
856: l_valid_contract_type_flag VARCHAR2(1);
857: l_contract_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
858:
859: CURSOR contract_type_csr IS
860: SELECT name, start_date, end_date
861: FROM okc_bus_doc_types_vl

Line 2245: l_contract_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

2241:
2242: l_api_version CONSTANT NUMBER := 1;
2243: l_api_name CONSTANT VARCHAR2(30) := 'validate_Approval_Workflow';
2244: l_index PLS_INTEGER := 0;
2245: l_contract_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
2246:
2247: CURSOR contract_type_csr IS
2248: SELECT approval_workflow_name
2249: FROM okc_bus_doc_types_b