APPS.OKC_TERMS_UTIL_PVT dependencies on ALL_OBJECTS

Line 5333: l_procedure_spec_status ALL_OBJECTS.status%TYPE;

5329: l_msg_count NUMBER;
5330: l_msg_data VARCHAR2(2500);
5331: l_dynamic_sql_stmt LONG;
5332:
5333: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
5334: l_procedure_body_status ALL_OBJECTS.status%TYPE;
5335: l_dummy VARCHAR2(1);
5336:
5337: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

Line 5334: l_procedure_body_status ALL_OBJECTS.status%TYPE;

5330: l_msg_data VARCHAR2(2500);
5331: l_dynamic_sql_stmt LONG;
5332:
5333: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
5334: l_procedure_body_status ALL_OBJECTS.status%TYPE;
5335: l_dummy VARCHAR2(1);
5336:
5337: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5338: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

Line 5374: FROM all_objects

5370: --Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
5371:
5372: CURSOR csr_check_proc_spec_status (p_procedure_name VARCHAR2) IS
5373: SELECT status
5374: FROM all_objects
5375: WHERE object_name = SUBSTR(p_procedure_name,
5376: INSTR(p_procedure_name,'.')+1,
5377: (INSTR(p_procedure_name,'.',1,2) -
5378: INSTR(p_procedure_name,'.') - 1))

Line 5385: FROM all_objects

5381:
5382:
5383: CURSOR csr_check_proc_body_status (p_procedure_name VARCHAR2) IS
5384: SELECT status
5385: FROM all_objects
5386: WHERE object_name = SUBSTR(p_procedure_name,
5387: INSTR(p_procedure_name,'.')+1,
5388: (INSTR(p_procedure_name,'.',1,2) -
5389: INSTR(p_procedure_name,'.') - 1))