APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on ALL_OBJECTS

Line 521: l_procedure_spec_status ALL_OBJECTS.status%TYPE;

517: -- Below Added for bug 5958643
518: l_variable_source_tbl l_variable_source;
519: l_procedure_name_tbl l_procedure_name;
520:
521: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
522: l_procedure_body_status ALL_OBJECTS.status%TYPE;
523:
524: l_dummy VARCHAR2(1);
525: -- Above Added for bug 5958643

Line 522: l_procedure_body_status ALL_OBJECTS.status%TYPE;

518: l_variable_source_tbl l_variable_source;
519: l_procedure_name_tbl l_procedure_name;
520:
521: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
522: l_procedure_body_status ALL_OBJECTS.status%TYPE;
523:
524: l_dummy VARCHAR2(1);
525: -- Above Added for bug 5958643
526:

Line 572: FROM all_objects

568: -- Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
569:
570: CURSOR csr_check_proc_spec_status (p_procedure_name VARCHAR2) IS
571: SELECT status
572: FROM all_objects
573: WHERE object_name = SUBSTR(p_procedure_name,
574: INSTR(p_procedure_name,'.')+1,
575: (INSTR(p_procedure_name,'.',1,2) -
576: INSTR(p_procedure_name,'.') - 1))

Line 583: FROM all_objects

579:
580:
581: CURSOR csr_check_proc_body_status (p_procedure_name VARCHAR2) IS
582: SELECT status
583: FROM all_objects
584: WHERE object_name = SUBSTR(p_procedure_name,
585: INSTR(p_procedure_name,'.')+1,
586: (INSTR(p_procedure_name,'.',1,2) -
587: INSTR(p_procedure_name,'.') - 1))