DBA Data[Home] [Help]

APPS.IGS_GE_GEN_001 dependencies on USER_OBJECTS

Line 20: cst_table CONSTANT user_objects.object_type%TYPE := 'TABLE';

16: RETURN BOOLEAN AS
17: gv_other_detail VARCHAR2(255);
18: BEGIN
19: DECLARE
20: cst_table CONSTANT user_objects.object_type%TYPE := 'TABLE';
21: cst_view CONSTANT user_objects.object_type%TYPE := 'VIEW';
22: v_object_type user_objects.object_type%TYPE;
23: v_col_comment user_col_comments.comments%TYPE;
24: v_table_name user_col_comments.table_name%TYPE;

Line 21: cst_view CONSTANT user_objects.object_type%TYPE := 'VIEW';

17: gv_other_detail VARCHAR2(255);
18: BEGIN
19: DECLARE
20: cst_table CONSTANT user_objects.object_type%TYPE := 'TABLE';
21: cst_view CONSTANT user_objects.object_type%TYPE := 'VIEW';
22: v_object_type user_objects.object_type%TYPE;
23: v_col_comment user_col_comments.comments%TYPE;
24: v_table_name user_col_comments.table_name%TYPE;
25: v_column_name user_col_comments.column_name%TYPE;

Line 22: v_object_type user_objects.object_type%TYPE;

18: BEGIN
19: DECLARE
20: cst_table CONSTANT user_objects.object_type%TYPE := 'TABLE';
21: cst_view CONSTANT user_objects.object_type%TYPE := 'VIEW';
22: v_object_type user_objects.object_type%TYPE;
23: v_col_comment user_col_comments.comments%TYPE;
24: v_table_name user_col_comments.table_name%TYPE;
25: v_column_name user_col_comments.column_name%TYPE;
26: v_search_condition VARCHAR2(10000);

Line 29: cp_object_name user_objects.object_name%TYPE) IS

25: v_column_name user_col_comments.column_name%TYPE;
26: v_search_condition VARCHAR2(10000);
27: v_full_stop_pos INTEGER;
28: CURSOR c_uo (
29: cp_object_name user_objects.object_name%TYPE) IS
30: SELECT uo.object_type
31: FROM user_objects uo
32: WHERE uo.object_name = cp_object_name AND
33: uo.object_type IN (cst_table, cst_view);

Line 31: FROM user_objects uo

27: v_full_stop_pos INTEGER;
28: CURSOR c_uo (
29: cp_object_name user_objects.object_name%TYPE) IS
30: SELECT uo.object_type
31: FROM user_objects uo
32: WHERE uo.object_name = cp_object_name AND
33: uo.object_type IN (cst_table, cst_view);
34: CURSOR c_ucc (
35: cp_view_name user_col_comments.table_name%TYPE,