APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_TABLE_PROP_STP

Line 2198: fem_table_prop_stp S

2194:
2195: CURSOR c_procedure (p_class VARCHAR2) IS
2196: SELECT DISTINCT S.stored_procedure_name
2197: FROM fem_table_class_prop C,
2198: fem_table_prop_stp S
2199: WHERE C.table_classification_code = p_class
2200: AND C.table_property_code = S.table_property_code;
2201:
2202: v_return_status VARCHAR2(1);

Line 2210: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;

2206: v_msg_data VARCHAR2(2000);
2207:
2208: v_db_tab_name ALL_TABLES.table_name%TYPE;
2209: v_tab_owner ALL_TABLES.owner%TYPE;
2210: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;
2211: BEGIN
2212: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2213: FEM_ENGINES_PKG.TECH_MESSAGE(
2214: p_severity => FND_LOG.level_procedure,

Line 2514: fem_table_prop_stp ftps

2510: WHERE flv.lookup_type = 'FEM_TABLE_CLASSIFICATION_DSC'
2511: AND not exists(
2512: select ftcp.table_classification_code
2513: from fem_table_class_prop ftcp,
2514: fem_table_prop_stp ftps
2515: where ftcp.table_classification_code = flv.lookup_code
2516: and ftcp.table_property_code = ftps.table_property_code
2517: and ftps.stored_procedure_name in(
2518: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',

Line 2787: fem_table_prop_stp S

2783:
2784: CURSOR c_procedure (p_class VARCHAR2) IS
2785: SELECT DISTINCT S.stored_procedure_name
2786: FROM fem_table_class_prop C,
2787: fem_table_prop_stp S
2788: WHERE C.table_classification_code = p_class
2789: AND C.table_property_code = S.table_property_code;
2790:
2791: v_return_status VARCHAR2(1);

Line 2799: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;

2795: v_msg_data VARCHAR2(2000);
2796:
2797: v_db_tab_name VARCHAR2(30);
2798: v_tab_owner VARCHAR2(30);
2799: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;
2800: l_apps VARCHAR2(30):=USER;
2801:
2802: BEGIN
2803: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN