DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on USER_OBJECTS

Line 15014: FROM user_objects

15010: l_error VARCHAR2(10);
15011:
15012: CURSOR c_package_status IS
15013: SELECT status
15014: FROM user_objects
15015: WHERE object_name = UPPER(p_package_name)
15016: AND object_type='PACKAGE'
15017: AND status <> 'VALID'
15018: AND rownum = 1;

Line 15022: FROM user_objects

15018: AND rownum = 1;
15019:
15020: CURSOR c_package_body_status IS
15021: SELECT status
15022: FROM user_objects
15023: WHERE object_name = UPPER(p_package_name)
15024: AND object_type = 'PACKAGE BODY'
15025: AND status <> 'VALID'
15026: AND rownum = 1;