26: lv_dummy1 VARCHAR2(32);
27: lv_dummy2 VARCHAR2(32);
28:
29:
30: lv_table_name FND_LOOKUP_VALUES.attribute1%Type;
31: lv_errtxt VARCHAR2(300);
32:
33: lv_total number :=0; -- total number of rows deleted
34:
33: lv_total number :=0; -- total number of rows deleted
34:
35: CURSOR table_names IS
36: SELECT DISTINCT (LV.ATTRIBUTE1) TABLE_NAME
37: FROM FND_LOOKUP_VALUES LV
38: WHERE LV.ENABLED_FLAG = 'Y'
39: AND LV.VIEW_APPLICATION_ID = 700
40: AND SUBSTR (LV.ATTRIBUTE1, 1, 3) = 'MSD'
41: AND LV.LOOKUP_TYPE = 'MSC_X_SETUP_ENTITY_CODE';