APPS.BEN_UTILITY dependencies on ALL_TABLES

Line 147: p_table_name IN all_tables.table_name%TYPE,

143: -- ----------------------------------------------------------------------------
144: -- |-------------------------< child_exists_error >---------------------------|
145: -- ----------------------------------------------------------------------------
146: PROCEDURE child_exists_error (
147: p_table_name IN all_tables.table_name%TYPE,
148: p_parent_table_name IN all_tables.table_name%TYPE DEFAULT NULL,
149: p_parent_entity_name IN VARCHAR2 DEFAULT NULL
150: )
151: IS

Line 148: p_parent_table_name IN all_tables.table_name%TYPE DEFAULT NULL,

144: -- |-------------------------< child_exists_error >---------------------------|
145: -- ----------------------------------------------------------------------------
146: PROCEDURE child_exists_error (
147: p_table_name IN all_tables.table_name%TYPE,
148: p_parent_table_name IN all_tables.table_name%TYPE DEFAULT NULL,
149: p_parent_entity_name IN VARCHAR2 DEFAULT NULL
150: )
151: IS
152: --

Line 154: l_table_name all_tables.table_name%TYPE := null;

150: )
151: IS
152: --
153: l_proc varchar2(72) := g_package || 'child_exists_error';
154: l_table_name all_tables.table_name%TYPE := null;
155: l_parent_table_name all_tables.table_name%TYPE := null;
156: l_parent_user_table_name varchar2(240);
157: l_user_table_name varchar2(240);
158: --

Line 155: l_parent_table_name all_tables.table_name%TYPE := null;

151: IS
152: --
153: l_proc varchar2(72) := g_package || 'child_exists_error';
154: l_table_name all_tables.table_name%TYPE := null;
155: l_parent_table_name all_tables.table_name%TYPE := null;
156: l_parent_user_table_name varchar2(240);
157: l_user_table_name varchar2(240);
158: --
159: Begin

Line 778: (p_table_name in all_tables.table_name%TYPE) Is

774: -- ----------------------------------------------------------------------------
775: -- |-------------------------< parent_integrity_error >------------------------|
776: -- ----------------------------------------------------------------------------
777: Procedure parent_integrity_error
778: (p_table_name in all_tables.table_name%TYPE) Is
779: --
780: l_proc varchar2(72) := g_package||'parent_integrity_error';
781: l_table_name all_tables.table_name%TYPE := null;
782: --

Line 781: l_table_name all_tables.table_name%TYPE := null;

777: Procedure parent_integrity_error
778: (p_table_name in all_tables.table_name%TYPE) Is
779: --
780: l_proc varchar2(72) := g_package||'parent_integrity_error';
781: l_table_name all_tables.table_name%TYPE := null;
782: --
783: Begin
784: --
785: l_table_name := upper(p_table_name);