APPS.OKC_XPRT_QA_PVT dependencies on ALL_OBJECTS

Line 2312: FROM all_objects

2308: --Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
2309:
2310: CURSOR csr_check_proc_spec_status (p_procedure_name VARCHAR2) IS
2311: SELECT status
2312: FROM all_objects
2313: WHERE object_name = SUBSTR(p_procedure_name,
2314: INSTR(p_procedure_name,'.')+1,
2315: (INSTR(p_procedure_name,'.',1,2) -
2316: INSTR(p_procedure_name,'.') - 1))

Line 2323: FROM all_objects

2319:
2320:
2321: CURSOR csr_check_proc_body_status (p_procedure_name VARCHAR2) IS
2322: SELECT status
2323: FROM all_objects
2324: WHERE object_name = SUBSTR(p_procedure_name,
2325: INSTR(p_procedure_name,'.')+1,
2326: (INSTR(p_procedure_name,'.',1,2) -
2327: INSTR(p_procedure_name,'.') - 1))

Line 2346: l_procedure_spec_status ALL_OBJECTS.status%TYPE;

2342:
2343:
2344: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_udv_procedure';
2345: l_dummy VARCHAR2(1);
2346: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
2347: l_procedure_body_status ALL_OBJECTS.status%TYPE;
2348: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2349:
2350: BEGIN

Line 2347: l_procedure_body_status ALL_OBJECTS.status%TYPE;

2343:
2344: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_udv_procedure';
2345: l_dummy VARCHAR2(1);
2346: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
2347: l_procedure_body_status ALL_OBJECTS.status%TYPE;
2348: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2349:
2350: BEGIN
2351: