DBA Data[Home] [Help]

APPS.AK_OBJECT_PVT dependencies on ALL_TAB_COLUMNS

Line 120: from ALL_TAB_COLUMNS a

116: and fv.view_name = p_table_name
117: and fvc.view_id = fv.view_id;
118: cursor l_check_all_column_csr(oracle_schema varchar2) is
119: select 1
120: from ALL_TAB_COLUMNS a
121: where a.table_name = p_table_name
122: and a.column_name = p_column_name
123: and a.owner = oracle_schema;
124: cursor l_find_appl_short_name is

Line 147: -- Check ALL_TAB_COLUMNS

143: open l_check_fnd_column_csr;
144: fetch l_check_fnd_column_csr into l_dummy;
145: if ( l_check_fnd_column_csr%notfound) then
146: close l_check_fnd_column_csr;
147: -- Check ALL_TAB_COLUMNS
148: open l_find_appl_short_name;
149: fetch l_find_appl_short_name into l_temp;
150: if (l_find_appl_short_name%notfound) then
151: close l_find_appl_short_name;