APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_ITEM_LIST_PRICE

Line 1269: from msd_item_list_price

1265: p_seq_num IN NUMBER) IS
1266:
1267: CURSOR c_delete IS
1268: (select sr_item_pk
1269: from msd_item_list_price
1270: where instance = p_instance_id
1271: MINUS
1272: select sr_item_pk
1273: from msd_st_item_list_price

Line 1276: TYPE sr_item_pk_tab is table of msd_item_list_price.sr_item_pk%TYPE;

1272: select sr_item_pk
1273: from msd_st_item_list_price
1274: where instance = p_instance_id);
1275:
1276: TYPE sr_item_pk_tab is table of msd_item_list_price.sr_item_pk%TYPE;
1277:
1278: a_sr_item_pk SR_ITEM_PK_TAB;
1279:
1280:

Line 1289: DELETE FROM msd_item_list_price

1285: CLOSE c_delete;
1286:
1287: IF (a_sr_item_pk.exists(1)) THEN
1288: FORALL i IN a_sr_item_pk.FIRST..a_sr_item_pk.LAST
1289: DELETE FROM msd_item_list_price
1290: WHERE sr_item_pk = a_sr_item_pk(i) and instance = p_instance_id;
1291: /*
1292: FORALL j IN a_sr_item_pk.FIRST..a_sr_item_pk.LAST
1293: INSERT INTO msd_deleted_item_list_price(instance, sr_item_pk, created_by_refresh_num,

Line 1336: from msd_item_list_price

1332:
1333: CURSOR c_fact_rows (p_item_pk VARCHAR2) IS
1334: select sr_item_pk, item, list_price, avg_discount, base_uom,
1335: item_type_id, forecast_type_id
1336: from msd_item_list_price
1337: where instance = p_instance_id and sr_item_pk = p_item_pk;
1338:
1339: l_item VARCHAR2(240);
1340: l_list_price NUMBER;

Line 1362: INSERT INTO msd_item_list_price( instance, item, list_price,

1358:
1359: /* If this row doesn't exist in fact table then insert */
1360: IF (l_item_pk is null) THEN
1361:
1362: INSERT INTO msd_item_list_price( instance, item, list_price,
1363: avg_discount, base_uom,
1364: sr_item_pk, item_type_id, forecast_type_id,
1365: action_code, created_by_refresh_num, last_refresh_num,
1366: last_update_date, last_updated_by,

Line 1390: UPDATE msd_item_list_price

1386: (nvl(rec_st_rows.item_type_id,-9999) <> nvl(l_item_type_id,-9999)) OR
1387: (nvl(rec_st_rows.forecast_type_id,-9999) <> nvl(l_forecast_type_id,-9999)) ) THEN
1388: /* If this row has been modified */
1389:
1390: UPDATE msd_item_list_price
1391: SET item = rec_st_rows.item,
1392: list_price = rec_st_rows.list_price,
1393: avg_discount = rec_st_rows.avg_discount,
1394: base_uom = rec_st_rows.base_uom,