DBA Data[Home] [Help]

APPS.XLA_VALIDATIONS_PKG dependencies on USER_OBJECTS

Line 820: CURSOR c_user_objects

816:
817: l_exist varchar2(1) := null;
818: l_return BOOLEAN := TRUE;
819:
820: CURSOR c_user_objects
821: IS
822: SELECT 'x'
823: FROM user_objects o
824: WHERE o.object_name = p_table_name;

Line 823: FROM user_objects o

819:
820: CURSOR c_user_objects
821: IS
822: SELECT 'x'
823: FROM user_objects o
824: WHERE o.object_name = p_table_name;
825:
826: BEGIN
827: xla_utility_pkg.trace('> xla_validations_pkg.table_name_is_valid' , 10);

Line 831: OPEN c_user_objects;

827: xla_utility_pkg.trace('> xla_validations_pkg.table_name_is_valid' , 10);
828:
829: xla_utility_pkg.trace('Table Name = '||p_table_name , 20);
830:
831: OPEN c_user_objects;
832: FETCH c_user_objects
833: INTO l_exist;
834: IF c_user_objects%found THEN
835: l_return := TRUE;

Line 832: FETCH c_user_objects

828:
829: xla_utility_pkg.trace('Table Name = '||p_table_name , 20);
830:
831: OPEN c_user_objects;
832: FETCH c_user_objects
833: INTO l_exist;
834: IF c_user_objects%found THEN
835: l_return := TRUE;
836: ELSE

Line 834: IF c_user_objects%found THEN

830:
831: OPEN c_user_objects;
832: FETCH c_user_objects
833: INTO l_exist;
834: IF c_user_objects%found THEN
835: l_return := TRUE;
836: ELSE
837: l_return := FALSE;
838: END IF;

Line 839: CLOSE c_user_objects;

835: l_return := TRUE;
836: ELSE
837: l_return := FALSE;
838: END IF;
839: CLOSE c_user_objects;
840:
841: xla_utility_pkg.trace('< xla_validations_pkg.table_name_is_valid' , 10);
842:
843: RETURN l_return;