APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on ALL_OBJECTS

Line 531: l_procedure_spec_status ALL_OBJECTS.status%TYPE;

527:
528: l_mrv_flag_tbl l_mrv_flag;
529: l_clm_Source_tbl l_clm_source;
530:
531: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
532: l_procedure_body_status ALL_OBJECTS.status%TYPE;
533:
534: l_dummy VARCHAR2(1);
535: -- Above Added for bug 5958643

Line 532: l_procedure_body_status ALL_OBJECTS.status%TYPE;

528: l_mrv_flag_tbl l_mrv_flag;
529: l_clm_Source_tbl l_clm_source;
530:
531: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
532: l_procedure_body_status ALL_OBJECTS.status%TYPE;
533:
534: l_dummy VARCHAR2(1);
535: -- Above Added for bug 5958643
536:

Line 584: FROM all_objects

580: -- Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
581:
582: CURSOR csr_check_proc_spec_status (p_procedure_name VARCHAR2) IS
583: SELECT status
584: FROM all_objects
585: WHERE object_name = SUBSTR(p_procedure_name,
586: INSTR(p_procedure_name,'.')+1,
587: (INSTR(p_procedure_name,'.',1,2) -
588: INSTR(p_procedure_name,'.') - 1))

Line 595: FROM all_objects

591:
592:
593: CURSOR csr_check_proc_body_status (p_procedure_name VARCHAR2) IS
594: SELECT status
595: FROM all_objects
596: WHERE object_name = SUBSTR(p_procedure_name,
597: INSTR(p_procedure_name,'.')+1,
598: (INSTR(p_procedure_name,'.',1,2) -
599: INSTR(p_procedure_name,'.') - 1))