DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_FACT_DATA dependencies on MSD_PRICE_LIST

Line 1327: UPDATE msd_price_list

1323: 'WHERE PRICE_LIST_NAME like NVL(:p_price_list, PRICE_LIST_NAME) ';
1324:
1325: ELSIF p_dest_table = MSD_COMMON_UTILITIES.PRICING_FACT_TABLE THEN
1326: IF (p_price_list is not NULL) THEN
1327: UPDATE msd_price_list
1328: SET Action_code = 'D', last_refresh_num = p_new_refresh_num
1329: WHERE Action_code = 'I' and instance = p_instance_id and
1330: price_list_name like p_price_list;
1331: ELSE

Line 1332: UPDATE msd_price_list

1328: SET Action_code = 'D', last_refresh_num = p_new_refresh_num
1329: WHERE Action_code = 'I' and instance = p_instance_id and
1330: price_list_name like p_price_list;
1331: ELSE
1332: UPDATE msd_price_list
1333: SET Action_code = 'D', last_refresh_num = p_new_refresh_num
1334: WHERE Action_code = 'I' and instance = p_instance_id;
1335:
1336: END IF;