APPS.JTF_QUALIFIER_PVT dependencies on ALL_TAB_COLUMNS

Line 281: FROM ALL_TAB_COLUMNS

277: IS
278: -- cursor to check that column exists in an Application schema
279: CURSOR c_column_datatype (l_column_name VARCHAR2, l_table_name VARCHAR2, l_apps_schema VARCHAR2) IS
280: SELECT data_type
281: FROM ALL_TAB_COLUMNS
282: WHERE column_name = UPPER(l_column_name)
283: AND table_name = UPPER(l_table_name)
284: AND owner =
285: (select table_owner

Line 291: l_column_datatype_csr ALL_TAB_COLUMNS.DATA_TYPE%TYPE;

287: where synonym_name = UPPER(l_table_name)
288: and owner = l_apps_schema);
289:
290: -- column datatype
291: l_column_datatype_csr ALL_TAB_COLUMNS.DATA_TYPE%TYPE;
292:
293: l_apps_schema_name VARCHAR2(30);
294: BEGIN
295:

Line 296: /* ACHANDA : Bug # 3511203 : get apps schema and use it to get the data type from all_tab_columns */

292:
293: l_apps_schema_name VARCHAR2(30);
294: BEGIN
295:
296: /* ACHANDA : Bug # 3511203 : get apps schema and use it to get the data type from all_tab_columns */
297: SELECT oracle_username
298: INTO l_apps_schema_name
299: FROM fnd_oracle_userid
300: WHERE read_only_flag = 'U';

Line 460: FROM ALL_TAB_COLUMNS

456:
457: -- cursor to check that table exists in an Application schema
458: CURSOR c_chk_table_exists (l_table_name VARCHAR2, l_apps_schema VARCHAR2) IS
459: SELECT 'X'
460: FROM ALL_TAB_COLUMNS
461: WHERE table_name = UPPER(l_table_name)
462: AND owner =
463: (select table_owner
464: from all_synonyms

Line 471: FROM ALL_TAB_COLUMNS

467:
468: -- cursor to check that column exists in an Application schema
469: CURSOR c_chk_col_exists (l_table_name VARCHAR2, l_col_name VARCHAR2, l_apps_schema VARCHAR2) IS
470: SELECT 'X'
471: FROM ALL_TAB_COLUMNS
472: WHERE column_name = UPPER(l_col_name)
473: AND table_name = UPPER(l_table_name)
474: AND owner =
475: (select table_owner

Line 486: /* ACHANDA : Bug # 3511203 : get apps schema and use it to get the data type from all_tab_columns */

482: l_apps_schema_name VARCHAR2(30);
483:
484: BEGIN
485:
486: /* ACHANDA : Bug # 3511203 : get apps schema and use it to get the data type from all_tab_columns */
487: SELECT oracle_username
488: INTO l_apps_schema_name
489: FROM fnd_oracle_userid
490: WHERE read_only_flag = 'U';