APPS.INL_RULE_PVT dependencies on USER_OBJECTS

Line 686: FROM user_objects

682: l_rule_name VARCHAR2(30);
683:
684: CURSOR c_package_status(p_package_name VARCHAR2)IS
685: SELECT status
686: FROM user_objects
687: WHERE object_name = UPPER(p_package_name)
688: AND object_type = 'PACKAGE'
689: AND status <> 'VALID'
690: AND rownum = 1;

Line 796: FROM user_objects

792: l_check_submit VARCHAR2(1); -- Bug 16758966
793:
794: CURSOR c_package_body_status(p_package_name VARCHAR2)IS
795: SELECT status
796: FROM user_objects
797: WHERE object_name = UPPER(p_package_name)
798: AND object_type = 'PACKAGE BODY'
799: AND status <> 'VALID'
800: AND rownum = 1;

Line 1511: FROM user_objects

1507: p_var_value => l_db_function);
1508:
1509: SELECT COUNT(1)
1510: INTO l_valid_function
1511: FROM user_objects
1512: WHERE object_name = l_db_function
1513: AND object_type = 'FUNCTION';
1514:
1515: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

Line 1670: FROM user_objects

1666: IF l_package_name IS NOT NULL AND l_package_name LIKE 'INL_RULE_%' || p_rule_id THEN
1667:
1668: SELECT COUNT(1)
1669: INTO l_exist_package_spec
1670: FROM user_objects
1671: WHERE object_name = UPPER(l_package_name)
1672: AND object_type = 'PACKAGE'
1673: AND rownum = 1;
1674:

Line 1685: FROM user_objects

1681: END IF;
1682:
1683: SELECT COUNT(1)
1684: INTO l_exist_package_body
1685: FROM user_objects
1686: WHERE object_name = UPPER(l_package_name)
1687: AND object_type = 'PACKAGE BODY'
1688: AND rownum = 1;
1689: