DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_FACT_DATA dependencies on MSD_PRICE_LIST

Line 1253: UPDATE msd_price_list

1249: 'WHERE PRICE_LIST_NAME like NVL(:p_price_list, PRICE_LIST_NAME) ';
1250:
1251: ELSIF p_dest_table = MSD_COMMON_UTILITIES.PRICING_FACT_TABLE THEN
1252: IF (p_price_list is not NULL) THEN
1253: UPDATE msd_price_list
1254: SET Action_code = 'D', last_refresh_num = p_new_refresh_num
1255: WHERE Action_code = 'I' and instance = p_instance_id and
1256: price_list_name like p_price_list;
1257: ELSE

Line 1258: UPDATE msd_price_list

1254: SET Action_code = 'D', last_refresh_num = p_new_refresh_num
1255: WHERE Action_code = 'I' and instance = p_instance_id and
1256: price_list_name like p_price_list;
1257: ELSE
1258: UPDATE msd_price_list
1259: SET Action_code = 'D', last_refresh_num = p_new_refresh_num
1260: WHERE Action_code = 'I' and instance = p_instance_id;
1261:
1262: END IF;