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 154: msd_dem_entities_inuse

150: as
151:
152: cursor verify_entities_inuse is
153: select 1 from
154: msd_dem_entities_inuse
155: where internal_name = p_prl_code
156: and ebs_entity = 'PRL';
157:
158: type c_get_new_prl_display_unit is ref cursor;

Line 254: l_stmt := 'insert into msd_dem_entities_inuse(

250: close get_profile_table;
251:
252:
253:
254: l_stmt := 'insert into msd_dem_entities_inuse(
255: ebs_entity
256: ,demantra_entity
257: ,internal_name
258: ,table_name

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

350:
351:
352: /*else
353: l_stmt := null;
354: l_stmt := 'update msd_dem_entities_inuse set table_name = ''biio_ebs_price_list''' ||
355: ', column_name = (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||
356: 'where ebs_entity = ''PRL'' and demantra_entity = ''DISPLAY_UNIT'' and internal_name = :2';
357:
358: msd_dem_common_utilities.log_debug(l_stmt);

Line 803: from msd_dem_entities_inuse

799: as
800:
801: cursor entities_inuse_cur(p_price_list_name varchar2) is
802: select internal_name, column_name
803: from msd_dem_entities_inuse
804: where internal_name = p_price_list_name
805: and ebs_entity = 'PRL';
806:
807: l_internal_name varchar2(240);

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

906: msd_dem_common_utilities.log_debug(l_stmt_updates);
907:
908: execute immediate l_stmt_updates using l_column_name, l_column_name;
909:
910: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||
911: ' where internal_name = :1 and ebs_entity = ''PRL''';
912:
913: msd_dem_common_utilities.log_message(l_stmt_deletes);
914: msd_dem_common_utilities.log_debug(l_stmt_deletes);