APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_TABLE_CLASS_ASSIGNMT

Line 463: DELETE FROM fem_table_class_assignmt

459:
460: DELETE FROM fem_tab_column_prop
461: WHERE table_name = p_table_name;
462:
463: DELETE FROM fem_table_class_assignmt
464: WHERE table_name = p_table_name;
465:
466: IF l_di_view_name is NOT NULL THEN
467:

Line 595: DELETE FROM fem_table_class_assignmt ftca

591: l_init_msg_list := NVL(p_init_msg_list, c_false);
592: l_commit := NVL(p_commit, c_false);
593: l_encoded := NVL(p_encoded, c_true);
594:
595: DELETE FROM fem_table_class_assignmt ftca
596: WHERE EXISTS ( SELECT table_classification_code
597: FROM fem_tab_class_errors_gt ftce
598: WHERE ftce.table_classification_code = ftca.table_classification_code
599: AND table_name = p_table_name

Line 1833: FROM fem_table_class_assignmt

1829: IF is_table_registered(p_table_name) <> 'Y' THEN
1830: RETURN 'N';
1831: END IF;
1832: SELECT DECODE(count(*),0,'N','Y') INTO l_valid_flag
1833: FROM fem_table_class_assignmt
1834: WHERE table_classification_code = p_table_class_code
1835: AND table_name = p_table_name
1836: AND enabled_flag='Y';
1837:

Line 1879: FROM fem_table_class_assignmt

1875: END LOOP;
1876: CLOSE classifs;
1877: l_concat_classif := LTRIM(l_concat_classif,',');
1878: SELECT DECODE(count(*),0,'N','Y') INTO l_valid_flag
1879: FROM fem_table_class_assignmt
1880: WHERE table_classification_code IN (SELECT lookup_code
1881: FROM fnd_lookup_values
1882: WHERE lookup_type=p_table_class_lookup_type
1883: AND language=userenv('LANG'))

Line 2214: FROM fem_table_class_assignmt

2210: BEGIN
2211:
2212: SELECT count(*)
2213: INTO i
2214: FROM fem_table_class_assignmt
2215: WHERE table_name = p_object_name
2216: AND TABLE_CLASSIFICATION_CODE = 'DI_READ_ONLY';
2217:
2218: IF (i = 1) THEN