APPS.MSD_DEM_COLLECT_PRICE_LISTS dependencies on MSD_DEM_ENTITIES_INUSE

Line 58: from msd_dem_entities_inuse

54: as
55:
56: cursor get_prl_metadata is
57: select table_name, column_name
58: from msd_dem_entities_inuse
59: where ebs_entity = 'PRL'
60: and demantra_entity = 'DISPLAY_UNIT'
61: and internal_name = p_prl_code;
62:

Line 158: msd_dem_entities_inuse

154: as
155:
156: cursor verify_entities_inuse is
157: select 1 from
158: msd_dem_entities_inuse
159: where internal_name = p_prl_code
160: and ebs_entity = 'PRL';
161:
162: type c_get_new_prl_display_unit is ref cursor;

Line 235: ' select column_name from msd_dem_entities_inuse where ebs_entity = ''PRL'' )' ||

231: ' select distinct display_units_id from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') || ')' ||
232: ' and data_field in ' ||
233: ' (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where data_field like ''EBSPRICELIST%'' ' ||
234: ' minus ' ||
235: ' select column_name from msd_dem_entities_inuse where ebs_entity = ''PRL'' )' ||
236: ' and rownum < 2';
237:
238: msd_dem_common_utilities.log_debug(l_stmt_new_prl_display_unit);
239: -- syenamar

Line 266: l_stmt := 'insert into msd_dem_entities_inuse(

262: close get_profile_table;
263:
264:
265:
266: l_stmt := 'insert into msd_dem_entities_inuse(
267: ebs_entity
268: ,demantra_entity
269: ,internal_name
270: ,table_name

Line 378: l_stmt := 'update msd_dem_entities_inuse set table_name = ''biio_ebs_price_list''' ||

374:
375:
376: /*else
377: l_stmt := null;
378: l_stmt := 'update msd_dem_entities_inuse set table_name = ''biio_ebs_price_list''' ||
379: ', column_name = (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||
380: 'where ebs_entity = ''PRL'' and demantra_entity = ''DISPLAY_UNIT'' and internal_name = :2';
381:
382: msd_dem_common_utilities.log_debug(l_stmt);

Line 1057: from msd_dem_entities_inuse

1053: as
1054:
1055: cursor entities_inuse_cur(p_price_list_name varchar2) is
1056: select internal_name, column_name
1057: from msd_dem_entities_inuse
1058: where internal_name = p_price_list_name
1059: and ebs_entity = 'PRL';
1060:
1061: l_internal_name varchar2(240);

Line 1164: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||

1160: msd_dem_common_utilities.log_debug(l_stmt_updates);
1161:
1162: execute immediate l_stmt_updates using l_column_name, l_column_name;
1163:
1164: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||
1165: ' where internal_name = :1 and ebs_entity = ''PRL''';
1166:
1167: msd_dem_common_utilities.log_message(l_stmt_deletes);
1168: msd_dem_common_utilities.log_debug(l_stmt_deletes);