DBA Data[Home] [Help]

APPS.HZ_GEN_PLSQL dependencies on USER_OBJECTS

Line 56: SELECT STATUS INTO l_status FROM USER_OBJECTS

52: dbms_sql.parse(cur_hdl, m_array, 1, m_idx, false, dbms_sql.native);
53: n := dbms_sql.execute(cur_hdl);
54:
55: BEGIN
56: SELECT STATUS INTO l_status FROM USER_OBJECTS
57: WHERE OBJECT_NAME = m_name
58: AND OBJECT_TYPE = m_type;
59:
60: IF l_status <> 'VALID' THEN