APPS.OKC_XPRT_QA_PVT dependencies on ALL_OBJECTS

Line 2241: FROM all_objects

2237: --Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
2238:
2239: CURSOR csr_check_proc_spec_status (p_procedure_name VARCHAR2) IS
2240: SELECT status
2241: FROM all_objects
2242: WHERE object_name = SUBSTR(p_procedure_name,
2243: INSTR(p_procedure_name,'.')+1,
2244: (INSTR(p_procedure_name,'.',1,2) -
2245: INSTR(p_procedure_name,'.') - 1))

Line 2252: FROM all_objects

2248:
2249:
2250: CURSOR csr_check_proc_body_status (p_procedure_name VARCHAR2) IS
2251: SELECT status
2252: FROM all_objects
2253: WHERE object_name = SUBSTR(p_procedure_name,
2254: INSTR(p_procedure_name,'.')+1,
2255: (INSTR(p_procedure_name,'.',1,2) -
2256: INSTR(p_procedure_name,'.') - 1))

Line 2275: l_procedure_spec_status ALL_OBJECTS.status%TYPE;

2271:
2272:
2273: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_udv_procedure';
2274: l_dummy VARCHAR2(1);
2275: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
2276: l_procedure_body_status ALL_OBJECTS.status%TYPE;
2277: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2278:
2279: BEGIN

Line 2276: l_procedure_body_status ALL_OBJECTS.status%TYPE;

2272:
2273: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_udv_procedure';
2274: l_dummy VARCHAR2(1);
2275: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
2276: l_procedure_body_status ALL_OBJECTS.status%TYPE;
2277: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2278:
2279: BEGIN
2280: